PDA

View Full Version : database error


wreck
10 Sep 2004, 17:28
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
10 Sep 2004, 18:23
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
11 Sep 2004, 13:43
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
11 Sep 2004, 16:17
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
11 Sep 2004, 17:05
Hey Zachery... you're not supposed to advertise your service here... please!