config app crashes when I click Export button on Plugins tab

[Wakalaka]

logs attached

[sub]

If you zip and email your gbpvr.db3 I'll take a look. I'll pm you my email address.

[sub]

I've emailed you back a fixed database.

I'm not sure how it happened in the first place, but you ended up with a few 'Cities of the Underworld' recordings linked to a channel id which didnt exist in your database. I've updated thpse recordings to point them at the history channel.

[Wakalaka]

Comcast Cable (my provider) changed channel numbers around at the end of October. History Channel was one of them. Any way to put in a fix for this scenario? I had to remove all channels, then update channel data. I use Schedules Direct for channel data.

[sub]

It doesnt already try to work around this situation by leaving referenced channels in the database (visible in main channels tab), and only removing them from capture source channel list. Its not related to the channel numbers, but rather the channel being present in the database.

If you can tell me the exact steps to reproduce the problem, I'm sure I can fix it.

[Wakalaka]

Your zip file fixed the Export problem. However, now all "Cities of the Underworld" programs say they were recorded on WGNSAT (which is channel 9), and not HISTP (which is channel 50) like they should be. How do I fix this?

[sub]

Sorry, I must have put the wrong channel oid. Download something like SQLiteSpy and execute the following:

update "RECORDING_SCHEDULE" set manual_channel_oid = 25 where filename like '%Cities%';

[Wakalaka]

Problem fixed, thanks! I need to learn SQL better, it's pretty simple. I figured it was the oid that was set wrong for the recordings.