Fatal error: Uncaught Exception: Mysql error:: 1055 (Expression #1 of ORDER BY clause is not in GROUP BY clause..

Post Reply
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Fatal error: Uncaught Exception: Mysql error:: 1055 (Expression #1 of ORDER BY clause is not in GROUP BY clause..

Post by S_Flash »

SmartCJ Pro V 2.1 Build 201806061720 (Current build: 201806061720 )
PHP Version 7.2.5-0ubuntu0.18.04.1
MySQL Server version: 5.7.22-0ubuntu18.04.1 (Ubuntu)

Code: Select all

Warning: Use of undefined constant a - assumed 'a' (this will throw an Error in a future version of PHP) in /home/user/www/alphavids.com/tube/includes/db_modules/mysql.php on line 57

Fatal error: Uncaught Exception: 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 ('770') AND group_id != 0 AND best_thumb = 'yes') as t /* order by total_ctr desc */ GROUP BY gallery_id, group_id ORDER BY total_ctr DESC . (alphavids.com) in /home/user/www/alphavids.com/tube/includes/db_modules/mysql.php:129 Stack trace: #0 /home/user/www/alphavids.com/tube/includes/db_modules/mysql.php(159): db_error('SELECT gallery_...', 1055, 'Expression #1 o...', 'db_link') #1 /home/user/www/alphavids.com/tube/includes/libs/tpl_functions.php(0): db_query('SELECT gallery_...', 'db_link') #2 /home/user/www/alphavids.com/tube/tube/index.php(0): gallery_get_groups('770') #3 /home/user/www/alphavids.com/ in /home/user/www/alphavids.com/tube/includes/db_modules/mysql.php on line 129
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Fatal error: Uncaught Exception: Mysql error:: 1055 (Expression #1 of ORDER BY clause is not in GROUP BY clause..

Post by admin »

Проведите плз ап, добавлена обработка для новых версий.
Don't forget to run script update
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Re: Fatal error: Uncaught Exception: Mysql error:: 1055 (Expression #1 of ORDER BY clause is not in GROUP BY clause..

Post by S_Flash »

После апа всё норм, только

Quick scj folder check returns following warnings:
includes/libs/tube_parsers/xhamster.com.php is not a part of SCJ. Check it manually
includes/libs/vars.php is not a part of SCJ. Check it manually
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Fatal error: Uncaught Exception: Mysql error:: 1055 (Expression #1 of ORDER BY clause is not in GROUP BY clause..

Post by admin »

Еще раз запустите и будет ок.
Don't forget to run script update
Post Reply