The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
SQL Error when adding a new usergroup.
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/.../usergroup.php Referer: http://www.winespringinn.com/forums/...hp?action=add& Repair Report: This type of error cannot be automatically repaired. |
#2
|
||||
|
||||
your inserting either too many or too few items into the row
|
#3
|
||||
|
||||
How? I'm making sure every item is selected how I wish it.
|
#4
|
||||
|
||||
35 rows, but only 34 values =)
|
#5
|
||||
|
||||
**EDIT***
Nevermind, I figured it out. Thanks everyone for pointing me in the right direction. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|