MythWeb: Recommended Program SQL Error

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
Posts: 27
Joined: Sun Mar 08, 2015 7:33 pm
United States of America

MythWeb: Recommended Program SQL Error

Post by nello » Mon Jan 18, 2016 6:32 pm

Within MythWeb, when I click on "Recorded Programs" (http://<myth host>/tv/recommended) I get the following error:

Code: Select all

Fatal Error

!!NoTrans: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY program.title ORDER BY program.starttime' at line 13 [#1064]!!

It lists this SQL command as the cause of the error:

Code: Select all

SELECT program.*,
                         UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
                         UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
                         IFNULL(programrating.system, "") AS rater,
                         IFNULL(programrating.rating, "") AS rating,
                  FROM program USE INDEX (id_start_end)
                       LEFT JOIN programrating USING (chanid, starttime)
                       LEFT JOIN channel ON program.chanid = channel.chanid
                       LEFT JOIN credits ON (program.chanid = credits.chanid AND program.starttime = credits.starttime)
                       LEFT JOIN people ON (credits.person = people.person)
                 WHERE program.chanid IN (1021,1022,1051,1052,1071,1072,1073,1091,1092,1093,1111,1112,1113,1114,1201,1202,1203,1231,1232,1233,1241,1243,1244,1245,1246,1247,1261,1262,1263,1264,1265,1321,1381,1382,1383,1384,1385,1386,1411,1412,1441,1442,1481,1482,1501,1502,1503,1504,1571,1601,1602,1603,1621,1622,1623,1624,1661,1662,1663) AND (program.endtime > FROM_UNIXTIME('1453141518') AND program.starttime < FROM_UNIXTIME('1455819918') AND program.starttime != program.endtime) AND ()
GROUP BY program.title ORDER BY program.starttime
I presume that the problem is the empty parentheses after AND in the second to last line of the SQL statement.

Does anyone have any idea what condition is supposed to be within these parentheses? Do I have a configuration error or database problem that's preventing this condition from being specified?

Thank you.

- nello

Posts: 140
Joined: Tue Apr 28, 2015 1:17 pm
Great Britain

Re: MythWeb: Recommended Program SQL Error

Post by mythbuntubox » Mon Jan 18, 2016 10:27 pm

What happens when you go to:


instead of "recommended"?

Can you see a list of your recorded programmes without problems in MythTV frontend?

Post Reply