Analog tv channel names uses program name or channel number - Page 2

doornjoostje · 2008-05-20, 08:53

Quote:

Originally Posted by Ries

Please use this at your own risk!

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

Quote:

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:

Quote:

SELECT * FROM channel

Good luck!

Richard

Thanks, will try tonight.

chrik · 2008-05-20, 13:04

thanks I try to fix the names manually then

ronilse · 2008-05-20, 14:07

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
scanning analog incorrect channel names	doornjoostje	1.0 RC1 and SVN Builds	8	2008-05-19 21:33
Channel changes to channel index rather than channel number	jadz	pre 1.0 RC1	2	2007-11-09 17:21
TVServer channel scan now uses hex numbers instead of channel names?	HappyTalk	0.2.2.0 Final and SVN Builds	6	2007-05-10 20:05
[Patch] Numeric channel selection by index or channel number	CodeMonkey	General Development (no feature request here!)	0	2006-01-02 15:32
My TV - Lost / Channel List / Frequences / Names	Schmidti	Improvement Suggestions	2	2005-01-12 20:36

2008-05-20, 13:04	#12 (permalink)
chrik Portal Member Join Date: May 2008 Posts: 12 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	thanks I try to fix the names manually then

2008-05-20, 14:07	#13 (permalink)
ronilse Portal Tester Join Date: Jul 2005 Posts: 3,110 Thanks: 18 Thanked 83 Times in 69 Posts Country: My System	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