Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-2218

MySQL 5.7.5+ sql-mode should remove ONLY_FULL_GROUP_BY option

    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

          People

          • Assignee:
            tyson Tyson Phillips (Inactive)
            Reporter:
            tyson Tyson Phillips (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              3/Mar/17

              Agile