Error: SQLSTATE[HY000]: General error: 1366 Incorrect integer value

Problem:

I installed mysql DB 5.7.19 on my ubuntu server by default. After that, my all PHP projects that used queries with “Insert into integer with value ”” got errors like this:

Error: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ” for column

Continue reading Error: SQLSTATE[HY000]: General error: 1366 Incorrect integer value

Error: SQLSTATE[42000]: Syntax error or access violation

Problem:

I installed mysql DB 5.7.19 on my ubuntu server by default. After that all my PHP projects that used queries with “GROUPING BY” got errors like this:

Error: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY

Continue reading Error: SQLSTATE[42000]: Syntax error or access violation