Sql error, again

[Hobbes]

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

[filburt1]

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.

[Hobbes]

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*

[Xenon]

0,,0,0

between the two , there should be a value

[Hobbes]

Today at 04:39 AM Xenon said this in Post #4

0,,0,0

between the two , there should be a value

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

[Xenon]

you have to add a value for example 0

[Hobbes]

??????? sorry i know nothign

[Hobbes]

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]