Database Error when in Admins

[darkjedi]

I tried to update the settings for the unregistered/not logged in group...and this is the error I get !

Any ideas ? I'm lost !!

Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: UPDATE usergroup SET title='Unregistered / Not Logged In',usertitle='Guest',cancontrolpanel=0,canmodifyp rofile=0,canviewmembers=0,canview=1,showgroup=,can search=0,canemail=1,canpostnew=0,canmove=0,canopen close=0,candeletethread=0,canreplyown=0,canreplyot hers=0,canviewothers=1,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=1,canpostnew=0,canmove=0,can openclose=0,candeletethread=0,c' at line 1

mysql error number: 1064

Date: Wednesday 06th of February 2002 02:26:40 PM
Script: http://www.allexotics.com/vb/vb/admin/usergroup.php
Referer: http://www.allexotics.com/vb/admin/usergroup.php?action=edit&usergroupid=1

[tubedogg]

Have you hacked usergroup.php at all?
Alternatively try upgrading to 2.2.2.

[darkjedi]

Ok, this took me awhile but....

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 ??

[darkjedi]

This is the error that was emailed to me as well....

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=1,canviewmembers=1,canview=0,showgroup=,can search=1,canemail=1,canpostnew=0,canmove=0,canopen close=0,candeletethread=0,canreplyown=0,canreplyot hers=0,canviewothers=1,caneditpost=0,candeletepost =0,canusepm=0,canpostpoll=0,canvote=0,canpostattac hment=0,ismoderator=0,canpublicedit=0,canpubliceve nt=0,canthreadrate=1,cantrackpm=0,candenypmreceipt s=0,maxbuddypm=0,maxforwardpm=0,canwhosonline=0,ca nwhosonlineip=0,cangetattachment=1 WHERE usergroupid=1
mysql error: You have an error in your SQL syntax near 'cansearch=1,canemail=1,canpostnew=0,canmove=0,can openclose=0,candeletethread=0,c' at line 1

mysql error number: 1064

[darkjedi]

I believe i posted this in the wrong area, so i'm asking again here, but only linking to the original post...

DATA BASE ERROR WHEN UPDATING USER GROUP INFO (http://vbulletin.com/forum/showthread.php?s=&threadid=39179)

[darkjedi]

Any ideas ?? anybody ??

[darkjedi]

bumping...still unresolved :-(

[Steve Machol]

What's the URL to your forums? Also you might want to fill out an official support request at:

http://www.vbulletin.com/members/support.php

Be sure to include the info to access your Admin CP, phpMyAdmin and FTP.

[darkjedi]

sorry, we just moved them recently....hadn't updated the link yet !

http://www.kritter-korner.org

I'll be sure to put in a support request, thanks !

[Steve Machol]

Actually because you have hacked your forum (with vBPortal) there's not really anything Support can do to help you. You can try uninstalling the hack first, but I belive that's a difficult thing to do with vBPortal because of changes to the db. You can also try asking for help on the vBPortal forums. Good luck!

[darkjedi]

thanks again ....

guess I'll just let it go then....it was this way before the vbportal hack, but it's not a major problem, for anyone but me LOL