Opened 8 years ago
Closed 8 years ago
#12824 closed Bug Report - General (Duplicate)
Using Mythweb to view TV listings
Reported by: | 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)
Change History (7)
Changed 8 years ago by
Attachment: | listings-backtrace added |
---|
Changed 8 years ago by
Attachment: | recorded-programs-backtrace added |
---|
comment:1 Changed 8 years ago by
comment:2 Changed 8 years ago by
Milestone: | unknown → 0.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 8 years ago by
Resolution: | → Duplicate |
---|---|
Status: | new → closed |
comment:4 Changed 8 years ago by
Resolution: | Duplicate |
---|---|
Status: | closed → new |
Leaving this one open for recordedmarkup.data in recorded programs (which doesn't seem to be fixed, yet)
comment:5 Changed 8 years ago by
Resolution: | → Duplicate |
---|---|
Status: | new → closed |
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.
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!!