MySQL error on colours section?
MySQL error on colours section?
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..
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..
-
- Posts: 1586
- Joined: 07 Jan 2006 09:04 pm
- Gender: Female
- Human Avatar: 155477
- Location: Home. :)
- Contact:
-
- Posts: 1586
- Joined: 07 Jan 2006 09:04 pm
- Gender: Female
- Human Avatar: 155477
- Location: Home. :)
- Contact:
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
Last edited by Zap on 14 Apr 2006 04:04 pm, edited 1 time in total.
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.
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.
Who is online
Users browsing this forum: No registered users and 34 guests