Unknown column 'infractiongroupid' in 'field list'

Jealousy

Here is the error

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 > 1155786482
	ORDER BY username ASC;
MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Error Number : 1054
Date : Wednesday, August 16th 2006 @ 09:03:03 PM
Script :
Referrer :
IP Address :
Username :
Classname : vb_database

Jealousy

Whats the problem? Why is it doing this & how can I fix it?

bradgrafelman

Have you done a SHOW TABLE or used phpMyAdmin to verify the spelling of this column? Do you actually have an "infractiongroupid" column?

harmor

Illegal vBulletin perhaps?
The new vBulletin has an Infraction System that uses that column name.

Why not ask on vBulletin.com where they know the script very well?