Database error when trying to Edit Users via. AdminCP

[ZiRu$]

Hey, I'm trying to edit my info (change avatar, country, details etc.) from the admin CP and whenever i do i get this error:


Database error in vBulletin Control Panel 2.3.5:

Invalid SQL: UPDATE user SET birthday='1985-03-25',options='3',usergroupid='6',username='Zirus',e mail='test@hotmail.com',styleid='',parentemail='', coppauser=,homepage='',icq='',aim='',yahoo='',sign ature='hi mom',adminemail=0,showemail=0,invisible=0,usertitl e='Administrator',customtitle=,joindate=UNIX_TIMES TAMP('2004-11-05 18:27:35'),cookieuser=1,nosessionhash=0,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2004-11-17 22:07:35'),lastactivity=UNIX_TIMESTAMP('2004-11-18 22:18:57'),lastpost=UNIX_TIMESTAMP('2004-11-08 17:45:59'),posts='1',timezoneoffset='-6',country='Canada',emailnotification=0,receivepm= '0',emailonpm='0',ipaddress='',pmpopup=IF(pmpopup= 2 AND 0=1,pmpopup,'0') WHERE userid=1
mysql error: You have an error in your SQL syntax near 'homepage='',icq='',aim='',yahoo='',signature='hi mom',adminemail=0,showemail=0,i' at line 1

mysql error number: 1064

Date: Thursday 18th of November 2004 10:19:15 PM
Script: XXXXXXXXXXXXXXXXXXXXXXX/forum/admin/user.php
Referer: XXXXXXXXXXXXXXXXXXXXXXX/forum/admin/user.php?action=edit&userid=1


Can anyone help?

[Colin F]

Hey, I'm trying to edit my info (change avatar, country, details etc.) from the admin CP and whenever i do i get this error:


Database error in vBulletin Control Panel 2.3.5:

Invalid SQL: UPDATE user SET birthday='1985-03-25',options='3',usergroupid='6',username='Zirus',e mail='test@hotmail.com',styleid='',parentemail='', coppauser=,homepage='',icq='',aim='',yahoo='',sign ature='hi mom',adminemail=0,showemail=0,invisible=0,usertitl e='Administrator',customtitle=,joindate=UNIX_TIMES TAMP('2004-11-05 18:27:35'),cookieuser=1,nosessionhash=0,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2004-11-17 22:07:35'),lastactivity=UNIX_TIMESTAMP('2004-11-18 22:18:57'),lastpost=UNIX_TIMESTAMP('2004-11-08 17:45:59'),posts='1',timezoneoffset='-6',country='Canada',emailnotification=0,receivepm= '0',emailonpm='0',ipaddress='',pmpopup=IF(pmpopup= 2 AND 0=1,pmpopup,'0') WHERE userid=1
mysql error: You have an error in your SQL syntax near 'homepage='',icq='',aim='',yahoo='',signature='hi mom',adminemail=0,showemail=0,i' at line 1

mysql error number: 1064

Date: Thursday 18th of November 2004 10:19:15 PM
Script: XXXXXXXXXXXXXXXXXXXXXXX/forum/admin/user.php
Referer: XXXXXXXXXXXXXXXXXXXXXXX/forum/admin/user.php?action=edit&userid=1


Can anyone help?
you're missing the ''s after coppauser.

Did you edit your admincp/user.php lately? If so, try to take the default file and redo the changes.

[HiDeo]

Yes, upload original file ;)