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='\'Foffo rO',email='thenewhbk2@aol.com',styleid='1',parente mail='',coppauser=0,homepage='http://',icq='',aim='The new hbk2',yahoo='Fofforo101',signature='Bringin the heat',adminemail=1,showemail=0,invisible=0,usertit le='Junior Member',customtitle=0,joindate=UNIX_TIMESTAMP('200 4-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',emailnot ification=1,receivepm='1',emailonpm='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/adm...dit&userid=110

[Zachery]

Originally Posted by 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='\'Foffo rO',email='thenewhbk2@aol.com',styleid='1',parente mail='',coppauser=0,homepage='http://',icq='',aim='The new hbk2',yahoo='Fofforo101',signature='Bringin the heat',adminemail=1,showemail=0,invisible=0,usertit le='Junior Member',customtitle=0,joindate=UNIX_TIMESTAMP('200 4-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',emailnot ification=1,receivepm='1',emailonpm='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/adm...dit&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]

Originally Posted by 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 :-\

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.

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