[mythtv-users] Changing channel station names

[scut erky]

I had the same thing happen to me, with TBS, in fact and it was a pain in the ass. 

My only recourse was to go into the database and manually remove any record of the old channel and replace it with the new one. While both channels both appeared as 55 (or whatever), the new on was actually listed as 56 (well, 1056) in the database. 

I found the following text from either a post or the docs, I forget, but this is essentially what I had to do:

"First, comment out the channel from the  /.mythtv/<sourcename>.xmltv file by inserting a "#" in front of the unwanted entry. This will prevent mythfilldatabase from grabbing future listings.

Next, delete the unwanted item from the channel table so that it will not appear in the EPG or when changing channels. The channels will always have "1000" added to them, so for example, assuming that HBO is channel 15:

$ mysql -u root mythconverg
mysql> delete from channel where chanid = '1015';

Old program data will be removed over the course of a week. However, you may want to immediately delete any current program listings for the channel that has been removed:

$ mysql -u root mythconverg
mysql> delete from program where chanid = '1015';"

And, of course, I'd recommend backing up your database first, even just with tar. 


ps. May want to update your pgp key, looks like it expired on 3/22/2003. 

> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org 
> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of James L. Paul
> Sent: Monday, October 13, 2003 2:17 AM
> To: Discussion about mythtv
> Subject: [mythtv-users] Changing channel station names
> 
> 
> Does there exist any tool or method for updating the names of 
> channels in the database? It's easy enough to change the 
> xmltv config file so that name changes don't result in the 
> channel being skipped by XMLTV due to not being recognized, 
> but that just causes multiple channels in the database.
> 
> Is it safe to just delete a row in the table for the unwanted (and
> incorrect) duplicate when a channel changes it's name, or 
> will that cause other problems?
> 
> I have about a dozen channels that I care about that change 
> names in Tribune's listing twice or 4 times a year, so it 
> would be nice to have the database key off the channel number 
> rather than the name.
> 
> For example, last week my listing for TBS changed to TBSP, 
> and now my MythTV EPS has two channel 45's, one named TBS and 
> one named TBSP, and the TBSP one is correct. It's recording 
> shows at the wrong time, perhaps because TBS is first in the 
> table right now.
> 
> For a bit of background, Tribune often forgets to update 
> listings for Hawaii, at programming season changes and 
> daylight savings time changes. ~ When somebody prods them to 
> correct things, they prepend or append P,O,HI to station 
> names for part of the year and change them back again. The 
> Food channel might be FOOD, OFOOD, or FOODP depending on the 
> time of year. It's not consistent for all the channels 
> either, right now we have HITLC, FOODP, and even HIUSAP which 
> currently has additions at both ends ;)
> 
> This also breaks the little station logo icons, but I'm sure 
> that's easy to fix in a table somewhere, I just haven't 
> looked for it yet, it's more important right now to make it 
> work first. :)
> 
> Anyway, it sure would be nice to have a simple way to rename 
> a channel without losing any recording schedules, since this 
> happens a lot here.
> 
> Am I missing something obvious?
>


---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20031013/db760872/attachment.html