Announcement

Collapse
No announcement yet.

problem with my database

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

  • problem with my database

    i have an accident my database was droped one field is IPaddress and now i can't add new users in admincp or member can't finish register at my site.

    and here errors message :

    Database error in vBulletin 3.6.8:

    Invalid SQL:
    INSERT INTO NNNLSSuser
    (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
    ('6<e', FROM_UNIXTIME(1227034702), '3bb496477b033b4261cf2aff3f4f8e48', 7254, 0, '', 0, 'jen', '[email protected]', 0, '', '', '', 0, '', '', '', '', '', '', 0, '', 0, 2, 5, 10, 0, 0, 0, 1, -1, 0, 2, 0, '0', -1, 1227034620, 1227034620, 0, '', '', 1227034702, -1, -1);

    MySQL Error : Unknown column 'ipaddress' in 'field list'
    Error Number : 1054
    Date : Wednesday, November 19th 2008 @ 01:58:23 AM
    Script : http://xxxx/user.php?do=update
    Referrer : http://xxxxx/admincp/user.php?do=add
    IP Address : xxx.xxx.x.xxx
    Username : xxxx
    Classname : vb_database
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X