PDA

View Full Version : Edit user not working?


McDohl
03-30-2003, 12:49 PM
Hey all...

Just tried to edit a user via the admin CP and got this:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE user SET birthday='0000-00-00',options='15',usergroupid='2',username='Craig', email='sitereviews@hotmail.com',styleid='1',parent email='',coppauser=0,homepage='http://www.',icq='',aim='',yahoo='',signature='',adminema il=1,showemail=1,invisible=0,usertitle='Newbie',cu stomtitle=0,joindate=UNIX_TIMESTAMP('2003-03-29 08:58:07'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2003-03-29 12:53:29'),lastactivity=UNIX_TIMESTAMP('2003-03-29 12:53:29'),lastpost=UNIX_TIMESTAMP('2003-03-29 11:42:10'),posts='2',spamposts='0',timezoneoffset= '0',emailnotification=1,receivepm='1',emailonpm='0 ',ipaddress='',pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=3
mysql error: Unknown column 'spamposts' in 'field list'

mysql error number: 1054

Date: Sunday 30th of March 2003 08:51:42 AM
Script: http://www.lifebar.com/forums/forums/admin/user.php
Referer: http://www.lifebar.com/forums/admin/user.php?action=edit&userid=3


I have no clue what this is, so if anyone could help me out, i'd appreciate it.

Thanks :)
-Scott

McDohl
03-30-2003, 12:50 PM
Oh sorry. I've noticed what it is. :P