Gallery pages - Mysql error:: 1055

Post Reply
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Gallery pages - Mysql error:: 1055

Post by alexscj »

Hello,

getting a mysql error on all gallery pages:

" 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 ('659417') AND group_id != 0 order by total_ctr desc) as t GROUP BY gallery_id, group_id ORDER BY total_ctr DESC . (www.DOMAIN.NAME) ' in /home/USER/DOMAIN.NAME/scj/includes/db_modules/mysql.php:72 Stack trace: #0 /home/USER/DOMAIN.NAME/scj/includes/db_modules/mysql.php(103): db_error('SELECT gallery_...', 1055, 'Expression #1 o...', 'db_link') #1 /home/USER/DOMAIN.NAME/scj/includes/libs/tpl_functions.php(0): db_query('SELECT gallery_...', 'db_link') #2 /home/USER/DOMAIN.NAME/scj/tube/index.php(0): gallery_get_groups('6594 in /home/USER/DOMAIN.NAME/scj/includes/db_modules/mysql.php on line 72 "

* TCMS build 201711200530
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Gallery pages - Mysql error:: 1055

Post by admin »

Hi,

there are 2 option:

1. quick - turn off sql_mode=only_full_group_by in mysql config
2. PM me ftp access - i'll check mysql and script settings
Don't forget to run script update
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Gallery pages - Mysql error:: 1055

Post by alexscj »

The quick option fixed it, thanks!
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Gallery pages - Mysql error:: 1055

Post by admin »

NP
Don't forget to run script update
Post Reply