Post by ehutch67 » Sat Feb 07, 2009 7:19 am

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
Last edited by ehutch67 on Sat Feb 07, 2009 7:23 am, edited 1 time in total.

Newbie

Posts

Joined
Fri Feb 06, 2009 10:15 am

Post by fido-x » Sat Feb 07, 2009 9:26 am

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 --

Code: Select all

`date_modified` datetime NOT NULL,
Changing this line (line 1071) to --

Code: Select all

`date_modified` datetime default NULL,
fixed it.

Fido-X.

Image
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!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by dad » Sat Feb 07, 2009 9:28 am

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

dad
New member

Posts

Joined
Tue May 27, 2008 4:30 am

Post by fido-x » Sat Feb 07, 2009 9:35 am

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.

Image
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!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia
Who is online

Users browsing this forum: No registered users and 21 guests