[mythtv-users] No Upcoming Recordings

Bruce Markey bjm at lvcm.com
Mon Oct 9 21:48:52 UTC 2006


James Pifer wrote:
> I move my mythbackend to a new/better/faster server. I installed
> mythtv-suite and then restored my database from a sql backup. Everything
> appears to be ok, i can watch LiveTV and play recordings, but "Upcomings
> Recordings" is blank. I can see all my Schedules fine in "Recording
> Schedules".
> 
> I'm not sure where to look for the problem. Any suggestions?

This seems to be going in circles so let's get on track.
Because you've been deleting and re-adding card/input/source
data, let's start fresh and find what isn't happening.

One (of many) possibilities is that you may not have cleared
your channel table along with changing the video source leaving
old channels not associated with the current video source. Any
Single, Timeslot, Weekslot, or Channel chosen from the EPG for
such a channel would not match any channel that could record. I'm
not sure about the "-v" advice given but the issue is with the
scheduler not scheduling anything so use "mythbackend -v schedule"
only until there is reason to look for something else.

2006-10-09 13:49:11.634 Using runtime prefix = /usr/local
2006-10-09 13:49:11.702 New DB connection, total: 1
2006-10-09 13:49:11.711 Connected to database 'mythconverg' at host: moktoo
2006-10-09 13:49:11.717 Current Schema Version: 1164
Starting up as the master server.

... 

2006-10-09 13:49:13.853 Reschedule requested for id -1.
Query 0: /record.search = :NRST AND (record.recordid = :NRRECORDID OR :NRRECORDID = -1) AND program.manualid = 0 AND program.title = record.title
2006-10-09 13:49:13.857  |-- Start DB Query 0...
2006-10-09 13:49:13.860  |-- -1 results in 0.002839 sec.
2006-10-09 13:49:13.861  +-- Done.
2006-10-09 13:49:13.862 Encoder card 1 free space 17207296
2006-10-09 13:49:13.862 Encoder card 2 free space -1
2006-10-09 13:49:13.863 PruneOldRecords...
2006-10-09 13:49:13.864 AddNewRecords...
2006-10-09 13:49:13.872  |-- Start DB Query...
2006-10-09 13:49:13.900  |-- 0 results in 0.027417 sec. Processing...
2006-10-09 13:49:13.901  +-- Cleanup...
2006-10-09 13:49:13.901 AddNotListed...
2006-10-09 13:49:13.901  |-- Start DB Query...
2006-10-09 13:49:13.903  |-- 0 results in 0.001306 sec. Processing...
2006-10-09 13:49:13.903 Sort by time...
2006-10-09 13:49:13.904 PruneOverlaps...
2006-10-09 13:49:13.904 Sort by priority...
2006-10-09 13:49:13.904 BuildListMaps...
2006-10-09 13:49:13.904 SchedNewRecords...
2006-10-09 13:49:13.905 Scheduling:
2006-10-09 13:49:13.905 ClearListMaps...
2006-10-09 13:49:13.905 Sort by time...
2006-10-09 13:49:13.905 PruneRedundants...
2006-10-09 13:49:13.905 Sort by time...
--- print list start ---
Title - Subtitle                    Chan ChID Day Start  End   C I  T N   Pri
---  print list end  ---
2006-10-09 13:49:13.907 Scheduled 0 items in 0.1 = 0.01 match + 0.04 place

This found nothing to record. Let's get to this starting point.


1) Make a backup of your current database if for no other reason
than to go back to see the titles of your record rules that you
may want to recreate or to look at your old channel settings:

http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5

2) Run the mysqlclient in a window that you can refer back to.

$ mysql -u mythtv -pmythtv mythconverg

3) Clean up all the relevant tables. This will not affect your
recordings or settings. From the "mysql> " prompt, cut'n'paste
the following:

truncate table program;
truncate table programrating;
truncate table programgenres;
truncate table credits;
truncate table channel;
truncate table videosource;
truncate table cardinput;
truncate table capturecard;

4) Run "mythtv-setup" from the master host. Double check the info
in General. Add one Capture card. Add one Video source. Add one
Input connection to associate the source to the active input on
the card. Exit "mythtv-setup".

5) Run "mythbackend -v schedule". Do you see output similar to
the above example (start as "master" and "Scheduled 0 items")?

6) Run "mythfilldatabase --max-days 1". Near the end of the
output, do you see messages like this with at least some of the
"Found" numbers greater than zero?

2006-10-09 14:16:04.376 Marking generic episodes.
2006-10-09 14:16:04.386     Found 278
2006-10-09 14:16:04.386 Marking repeats.
2006-10-09 14:16:04.406     Found 784
2006-10-09 14:16:04.406 Unmarking new episode rebroadcast repeats.
2006-10-09 14:16:04.413     Found 16
2006-10-09 14:16:04.420 Marking episode first showings.
2006-10-09 14:16:05.296     Found 888
2006-10-09 14:16:05.296 Marking episode last showings.
2006-10-09 14:16:06.171     Found 888
2006-10-09 14:16:06.190 Grabbing next suggested grabbing time
2006-10-09 14:16:06.713 DataDirect: BlockedTime is: 2006-10-09T14:16:06
2006-10-09 14:16:06.714 DataDirect: NextSuggestedTime is: 2006-10-10T17:21:01
2006-10-09 14:16:06.720
===============================================================
| Attempting to contact the master backend for rescheduling.  |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted.                            |
===============================================================

7) Run this query rom your mysql prompt:

mysql> select chanid,channum,callsign from channel order by chanid;
+--------+---------+----------+
| chanid | channum | callsign |
+--------+---------+----------+
|   1003 | 3       | KVBC     |
|   1005 | 5       | KVVU     |
|   1006 | 6       | KVCW     |
     ...   ...        ...

Are the chanids one-thousand plus the channel number?

8) Restart "mythbackend -v schedule" if it isn't still running
and run "mythfrontend". Go to Schedule Recordings->Program Guide.
Does it show program listings?

9) Find a show an hour or two from now tbat will be shown more
than once today. Press "I"nfo than left arrow to select "Record
at any time on any channel". Click "[Save these settings]".

10) look at the backend output. Does it show that there are one
or more of the test show scheduled?

--- print list start ---
Title - Subtitle                    Chan ChID Day Start  End   C I  T N   Pri
Home Improvement - "Alarmed by Burg    7 1007  09 15:00-15:30  1 1  A 1   0/0
Home Improvement - "Howard's End"     16 1016  09 15:00-15:30  0 0  A C   0/0
Home Improvement - "Much Ado About     7 1007  09 15:30-16:00  1 1  A 1   0/0
Home Improvement - "Burnin' Love"     16 1016  09 15:30-16:00  0 0  A C   0/0
---  print list end  ---
2006-10-09 14:34:29.443 Scheduled 4 items in 0.4 = 0.21 match + 0.16 place


If this all works, change your test rule back to "Do not record
this program", add any additional card, sources and inputs then
run "mythfilldatabase" with no args and "mythbackend" with no
args. Then, of course, start adding rules for the shows you do
want to record.

--  bjm







More information about the mythtv-users mailing list