Can't enter my game's forums...

Hi Keleth, for my game Guardians of Gurrai I can't enter the "forum" part of my game. I see this:



Here's what it said

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 ')' at line 1' in /var/www/gamersplane/includes/forums/ForumPermissions.class.php on line 33

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 ')' at line 1 in /var/www/gamersplane/includes/forums/ForumPermissions.class.php on line 33

# Time Memory Function Location
1 0.0001 231856 {main}( ) ../dispatch.php:0
2 0.0106 340272 require( '/var/www/gamersplane/forums/forum.php' ) ../dispatch.php:69
3 0.0113 472040 ForumManager->__construct( ) ../forum.php:5
4 0.0122 475856 ForumPermissions::getPermissions( ) ../ForumManager.class.php:35
5 0.0123 481944 query ( ) ../ForumPermissions.class.php:33

(Thanks Keleth, I don't understand the mechanics of running a site but I'm sure its a pain in the ass sometimes and I appreciate you creating this Valhalla).

So I put in a fix so you don't get that error anymore, but it doesn't solve the bug.

What link did you click to get there? Basically, from what page did you get there?

The page for my game. http://gamersplane.com/games/32/

Thanks for responding so quickly!

(Uh when I click "forum" it takes me to ALL the forums)

Oh shoot just discovered another bug...When I refresh the Guardians of Gurrai page it resets the game to "private" when I have it set on "public".

Well, that's the bug in question. Rather then giving you an error, it now forwards you to the home forum page. I'll try to figure out why its giving you a bad URL.

As for the refreshing turning the game to private, I have NO idea how that is happening. Nothing on the game homepage should switch that.

When you made your game, did it go to a blank page?

Either way, seems like there was a bug that failed. I've fixed it.

Um I don't remember...There was an error though, although I think it resolved itself.

Dammit. It took me to the forum list again , but at the bottom there was my game. I opened it and subscribed to it, and now the "forum" button on my game's page shows another error.

) 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 ')' at line 1' in /var/www/gamersplane/includes/forums/ForumPermissions.class.php on line 33
( ! ) 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 ')' at line 1 in /var/www/gamersplane/includes/forums/ForumPermissions.class.php on line 33
Call Stack
# Time Memory Function Location
1 0.0001 232224 {main}( ) ../dispatch.php:0
2 0.0045 340224 require( '/var/www/gamersplane/forums/forum.php' ) ../dispatch.php:69
3 0.0051 472016 ForumManager->__construct( ) ../forum.php:5
4 0.0060 475872 ForumPermissions::getPermissions( ) ../ForumManager.class.php:37
5 0.0061 481968 query ( ) ../ForumPermissions.class.php:33

It's good that Guardians showed up on the game list, but I think me subscribing to it might have done something.

Fixed your bug. Manually adding the stuff was problematic.