Helpful Information
 
 
Category: vBulletin 3 Discussion
mysql error number: 1064

Database error in vBulletin Control Panel 2.2.2:
I got this error when I was trying to modefy the Users group access in my board


Invalid SQL: UPDATE usergroup SET title='Users Awaiting Email Confirmation',usertitle='',cancontrolpanel=0,canmodifyprofile=0,canviewmembers=0 ,canview=0,showgroup=,cansearch=0,canemail=0,canpostnew=0,canmove=0,canopenclose =0,candeletethread=0,canreplyown=0,canreplyothers=0,canviewothers=0,caneditpost= 0,candeletepost=0,canusepm=0,canpostpoll=0,canvote=0,canpostattachment=0,ismoder ator=0,canpublicedit=0,canpublicevent=0,canthreadrate=0,cantrackpm=0,candenypmre ceipts=0,maxbuddypm=0,maxforwardpm=0,canwhosonline=0,canwhosonlineip=0,cangetatt achment=0 WHERE usergroupid=3
mysql error: You have an error in your SQL syntax near 'cansearch=0,canemail=0,canpostnew=0,canmove=0,canopenclose=0,candeletethread=0, c' at line 1

mysql error number: 1064

Date: Wednesday 04th of September 2002 12:22:04 AM
Script: http://www.******.com/***/***/admin/usergroup.php
Referer: http://*******.******.net:2086/scripts/command


Please help me , am running vB 2.2.2 on a Dual Pentium III 1G | Linux 2.4.18-pre3 | Apache 1.3.20 (Unix) | mod_bwlimited 1.0 | PHP 4.0.6 | mod_log_bytes 0.3 | FrontPage 5.0.2.2510 | mod_ssl 2.8.4 | OpenSSL 0.9.6

first off vb2.2.2 is extremely unstable i believe... you should upgrade immediately... as for your problem it has to do with the selecting of a query that has no value... hope that helps... regards...

g-force2k2

The problem is that your host recently upgraded to PHP 4.2.x which broke older versions of vB. You will need to upgrade to vB 2.2.7 to fix this and other problems.










privacy (GDPR)