Project

General

Profile

Bug #8029

MYSQL 5.7 error incompatible with sql_mode=only_full_group_by,

Added by Julio Montoya almost 4 years ago. Updated over 3 years ago.

Status:
Bug resolved
Priority:
Normal
Assignee:
Category:
Database & API changes
Target version:
Start date:
05/01/2016
Due date:
% Done:

100%

Estimated time:
Complexity:
Normal
SCRUM pts - complexity:
?

Description

I'm using this version of mysql:

Server version: 5.7.10 MySQL Community Server (GPL)

And I have some error with

An exception occurred while executing '
SELECT * FROM settings_current\n            WHERE access_url = 1    AND category='search_setting'  GROUP BY variable ORDER BY id ASC':\n\nSQLSTATE[42000]: 

Syntax error or access violation: 
1055 Expression #1 of 
SELECT list is not in GROUP BY clause and contains nonaggregated column 'chamilo.settings_current.id' which is not functionally dependent on columns in GROUP BY clause; 

this is incompatible with sql_mode=only_full_group_by, 

referer: http://localhost/chamilo/main/admin/

Question is do you have the same errors? :)


Related issues

Related to Chamilo LMS - Bug #8189: Instalar Chamilo 1.10.4 (problemas con MySQL 5.7)Rejected - Abandoned07/04/2016

Actions

Associated revisions

Revision 0755fb60 (diff)
Added by Julio Montoya almost 4 years ago

Remove non deterministic "group by" see #8029

History

#1

Updated by Julio Montoya almost 4 years ago

  • Status changed from New to Needs more info
  • Assignee deleted (Julio Montoya)
#2

Updated by Julio Montoya almost 4 years ago

MySQL 5.7.5: GROUP BY respects functional dependencies:

http://rpbouman.blogspot.fr/2014/09/mysql-575-group-by-respects-functional.html

#3

Updated by Julio Montoya almost 4 years ago

This problem appears for MySQL version >= 5.7.5

#4

Updated by Julio Montoya almost 4 years ago

  • Subject changed from mysql errors? to MYSQL error incompatible with sql_mode=only_full_group_by,
#5

Updated by Yannick Warnier almost 4 years ago

  • Status changed from Needs more info to Bug resolved
  • Assignee set to Julio Montoya
  • % Done changed from 0 to 100

I don't have MySQL 5.7 so I couldn't test, but I think it's safe to consider it OK

#6

Updated by Julio Montoya over 3 years ago

  • Subject changed from MYSQL error incompatible with sql_mode=only_full_group_by, to MYSQL 5.7 error incompatible with sql_mode=only_full_group_by,
#7

Updated by Julio Montoya over 3 years ago

Note: To ignore those errors a sql query should be run in the "Database::connect()" function :

$connection->executeQuery('set sql_mode=""');

Also available in: Atom PDF