recordings screen exits as soon as it enters and unhandled exception viewing tv guide

[fdm225]

Hi all,
I am having the weirdest problem! Today, I was watching a show using gbpvr. After the show was done I was deleted it and then GBPVR froze up. So I left it sit for a while, to which it exited out of the recordings screen and went to the main menu. Now if I try to go to either the recordings screen or tv guide I get two very different issues:

If I go to the recordings screen GBPVR draws the screen and then exits back to the main menu as fast as it draws it.

If I go to the tv guide I get an unhandled exception due to an invalid date string and the program then crashes.

This is really strange due to the fact that prior to watching and deleting this show it worked great! Since then I have tried to repair/uninstall/reinstall GBPVR with the same results. Any ideas?

dave

ps. The logs I have included are from after the uninstall and reinstall. I should have the logs from right after I deleted show but I would have to go and get them off of the machine.

[JavaWiz]

Code:

2009-05-11 21:23:19.984 ERROR [1] Failure in ChannelFactory::loadProgrammeByOID(): String was not recognized as a valid DateTime.
(Shown several times in the log)
....
2009-05-11 21:27:56.156 VERBOSE [1] Emptying EPG...
2009-05-11 21:28:26.531 ERROR [1] Error with EmptyEPG : System.Data.SQLite.SQLiteException: The database file is locked
database is locked
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at GBPVR.Backend.Common.xbdfb880686f2538b.x52e8ddd0b9bc8c68(IEpgUpdateProgressCallback x421ce789b9741187)

Indicates you have a corrupted db. Based on error message, it's not clear which table has the problem (one with a datetime field).

A possible solution may be to delete your capture sources, empty your EPG, then re-add capture sources and load EPG.

[fdm225]

wow, that's painful.

dave

[JavaWiz]

Well.... you could try zipping and posting your gbpvr.db3. Might be able to spot the bad date-time field and clean up.

[fdm225]

I would greatly appreciate that!

dave

[Carlito]

try this db.
How I Met Your mother had a different start and end time format then all the other records. Not sure how..

[JavaWiz]

I found one entry in the RECORDING_SCHEDULE table that looked suspect. I've deleted in the attached db copy.

Make a backup of your db, then overlay gbpvr.db3 with this version and see if your problem goes away....

[fdm225]

Great, will try it tonight! Thanks for looking.

dave