MySQL error on colours section?

Aqua · Post by **Aqua** » 14 Apr 2006 03:50 am

When I try to view the new colours, any section (main, poses), I get this error:

Could not retrieve userdata for : 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

Doesn't happen on my alternate browsers, just my main one, Safari..

Silverevilchao · Post by **Silverevilchao** » 14 Apr 2006 03:52 am

It happens to me every other time I even try to go on Neocolours, and I'm using IE.

Happy · Post by **Happy** » 14 Apr 2006 04:00 am

Happens everyother time to me too, I'm on Firefox. I can only get to the forums by going through an error page.

Post by **Huggles** » 14 Apr 2006 04:04 am

I'm not experiencing any technical difficulties.

TCD · Post by **TCD** » 14 Apr 2006 04:06 am

Me either.

Aqua · Post by **Aqua** » 14 Apr 2006 04:32 am

Hm, seems to be working now.. Maybe I'm in the sometimes camp then.

KasiTL · Post by **KasiTL** » 14 Apr 2006 04:57 am

I've been getting that the past few days as well. Seems to hit in the afternoon my time, but morning and night don't get the problems so much.
Perhaps we should log what times NST that the main page is b0rked for us.
And for reference, I stick pretty exclusively to Firefox.

Silverevilchao · Post by **Silverevilchao** » 14 Apr 2006 08:33 am

B0rked at 12:33 NST.

Zap · Post by **Zap** » 14 Apr 2006 09:49 am

Seems to be all working again. It was complaining about syntax, earlier (before 12:00 AM NST) but it worked if I used http://neocolours.me.uk instead of http://www.neocolours.me.uk

Joeno · Post by **Joeno** » 14 Apr 2006 10:05 am

I believe this is related to some code I use to handle cookies. What happens is that when checking whether you are logged in, and what you are allowed to access (mostly for Turmaculus at the moment - the link to set it is hidden if you are not logged in) I first check the session cookie and table before using the actual users table. It's faster and less time-consuming because part of the verification is skipped, the first time you load the forums fixes this.

What happens in this case is that this cookie is still set on the user-side, but that it has since then expired on the server. A few numbers don't match up properly, and I pass an empty condition to the database that messes it up.

Reloading the forums should work, and I will try to recode the error messages so that it doesn't prevent page-loading (I thought I already did, but I guess I messed up somewhere by forcing debugging).

Edit: I've implemented a fix. Please let me know if it still goes wrong - I'll need to do some more debugging if it does.

MySQL error on colours section?

MySQL error on colours section?

Who is online