PDA

View Full Version : mysql error number: 1064


mIRCnet
09-03-2002, 07:35 PM
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,canmo difyprofile=0,canviewmembers=0,canview=0,showgroup =,cansearch=0,canemail=0,canpostnew=0,canmove=0,ca nopenclose=0,candeletethread=0,canreplyown=0,canre plyothers=0,canviewothers=0,caneditpost=0,candelet epost=0,canusepm=0,canpostpoll=0,canvote=0,canpost attachment=0,ismoderator=0,canpublicedit=0,canpubl icevent=0,canthreadrate=0,cantrackpm=0,candenypmre ceipts=0,maxbuddypm=0,maxforwardpm=0,canwhosonline =0,canwhosonlineip=0,cangetattachment=0 WHERE usergroupid=3
mysql error: You have an error in your SQL syntax near 'cansearch=0,canemail=0,canpostnew=0,canmove=0,can openclose=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

g-force2k2
09-03-2002, 08:34 PM
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

Steve Machol
09-04-2002, 04:02 AM
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.