Return to Answer

Fixed the formatting

Source Link

edit approved Nov 26, 2015 at 22:22

We have the same problem. MysqlMySQL version (Ver 14.14 Distrib 5.7.9, for osx10.11 (x86_64) using EditLine wrapper)

Had problems "SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression"SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression and by adding the code at my.cnf file resolved it for me :

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

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

We have the same problem. Mysql version (Ver 14.14 Distrib 5.7.9, for osx10.11 (x86_64) using EditLine wrapper)

Had problems "SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression" and by adding the code at my.cnf file resolved it for me :

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

We have the same problem. MySQL version (Ver 14.14 Distrib 5.7.9, for osx10.11 (x86_64) using EditLine wrapper)

Had problems SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression and by adding the code at my.cnf file resolved it for me:

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

Source Link

created Nov 24, 2015 at 2:50

Joniel Roy Rosales

We have the same problem. Mysql version (Ver 14.14 Distrib 5.7.9, for osx10.11 (x86_64) using EditLine wrapper)

Had problems "SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression" and by adding the code at my.cnf file resolved it for me :

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