PDA

View Full Version : Database Error


The Realist
03-16-2006, 02:54 PM
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
03-16-2006, 03:25 PM
what mods have you implemented recently that affect custom avatars? A store mod maybe?

The Realist
03-16-2006, 03:31 PM
No store mods installed.

amykhar
03-16-2006, 03:32 PM
anything else that goes near the profile options? Something has wiped out the userid in the query.

The Realist
03-16-2006, 03:35 PM
Are you on MSN M8?

amykhar
03-16-2006, 03:43 PM
Nope. I'm at work and keep sneaking in here when I should be doing real stuff ;)

AKapadia
03-16-2006, 04:00 PM
the error is for all user or just the use who dont have thier Avtar ?

The Realist
03-16-2006, 04:07 PM
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
03-16-2006, 04:35 PM
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
03-17-2006, 02:07 PM
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

The Realist
03-19-2006, 12:25 PM
Found the problem :)

It was this hack https://vborg.vbsupport.ru/showthread.php?t=82767

Laters