Announcement

Collapse
No announcement yet.

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

Collapse
X
Collapse
First Prev Next Last
 
  • Filter
  • Time
  • Show
Clear All
new posts

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


    The code works completely



    Code:
    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)
    );​
    
    ​​

    #2
    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.

    Comment


      #3
      Originally posted by glennrocksvb View Post
      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






      Attached Files

      Comment

      Latest Posts

      Collapse

      Working...
      X
      Searching...Please wait.
      An unexpected error was returned: 'Your submission could not be processed because you have logged in since the previous page was loaded.

      Please push the back button and reload the previous window.'
      An unexpected error was returned: 'Your submission could not be processed because the token has expired.

      Please push the back button and reload the previous window.'
      An internal error has occurred and the module cannot be displayed.
      There are no results that meet this criteria.
      Search Result for "|||"