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

[fermin]

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.

 

[infinite.loop]

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).

 

[fermin]

where the group tabs are missing.

The group Tabs in TV-Channels have been removed by Mr.Hipp, thats not a bug.

Groups are managed inside the "TV-Channels -> TV Groups" section.

Can we please get the old group tabs back? They were great for quick ordering of channels, way easier than the way we have to do it now.

 

[infinite.loop]

Can we please get the old group tabs back?

Read my post (and the link inside) above your last post please.

 

[chemelli]

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.



Simone

 

[fermin]

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]

@
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

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]

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.



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

 

[thecubist]

@
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

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
Yes, I deleted encrypted radio stations by pressing the button "Delete encrypted". That's it.
Bye,
thecubist

 

[chemelli]

Now in mantis:

0002209: After deleting groupped scrambled Radio channels, you cannot access manual and group session anymore - MediaPortal Bugtracker

Simone