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:
PHP Code:
Database error in vBulletin Control Panel 2.3.5:
Invalid SQL: UPDATE user SET birthday='1985-03-25',options='3',usergroupid='6',username='Zirus',email='test@hotmail.com',styleid='',parentemail='',coppauser=,homepage='',icq='',aim='',yahoo='',signature='hi mom',adminemail=0,showemail=0,invisible=0,usertitle='Administrator',customtitle=,joindate=UNIX_TIMESTAMP('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?
11-19-2004, 04:25 AM
Database error when trying to Edit Users via. AdminCP
Threaded Mode