[djilou]

I have a problem with the 1.4.1 version

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 thread AS t
INNER JOIN post AS p ON t.lastpostid=p.postid
INNER JOIN user AS u ON p.userid=u.userid
LEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid)
WHERE t.forumid=86 AND t.visible=1
ORDER BY t.lastpost
LIMIT 10;

MySQL Error : Unknown column 'user.avatarrevision' in 'field list'
Error Number : 1054