Jump to content

SQL error on query Invalid default value for 'last_connection_date'


Recommended Posts

  • 8 months later...

Yep it is simple, although prestashop in eight months could not be bothered to reply to this topic it makes you wonder if installing this product is wise.

the problem is simple prestashop is not set up to work with mysql 5.7 so I would suggest you move back to 5.6 or 5.5 mysql

  • Like 1
Link to comment
Share on other sites

  • 4 months later...
  • 3 weeks later...

You have to change the sql-mode and remove the STRICT_ALL_TABLES value

 

Thank you very much for this information. For testing purposes, I had to install Prestashop version 1.6.0.11. After I removed "STRICT_ALL_TABLES" of "sql-mode" in the SQL configuration file my.ini, I could easily install.

#sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"
sql-mode="ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"
  • Like 4
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...