Sql error, again
 

[sql]Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO usergroup (candeleteusercomments,usergroupid,title,usertitle ,cancontrolpanel,canmodifyprofile,canviewmembers,c anview,showgroup,cansearch,canemail,canpostnew,can move,canopenclose,candeletethread,canreplyown,canr eplyothers,canviewothers,caneditpost,candeletepost ,canusepm,canpostpoll,canvote,canpostattachment,is moderator,canpublicevent,canpublicedit,canthreadra te,cantrackpm,candenypmreceipts,maxbuddypm,maxforw ardpm,canwhosonline,canwhosonlineip,cangetattachme nt)
VALUES (NULL,'Banned Database Error','Data Error',0,1,1,1,0,1,0,0,0,0,0,0,0,1,0,0,1,1,1,1,0,0 ,0,1,0,0,0,0,1,0,1)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136
[/sql]

*cries*....any idea? :(

You're trying to insert more or less values for the number of columns you entered. It also happens to be a bug in my User COmments hack, so see the support thread.

alright, i fixed what was said in the support thread, but now...

[sql]Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO usergroup (candeleteusercomments,usergroupid,title,usertitle ,cancontrolpanel,canmodifyprofile,canviewmembers,c anview,showgroup,cansearch,canemail,canpostnew,can move,canopenclose,candeletethread,canreplyown,canr eplyothers,canviewothers,caneditpost,candeletepost ,canusepm,canpostpoll,canvote,canpostattachment,is moderator,cancalendar,canpublicevent,canpublicedit ,canthreadrate,cantrackpm,candenypmreceipts,maxbud dypm,maxforwardpm,canwhosonline,canwhosonlineip,ca ngetattachment)
VALUES (NULL,'Banned Database Error','Data Error',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,, 0,0,0,0,0,0,0,0,0,0)
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 '0,0,0,0,0,0,0,0,0,0)' at line 2

mysql error number: 1064[/sql]

*tear*

between the two , there should be a value

any idea how to fix that?? < / n00bish >

you have to add a value for example 0

??????? :( sorry i know nothign :(

bummmp....how do i add a value :(


EDIT:

[sql]Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO usergroup (candeleteusercomments, usergroupid,title,usertitle,cancontrolpanel,canmod ifyprofile,canviewmembers,canview,showgroup,cansea rch,canemail,canpostnew,canmove,canopenclose,cande letethread,canreplyown,canreplyothers,canviewother s,caneditpost,candeletepost,canusepm,canpostpoll,c anvote,canpostattachment,ismoderator,canpubliceven t,canpublicedit,canthreadrate,cantrackpm,candenypm receipts,maxbuddypm,maxforwardpm,canwhosonline,can whosonlineip,cangetattachment)
VALUES (NULL,'Banned Database Error','Data Error',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136[/sql]