hi i have this error, once i created a ladder,
Database error in vBulletin 4.0.3:
Invalid SQL:
SELECT players.*, players.userid AS userid,
user.avatarrevision AS avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, user.username AS username
, userfield.*, usertextfield.* , players.rank AS rank
FROM vbtmnt_ladder_players AS players
LEFT JOIN vbuser AS user ON (players.userid = user.userid) LEFT JOIN vbavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbcustomavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
WHERE players.lid=1
AND players.active=1
ORDER BY players.rank DESC,
players.wins DESC,
players.draws DESC
LIMIT 0, 25;
the ladder shows but i when i click on it i get the same message,
any ideas
Thanks
Dodge
i have installed latest version too, will try unistalling and will post again
|