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
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
Last edited by ehutch67 on Sat Feb 07, 2009 7:23 am, edited 1 time in total.
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.
I tracked it down to the "date_modified" field in the product table, which reads --
Code: Select all
`date_modified` datetime NOT NULL,
Code: Select all
`date_modified` datetime default NULL,
Fido-X.
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
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.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'.
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Who is online
Users browsing this forum: No registered users and 17 guests