Unknown column 'infractiongroupid' in 'field list'

Whats the problem? Why is it doing this & how can I fix it?
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 > 1155786772
ORDER BY username ASC;

MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Error Number : 1054
Date : Wednesday, August 16th 2006 @ 09:07:52 PM
Script :
Referrer :
IP Address :
Username :
Classname : vb_database

it looks like maybe you've updated the code of your application without running the necessary database updates? (or vice-versa...)

what are you doing on this line:
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
it seems like you are trying to call two columns at once and give the second one an alias. I don't believe you can do that.