Incorrect datetime value: '' for column 'date_modified' at row 1

Step 1 is all green

When I click continue on Step 2 of 1.0 installation I get this error: Incorrect datetime value: '' for column 'date_modified' at row 1

It will not let me go any further.

The database is created ok, the db column and the .sql match up correctly: date_modified = datetime NULL default NULL

If I try to delete the install folder and go to /index.php I get a mysql error saying install/index.php cannot be found.

This is the date_modified format in my db: 2009-02-02 14:11:14

I got a similar error after removing all the products and categories from the "install/opencart.sql" file for the purpose of having a "clean" install.

I tracked it down to the "date_modified" field in the product table, which reads -- Changing this line (line 1071) to -- fixed it.

Fido-X.

Please open file opencart.sql, find the row 1350 and fill empty value of the field 'date_modified' in the table 'tax_rate'.

dad wrote: Please open file opencart.sql, find the row 1350 and fill empty value of the field 'date_modified' in the table 'tax_rate'.

The "date_modified" field in this table allows for a default value of NULL. The problem is with the "date_modified" field in the product table.