Database Error
 

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

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

No store mods installed.

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

Are you on MSN M8?

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

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

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.

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.

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