Gbpvr 1.1.5 Recorder Conflicts Problem

[SUPERMAN40]

In the recorder conflicts window I have 4 conflicts that are nonsense. Two of the 4 have different program names but all are labeled '1/1/0001 12PM-12AM'

I assume this is a problem with a database somewhere in the program directory.

How do I fix this problem?

[sub]

I dont know - try cancelling them.

[SUPERMAN40]

they will not cancel

[sub]

Sorry, I dont know then. You could using a tool like SQLiteSpy to directly delete then from the database.

[SUPERMAN40]

I downloaded and tried SQLiteSpy and opened gbprv.db3 file. Can not find data related to 'conflicts'

There is sure a lot of data in the file and I am afraid to muck around too much

[sub]

If you execute the following SQL it'll delete the conflicts:

delete from RECORDING_SCHEDULE where status=5

[SUPERMAN40]

I am only slightly familiar with SQL statements. How do I run this? From and CMD or from a windows program? Where is the SQL program?

[sub]

You can run it from SQLiteSpy.

[SUPERMAN40]

It worked as you said. What I did, incase anyone else whats to know:

1. Made a blank notepad document with name 'updatesql' and extension .sql in the GBPVR directory
2. put the statement 'delete from RECORDING_SCHEDULE where status=5' in the document as the first and only line
3. open SQLiteSpy and /file/open sql opened the 'updatesql.sql' file
4. open the 'gbpvr.db3' file in the gbpvr directory
5. in the SQLiteSpy/execute/ click 'execute sql'

many thanks

[tvshowman]

thank you for the update info. that will help many figure out what they need to do,

glad you got it fixed

cheers!