[mythtv-users] Can't schedule recordings in mythtv

shahada abubakar shahada.abubakar.lists at gmail.com
Mon Dec 25 16:02:57 UTC 2006


Hi,

I've recently setup a mythtv using atrpms on FC6, with a PVR350. I can 
watch liveTV just fine using it, pause, and playback, and when I press 
the record button while watching liveTV, the programmes currently being 
viewed is recorded. I can also play back the programmes recorded this way.

However, I don't seem to be able to record anything from the schedules. 
When I go into the schedules, and pick a program, and change the "Do not 
record this program" to "Record only this showing", followed by "Save 
these settings", the screen returns back to the schedule display, 
however the indicator at the top says "Not Recording". When I select the 
same program again, it has reverted to "Do not record this program".

A similar case happens when I use the mythweb interface; I can select a 
program to be recorded, but when I view the schedule a second time, the 
program has reverted to "Do not record this program" again.

I checked the "record" table in mysql, and the entries seem to be there, 
but they just don't seem to "stick' in the display, and also, nothing 
scheduled is ever recorded.

Does anybody have any idea what I should check next?

I included my mythbackend and mythfrontend log entries from when I 
select a program in the schedule below.

mythfrontend:
2006-12-25 23:37:38.905 MSqlQuery: INSERT INTO record (recordid) VALUES (0);
2006-12-25 23:37:38.906 MSqlQuery: SELECT LAST_INSERT_ID();
2006-12-25 23:37:38.908 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.910 MSqlQuery: UPDATE record SET recordid = 54, 
chanid = '1007' WHERE recordid = 54;
2006-12-25 23:37:38.912 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.913 MSqlQuery: UPDATE record SET recordid = 54, 
station = 'AXN' WHERE recordid = 54;
2006-12-25 23:37:38.915 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.918 MSqlQuery: UPDATE record SET recordid = 54, 
title = 'The Ultimate Fighter' WHERE recordid = 54;
2006-12-25 23:37:38.920 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.921 MSqlQuery: UPDATE record SET recordid = 54, 
subtitle = '' WHERE recordid = 54;
2006-12-25 23:37:38.923 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.925 MSqlQuery: UPDATE record SET recordid = 54, 
description = '' WHERE recordid = 54;
2006-12-25 23:37:38.951 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.953 MSqlQuery: UPDATE record SET recordid = 54, 
starttime = '00:00:00' WHERE recordid = 54;
2006-12-25 23:37:38.955 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.959 MSqlQuery: UPDATE record SET recordid = 54, 
endtime = '01:30:00' WHERE recordid = 54;
2006-12-25 23:37:38.961 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.963 MSqlQuery: UPDATE record SET recordid = 54, 
startdate = '2006-12-26' WHERE recordid = 54;
2006-12-25 23:37:38.965 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.966 MSqlQuery: UPDATE record SET recordid = 54, 
enddate = '2006-12-26' WHERE recordid = 54;
2006-12-25 23:37:38.968 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.970 MSqlQuery: UPDATE record SET recordid = 54, 
category = '' WHERE recordid = 54;
2006-12-25 23:37:38.972 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.973 MSqlQuery: UPDATE record SET recordid = 54, 
seriesid = '246455170' WHERE recordid = 54;
2006-12-25 23:37:38.976 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.977 MSqlQuery: UPDATE record SET recordid = 54, 
programid = '' WHERE recordid = 54;
2006-12-25 23:37:38.979 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.981 MSqlQuery: UPDATE record SET recordid = 54, 
findday = '3' WHERE recordid = 54;
2006-12-25 23:37:38.983 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.984 MSqlQuery: UPDATE record SET recordid = 54, 
findtime = '00:00:00' WHERE recordid = 54;
2006-12-25 23:37:38.986 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.987 MSqlQuery: UPDATE record SET recordid = 54, 
findid = '733036' WHERE recordid = 54;
2006-12-25 23:37:38.990 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.992 MSqlQuery: UPDATE record SET recordid = 54, 
parentid = '0' WHERE recordid = 54;
2006-12-25 23:37:38.994 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.995 MSqlQuery: UPDATE record SET recordid = 54, 
search = '0' WHERE recordid = 54;
2006-12-25 23:37:38.997 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:38.998 MSqlQuery: UPDATE record SET recordid = 54, type 
= '1' WHERE recordid = 54;
2006-12-25 23:37:39.001 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.003 MSqlQuery: UPDATE record SET recordid = 54, 
recpriority = '0' WHERE recordid = 54;
2006-12-25 23:37:39.005 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.006 MSqlQuery: UPDATE record SET recordid = 54, 
startoffset = '0' WHERE recordid = 54;
2006-12-25 23:37:39.008 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.010 MSqlQuery: UPDATE record SET recordid = 54, 
endoffset = '0' WHERE recordid = 54;
2006-12-25 23:37:39.012 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.013 MSqlQuery: UPDATE record SET recordid = 54, 
dupmethod = '6' WHERE recordid = 54;
2006-12-25 23:37:39.015 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.017 MSqlQuery: UPDATE record SET recordid = 54, 
dupin = '15' WHERE recordid = 54;
2006-12-25 23:37:39.019 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.020 MSqlQuery: UPDATE record SET recordid = 54, 
prefinput = '0' WHERE recordid = 54;
2006-12-25 23:37:39.022 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.023 MSqlQuery: UPDATE record SET recordid = 54, 
inactive = '0' WHERE recordid = 54;
2006-12-25 23:37:39.025 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.027 MSqlQuery: UPDATE record SET recordid = 54, 
profile = 'Default' WHERE recordid = 54;
2006-12-25 23:37:39.029 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.030 MSqlQuery: UPDATE record SET recordid = 54, 
recgroup = 'Default' WHERE recordid = 54;
2006-12-25 23:37:39.032 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.033 MSqlQuery: UPDATE record SET recordid = 54, 
playgroup = 'Default' WHERE recordid = 54;
2006-12-25 23:37:39.035 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.037 MSqlQuery: UPDATE record SET recordid = 54, 
autoexpire = '1' WHERE recordid = 54;
2006-12-25 23:37:39.039 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.040 MSqlQuery: UPDATE record SET recordid = 54, 
maxepisodes = '0' WHERE recordid = 54;
2006-12-25 23:37:39.043 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.044 MSqlQuery: UPDATE record SET recordid = 54, 
maxnewest = '0' WHERE recordid = 54;
2006-12-25 23:37:39.046 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.047 MSqlQuery: UPDATE record SET recordid = 54, 
autocommflag = '1' WHERE recordid = 54;
2006-12-25 23:37:39.049 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.051 MSqlQuery: UPDATE record SET recordid = 54, 
autotranscode = '0' WHERE recordid = 54;
2006-12-25 23:37:39.053 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.054 MSqlQuery: UPDATE record SET recordid = 54, 
transcoder = '0' WHERE recordid = 54;
2006-12-25 23:37:39.057 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.060 MSqlQuery: UPDATE record SET recordid = 54, 
autouserjob1 = '0' WHERE recordid = 54;
2006-12-25 23:37:39.062 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.063 MSqlQuery: UPDATE record SET recordid = 54, 
autouserjob2 = '0' WHERE recordid = 54;
2006-12-25 23:37:39.079 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.080 MSqlQuery: UPDATE record SET recordid = 54, 
autouserjob3 = '0' WHERE recordid = 54;
2006-12-25 23:37:39.082 MSqlQuery: SELECT * FROM record WHERE recordid = 54;
2006-12-25 23:37:39.084 MSqlQuery: UPDATE record SET recordid = 54, 
autouserjob4 = '0' WHERE recordid = 54;
2006-12-25 23:37:39.085 MSqlQuery: UPDATE recorded SET recpriority = 0, 
transcoder = 0, playgroup = 'Default' WHERE recordid = 54 ;
2006-12-25 23:37:39.085 write -> 13 24      RESCHEDULE_RECORDINGS 54
2006-12-25 23:37:39.126 read  <- 13 1       0
2006-12-25 23:37:39.132 write -> 13 19      QUERY_GETALLPENDING
2006-12-25 23:37:39.183 read  <- 13 7       0[]:[]0
2006-12-25 23:37:39.190 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.commfree,     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 = 1006   AND program.endtime 
 >= '2006-12-25T22:30:00'   AND program.starttime <= 
'2006-12-26T00:30: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
2006-12-25 23:37:39.200 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.commfree,     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 = 1007   AND program.endtime 
 >= '2006-12-25T22:30:00'   AND program.starttime <= 
'2006-12-26T00:30: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
2006-12-25 23:37:39.207 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.commfree,     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 = 1009   AND program.endtime 
 >= '2006-12-25T22:30:00'   AND program.starttime <= 
'2006-12-26T00:30: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
2006-12-25 23:37:39.238 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.commfree,     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 = 1010   AND program.endtime 
 >= '2006-12-25T22:30:00'   AND program.starttime <= 
'2006-12-26T00:30: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
2006-12-25 23:37:39.245 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.commfree,     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 = 1011   AND program.endtime 
 >= '2006-12-25T22:30:00'   AND program.starttime <= 
'2006-12-26T00:30: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
2006-12-25 23:37:39.249 MSqlQuery: SELECT icon FROM channel WHERE chanid 
= '1007' ;
2006-12-25 23:37:39.261 MSqlQuery: SELECT icon FROM channel WHERE chanid 
= '1007' ;
2006-12-25 23:37:39.279 MSqlQuery: SELECT icon FROM channel WHERE chanid 
= '1007' ;

Mythbackend:
2006-12-25 23:37:39.086 MythSocket(8272d00:11): socket is readable
2006-12-25 23:37:39.121 MythSocket(8272d00:11): cb->readyRead()
2006-12-25 23:37:39.122 MythSocket(8272d00:11): UpRef: 2
2006-12-25 23:37:39.124 read  <- 11 24      RESCHEDULE_RECORDINGS 54
2006-12-25 23:37:39.125 write -> 11 1       0
2006-12-25 23:37:39.134 MythSocket(8272d00:11): socket is readable
2006-12-25 23:37:39.137 MythSocket(8272d00:11): cb->readyRead()
2006-12-25 23:37:39.138 MythSocket(8272d00:11): UpRef: 2
2006-12-25 23:37:39.135 MythSocket(8272d00:11): DownRef: 1
2006-12-25 23:37:39.180 read  <- 11 19      QUERY_GETALLPENDING
2006-12-25 23:37:39.181 write -> 11 7       0[]:[]0
2006-12-25 23:37:39.284 MythSocket(8272d00:11): DownRef: 1

The entry does get saved into the "record" table, as seen below:

mysql> select * from record where recordid = 54;
+----------+------+--------+-----------+------------+----------+------------+----------------------+----------+-------------+----------+---------+-------------+------------+-------------+-----------+-------------+-----------+----------+-----------+-------+---------+-----------+-----------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+-----------+---------------------+---------------------+---------------------+
| recordid | type | chanid | starttime | startdate  | endtime  | 
enddate    | title                | subtitle | description | category | 
profile | recpriority | autoexpire | maxepisodes | maxnewest | 
startoffset | endoffset | recgroup | dupmethod | dupin | station | 
seriesid  | programid | search | autotranscode | autocommflag | 
autouserjob1 | autouserjob2 | autouserjob3 | autouserjob4 | findday | 
findtime | findid | inactive | parentid | transcoder | tsdefault | 
playgroup | prefinput | next_record         | last_record         | 
last_delete         |
+----------+------+--------+-----------+------------+----------+------------+----------------------+----------+-------------+----------+---------+-------------+------------+-------------+-----------+-------------+-----------+----------+-----------+-------+---------+-----------+-----------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+-----------+---------------------+---------------------+---------------------+
|       54 |    1 |   1007 | 00:00:00  | 2006-12-26 | 01:30:00 | 
2006-12-26 | The Ultimate Fighter |          |             |          | 
Default |           0 |          1 |           0 |         0 |           
0 |         0 | Default  |         6 |    15 | AXN     | 246455170 
|           |      0 |             0 |            1 |            0 
|            0 |            0 |            0 |       3 | 00:00:00 | 
733036 |        0 |        0 |          0 |         1 | Default   
|         0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 0000-00-00 
00:00:00 |
+----------+------+--------+-----------+------------+----------+------------+----------------------+----------+-------------+----------+---------+-------------+------------+-------------+-----------+-------------+-----------+----------+-----------+-------+---------+-----------+-----------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+-----------+---------------------+---------------------+---------------------+
1 row in set (0.00 sec)

And this is a log from mythfrontend when I view the program entry a 
second time (it shows "do not record this program"):

2006-12-25 23:45:12.083 MSqlQuery: SELECT icon FROM channel WHERE chanid 
= '1007' ;
2006-12-25 23:45:15.377 MSqlQuery: SELECT name, id FROM 
recordingprofiles WHERE profilegroup = 6 ORDER BY id
2006-12-25 23:45:15.381 MSqlQuery: SELECT DISTINCT recgroup FROM recorded
2006-12-25 23:45:15.394 MSqlQuery: SELECT DISTINCT recgroup FROM record
2006-12-25 23:45:15.433 MSqlQuery: SELECT name FROM playgroup WHERE name 
<> 'Default' ORDER BY name;
2006-12-25 23:45:15.439 MSqlQuery: SELECT 
cardinputid,cardid,inputname,displayname FROM cardinput ORDER BY cardinputid
2006-12-25 23:45:15.473 MSqlQuery: SELECT channum, callsign, name FROM 
channel WHERE chanid = '1007';
2006-12-25 23:45:15.474 MSqlQuery: SELECT name FROM playgroup WHERE name 
= 'The Ultimate Fighter' OR       name = '' OR       (titlematch <> '' 
AND        'The Ultimate Fighter' REGEXP titlematch)
2006-12-25 23:45:15.475 MSqlQuery: SELECT name FROM playgroup WHERE name 
= 'The Ultimate Fighter' OR       name = '' OR       (titlematch <> '' 
AND        'The Ultimate Fighter' REGEXP titlematch)
2006-12-25 23:45:15.609 XMLParse::LoadTheme using 
/usr/share/mythtv/themes/blue/ui.xml
2006-12-25 23:45:16.040 MSqlQuery: SELECT icon FROM channel WHERE chanid 
= '1007' ;


Thanks in advance!

Regards,
.sha


More information about the mythtv-users mailing list