id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,mlocked 12713,Mythweb fails with mysql Server version: 5.7.11-0ubuntu5,jksjdevelop@…,Karl Egly,"After today's update of XenialXerus 08/04/16 4.4.0-17-generic #33-Ubuntu SMP Tue Mar 29 17:17:28 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux. Mythweb (latest) fails. MythTV Version : v0.28-rc1-3-g2520617 MythTV Branch : fixes/0.28 Network Protocol : 88 Library API : 0.28.20160309-1 QT Version : 5.5.1 mythweb 94ec03ada41da6ab7883b0eb037ea58239f05913 Sat Mar 5 I think this is due to Xenial forcing an upgrade of mysql server from 5.6 to 5.7. The Listings and Recordings pages fail but all others are ok. Listings fail with this error:- Error Fatal Error !!NoTrans: SQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.channel.chanid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [#1055]!! Recorded fails with this error Fatal Error !!NoTrans: SQL Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.recordedmarkup.data' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [#1055]!! ",Bug Report - General,closed,minor,0.28.1,Plugin - MythWeb,0.28.0,medium,Fixed,,,0