[mythtv-users] Changing channel station names

[James L. Paul]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



Gregorio Gervasio, Jr. wrote:
|>>>>>James L Paul writes:
|
| [...]
| j> For example, last week my listing for TBS changed to TBSP, and now my
| j> MythTV EPS has two channel 45's, one named TBS and one named TBSP, and
| j> the TBSP one is correct. It's recording shows at the wrong time,
perhaps
| j> because TBS is first in the table right now.
|
|         Apart from editing the xmltv config file, the only thing I did
| was something like (in mysql):
|
|
|>update channel set callsign='TBSP', name='Channel 45 TBSP',
xmltvid='C45tbsp.zap2it.com' where chanid=1045;

I see. This will change the name of the old channel, but it doesn't
update the program information. It leaves me with a correct name but
incorrect times for everything within the next week. So far I haven't
had much luck with mythfilldatabase correcting this type of problem the
day before and any programs that were scheduled before the change are
still recorded at the wrong time.
|
|
| then rerunning mythfilldatabase.  Make sure that 1045 is the correct
| chanid.  Since you've already run with a new xmltv config file, you
| should also delete the new channel that got added:

I wonder perhaps if maybe instead of deleting the new one that got added
it might be better to just delete the old one with incorrect program
times? That's what I was asking, if there was anything else I need to do
or if that will break something. I haven't tried it yet. I mainly wonder
what will happen to existing schedules for that channel if I just delete
the older incorrect one.

I think in the future the key will be to change the channel name in the
database _before_ editing the xmltv file and running mythfilldatabase. I
think that may prevent the problem of ending up with duplicate channels
in the EPG.

Thanks for the input, it helps me choose the right track!

|
|>delete from channel where chanid=1xxx;
|>delete from program where chanid=1xxx;
|
|
| where "1xxx" is the new chanid.
|
|
| ------------------------------------------------------------------------
|
| _______________________________________________
| mythtv-users mailing list
| mythtv-users at mythtv.org
| http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQE/i00PT8BYaKRUpkQRAsqPAJ4tTXGRvmpi5dymM1WXm1e3eLQC4wCfYAZg
Egn0sSS1R7QgtaPLb89VtJs=
=0uce
-----END PGP SIGNATURE-----