Opened 3 years ago

Closed 3 years ago

#12896 closed Bug Report - General (Fixed)

MythTV Statistics Page Error

Reported by: drmchsr87@… Owned by:
Priority: minor Milestone: unknown
Component: MythTV - General Version: Unspecified
Severity: medium Keywords:
Cc: Ticket locked: no

Description

When looking up statistics, I get an SQL error: !NoTrans: SQL Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.channel.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by #1055!!

Attachments (1)

Mythweb_stats Error - 2016-1009.pdf (507.4 KB) - added by drmchsr87@… 3 years ago.
Myth Statistics Error Output

Download all attachments as: .zip

Change History (4)

Changed 3 years ago by drmchsr87@…

Myth Statistics Error Output

comment:1 Changed 3 years ago by drmchsr87@…

I get this error for Myth Statistics since the upgrade to Ubuntu 16.04 LTS from 14.04 LTS. I am running MythTV v0.28-69-g8580a41, but this was happening before this version of MythTV (but always since I had v0.28). It started happening after the Ubuntu upgrade, which was done about two weeks after upgrading from v0.27 to v0.28.

comment:2 Changed 3 years ago by Peter Bennett

see #12811

comment:3 Changed 3 years ago by Peter Bennett

Resolution: Fixed
Status: newclosed
Note: See TracTickets for help on using tickets.