Sql error, again

[Hobbes]

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


*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...

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

*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 (https://vborg.vbsupport.ru/showthread.php?postid=405107#post405107)
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:

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