Database error in vBulletin 3.8.6:
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.032;
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.032' at line 13
Error Number : 1064
Request Date : Sunday, August 29th 2010 @ 11:14:34 PM
Error Date : Sunday, August 29th 2010 @ 11:14:34 PM
Script : http://board.m2-tr.com/member.php?action=getinfo&u=1
Referrer : http://board.m2-tr.com/private.php?do=showpm&pmid=76836
IP Address : xx.xxx.xx.xxx
Username : Shorty
Classname : vB_Database
MySQL Version : 5.0.91-communityCanlı görmek isteyenler : http://board.m2-tr.com/1-shorty.htmlProfil / Özel mesajları temizledikten sonra böyle bir hata ile karşılasıyorum sorun sadece benim profilimde var. Galiba Mysql Versionundan kaynaklanan bir sorun. Nasıl çözebilirim yardımcı olurmusunuz?

tools.php / repair database felan herşeyi denedim