TV Groups are not showing up in TVServer Setup (1 Viewer)

fermin

MP Donator
  • Premium Supporter
  • August 1, 2008
    57
    0
    Zug
    Switzerland Switzerland
    Unfortunately, I don't have the same problem - no channels mapped to a group that no longer exists. I've attached a SQL backup of my database (using MS SQL 2005 Express).

    What happened on my system:

    1. Installed 1.0.0 on a clean Vista SP1 box. Everything fine, TV Group tabs available.
    2. When it became available, installed 1.0.1 using the update option. TV Group tabs gone.
    3. When it became available, installed 1.0.2 using the update option. TV Group tabs still gone.

    I would really prefer a solution that doesn't involve dropping the database and redoing the config, since that would mean a lot of work...

    Regards
    Fermin

    edit: TVServer logs attached, too.
     

    Attachments

    infinite.loop

    Retired Team Member
  • Premium Supporter
  • December 26, 2004
    16,163
    4,133
    127.0.0.1
    Austria Austria
    2. When it became available, installed 1.0.1 using the update option. TV Group tabs gone.
    I have allready explain this in a lot of threads. ;)

    TABS inside the "Channels" Section have been REMOVED from the TV-Server Configuration.
    So it is INTENTIONAL that there are no Group-TABS in 1.0.1 AND 1.0.2


    This thread is about beeing unable to access the "TV Groups" section and "manual control".
    Tabs will be re-added in 1.1.0 (if any developer volunteers to do that change).

    :)
     

    chemelli

    Retired Team Member
  • Premium Supporter
  • September 28, 2006
    6,159
    2,264
    46
    Milano, Italy
    Italy Italy
    Country flag
    Me again, I thought the problem was gone in a mysterious way, could configure my tv group an the tv groups tab was accessable every time I entered the tv server configuration. today, I tried to sort the radio channels also and now the tv groups tab is gone!

    STEP BY STEP description:
    1.) entered tv server configuration an checked tv groups tab. it was shown correctly
    2.) changed to the radio channels page
    3.) pressed delete encrypted
    4.) changed to the radio groups tab
    5.) added a new group (is it ok to call it "my channels" if there is also a tv group "my channels"?)
    6.) tried to access tv groups tab -> DOES NO LONGER WORK
    7.) tried to access manual control -> DOES NO LONGER WORK

    Maybe this helps to reproduce the problem?

    Regards,
    thecubist
    thecubist,

    the issue is that in your DB there are some channels in the "GroupMap" table but not in the "Channel" table.
    Please do the following:

    1. Stop tvservice
    2. "SetupTv -c" and specify a new db name for testing
    3. Start tvservice
    4. SetupTv -> scan
    5. db backup
    6. remove radio encrypted
    7. db backup
    8. collect logs

    To go back to your production DB simply run again step 1. to 3. using the old DB name.

    Looking forward for your feedback.

    :D

    Simone
     

    fermin

    MP Donator
  • Premium Supporter
  • August 1, 2008
    57
    0
    Zug
    Switzerland Switzerland
    2. When it became available, installed 1.0.1 using the update option. TV Group tabs gone.
    I have allready explain this in a lot of threads. ;)

    TABS inside the "Channels" Section have been REMOVED from the TV-Server Configuration.
    So it is INTENTIONAL that there are no Group-TABS in 1.0.1 AND 1.0.2


    This thread is about beeing unable to access the "TV Groups" section and "manual control".
    Tabs will be re-added in 1.1.0 (if any developer volunteers to do that change).

    :)
    Yes, sorry, saw that answer a few pages back a little too late. Great it will be back in 1.1.0; this really made sorting channels relatively painless, especially if you have Astra+HotBird+Digital Cable with several overlaps.

    Thanks for your patience!
     

    Spitti

    Portal Member
    May 28, 2009
    8
    0
    Germany Germany
    :D;):D:):D:):D:D:D:D:D
    @
    one of our delevlopers has found the reason in your DB
    you have 72 channels mapped to a group, which nolonger exist.

    if you run the following query, this should be fixed
    Code:
    delete FROM groupmap WHERE NOT EXISTS (SELECT * FROM channel WHERE channel.Idchannel = groupmap.Idchannel)
    Question now is how you managed to end up with this situation.
    I think you said that you deleted RadioStations?
    Hey, thanks to that Query!! It works!!
    Now my TV Group is aviable again!!!!

    I you need my MpTvDb anyway, please make a post!:)

    EDIT: I don't know how I managed to end up with this situation. I only know, that once I opened the TV Server Config, I could not open TV Groups.
     

    thecubist

    MP Donator
  • Premium Supporter
  • April 22, 2009
    31
    0
    Germany Germany
    Me again, I thought the problem was gone in a mysterious way, could configure my tv group an the tv groups tab was accessable every time I entered the tv server configuration. today, I tried to sort the radio channels also and now the tv groups tab is gone!

    STEP BY STEP description:
    1.) entered tv server configuration an checked tv groups tab. it was shown correctly
    2.) changed to the radio channels page
    3.) pressed delete encrypted
    4.) changed to the radio groups tab
    5.) added a new group (is it ok to call it "my channels" if there is also a tv group "my channels"?)
    6.) tried to access tv groups tab -> DOES NO LONGER WORK
    7.) tried to access manual control -> DOES NO LONGER WORK

    Maybe this helps to reproduce the problem?

    Regards,
    thecubist
    thecubist,

    the issue is that in your DB there are some channels in the "GroupMap" table but not in the "Channel" table.
    Please do the following:

    1. Stop tvservice
    2. "SetupTv -c" and specify a new db name for testing
    3. Start tvservice
    4. SetupTv -> scan
    5. db backup
    6. remove radio encrypted
    7. db backup
    8. collect logs

    To go back to your production DB simply run again step 1. to 3. using the old DB name.

    Looking forward for your feedback.

    :D

    Simone
    Hi,
    I just did the steps above, again, after scanning, the tv groups page was accessible. Then, I deleted the encrypted radio channels and the tv groups page was no longer accessible.
    Hope the db-backups and log files help you to find the problem ...
    Bye,
    thecubist
     

    Attachments

    thecubist

    MP Donator
  • Premium Supporter
  • April 22, 2009
    31
    0
    Germany Germany
    @
    one of our delevlopers has found the reason in your DB
    you have 72 channels mapped to a group, which nolonger exist.

    if you run the following query, this should be fixed
    Code:
    delete FROM groupmap WHERE NOT EXISTS (SELECT * FROM channel WHERE channel.Idchannel = groupmap.Idchannel)
    Question now is how you managed to end up with this situation.
    I think you said that you deleted RadioStations?
    The db-query brought back the tv groups page:D
    Yes, I deleted encrypted radio stations by pressing the button "Delete encrypted". That's it.
    Bye,
    thecubist
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    K How to turn off "All channels" groupe in Radio? MediaPortal 1 Talk 3
    N [Finished] [MP2-781] Enable one-click deletion of grouped TV recordings MediaPortal 2 70
    HTPCSourcer [Rejected] Replace "Filter by" by "Group by" MediaPortal 2 14
    N [Rejected] Rename "Filter" to "Group by" Feature Requests 3
    N HD Channels of RTL Channel Group not working anymore Television (MyTV frontend and TV-Server) 6
    Frans Nijhuis [further infos missing] Deleting all TV channels and all channel groups in "MP 2 TV configuration" fails 2.2 Archive 1
    M EPG color by length of TV-show MediaPortal 1 Talk 1
    toricred Only Show Actual Recordings General 1
    R MP 2.2.3 Search TV program only with the correct begin of show title General 7
    F Show Player info while skipping Feature Requests 0
    P Recordings not showing up unless re-imported and not possible to delete General 0
    C Imported media doesn't show up immediately? General 1
    mrmojo666 [Tv Server Plugin ]Direct Show Video Control Plugin 0.0.0.1 for Hauppauge PVR cards MediaPortal 1 Plugins 0
    tano_grasa Movie cover not showing when starting a movie aMPed 0
    M [Rejected] Always show full hours in TV Guide Feature Requests 2
    J Understanding what EPG shows about schedules General 8
    J Show media item location Feature Requests 4
    ratata Non present codecs is still showing... MediaPortal 1 Talk 2
    C Recording back to back shows from IPTV streams General Support 8
    J Resume from Standby Last Module TV Showing TV Server Settings Television (MyTV frontend and TV-Server) 2
    K Genres in MovingPictures not show ... Fanart Handler 12
    G How best to get cover art for tracks to show up on the Audio Menu (Latest Added, Unplayed)? General 9
    Lehmden Manual schedule: Possibility to enter a show name Feature Requests 1
    N [Finished] [MP2-806] Playing a recorded radio program does not show screen to allow skipping forward, etc MediaPortal 2 141
    B Media info shows audio is 5.1 MP shows 2.0 Watch / Listen Media 2
    Similar threads

























    Top Bottom