Fails to enter LiveTV or scheduled recording

[g8ecj@…]

Problem since [10406], currently on [10488]

Start up, enter 'Watch LiveTV' and frontend exits back to menu. Backend continualy outputs last few lines to log forever.

start of -v channel,record backend log and mysql dump of channel table attached.

[g8ecj@…]

Channel table

[g8ecj@…]

backend log

[g8ecj@…]

Better backend log

[g8ecj@…]

Can now enter LiveTV (after an overnight scheduled recording or two on a version < [10390]. Still can't change channel on [10488] but the backend log looks much more useful (mythbackend.1.log). Tried more versions, [10390] is OK, [10402] breaks.

[danielk]

Robin, how did you insert these channels ?

Many of them have an mplexid of 1, this is not right. That would imply that all of these channels are on the same frequency.

If you accidentally mangled the DB at some point then we can just close this as a one-off, but if the channels were inserted this way by MythTV, we need to fix this.

Incidentally, "UPDATE channel SET mplexid=0 where serviceid = 0 AND atsc_minor_chan = 0;" should fix this in your case.

[g8ecj@…]

I think this can be closed now - the database fix sorted it out.

The channels were originally created back in Feb by inserting just one channel on each source and then running mythfilldatabase manually with an XML file to create the rest. The tuning details etc were then corrected using mythweb. No surprise that something got screwed either then or sometime in updates over the last 5 months.

I can get onto testing the XvMC DVD fixes now!