[mythtv-users] Invalid chanid

Nick Morrott knowledgejunkie at gmail.com
Thu Mar 22 01:32:26 UTC 2007


On 21/03/07, Ron Scott <ronnie.scott at gmail.com> wrote:
>  On 20/03/07, Ron Scott <ronnie.scott[at]gmail.com> wrote:
> > Does anyone know why an invalid chanid might be created in the tvchain
> >> and inuseprograms for a particular channel.
> >>
> >> I am running .20 mythtv and currenly I have one channel that always
> >> displays blank program information in the nowshowing areas (everything
> >> is fine in guide). I think this is occuring because it thinks the
> >> chanid is '45673892' as shown in the inuseprograms and tvchains
> >> tables. Anyone know why this might be happening? For some reason
> >> when these rows in the database are entered the chanid is entered
> >> wrong.
>
> >Use the channel editor in mythtv-setup and check what the chanid is
> >set to for this channel. If it's bad there, any further use of it
> >could be broken.
>
> >How were your channels configured initially?
>
> >Nick
>
> My setup is not too complicated  I have the following:
>
> cardinputid  cardid  sourceid Inputname displayname
> 8      5        1       S-Video 1       DirecTv
> 6      3        6       MPEG2TS      HDTV-0
> 7      4        6       MPEG2TS      HDTV-1
> 10      6       7       S-Video 1       GLOBO
>
> The channel that I am having trouble with is the only one attached to
> the GLOBO input card.  It is channel 596.  The chanid in the channel
> table is 7596.
>
> chanid   channum    freqid    sourceid    callsign    name
> 7596    596     596     7       RGTI    Rede Globo TV Internacional
>
> When I view through mythweb or through the "Recorded Shows" I see
> blank information for channel information, title and genre etc..  When
> I look into the tvchain and inuseprograms tables while watching livetv
> or recording this channel I see a chanid of 4294967295.  Which is way
> off.  I don't have this chanid in my channels table so I am assuming
> this is why I see no information in the recording screens.

4294967295 is equal to 2^32 - 1, which leads me to think something
*funny* is going on here when your current chanid is interpreted.

> Do you know how the inuseprograms and tvchains are populated?

inuseprograms is populated when MythTV is recording, tvchain is
populated when you are watching LiveTV. Both tables should be empty
when no recording is going on. You seem to have an old entry in your
tvchain table, which you should remove.

> Could it be because I don't have genre or rating informations for the programming
> on this channel?  Other than this phenomina I can't put my finger on

No.

> what is different about this channel setup from all of the others I
> have..
>
> (From tvchain table)
> chanid           starttime       chainid         chainpos        discontinuity
> watching         hostprefix      cardtype        input           channame
> endtime
> 4294967295      2007-02-19 15:09:34     live-TvHD-2007-02-19T10:08:54   7
>         0       0       myth://192.168.1.40:6543/       MPEG    S-Video 1       *blank*
>         2007-02-19 16:09:34
>
> (I added the *blank* to let you know that in the channame collumn it is blank)

You want to remove this entry.

> I have removed this channel and input card from mythsetup and
> reinserted them but this has not repaired the problem so I am
> wondering if mythfilldatabase isn't inserting a key piece of program
> information needed for a join to work?

What grabber have you associated with this channel? If you have no
grabber associated, you should specify '/bin/true' as your channel
change command. You probably also want to check whether you have a
valid xmltvid (or whatever your grabber uses) to enable listings to be
applied to this channel.

If you are familiar wit the mysql command line, what is the output of

mysql> SELECT COUNT(*) FROM `program` WHERE `chanid`='7596';

I would also recommend checking your database for problems - details
of using optimize_mythdb.pl are on the wiki and mailing list.

Mike's time-tested solution will remove *all* of your video sources,
and you would have to recreate them. If you decide to do this, I would
go the extra distance and 'Delete All Capture Cards' also, and re-add
you capture cards, most preferred card first.

Nick
-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin


More information about the mythtv-users mailing list