Column count not matching, completely confuzzled

CloudedVision · Mar 20th, 2008, 23:35

I've been trying to insert a value into a table with this:

INSERT INTO `page` VALUES('2','asdfasdf','0','','2','1','20080320193013','20080320193013')

But I get the following error: Incorrect integer value: '' for column 'parent' at row 1

I figured the timestamps might be messing it up, but I've tried it with one of them and none of them, still doesn't work. Any help? This is the table:

Code: Select all

DROP TABLE IF EXISTS `divaba_development`.`page`;
CREATE TABLE  `divaba_development`.`page` (
  `id` smallint(5) unsigned NOT NULL,
  `name` varchar(20) default NULL,
  `type` tinyint(4) default NULL,
  `parent` smallint(5) unsigned default NULL,
  `order` smallint(5) unsigned default NULL,
  `nav` tinyint(3) unsigned default NULL,
  `updated_at` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL default '0000-00-00 00:00:00',
  UNIQUE KEY `id` (`id`),
  KEY `parent` (`parent`),
  KEY `order` (`order`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;