SQL error on Dungeon Busters and San Waterdeep

Be sure to read and follow the guidelines for our forums.

Nov 26, 2015 6:00 am
( ! ) Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR p.userID = )' at line 1' in /var/www/gamersplane/includes/characters/Character.class.php on line 89
( ! ) PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR p.userID = )' at line 1 in /var/www/gamersplane/includes/characters/Character.class.php on line 89
Call Stack
# Time Memory Function Location
1 0.0001 232992 {main}( ) ../dispatch.php:0
2 0.0048 362672 require( '/var/www/gamersplane/forums/thread.php' ) ../dispatch.php:73
3 0.0208 733768 Character->getForumTop( ) ../thread.php:178
4 0.0208 733816 Character->checkPermissions( ) ../Character.class.php:126
5 0.0208 734136 query ( ) ../Character.class.php:89
Nov 26, 2015 6:12 am
It's on another game thread, too:
http://gamersplane.com/forums/thread/1233/?view=lastPost#lastPost

Main forum seems to indicate that there are actual posts beyond the point where the error occurs, but they don't show up.
Nov 26, 2015 6:24 am
Also getting the same error or similar.

Affected games (besides those already mentioned):
Octagon - Another Purpose
Strange Allies - Skyrealms of Jorune
Talos - Darkness Rising
Orphans of Waterdeep
Out of the Abyss

Edit: Seeing it on both my phone and my laptop.
Last edited November 26, 2015 6:25 am
Nov 26, 2015 6:24 am
I'm actually seeing a similar error on the game, though not the same one. This never came up in local testing and I can't replicate it locally, so this is giving me some trouble to figure out...
Nov 26, 2015 6:31 am
On the same thread as I linked (http://gamersplane.com/forums/thread/1233/?page=6) I am now seeing the character sheet entry instead of avatar/player-and-post.

Edit: did a refresh and it disappeared, but still seeing the sql errors at the bottom.
Last edited November 26, 2015 6:32 am
Nov 26, 2015 6:43 am
Just additional confirmation: this is appearing on many game threads I view, but not all of them. It is also appearing consistently across various browsers. I'm also seeing different messages displayed across different threads.

In this thread: Dead End Job, Chapter Two, I'm seeing the error at the tail end of the posts, and nothing else wonky.

But in this thread: Temple of Elemental Evil, I'm not seeing the error at the tail end of the posts, but I am seeing "boolean false" in between each post.

I'm also seeing changing behavior over time, where in some threads I saw some posts and then the error message, I now see no posts and only the error message (such as here: Dungeon Busters Against the Cult of the Reptile God).

This suggests to me something variable that's causing the problem, like a resource issue. So I will stop banging on the site and just check back here occasionally, so I don't add to the problem.
Nov 26, 2015 6:43 am
Ok, as far as I can see, its fixed.
Nov 26, 2015 6:46 am
spaceseeker, you're not insane. I couldn't replicate the problem locally, so I had to commit the ultimate sin: testing on the live site...

You do not have permission to post in this thread.