Prevent channels from combining (1 Viewer)

ophth1

Portal Member
January 14, 2007
35
0
44
Hi!
I am using DVB-T card and FireTV DVB-C with TV-Server (RC1 and latest svn build).
The problem is: Directly during scanning for new channels, all channels with same names are combined into one and listed with their name and the two frequencies .
It would be great to have them listed separately in the channel list in order to be able to choose them manually (according e.g. to picture quality), even if I would loose some nice properties (such as letting tv-server decide between choosing which channels etc.)
Nevertheless, is there a way to prevent those channels from being matched together or to manually separate them into two separate channels afterwards?

Thanks!!!!
 

armandp

Retired Team Member
  • Premium Supporter
  • April 6, 2008
    990
    620
    Zoetermeer
    Home Country
    Netherlands Netherlands
    i have a similar issue: Ziggo (my cable company) broadcasts the History Channel in both SD and HD quality but they use the same name. After scanning they are combined into one channel.

    Below is short walkthrough of how i manually seperated them.
    It's a bit technical and some knowledge of SQL Server Management Studio Express is required.

    Also when you do a new scan these changes will probably get overwritten.

    CAUTION: USE THIS _HACK_ AT YOUR OWN RISK

    - First scan all your channels in the TV Server configuration so they get saved into the database.
    - Start up SQL Server Management Studio Express and connect to the MpTvDbRC1 database
    - New query:

    Code:
    select * from channel
    where name = '[B]MyChannel[/B]'

    Replace MyChannel with the channel name you want to split.
    Write down the idChannel value for reference.

    Now create a 'copy' of this channel with new name:

    Code:
    INSERT INTO [Channel]
    (
    [name],[isRadio],[isTv],[timesWatched],[totalTimeWatched],
    [grabEpg],[lastGrabTime],[sortOrder],[visibleInGuide],
    [externalId],[freetoair],[displayName],[epgHasGaps]
    )
    SELECT
    '[B]MyNewChannel[/B]',[isRadio],[isTv],[timesWatched],[totalTimeWatched],
    [grabEpg],[lastGrabTime],[sortOrder],[visibleInGuide], [externalId] ,
    [freetoair], [displayName], [epgHasGaps] 
    from [Channel]
    where idChannel=[B]X[/B]

    Replace X with the idChannel you wrote down and replace the MyNewChannel's with the new name for the channel. Hit execute and you'll get 1 row(s) affected if the copy is succesfull.

    Check the id for the new channel by quering:

    Code:
    select * from channel
    where name = '[B]MyNewChannel[/B]'


    Now onto the real splitting, new query:

    Code:
    select * from TuningDetail
    where idChannel = '[B]X[/B]'

    Replace the X with the original channel id you wrote down in the beginning.
    Now you'll get a row for each channel (allthough they are listed as combined in the TV Server configuration they are seperate rows in this table).

    Now we are going to update one of these records to use the new idChannel we created. Pick one of the rows and write down the idTuning value and update the record:

    Code:
    UPDATE TuningDetail
    SET idChannel = [B]NewChannelID[/B]
    where idTuning = [B]X[/B]

    Replace NewChannelID with the idChannel of the new channel you created and replace X with the idTuning value you wrote down before.

    You have now seperated the channels. Startup the TV Server configuration and check if the new channel is present and that it's correctly mapped to a card and/or group (optional). Startup the TV plugin in MP and test if the channel works.

    Hope this workaround works for you! I don't know of any other way to achieve the same using just the configuration UI.
     

    D4bFz3awSRYHKjr3

    MP Donator
  • Premium Supporter
  • August 14, 2006
    253
    16
    Home Country
    Aruba Aruba
    I also seem to suffer from this problem, anny way that there can be an option added to prvent this?

    It's pretty annoying that a FTA channel from DVB-C is combined with a scrambled channel from DVB-S and when tvserver decides that you watch the DVB-S one, there comes the error 'channel is scrambled'
     

    Users who are viewing this thread

    Top Bottom