Fatal error: Uncaught Exception: Mysql error:: 1055 (Expression #1 of ORDER BY clause is not in GROUP BY clause..
Posted: Wed Jun 06, 2018 4:17 pm
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)
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