
02-25-2009, 04:05 AM
|
|
|
Join Date: Jun 2005
Location: Australia
Posts: 2,469
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I am getting a database error after upgrading as well :/
Quote:
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT user.*, usergroup.usergroupid, usergroup.isstaff, usergroup.title, user.options, usertextfield.*, userfield.*,
userfield.field2,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM vb3_user AS user
LEFT JOIN vb3_usergroup AS usergroup ON(vb3_usergroup.usergroupid = vb3_user.usergroupid)
LEFT JOIN vb3_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vb3_usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
WHERE vb3_usergroup.isstaff = '1'
AND (FIND_IN_SET('6', membergroupids) OR user.usergroupid = 6);
MySQL Error : Unknown column 'vb3_usergroup.isstaff' in 'where clause'
Error Number : 1054
Request Date : Wednesday, February 25th 2009 @ 01:03:07 AM
Error Date : Wednesday, February 25th 2009 @ 01:03:14 AM
Script : http://www..net/forums/staff.php?do=...oups&groupid=6
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community
|
|