The Arcive of vBulletin Modifications Site. |
|
Can't Edit User - MySQL Error Number 1064 Details »»
|
|||||||||||||||||||||||||||
|
Can't Edit User - MySQL Error Number 1064
Developer Last Online: Jun 2011
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. Code:
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='taffywduck',email='taffyduck_02@hotmail.com',styleid='1',parentemail='',coppauser=0,homepage='http://',icq='17541430',aim='',yahoo='',signature='',adminemail=1,showemail=0,invisible=0,usertitle='Egg',customtitle=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='taffywduck',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/a...=edit&userid=5
Thanks. ![]() Show Your Support
|
|||||||||||||||||||||||||||
| Comments |
|
#2
|
||||
|
||||
|
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.
|
|
#3
|
||||
|
||||
|
It worked. Thank you very much.
|
|
#4
|
||||
|
||||
|
No problem!
|
![]() |
|
|