Details
-
Type:
Task
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 4.0.0-b6
-
Component/s: None
-
Labels:None
Description
For users using MySQL 5.7.5 or greater, it is possible to encounter an error, e.g.:
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'temp.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
This is caused by a change in MySQL 5.7.5 that added the ONLY_FULL_GROUP_BY option to sql-mode, removing backward-compatibility with older versions of MySQL that default to MySQL's relaxed GROUP BY ruleset.
This can be resolved by updating the sql-mode in your MySQL configuration file to remove the ONLY_FULL_GROUP_BY option.
You can fetch your current sql-mode options via:
SELECT @@GLOBAL.sql_mode;
For this task, we will likely need to update the database configuration details in Blesta to set a specific sql-mode by default (e.g. TRADITIONAL).
