stylesheets error

[DMS]

Clean installation, a new database (clean).
When I login to the administration panel and open the tab - stylesheets, I see this message:

Code: Select all

SELECT SQL_CALC_FOUND_ROWS DISTINCT S.id FROM db_layout_stylesheets S ORDER BY S.name ASC LIMIT 0, 100 -- Expression #1 of ORDER BY clause is not in SELECT list, references column 'dmss.S.name' which is not in SELECT list; this is incompatible with DISTINCT

so I can not manage the styles. I do not see any style and I can not add.

what is the problem?

OS - Win Server 2008R2 x64
CMS - v2.1.2
Apache - 2.4.18 x64
PHP - 5.6.19 x64
MySQL - 5.7.11 x64

[DMS]

Now install cms v1.12.1. No problem. everything is working.

all 2.x.x version have problem

[velden]

Seems related to http://dev.mysql.com/doc/refman/5.7/en/ ... l_group_by

Not a solution but maybe you can work around that with that information.

[DMS]

solved.
in mysql 5.7 by default use ONLY_FULL_GROUP_BY
need to disable ONLY_FULL_GROUP_BY

my.ini

Code: Select all

sql_mode="NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE"