database error

[wreck]

one my smods banned a user partly due to personal opinion this person, and i tried unbanning him on the admin cp but get this error


Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: UPDATE user SET birthday='1988-12-26',options='15',usergroupid='2',username='\'FofforO',email='thenewhbk2@aol.com' ,styleid='1',parentemail='',coppauser=0,homepage='http://',icq='',aim='The new hbk2',yahoo='Fofforo101',signature='Bringin the heat',adminemail=1,showemail=0,invisible=0,usertitle='Junior Member',customtitle=0,joindate=UNIX_TIMESTAMP('2004-08-27 13:01:51'),cookieuser=1,nosessionhash=1,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2004-09-10 13:20:06'),lastactivity=UNIX_TIMESTAMP('2004-09-10 13:23:48'),lastpost=UNIX_TIMESTAMP('2004-09-09 21:35:35'),posts='135',timezoneoffset='0',emailnotification=1,receivepm='1',emai lonpm='0',ipaddress='24.215.130.110',pmpopup=IF(pmpopup=2 AND =1,pmpopup,'') WHERE userid=110
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 '=1,pmpopup,'') WHERE userid=110' at line 1

mysql error number: 1064

Date: Friday 10th of September 2004 01:24:10 PM
Script: http://www.rapdome.com/front-linez/forum/admin/user.php
Referer: http://www.front-linez.com/forum/admin/user.php?action=edit&userid=110

[Zachery]

one my smods banned a user partly due to personal opinion this person, and i tried unbanning him on the admin cp but get this error


Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: UPDATE user SET birthday='1988-12-26',options='15',usergroupid='2',username='\'FofforO',email='thenewhbk2@aol.com' ,styleid='1',parentemail='',coppauser=0,homepage='http://',icq='',aim='The new hbk2',yahoo='Fofforo101',signature='Bringin the heat',adminemail=1,showemail=0,invisible=0,usertitle='Junior Member',customtitle=0,joindate=UNIX_TIMESTAMP('2004-08-27 13:01:51'),cookieuser=1,nosessionhash=1,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2004-09-10 13:20:06'),lastactivity=UNIX_TIMESTAMP('2004-09-10 13:23:48'),lastpost=UNIX_TIMESTAMP('2004-09-09 21:35:35'),posts='135',timezoneoffset='0',emailnotification=1,receivepm='1',emai lonpm='0',ipaddress='24.215.130.110',pmpopup=IF(pmpopup=2 AND =1,pmpopup,'') WHERE userid=110
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 '=1,pmpopup,'') WHERE userid=110' at line 1

mysql error number: 1064

Date: Friday 10th of September 2004 01:24:10 PM
Script: http://www.rapdome.com/front-linez/forum/admin/user.php
Referer: http://www.front-linez.com/forum/admin/user.php?action=edit&userid=110
looks like its missing a closing ' maybe?

If your still running 2.2.6 its really time to upgrade to vB3

[wreck]

i dont like vB3 i have yet to find a style on vB3 that looks nice, and ive spent alot of money on custom styles for the vB2 i have, so unless i can use them on it then im really not interested in vB3 :-\

[Zachery]

i dont like vB3 i have yet to find a style on vB3 that looks nice, and ive spent alot of money on custom styles for the vB2 i have, so unless i can use them on it then im really not interested in vB3 :-\
Why dont you like vB3?

You dont like vB.orgs style? how about www.geekydesigns.com/board ? or my new xp style http://www.usshomestarrunner.com/screen.gif

Custom styles can be ported for either the right price or the right ammount of hours spent converting them over.

[nexialys]

Hey Zachery... you're not supposed to advertise your service here... please!