. MySQL Error : Unknown column 'u.infractiongroupid' in 'field list'

[ahmedzedan91]

The code works completely

DROP TABLE session;
CREATE TABLE session (
sessionhash CHAR(32) NOT NULL DEFAULT '',
userid INT UNSIGNED NOT NULL DEFAULT '0',
host VARCHAR(45) NOT NULL DEFAULT '',
idhash CHAR(32) NOT NULL DEFAULT '',
lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
******************************** CHAR(255) NOT NULL DEFAULT '',
useragent CHAR(255) NOT NULL DEFAULT '',
styleid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
********************************id SMALLINT UNSIGNED NOT NULL DEFAULT '0',
loggedin SMALLINT UNSIGNED NOT NULL DEFAULT '0',
bad******************************** SMALLINT UNSIGNED NOT NULL DEFAULT '0',
apiclientid INT UNSIGNED NOT NULL DEFAULT '0',
apiaccesstoken VARCHAR(32) NOT NULL DEFAULT '',
wol CHAR(255) NOT NULL DEFAULT '',
pagekey VARCHAR(255) NOT NULL DEFAULT '',
emailstamp INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (sessionhash),
KEY last_activity USING BTREE (lastactivity),
KEY user_activity USING BTREE (userid, lastactivity),
KEY guest_lookup (idhash, host, userid),
KEY apiaccesstoken (apiaccesstoken),
KEY pagekey (pagekey)
);​

​​

[glennrocksvb]

You just posted the SQL code for re-creating the session table which has nothing to do with the unknown column error. When do you get the error and what is the SQL query where the error came from and what is the error stack trace? Please provide more information to help us understand the issue.

[ahmedzedan91]

You just posted the SQL code for re-creating the session table which has nothing to do with the unknown column error. When do you get the error and what is the SQL query where the error came from and what is the error stack trace? Please provide more information to help us understand the issue.

MySQL Error : Unknown column 'u.infractiongroupid' in 'field list' Error Number : 1054


This is the error code. The error was resolved with the attached code