Analog tv channel names uses program name or channel number (1 Viewer)

[doornjoostje]

Please use this at your own risk!

The SQL query, in the correct database ('tvlibrary'?), for changing the name in a channel is:

UPDATE channel SET name = '<NAME>' WHERE idChannel = '<CHANNEL_NUM>'

For <NAME> you use the name you want to give the channel (like NL1 or BBC1) and for <CHANNEL_NUM> the idChannel number of the row you like the name changed.

To view the content of the CHANNEL TABLE you enter the following query:

SELECT * FROM channel

Good luck!

Richard

Thanks, will try tonight.

 

[chrik]

thanks I try to fix the names manually then

 

[ronilse]

Hi,
If you change Name field in db you fu.. up new scan/overwrite, since that field it's only for internal reference(DisplayName filed it's used for what shows in EPG etc)!

Instead rename channels in TV Server Config -> TV Channels & mark a chanel & Edit + rename

Regards
Roy