[mythtv-users] Mythweb not showing program guide

Cj B black at comet.n-polk.k12.ia.us
Thu Mar 16 19:43:35 UTC 2006


> You can get rid of those SELECTs by commenting out the following lines
> from programs.php:
>
> /*            elseif ($this->chanid) {
>                 unset($this->filename);
>             // Kludge to avoid redefining the object, which doesn't  
> work in php5
>                 $tmp =
> @get_object_vars(load_one_program($this->starttime, $this->chanid));
>                 if (is_array($tmp) && count($tmp) > 0) {
>                     foreach ($tmp as $key => $value) {
>                         $this->$key = $value;
>                     }
>                 }
>             }*/
>
> But that should only speed up the generation of the page, so it can
> not explain why you do not get anything at all.
> I had a very long delay (40 seconds) before getting the page and my
> apache log showed that it tried to retrieve the *.js files
> (mouseovers.js etc) for every single page. Apparently it did not
> retrieve them correctly and there was a long delay. Do you have
> indications in your apache log files, that it tries to retrieve such
> files ?


Ok, I turned that off and found the following SQL statement which  
looks like it's supposed to be returning programs but is actually  
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,
Cj B


More information about the mythtv-users mailing list