Mysql error:: 1055

[demod]

Поставил скрипт с нуля, на новый сервер.

Добавил тестовые галеры в zip'ах.

Тумбы создались, никаких ошибок нету, кроме тоого как когда заходишь на саму галерею, например

http://******.com/gallery/first-galley/index.html

вылазит такая ошибка

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1055 (Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 't.total_ctr' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by) (db_link) in query SELECT gallery_id, group_id FROM (SELECT gallery_id, group_id, total_ctr FROM rot_gallery_stats1 WHERE gallery_id IN ('6') AND group_id != 0 order by total_ctr desc) as t GROUP BY gallery_id, group_id ORDER BY total_ctr DESC . (website.com) ' in /home/user/website.com/www/public_html/scj/includes/db_modules/mysql.php:72 Stack trace: #0 /home/user/website.com/www/public_html/scj/includes/db_modules/mysql.php(103): db_error('SELECT gallery_...', 1055, 'Expression #1 o...', 'db_link') #1 /home/user/website.com/www/public_html/scj/includes/libs/tpl_functions.php(0): db_query() #2 /home/user/website.com/www/public_html/scj/tube/index.php(0): gallery_get_groups() #3 /home/user in /home/user/website.com/www/public_html/scj/includes/db_modules/mysql.php on line 72

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.7.17-0ubuntu0.16.04.1 - (Ubuntu)
Protocol version: 10
User: user@localhost
Server charset: UTF-8 Unicode (utf8)

Apache/2.4.18 (Ubuntu)
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
PHP extension: mysqli Documentation
PHP version: 5.6.30-7+deb.sury.org~xenial+1

[admin]

Надов мускле отключить

sql_mode=only_full_group_by