CMS MADE SIMPLE FORGE

LISE

 
Back Back to List

[#12039] Orderby doesn't work with mysql 5.7+

avatar
Created By: blast blast (blast)
Date Submitted: Mon May 13 19:19:48 -0400 2019

Assigned To: Fernando Morgado (JoMorg)
Version: 1.3.1
CMSMS Version: 2.2.10
Severity: Major
Resolution: None
State: Open
Summary:
Orderby doesn't work with mysql 5.7+
Detailed Description:
It's impossibile to use orderby="custom_field" with mysql 5.7+ (mine is 5.7.26)

Error is:
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
nonaggregated column 'dbname.VALn.value' which is not functionally dependent on
columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by

This is very sad because most of providers doesn't permit sql_mode (strict)
modifications.

Also filter actions doesn't works anymore.

Any suggestion?


History

Comments
avatar 
Date: 2019-07-03 12:06
Posted By: blast blast (blast)

Any ideas?