[fixed] mysql error 1064

[darkjedi]

I did a complete FRESH install of VB 2.2.2 , and have no hacks in usergroup.php at all, and just went to update the non registered users information and again got this error message...

Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: UPDATE usergroup SET title='Unregistered / Not Logged In',usertitle='Guest',cancontrolpanel=0,canmodifyp rofile=0,canviewmembers=0,canview=0,showgroup=,can
search=0,canemail=0,canpostnew=0,canmove=0,canopen close=0,candeletethread=0,canreplyown=0,canreplyot
hers=0,canviewothers=0,caneditpost=0,candeletepost =0,canusepm=0,canpostpoll=0,canvote=0,canpostattac
hment=0,ismoderator=0,canpublicedit=0,canpubliceve nt=0,canthreadrate=0,cantrackpm=0,candenypmreceipt
s=0,maxbuddypm=0,maxforwardpm=0,canwhosonline=0,ca nwhosonlineip=0,cangetattachment=0 WHERE usergroupid=1
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


any ideas ??

[Dirk92GTA]

I get the same error message when I try to update my not Unregistered / Not Logged In user permission thingy. I figured it was perhaps an error in the length of the query. I used PHPMyAdmin to manually edit the Unregistered / Not Logged In user permissions and it worked fine :) But I do think this is a problem.