SQL Error in arcade when playing game
 

*Occasionally* I get these errors mailed through...no more than once or twice a day.

Invalid SQL:

SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
customavatar.width, customavatar.height, customavatar.width_thumb, customavatar.height_thumb
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid =;

MySQL Error : 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 6
Error Number : 1064
Request Date : Saturday, June 28th 2008 @ 10:11:25 AM
Error Date : Saturday, June 28th 2008 @ 10:11:26 AM
Script : http://www.bowlandcentral.com/forum/...lay&gameid=599
Referrer : http://www.bowlandcentral.com/forum/...de&do=newscore



As you can see, it isn't picking up a userid somewhere along the line.

I have tried clicking on the script mentioned but the games always load fine.

Any ideas? I'm now on 2.6.7 and vB 3.7.0 but this error has plagued me for over a year now.

very strange, no idea about it ... if that really a user calling the script ?

Yes...it always has the username at the bottom of the email, and they are always real members.

Of course, it *could* be someone cheating...I've no way of knowing.

I cannot replicate the error myself, it has never happened to me. But then, I don't play the games all day like some of my members do.

as the referrer is "newscore", it assume this is somebody trying to cheat...

I'm not sure to be honest...the members it happens to seem to be very random and quite long standing members. I don't reckon they'd even know about cheating to be honest.

The referrer isn't always newscore, sometimes it's other scripts. It just seems to relate to clicking on games. It seems to have trouble pulling the userid for the avatar, but only on one-off occasions, as if I click the link it always works.