PDA

View Full Version : Probelm (mysql error 1136)


JJB2004
06-09-2005, 03:11 PM
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/admincp/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

sv1cec
06-10-2005, 05:04 AM
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.

sv1cec
08-25-2005, 04:16 AM
vB 2.3.2?? This is a vB3 hack.

ChAiN LeTtEr
08-25-2005, 04:18 AM
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.