Code: Select all
Incorrect datetime value: '' for column 'date_modified' at row 1
Incorrect datetime value: '' for column 'date_modified' at row 1
Out of range value adjusted for column 'setting_id' at row 1
Out of range value adjusted for column 'setting_id' at row 1
Out of range value adjusted for column 'setting_id' at row 1
............................
File structure.sql:
===================
Change all datetime NOT NULL default '0000-00-00 00:00:00';
to datetime NOT NULL default '1000-01-01 00:00:00';
because '0000-00-00 00:00:00' is incompatible with NOT NULL.
File default.sql:
=================
Same: change all datetime NOT NULL default '0000-00-00 00:00:00';
to datetime NOT NULL default '1000-01-01 00:00:00';
Change 'NULL' --> NULL (without quotes) in all lines for table 'setting' (syntax error)
INSERT INTO `setting` (`setting_id`, `type`, `group`, `key`, `value`) VALUES (NULL, 'catalog', 'footer', 'footer_status', '1');
Modify product 24, add a date_modified value:
INSERT INTO `product` (`product_id`, `quantity`, `min_qty`, `manufacturer_id`, `image_id`, `shipping`, `price`, `sort_order`, `date_added`, `date_modified`, `date_available`, `weight`, `weight_class_id`, `status`, `featured`, `special_offer`, `related`, `sale_end_date`, `sale_start_date`, `special_price`, `tax_class_id`, `viewed`) VALUES ('24', '0', '1', '3', '6', '1', '100.0000', '0', '2009-10-04 10:44:41', '2009-10-04 10:43:02', '2009-10-04 00:00:00', '2.00', '4', '1', '0', '0', '0', '1969-12-31 00:00:00', '1969-12-31 00:00:00', '0.0000', '6', '0');