problem with my database

[lkn]

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', '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

[Lynne]

ipaddress
type - varchar(15)
collation - latin1_swedish_ci
null - Yes

That's the struction for that field in my 3.6.8 database. Just add it back in using phpMyAdmin.

[lkn]

i try with your command and error :

SQL query:

TYPE - varchar( 15 ) COLLATION - latin1_swedish_ci NULL - Yes

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type - varchar(15)
collation - latin1_swedish_ci
null - Yes' at line 1

[SEOvB]

Thats because its not a SQL command to add it back.

Login to phpMyAdmin (or other admin tool) and do it manually by adding the row or table which ever it was.

[lkn]

Many thanks!

it's ok now