mySQL Error When Adding Usergroup

[Alexis Bledel]

I've just noticed that there's a mySQL error when I went to add another usergroup on my version 2.3.5 board today:


Database error in vBulletin Control Panel 2.3.5:

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,'Graffitti Designer','Graffitti Designer',0,1,1,1,1,1,0,1,1,1,1,1,1,1,1,1,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

Date: Sunday 19th of September 2004 03:15:53 AM
Script: http://legacy-boards.net/admin/usergroup.php
Referer: http://www.legacy-boards.net/admin/usergroup.php?action=add&


I'm really new to the mySQL databases and queries, so I haven't fiddled with anything besides installing hacks based on .php files. Could anyone please help me in fixing this?

[Colin F]

Search for this in your admin/usergroup.php

INSERT INTO usergroup (candeleteusercomments, usergroupid,title,usertitle,cancontrolpanel,canmod ifyprofile,canviewmembers,canv iew,showgroup,cansearch,canemail,canpostnew,canmov e,canopenclose,candeletethread ,canreplyown,canreplyothers,canviewothers,caneditp ost,candeletepost,canusepm,can postpoll,canvote,canpostattachment,ismoderator,can publicevent,canpublicedit,cant hreadrate,cantrackpm,candenypmreceipts,maxbuddypm, maxforwardpm,canwhosonline,can whosonlineip,cangetattachment)

try deleting the "candeleteusercomments, " from the query, that seems kind of misplaced to me.

[Alexis Bledel]

Thank you for your help! It totally fixed the problem!