CMS MADE SIMPLE FORGE

CGCalendar

 
Back Back to List

[#12061] The list view does not work if MySQL database server version is greater than 5.7

avatar
Created By: Gabor Horvath (zsiri)
Date Submitted: Mon Jul 01 11:09:55 -0400 2019

Assigned To:
Version: 2.5
CMSMS Version: 2.2.10
Severity: Critical
Resolution: None
State: Open
Summary:
The list view does not work if MySQL database server version is greater than 5.7
Detailed Description:
I found that the list works well on one server, but the other doesn't work with
the same content. The difference is that MySQL version 5.6 on the first server
and 5.7 on the other.

Newer database server error message:
"ERROR 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list,
references column '[database].E.event_date_start' which is not in SELECT list;
this is incompatible with DISTINCT"

Please take a look at the error.
thanks
Gabor


History