Announcement

Collapse
No announcement yet.

Urgent - Need Database Help - casuing errors

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

  • Urgent - Need Database Help - casuing errors

    Database error in vBulletin 3.6.0:

    Invalid SQL:
    INSERT INTO user
    (salt, passworddate, password, options, adminoptions, usertitle, customtitle, username, email, languageid, homepage, birthday_search, birthday, showbirthday, icq, aim, yahoo, msn, skype, parentemail, referrerid, ipaddress, posts, usergroupid, reputationlevelid, reputation, warnings, infractions, ipoints, pmpopup, autosubscribe, threadedmode, showvbcode, styleid, timezoneoffset, daysprune, joindate, lastactivity, lastpost, membergroupids, displaygroupid, lastvisit, maxposts, startofweek)
    VALUES
    ('$vp', FROM_UNIXTIME(1156436967), '5c42177bd427539187839e4fe9b16b5e', 7255, 0, 'Registered User', 0, 'testuser123121', '', 0, '', '', '', 0, '', '', '', '', '', '', 0, '', 0, 2, 5, 10, 0, 0, 0, 1, 2, 0, 2, 0, '0', -1, 1156436940, 1156436940, -1, '', '', 1156436967, -1, -1);

    MySQL Error : Unknown column 'warnings' in 'field list'
    Error Number : 1054
    Date : Thursday, August 24th 2006 @ 12:29:28 PM
    Script :
    Referrer :
    IP Address :
    Username :
    Classname :
    I am getting this database error. How can I remove the warnings thing so that I dont get it each time.

    It might have to do with the AWS hack I removed and it not removing everything from the database. How can I do that manually?

    URGENT.

    Thanks,
    mattlab

  • #2
    You have probably removed AWS after the upgrade to 3.6?

    If so, you can fix this by running the following query:
    Code:
    ALTER TABLE user ADD COLUMN `warnings` int(10) unsigned NOT NULL default '0';
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

    Comment


    • #3
      Thanks! It worked!

      Comment

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