PDA

View Full Version : SQL Error in Admin CP when I Edit a user


DannyBoy8406
11-17-2003, 11:10 PM
When I edit a user and go to save it gives me a 1064 error. I'm lost and clueless, I read the thread but its all latin to me :( can someone please help me out....alot!


Database error in vBulletin Control Panel 2.3.3:

Invalid SQL: UPDATE user SET birthday='0000-00-00',options='15',usergroupid='6',username='Sherloc k Holmes',email='dghunsucker@roanoke.edu',styleid='9 ',parentemail='',coppauser=0,homepage='www.mystery-boards.com',icq='59997479',aim='DannyBoy8406',yaho o='scinzihs',signature='',adminemail=1,showemail=1 ,invisible=0,usertitle='<i><b>Commissioner</b><br>Elementary Dear Watson</i>',customtitle=1,joindate=UNIX_TIMESTAMP('2003-11-16 22:33:44'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2003-11-17 16:26:43'),lastactivity=UNIX_TIMESTAMP('2003-11-17 17:17:20'),lastpost=UNIX_TIMESTAMP('2003-11-17 11:14:09'),
posts='2',profileview=''',timezoneoffset='-5',emailnotification=0,receivepm='1',emailonpm='0' ,ipaddress='',pmpopup=IF(pmpopup=2 AND 1=1,pmpopup,'1') WHERE userid=1
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '',emailnotification=0,receivepm='1',emailonpm='0' ,ipaddress='',

mysql error number: 1064

Date: Monday 17th of November 2003 05:19:43 PM
Script: http://www.mystery-boards.com/admin/user.php
Referer:

assassingod
11-18-2003, 05:52 AM
Have you installed a hack recently that edits user.php? If so, You have have installed it incorrectly. Upload an unhacked user.php and see if that fixes the problem.

Zachery
11-18-2003, 06:04 AM
Have you installed a hack recently that edits user.php? If so, You have have installed it incorrectly. Upload an unhacked user.php and see if that fixes the problem.
i swore i replied to this >.>

like i said before the only thing that i could think of is a bad hack >.>

assassingod
11-18-2003, 06:22 AM
You try this, open user.php and find:

$emailnotification

and replace with

'$emailnotification'


If there are already single quotes around there, leave it and upload an unhacked user.php