LinHES Forums
http://forum.linhes.org/

Mythweb not showing program guide
http://forum.linhes.org/viewtopic.php?f=17&t=8976		 Page 1 of 1
Author:  blackc2004 [ Tue Mar 14, 2006 9:59 pm ]
Post subject:  Mythweb not showing program guide
Hi.
I just installed a fresh version of Knoppmyth (SCALE version) and mythweb is not showing any program data, however mythfilldatabase has filled the DB and the program data is showing up on mythfrontend.

Any ideas?

Thanks!
Author:  blackc2004 [ Fri Mar 17, 2006 11:35 am ]
Post subject: 
Hi, I'm still having this issue, is anyone else experiencing problems?

I have found that the following query is returning 0 rows;
SELECT program.*,
UNIX_TIMESTAMP(program.starttime) AS
starttime_unix,
UNIX_TIMESTAMP(program.endtime) AS
endtime_unix,
CONCAT(repeat('star_character',
program.stars * 'max_stars'),
IF((program.stars * 'max_stars' *
10) % 10,
"½", "")) AS starstring,
IFNULL(programrating.system, "") AS rater,
IFNULL(programrating.rating, "") AS rating,
oldrecorded.recstatus
FROM program
LEFT JOIN programrating USING (chanid,
starttime)
LEFT JOIN oldrecorded
ON LENGTH(IFNULL
(oldrecorded.seriesid, "")) > 0
AND LENGTH(IFNULL
(oldrecorded.programid, "")) > 0
AND oldrecorded.programid =
program.programid
AND oldrecorded.seriesid =
program.seriesid
WHERE program.chanid IN
(1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1
015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,102
9,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,
1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,10
58,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072
,1097,1117,1119) AND program.starttime = FROM_UNIXTIME('1142537851')
GROUP BY program.chanid, program.starttime ORDER BY program.starttime

Thanks.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/