[mythtv-users] Gadzooks! I can't open the program table

[Andy]

Here’s what I get in the browser connecting to mythweb:

Gadzooks! I can't open the program table. SELECT sum(record.type = 5 and program.title = record.title and record.chanid = program.chanid and record.starttime = sec_to_time(time_to_sec(program.starttime)) and DAYOFWEEK(record.enddate) = DAYOFWEEK(program.endtime))>0 as 'type5', sum(record.type = 4 and program.title = record.title)>0 as 'type4', sum(record.type = 3 and program.title = record.title and record.chanid = program.chanid)>0 as 'type3', sum(record.type = 2 and program.title = record.title and record.chanid = program.chanid and record.starttime = sec_to_time(time_to_sec(program.starttime)) and record.endtime = sec_to_time(time_to_sec(program.endtime)))>0 as 'type2', sum(record.type = 1 and program.title = record.title and record.chanid = program.chanid and record.starttime = sec_to_time(time_to_sec(program.starttime)) and record.startdate = from_days(to_days(program.starttime)))>0 as 'type1', channel.chanid, channel.channum, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, program.airdate, program.stars, concat(repeat('♦', program.stars*4), if((program.stars*4*10) % 10, '½', '')) as starstring, ifnull(programrating.system, '') as rater, ifnull(programrating.rating, '') as rating, ((UNIX_TIMESTAMP(program.endtime) - UNIX_TIMESTAMP(program.starttime)) / 60 ) as duration FROM channel left join program using (chanid) left join programrating using (chanid, starttime) , record WHERE program.starttime < 20030817181550 AND program.endtime > 20030817181550 GROUP BY program.chanid ORDER BY channel.channum + 0, programrating.system;

It was working fine an hour ago, and then started this.
The recordings page looks fine, it's just the EPG.

What's up with that?

-Andy.