[odln018]

Same here with 4.0

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT subscribeforumid, forum.forumid, forum.lastpost, CONCAT(usergroup.opentag, forum.lastposter, usergroup.closetag) AS lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
, forumread.readtime AS forumread
FROM forum AS forum
LEFT JOIN subscribeforum AS subscribeforum ON (subscribeforum.forumid = forum.forumid AND subscribeforum.userid = 1)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
LEFT JOIN user AS user ON (forum.lastposterid = user.userid) LEFT JOIN usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid);

MySQL Error : Not unique table/alias: 'user'
Error Number : 1066
Request Date : Monday, December 21st 2009 @ 07:01:06 PM
Error Date : Monday, December 21st 2009 @ 07:01:06 PM
Script : http://www.xxxxx.com/testforum/forum...-Announcements
Referrer : http://www.xxxxx.com/testforum/forum.php
IP Address : xx.xxx.xxx.xx
Username : User
Classname : vB_Database
MySQL Version : 5.1.39-community