The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Database error on profiles when user have >1000 friends
When an user have more than 1000 friends in the Friends List the profile shows Database error:
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 = 4434191 AND userlist.type = 'buddy' AND userlist.friend = 'yes' ORDER BY RAND() LIMIT 0, 1.005; 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.005' at line 13 Error Number : 1064 I think that the problem is the decimal dot in 1.005, which vB control the friends ? Thanks |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|