Column count doesn't match value count at row 1

[RedDragon]

thats the error message i get when trying to insert into a table:

	$db->query("DROP TABLE IF EXISTS `".$prefix."restrictions`");
	$db->query("CREATE TABLE `".$prefix."restrictions` (
	  `name` varchar(100) NOT NULL default '',
	  `status` smallint(1) NOT NULL default '0',
	  `settings` smallint(1) NOT NULL default '0',
	  `editmember` smallint(1) NOT NULL default '0',
	  `maintenance` smallint(1) NOT NULL default '0',
	  `skins` smallint(1) NOT NULL default '0',
	  `editforum` smallint(1) NOT NULL default '0',
	  `editbbcode` smallint(1) NOT NULL default '0',
	  `editposticons` smallint(1) NOT NULL default '0',
	  `editsmilies` smallint(1) NOT NULL default '0',
	  `editcensors` smallint(1) NOT NULL default '0',
	  `flash` smallint(1) NOT NULL default '0',
	  `ban` smallint(1) NOT NULL default '0',
	  `cplogopt` smallint(1) NOT NULL default '0',
	  `cplog` smallint(1) NOT NULL default '0',
	  `optimize` smallint(1) NOT NULL default '0',
	  `exec` smallint(1) NOT NULL default '0',
	  `pruneposts` smallint(1) NOT NULL default '0',
	  `prunepms` smallint(1) NOT NULL default '0',
	  `backup` smallint(1) NOT NULL default '0',
	  `newsletter` smallint(1) NOT NULL default '0',
	  `attachsettings` smallint(1) NOT NULL default '0',
	  `listattachments` smallint(1) NOT NULL default '0'
	)");

$db->query("INSERT INTO `".$prefix."restrictions` VALUES ('default', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1)");

please help!!! i cant find the error!

[trooper]

You need to put your values in ' '

HTH

GM

[superwormy]

Trooper is wrong.

That error usually occurs when the number of values you supplied to insert into the record does not match the number of fields in your table.

Make sure the number of values you're inserting matches the number of fields.

Also, a good way around this is to use SET instead of VALUES

INSERT INTO tablename SET field1 = value1, field2 = value2

That way you won't run into this error.

[trooper]

Cheers Superwormy - see thats what happens when you don't read the damn title correctly 😃

[superwormy]

LOL np Trooper, I do stupid stuff like that all the time :-)