Can someone please help me i get this error when i update someones profile in the AdminCP
Code:
Database error in vBulletin Control Panel 2.2.4:
Invalid SQL: UPDATE user SET away='0',awaydate=UNIX_TIMESTAMP('1970-01-01 01:00:00'),returndate='0000-00-00',awayreason='',birthday='0000-00-00',options='15',usergroupid='2',username='testing',email='',styleid='1',parentemail='',coppauser=0,homepage='http://www.',icq='',aim='',yahoo='',signature='',adminemail=,showemail,showemail=1,invisible=0,usertitle='Trial Member<br><img src=\"http://www.board.com/forums/images/0stars.gif\">',customtitle=0,joindate=UNIX_TIMESTAMP('2002-09-04 22:38:54'),cookieuser=1,nosessionhash=0,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2002-09-05 01:09:35'),lastactivity=UNIX_TIMESTAMP('2002-09-05 01:09:35'),lastpost=UNIX_TIMESTAMP('2002-09-05 01:00:34'),posts='10',timezoneoffset='0',emailnotification=1,receivepm='1',emailonpm='0',ipaddress='',pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=332
mysql error: You have an error in your SQL syntax near 'showemail,showemail=1,invisible=0,usertitle='Trial Member<br><img src=\"http://w' at line 1
mysql error number: 1064
Date: Thursday 05th of September 2002 10:52:40 PM
Script: http://www.board.com/forums/forums/admin/user.php
Referer: http://www.board.com/forums/admin/us...dit&userid=332
09-05-2002, 09:01 PM
User.php Problem :( Please Help.
Threaded Mode