The Arcive of vBulletin Modifications Site. |
|
Probelm (mysql error 1136) Details »»
|
|||||||||||||||||||||||||
Hi,
I get this error when I try to add or update a warning type: Database error in vBulletin 3.0.6: Invalid SQL: insert into warning_types values( '', 'Cyber', '5', 'Anything related to cyber including agreeing to and asking for', '99999', 'No', 'Yes', 'No', '' ) mysql error: Column count doesn't match value count at row 1 mysql error number: 1136 Date: Thursday 09th of June 2005 05:07:41 PM Script: http://www.realmfighter.com/forums/a...admin_warn.php Also, I if it helps I ran the query "describe warning_types" and this information came up: tid int(15) PRI NULL auto_increment warn_name varchar(255) warn_points int(15) 0 warn_desc text warn_maturity int(5) YES NULL warn_permban char(3) YES NULL warn_type char(3) YES NULL Show Your Support
|
|||||||||||||||||||||||||
| Comments |
|
#2
|
|||
|
|||
|
First of all, I do not know which version of AWS you are running, but it looks as if your warning_types table is missing some columns. Add them using the following queries:
ALTER TABLE `warning_types` ADD COLUMN `warn_alert` char(3) ALTER TABLE `warning_types` ADD COLUMN `warn_alertcomment` mediumtext Remember to add any prefix you might be using in front of the table name. |
|
#3
|
|||
|
|||
|
vB 2.3.2?? This is a vB3 hack.
|
|
#4
|
||||
|
||||
|
Yeah, I saw that after I posted. The error numbers were the same so it pulled it up in a search so... heh ah well.
|
![]() |
|
|