id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
13097	SQL Error on MythWeb When Viewing Listing or Recorded Programs	ctd.mh3@…	Peter Bennett	"The following error (with details in the attachment) is now shown when selecting ""Listening"" from the MythWeb UI.

Fatal Error

!!NoTrans: SQL Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.program.endtime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [#1055]!!

Similar error occurs when selecting ""Recorded Programs"":

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]!!

Using latest mythtv from mythbuntu repository.
"	Bug Report - General	closed	minor	0.28.1	MythTV - Web Frontend	0.28.0	medium	Duplicate			0