Another report for DB errors on RC2, here's the error incase you need it:
Code:
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 dhv_forum AS forum
LEFT JOIN dhv_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
LEFT JOIN dhv_user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN dhv_userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
LEFT JOIN dhv_user AS user ON (forum.lastposterid = user.userid) LEFT JOIN dhv_usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid);
MySQL Error : Not unique table/alias: 'user'
Error Number : 1066
Request Date : Saturday, December 12th 2009 @ 03:40:07 AM
Error Date : Saturday, December 12th 2009 @ 03:40:07 AM