[odln018]

Receiving this in RC 4

Database error in vBulletin 4.0.0 Release Candidate 4:

Invalid SQL:

SELECT 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 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 @ 10:20:54 AM
Error Date : Monday, December 21st 2009 @ 10:20:54 AM
Script : http://www.site.com/testforum/forum.php
Referrer : http://www.site.com/testforum/content.php
IP Address : xx.xxx.xxx.xx
Username : Admin
Classname : vB_Database
MySQL Version : 5.1.39-community