After just i have updated it
i got a db error..
Code:
Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT
t.postusername, t.threadid, t.title, t.lastpost, t.lastpostid, t.replycount, t.views, p.pagetext, p.dateline, p.userid, u.username,
IF(displaygroupid=0, u.usergroupid, displaygroupid) AS displaygroupid
, user.avatarrevision, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, customavatar.width as avwidth, customavatar.height as avheight, customavatar.filedata_thumb
FROM db_thread AS t
INNER JOIN db_post AS p ON t.lastpostid=p.postid
INNER JOIN db_user AS u ON p.userid=u.userid
LEFT JOIN db_avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN db_customavatar AS customavatar ON (customavatar.userid = u.userid)
WHERE t.forumid=187 AND t.visible=1
ORDER BY t.lastpost
LIMIT 10;
MySQL Error : Unknown column 'user.avatarrevision' in 'field list'
Error Number : 1054
Request Date : Tuesday, May 27th 2008 @ 04:02:23 PM
Error Date : Tuesday, May 27th 2008 @ 04:02:23 PM
Script : http://faz.la/group.php?groupid=7
Referrer : http://faz.la/group.php?do=createforum&groupid=7