[mythtv-users] Mythweb listing error

mford2 at comcast.net mford2 at comcast.net
Wed Jul 2 19:21:56 EDT 2003


I’ve been getting this error whenever I open the mythweb url.  Anybody have an idea what’s going wrong?  I’m using the .9 version of myth and mythweb.
 
Gadzooks! I can't open the program table. SELECT 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 < 20030702161550 AND program.endtime > 20030702161550 GROUP BY program.chanid ORDER BY channel.channum + 0, programrating.system;
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.snowman.net/pipermail/mythtv-users/attachments/20030702/7e23d200/attachment.htm


More information about the mythtv-users mailing list