"remove unreferenced channels" does not work

[zaldwaik]

I am trying to clean up my channel lineup, but this button does nothing. It never worked for me. I have a lot of channels that I do not subscribe to, that were added to my lineup by Zap2it, there does not seem to be a simple way to disable GB-PVR from adding new channels. At this point, I have too many channels and I do need a cleanup. I am using v.97.13

Removing channels one by one in the capture source is tedious and slow.

In case no way exists to do this through the inteface, which tables in the database I need to update to fix this problem?

[sub]

You're supposed to disable them in your channel lineup at http://labs.zap2it.com if you dont want them to be added, otherwise they'll get re-added with each EPG update.

If you've already got the channels, then you need to 'remove' them from each capture source channel list, then click the 'remove unreferenced channels' button.

[zaldwaik]

Dish network adds new channels all the time. Zap2it adds them to my list automatically, and there is not a way to disable that. Then they get added to my list in GBPVR.

Removing one channel at a time from each capture source (I cannot select multiple channels) will take me a week. I presume that removing the capture source completely will remove schedule recordings too?

I am skilled in SQL and if you feel that you can tell me which tables I can manipulate to remove channels, I would be grateful.

[sub]

I never recommend hacking manually in the database, but if you cant resist the urge, then the tables in question are CHANNEL and SOURCE_CHANNEL_MAPPING.

[gnutech]

I installed and used SQLiteSpy to delete unreferenced channels from my gbpvr.db3 database.

1. Make sure to make a copy of your working gbpvr.db3 database.
2. Remove all the channels from your recording source.
3. The remaining unreferenced channels will show under your channels tab.
4. Fire up SQLiteSpy.
5. In SQLiteSpy, right click and show data for the Channels table.
6. Use the following sql syntax to delete the remaining unreferenced rows (hit [F9] to execute sql):

DELETE FROM "CHANNEL" WHERE "oid" = 1;

7. Fire up the GB-PVR config utility and confirm the unreferenced rows have been removed.
8. Update your EPG and you should be back on your way.

Kind Regards,


Gary

[dennit]

Dish network adds new channels all the time. Zap2it adds them to my list automatically, and there is not a way to disable that. Then they get added to my list in GBPVR.

Removing one channel at a time from each capture source (I cannot select multiple channels) will take me a week. I presume that removing the capture source completely will remove schedule recordings too?

I am skilled in SQL and if you feel that you can tell me which tables I can manipulate to remove channels, I would be grateful.

I had a similar problem. You could could switch to mc2xml, it will let you list only the channels you want to retrieve.

If you stick with SD and it insists on adding new channels to the XML, then GBPVR will add them during the EPG update. However, they won't be mapped to a tuning string. This will let you select them, but remember that analogs are also without a tuning string, so also select on your source.

SELECT *
FROM SOURCE_CHANNEL_MAPPING
WHERE tuning_request is NULL and capture_source_oid in (3, 4, 7)

If you get the right answers, then change to delete them. After deleting select on CHANNEL where it's unreferenced:

select * from Channel c
where NOT EXISTS
(select * FROM SOURCE_CHANNEL_MAPPING scm
WHERE scm.channel_oid = c.oid OR c.channel_number=0)

The OR c.channel_number=0 is to prevent killing the IMPORT channel used by the vidimport plugin. If this works, then automate it.

You might ask SD nicely for an option of "do not add new channels" to the lineup.