Database Error

[The Realist]

Hi,

Well I just found out that members on my forum are getting a database error, but admin and moderators are able to use the forum 100%.

The error is:

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
customavatar.width, customavatar.height
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
Date : Thursday, March 16th 2006 @ 04:50:51 PM
Script :
Referrer :
IP Address :
Username :
Classname : vb_database

Does anyone have any ideas why?

Laters

[amykhar]

what mods have you implemented recently that affect custom avatars? A store mod maybe?

[The Realist]

No store mods installed.

[amykhar]

anything else that goes near the profile options? Something has wiped out the userid in the query.

[The Realist]

Are you on MSN M8?

[amykhar]

Nope. I'm at work and keep sneaking in here when I should be doing real stuff

[AKapadia]

the error is for all user or just the use who dont have thier Avtar ?

[The Realist]

Admin are ok.
Super Mods are ok.

All my other usergroups are effected.

If I change a users usergroup I get the database error as well.

[amykhar]

Disable all of your plugins and create a pure default style. Check to see if the problem still happens. If not, enable your plugins one by one and see when the problem starts up again.

[The Realist]

I have a default style with my standard template using the default template as a parent style. I have disabled all hacks and tested using the default style and the error is still there.

This tells me (if Im right) its a file thats been edited thats causing the problem and not a template.

Are there any coders available that would like to earn a few dollars sorting out this error for me.

PM me please.

Laters