This documentation will describes how to install Moodle 3.* on your virtual server. Install default PHP extensions for Moodle and configure PHP for optimal server work.
Tag: Mysql 5.7
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