
01-09-2010, 12:25 PM
|
 |
|
|
Join Date: Feb 2006
Location: Romania
Posts: 731
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I too am getting this error:
Quote:
Database error in vBulletin 4.0.0:
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
FROM forum AS forum
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 : Saturday, January 9th 2010 @ 04:23:24 PM
Error Date : Saturday, January 9th 2010 @ 04:23:25 PM
Script : http://127.0.0.1/forum/forum.php
Referrer : http://127.0.0.1/forum/admincp/index.php?do=head
IP Address : 127.0.0.1
Username : Magnumutz
Classname : vB_Database
MySQL Version : 5.1.37
|
The modification says that it's supported, but i see no support given in the last couple of weeks.
Is it really supported or not?
|