PDA

View Full Version : Can't Edit User - MySQL Error Number 1064


Tailfeathers
09-29-2002, 09:22 PM
If I try to edit a user from the admin control panel, I get this error:

There seems to have been a slight problem with the Tailfeathers database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE user SET birthday='0',awaydate=UNIX_TIMESTAMP('1969-12-31 19:00:00'),returndate='0000-00-00',awayreason='',1982-12-19',options='15',usergroupid='2',username='taffywd uck',email='taffyduck_02@hotmail.com',styleid='1', parentemail='',coppauser=0,homepage='http://',icq='17541430',aim='',yahoo='',signature='',admi nemail=1,showemail=0,invisible=0,usertitle='Egg',c ustomtitle=0,joindate=UNIX_TIMESTAMP('2002-09-29 17:14:58'),cookieuser=1,nosessionhash=1,daysprune= '5',lastvisit=UNIX_TIMESTAMP('2002-09-29 17:22:34'),lastactivity=UNIX_TIMESTAMP('2002-09-29 17:42:19'),lastpost=UNIX_TIMESTAMP('2002-09-29 17:20:34'),posts='1',timezoneoffset='-3.5',emailnotification=1,receivepm='1',emailonpm=' 1',ipaddress='65.94.131.31',pmpopup=IF(pmpopup=2 AND 1=1,pmpopup,'1'),canreportposts='1' WHERE userid=5
mysql error: You have an error in your SQL syntax near '1982-12-19',options='15',usergroupid='2',username='taffywd uck',email='taffyduck_' at line 1

mysql error number: 1064

Date: Sunday 29th of September 2002 06:20:10 PM
Script: http://www.tailfeathersnetwork.com/admin/user.php
Referer: http://www.tailfeathersnetwork.com/admin/user.php?s=&action=edit&userid=5

Any ideas?

Thanks. :)

Steve Machol
09-29-2002, 09:24 PM
Reupload the original user.php file from the 2.2.8 zip file. Make sure you upload in ASCII and overwrite the one on the server.

Tailfeathers
09-29-2002, 09:37 PM
It worked. Thank you very much. :)

Steve Machol
09-29-2002, 09:42 PM
No problem! :)