
01-02-2009, 02:20 PM
|
|
|
Join Date: Dec 2006
Posts: 56
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Hassan, problem
Quote:
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT user.*, usergroup.usergroupid, usergroup.title, usergroup.isstaff, user.options, usertextfield.buddylist,
userfield.field2,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM vB_user AS user
LEFT JOIN vB_usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
LEFT JOIN vB_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vB_usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
WHERE (vB_user.usergroupid = 6 OR FIND_IN_SET(6, vB_user.membergroupids));
MySQL Error : Unknown table 'vB_user' in where clause
Error Number : 1109
Request Date : Friday, January 2nd 2009 @ 06:59:54 PM
Error Date : Friday, January 2nd 2009 @ 06:59:54 PM
Script : http://xxx/staff.php?do=usergroups&groupid=6
Referrer : http://xxx/staff.php?do=main
IP Address : xxx.xxx.xxx.xxx
Username : Martell
Classname : vb_database
MySQL Version : 4.1.22
|
|