[mythtv-users] Mythweb not showing program guide

[Cj B]

On Mar 16, 2006, at 7:33 AM, Niels Dybdahl wrote:
> Do you have a lot of mysqld activity when you try to open the  
> program guide ?
>

No, mysql utilization goes up to about 5%, while apache is using 23%.

I checked the mysql.log and found that it's output a ton of queries  
like this:
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='1070' AND program.starttime =  
FROM_UNIXTIME('1143021600') GROUP BY program.chanid,  
program.starttime ORDER BY program.starttime

When exceuted manually it does return a program.

|   1070 | 2006-03-22 02:00:00 | 2006-03-22 02:30:00 | Family Guy |  
Holy Crap | Peter invites his religious father to live with the  
family. | Animated | series        |    2000 |     0 |                
1 |                 |      1 |         0 |    0 |              1  
|          0 |         0 | SH296001 | 1999-09-30      | Series    
|           | 111                     | EP2960010010 |        0  
|       0 |     1143021600 |   1143023400 |            | VCHIP |  
TV-14  |        11 |