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).
Activity
Tyson Phillips (Inactive)
created issue -
Tyson Phillips (Inactive)
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Rank | Ranked higher |
Tyson Phillips (Inactive)
made changes -
| Link | This issue is duplicated by CORE-2285 [ CORE-2285 ] |
Tyson Phillips (Inactive)
made changes -
| Fix Version/s | 4.0.0-b6 [ 11005 ] |
Tyson Phillips (Inactive)
made changes -
| Assignee | Tyson Phillips [ tyson ] |
Tyson Phillips (Inactive)
made changes -
| Fix Version/s | Short Term [ 10800 ] |
Tyson Phillips (Inactive)
made changes -
| Sprint | 4.0.0 Sprint 18 [ 36 ] |
Tyson Phillips (Inactive)
made changes -
| Rank | Ranked higher |
Tyson Phillips (Inactive)
made changes -
| Rank | Ranked lower |
Tyson Phillips (Inactive)
made changes -
| Summary | MySQL 5.7.5+ set-mode should remove ONLY_FULL_GROUP_BY option | MySQL 5.7.5+ sql-mode should remove ONLY_FULL_GROUP_BY option |
Automated transition triggered when Tyson Phillips (Inactive) created a branch in Stash -
| Status | Open [ 1 ] | In Progress [ 3 ] |
Automated transition triggered when Tyson Phillips (Inactive) created pull request #232 in Stash -
| Status | In Progress [ 3 ] | In Review [ 5 ] |
| Resolution | Fixed [ 1 ] |
Automated transition triggered when Tyson Phillips (Inactive) merged pull request #232 in Stash -
| Status | In Review [ 5 ] | Closed [ 6 ] |
Tyson Phillips (Inactive)
made changes -
| Link | This issue relates to CORE-2351 [ CORE-2351 ] |