The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Database error, and user info tabs dissapear.
Need some help again.
Every time someone tries to look at my profile (user 1) they get a database error, just saying the forum database has encounter a problem. Then on the admins email i get the following : Database error in vBulletin 3.7.4: Invalid SQL: SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb FROM userlist AS userlist INNER JOIN user AS user ON (user.userid = userlist.relationid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) WHERE userlist.userid = 1 AND userlist.type = 'buddy' AND userlist.friend = 'yes' ORDER BY RAND() LIMIT 0, 1.399; 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 '1.399' at line 13 Error Number : 1064" Now this only happens when trying to see user's 1 profile, not with any other profile, any clues? And also when looking at any profile with Internet Explorer 8 the tabs on user profiles don't show up (stats, about, contact, etc.) but with firefox they show up with no problem. Thanks for any help. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|