lemaymd
July 22nd, 2008, 12:58 AM
I've been having a bit of trouble getting a new Mythbuntu installation up and running on 8.04.1. I'm using an Intel D945GCLF Atom-based all-in-one motherboard, along with a Plextor ConvertX USB MPEG-4 hardware encoder. Originally, I wasn't able to watch live TV, but I was able to schedule recordings. However, the recordings were never actually carried out, because the tuner's status was always "unavailable". I believe that problem was related to group permissions, because I may have run mythtv-setup prior to adding myself to the mythtv group. I did add myself to that group and then deleted the .mythtv directories in the homes of mythtv and my main user account, from which I run mythtv-setup. I re-ran setup, re-added the tuner, and was able to watch live TV fine. However, now I can't schedule recordings! I've tried the program finder and the program guide, and it will let me go through the process of selecting "record just this showing", etc., but the status never changes from "not recording" within the guide. However, I CAN record by selecting live TV, and hitting R to record the current program. Here is the mythfrontend verbose output during one attempt to schedule a recording, in case it's useful:
2008-07-21 23:28:25.426 write -> 19 24 RESCHEDULE_RECORDINGS 18
2008-07-21 23:28:25.427 read <- 19 1 0
2008-07-21 23:28:25.427 write -> 19 19 QUERY_GETALLPENDING
2008-07-21 23:28:25.428 read <- 19 7 0[]:[]0
2008-07-21 23:28:25.430 MSqlQuery: SELECT DISTINCT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = 1072 AND program.endtime >= '2008-07-21T23:00:00' AND program.starttime <= '2008-07-22T01:00:00' AND program.manualid = 0 GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 1000
2008-07-21 23:28:25.438 MSqlQuery: SELECT DISTINCT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = 1002 AND program.endtime >= '2008-07-21T23:00:00' AND program.starttime <= '2008-07-22T01:00:00' AND program.manualid = 0 GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 1000
2008-07-21 23:28:25.488 MSqlQuery: SELECT DISTINCT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = 1003 AND program.endtime >= '2008-07-21T23:00:00' AND program.starttime <= '2008-07-22T01:00:00' AND program.manualid = 0 GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 1000
2008-07-21 23:28:25.500 MSqlQuery: SELECT DISTINCT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = 1004 AND program.endtime >= '2008-07-21T23:00:00' AND program.starttime <= '2008-07-22T01:00:00' AND program.manualid = 0 GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 1000
2008-07-21 23:28:25.506 MSqlQuery: SELECT DISTINCT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = 1005 AND program.endtime >= '2008-07-21T23:00:00' AND program.starttime <= '2008-07-22T01:00:00' AND program.manualid = 0 GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 1000
2008-07-21 23:28:25.756 MSqlQuery: SELECT icon FROM channel WHERE chanid = '1003' ;
2008-07-21 23:28:25.845 MSqlQuery: SELECT icon FROM channel WHERE chanid = '1003' ;
2008-07-21 23:28:26.269 MSqlQuery: SELECT icon FROM channel WHERE chanid = '1003' ;
I've already tried running mysqlcheck and myisamchk on the tables, but they come back clean. I've also tried optimizing the tables from within the mythbuntu control center. This is a stubborn one!
2008-07-21 23:28:25.426 write -> 19 24 RESCHEDULE_RECORDINGS 18
2008-07-21 23:28:25.427 read <- 19 1 0
2008-07-21 23:28:25.427 write -> 19 19 QUERY_GETALLPENDING
2008-07-21 23:28:25.428 read <- 19 7 0[]:[]0
2008-07-21 23:28:25.430 MSqlQuery: SELECT DISTINCT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = 1072 AND program.endtime >= '2008-07-21T23:00:00' AND program.starttime <= '2008-07-22T01:00:00' AND program.manualid = 0 GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 1000
2008-07-21 23:28:25.438 MSqlQuery: SELECT DISTINCT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = 1002 AND program.endtime >= '2008-07-21T23:00:00' AND program.starttime <= '2008-07-22T01:00:00' AND program.manualid = 0 GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 1000
2008-07-21 23:28:25.488 MSqlQuery: SELECT DISTINCT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = 1003 AND program.endtime >= '2008-07-21T23:00:00' AND program.starttime <= '2008-07-22T01:00:00' AND program.manualid = 0 GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 1000
2008-07-21 23:28:25.500 MSqlQuery: SELECT DISTINCT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = 1004 AND program.endtime >= '2008-07-21T23:00:00' AND program.starttime <= '2008-07-22T01:00:00' AND program.manualid = 0 GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 1000
2008-07-21 23:28:25.506 MSqlQuery: SELECT DISTINCT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = 1005 AND program.endtime >= '2008-07-21T23:00:00' AND program.starttime <= '2008-07-22T01:00:00' AND program.manualid = 0 GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 1000
2008-07-21 23:28:25.756 MSqlQuery: SELECT icon FROM channel WHERE chanid = '1003' ;
2008-07-21 23:28:25.845 MSqlQuery: SELECT icon FROM channel WHERE chanid = '1003' ;
2008-07-21 23:28:26.269 MSqlQuery: SELECT icon FROM channel WHERE chanid = '1003' ;
I've already tried running mysqlcheck and myisamchk on the tables, but they come back clean. I've also tried optimizing the tables from within the mythbuntu control center. This is a stubborn one!