TV Groups are not showing up in TVServer Setup (2 Viewers)

fermin

MP Donator
  • Premium Supporter
  • August 1, 2008
    57
    0
    Zug
    Home Country
    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

    • 2009-05-29-mptvdb-fermin.zip
      30.7 KB

    infinite.loop

    Retired Team Member
  • Premium Supporter
  • December 26, 2004
    16,163
    4,133
    127.0.0.1
    Home Country
    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
    49
    Milano, Italy
    Home Country
    Italy Italy
    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
    Home Country
    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
    Home Country
    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
    Home Country
    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

    • 090529_thecubist_mptvdb_after_channel_deletion.zip
      30.8 KB

    thecubist

    MP Donator
  • Premium Supporter
  • April 22, 2009
    31
    0
    Home Country
    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

    Top Bottom