Opened 3 years ago

Closed 3 years ago

#12824 closed Bug Report - General (Duplicate)

Using Mythweb to view TV listings

Reported by: mythtv.mark.khsecure@… Owned by: Stuart Auchterlonie
Priority: minor Milestone: 0.28.1
Component: Plugin - MythWeb Version: 0.28.0
Severity: medium Keywords:
Cc: Ticket locked: no

Description

I launched Mythweb using a URL of 192.168.2.107/mythweb.

If I click on the "Listings" or "Recorded Programs" menu items I get an error reported. All other menu items work correctly. I have attached backtrace files for each menu item error.

Regards Kevan Harding

Attachments (2)

listings-backtrace (9.5 KB) - added by mythtv.mark.khsecure@… 3 years ago.
recorded-programs-backtrace (10.0 KB) - added by mythtv.mark.khsecure@… 3 years ago.

Download all attachments as: .zip

Change History (7)

Changed 3 years ago by mythtv.mark.khsecure@…

Attachment: listings-backtrace added

Changed 3 years ago by mythtv.mark.khsecure@…

Attachment: recorded-programs-backtrace added

comment:1 Changed 3 years ago by mythtv.mark.khsecure@…

Here is the error text that preceeds each backtrace listing. For "Listings" it is:

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

and for "Recorded Programs" it is:

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

comment:2 Changed 3 years ago by Stuart Auchterlonie

Milestone: unknown0.28.1

Have you updated mythweb packages to the latest as well? We have already fixed a number of issues in this area.

Regards Stuart

comment:3 Changed 3 years ago by sphery

Resolution: Duplicate
Status: newclosed

comment:4 Changed 3 years ago by sphery

Resolution: Duplicate
Status: closednew

Leaving this one open for recordedmarkup.data in recorded programs (which doesn't seem to be fixed, yet)

comment:5 Changed 3 years ago by sphery

Resolution: Duplicate
Status: newclosed

Closing this as a dup of #12811 . Even though it's a different location in MythWeb/different database query/field, all of these are really duplicates in that they will be fixed the same way--by specifying a session sql_mode, as we do in MythTV's C++ code. There's a patch on #12811 and we just need it tested and confirmed working (without other changes to MySQL or workarounds) by someone who's using a sufficiently new MySQL so it can be included in MythWeb.

Note: See TracTickets for help on using tickets.