[mythtvnz] TV1+1 freeview.xml header update?

[Tim Stonehouse]

On 3 July 2012 10:47, David Moore <dmoo1790 at ihug.co.nz> wrote:

> On 03/07/12 08:59, Nick Rout wrote:
>
>> On Tue, Jul 3, 2012 at 8:38 AM, tortise<tortise at paradise.net.**nz<tortise at paradise.net.nz>>
>>  wrote:
>>
>>> For anyone who might want tv1+1 data these seem to be the steps to take:
>>>
>>> edit /home/mythtv/.mythtv/{**Whateveryoucalledit}.xmltv
>>>
>>> revise the tvnz7 line to:
>>>
>>> channel=tv1-plus1.freeviewnz.**tv <http://tv1-plus1.freeviewnz.tv>
>>>
>>> And from SQL:
>>>
>>> mysql>  update channel set serviceid = '1205' where chanid = 1007;
>>> mysql>  update channel set callsign = 'TV1 PLUS1' where chanid = 1007;
>>> mysql>  update channel set xmltvid = 'tv1-plus1.freeviewnz.tv' where
>>> chanid =
>>> 1007;
>>> mysql>  update channel set name = 'TV ONE plus 1' where chanid = 1007;
>>>
>>> If you want you can revise the icon also.
>>>
>>
>> Direct manipulation of the sql is deprecated. Use the tuning tools.
>>
>>
> IMHO nothing wrong with tinkering with sql as long as you accept the risk
> of breaking your system. I've messed with my db from day one with no ill
> effects.
>
> BTW I assume you mean the backend setup when you say "tuning tools"?
>
>
> ______________________________**_________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/**mailman/listinfo/mythtvnz<http://lists.ourshack.com/mailman/listinfo/mythtvnz>
> Archives http://www.gossamer-threads.**com/lists/mythtv/mythtvnz/<http://www.gossamer-threads.com/lists/mythtv/mythtvnz/>
>

I've used phpmyAdmin on my system without error, useful when wanting to
truncate the job queue (I stopped transcode globally but left recording
with auto transcode left on).

I have a NOVA-T 500 with 2 real tuners inside, so I've source id 1 and 2.
 This means I had 2 chanid's to update, 1007 and 2007.

I used phpmyAdmin to change the channels name, callsign, xmlid and
serviceid.

Tim
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20120703/029bcc4e/attachment.html>