Probelm (mysql error 1136)
 

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

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.

vB 2.3.2?? This is a vB3 hack.

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.