11-19-2004, 05:27 AM
|
 |
|
|
Join Date: Jul 2004
Location: Switzerland
Posts: 1,551
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
|
Originally Posted by 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:
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? |
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.
|
Linear Mode
