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

[Isaac Richards]

On Sunday 17 August 2003 09:52 pm, Andy wrote:
> 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?

Make sure you're not running out of space in /tmp

Isaac