PDA

View Full Version : SQL Error when adding a new usergroup.


Mike Gaidin
04-20-2003, 09:31 PM
I get this error when I try to add a new usergroup to my forums. Has anyone seen this before? Thanks! :)


Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: INSERT INTO usergroup (usergroupid,title,usertitle,cancontrolpanel,canmo difyprofile,canviewmembers,canview,showgroup,canse arch,canemail,canpostnew,canmove,canopenclose,cand eletethread,canreplyown,canreplyothers,canviewothe rs,caneditpost,candeletepost,canusepm,canpostpoll, canvote,canpostattachment,ismoderator,canpubliceve nt,canpublicedit,canthreadrate,cantrackpm,candenyp mreceipts,maxbuddypm,maxforwardpm,canwhosonline,ca nwhosonlineip,cangetattachment,candeleteusercommen ts)
VALUES (NULL,'Reporters','Reporter',0,1,1,1,1,1,0,1,0,0,0 ,1,1,1,0,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 20th of April 2003 05:41:59 PM
Script: http://www.winespringinn.com/forums/forums/admin/usergroup.php
Referer: http://www.winespringinn.com/forums/admin/usergroup.php?action=add&
Repair Report: This type of error cannot be automatically repaired.

mr e
04-20-2003, 11:05 PM
your inserting either too many or too few items into the row

Mike Gaidin
04-21-2003, 12:46 AM
How? I'm making sure every item is selected how I wish it.

Kriek
04-21-2003, 02:10 AM
35 rows, but only 34 values =)

Mike Gaidin
04-21-2003, 02:27 AM
**EDIT***

Nevermind, I figured it out. :D

Thanks everyone for pointing me in the right direction. :D