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 :
Quote:
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', 'jen@msn.com', 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
|
|
11-18-2008, 04:59 PM
Threaded Mode