Announcement

Collapse
No announcement yet.

Database error during adding infraction

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error during adding infraction

    What could it be?

    Error:
    Code:
    Database error in vBulletin 3.6.0:
    
    Invalid SQL:
    UPDATE user SET
    	warnings = warnings + 1
    WHERE userid = 15019;
    
    MySQL Error  : Unknown column 'warnings' in 'field list'
    Error Number : 1054
    Date         : Sunday, August 13th 2006 @ 06:51:50 PM
    Script       : http://www.forum.name/forum/infraction.php?do=update
    Referrer     : http://www.forum.name/forum/infraction.php?do=report&p=860870
    IP Address   : xx.xxx.xx.xxx
    Username     : Admin
    Classname    : vb_database

  • #2
    Could you check with phpmyadmin to see if this field is indeed in that table?

    Comment


    • #3
      Run this query to fix this:

      ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #4
        I had the very same error when I tried to manually add a new user after I upgraded from 3.5.4 to 3.6.0. Ran the above query and it fixed the sql error for me.

        Hope I dont get any more.

        Laters

        Originally posted by Steve Machol View Post
        Run this query to fix this:

        ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';

        Comment


        • #5
          I had this error too. This might be the cause of the Advanced Warning System (an add-on). I think when you uninstall that product it deletes that field.
          Last edited by Zidane007nl; Tue 22nd Aug '06, 2:06pm.
          Square Enix Forums

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X