Wednesday, March 17, 2010

Unknown column 'infractiongroupid' in 'field list'

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT
user
.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(
displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM session
AS session
LEFT JOIN user
AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1207340538
ORDER BY username ASC
;

MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Error Number : 1054
Date
: Saturday, April 5th 2008 @ 12:37:18 AM
Script
: http://.com/vb4/
Referrer :
IP Address :
Username : Unregistered
Classname
: vb_database

Solve the problem


ALTER TABEL user ADD `infractiongroupid` smallint(5) unsigned NOT NULL default '0';


No comments:

Post a Comment