Prestashop 1.6 unable to add employee

Question

I have Prestashop 1.6 and I am unable to add new employee because of this error

... employee (Incorrect date value: '0000-00-00' for column 'stats_compare_from' at row 1)

version is 1.6.0.9 on php 5.3 apache 2.2 and mysql 5.7 deployed on jelastic cloudlets

tried to google for solution but there is no such error

thanks for help

score 2 · Accepted Answer · edited May 23 '17 at 10:30

2

This error is usually related to MySQL strict mode.

You can see how you can set TRADITIONAL mode here: MySQL: Setting sql_mode permanently

edited May 23 '17 at 10:30

Community

answered Jan 05 '15 at 00:23

score 0 · Answer 2 · answered Jan 08 '17 at 16:55

On my Ubuntu 16.04 i did this:

Open mysql config like so sudo vim /etc/mysql/my.cnf
Created [mysql] block and added the configuration like so (its possible that you already have mysql block, in that case just add line starting with "sql_mode=.."):

[mysqld] sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

2 Answers2