Forum Upgrade!

So, its 2 am, but I finally go the forum upgrade done, before Dreamation. Time to head to bed. The problem: I won't be on much for the next two days, and I was stupid enough to build this upgrade in a way that I can't undo it. And unfortunately, there are bugs I didn't notice in dev popping up on the live site. I've already spent 20 minutes fixing one of them, and found a second. I'm sure there are a lot more.

I'm hoping you guys can help me find the bugs, and I can spend what time I have over the weekend fixing them.

Hi Keleth

Thanks for all your efforts. I am afraid I am seeing a lot of problems with the upgrade, namely:
1. I have a PM but get error when I open it so can't read it
2. Quote doesn't work
3. Page number in black box on thread doesn't show right number
4. Can't edit previously written posts

Many thanks!

For clarity, I should add:
1. Errors when clicking "quote"
2. Errors when clicking "personal message"
3. No option to edit posts (only quote link appears)
4. Page numbering messed up. For example shows 0 of 6 no matter what page you are on

Thanks

Here is message displayed when trying to open an old PM:

---

Fatal error: Call to a member function getAuthor() on a non-object in /var/www/gamersplane/javascript/markItUp/markitup.bbcode-parser.php on line 108
Call Stack
# Time Memory Function Location
1 0.0001 232272 {main}( ) ../dispatch.php:0
2 0.0041 340328 require( '/var/www/gamersplane/pms/view.php' ) ../dispatch.php:69
3 0.0048 352968 BBCode2Html( ) ../view.php:32

---

EDIT: Fast work, Keleth!

1) I'm not getting an error with quote. Can you elaborate on it?
2) Fixed the PM bug.
3) Fixed the edit bug.
4) Gotta look into that; I'm not seeing it either.

Keleth, you are awesome...
1) sorted... sort of
2) sorted
3) sorted
4) On a thread with 6 pages I see 0 of 6 in black box no matter what page I am on and only see selection for pages 1 and 2 and last.

(Hmmm, why didn't quote work?)

New bug... when I click "Reply" or "Advanced" on game thread I get this error (below). However I can reply to this thread, interestingly...

( ! ) Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.useID' in 'on clause'' in /var/www/gamersplane/forums/post.php on line 94
( ! ) PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.useID' in 'on clause' in /var/www/gamersplane/forums/post.php on line 94
Call Stack
# Time Memory Function Location
1 0.0000 233328 {main}( ) ../dispatch.php:0
2 0.0044 343192 require( '/var/www/gamersplane/forums/post.php' ) ../dispatch.php:69
3 0.0088 585040 query ( ) ../post.php:94

Merlin, if you could clarify what you mean by "Sort of" above, I can fix whatever is sort of broken, heh.

Also, try posting in a game forum again, should be good.

Keleth... Yes, game thread seems ok now.

Regarding quote, the quote worked but per my message above the square bracket quotes appear in my message instead of showing as a quote. I'm trying again...

Aha!! Worked this time. And corrected above too. Lol. Sorted.

I just want to say Keleth, you are fricking awesome.

I really shouldn't launch code at 2am when I have to be somewhere at 9am the next day...

Keleth it looks like the dice deck has gone.

Further to my comment on page numbers you can only step forwards through pages and not backwards, and you don't know what page you are on because only "1, 2 and last" show as options and page number is stuck as zero.

I'm getting an error when trying to "Mark forum as read":


( ! ) Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lastRead' in 'field list'' in /var/www/gamersplane/forums/process/read.php on line 10
( ! ) PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lastRead' in 'field list' in /var/www/gamersplane/forums/process/read.php on line 10
Call Stack
# Time Memory Function Location
1 0.0000 232320 {main}( ) ../dispatch.php:0
2 0.0041 340816 require( '/var/www/gamersplane/forums/process/read.php' ) ../dispatch.php:69
3 0.0124 341312 query ( ) ../read.php:10

This is also causing all read threads to be marked as unread.

The rest is working great for me!

I've had trouble with page numbers too. The thread view seems to think that the page is always 0/1 that is selected (on the paginator only) but the page's results are properly paginated. So on a 4 page thread it looks like this no matter what page you're on:

Thanks Rusty! That's exactly what I tried to describe.

What forum do you see that in? I put in a fix, and it looks like its working for me, but that fix was in before you put up your post RustInPieces.

I see the issue in Assassins Heart game.

In the EotE game forum, OOC topic. Except now in the forum view the threads no longer have a list of pages. And the bug persists in the thread view still.