video archive issues

[paperchaser]

I also looked in the logs and find this in ArchiveDB-MVP.log:

06/13/06 11:50:26:935 PM[15] Error removing recording record for file C:\MyVideos\The Colbert Report\The Colbert Report_20060530_23300000.mpg System.Data.SQLite.SQLiteException: SQLite error
no such table: RECORDING_TABLE
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at ArchiveVideosPlugin.VideoFileInfoDialog.RemoveRecording()
06/13/06 11:50:33:482 PM[15] Error removing recording record for file C:\MyVideos\The Colbert Report\The Colbert Report_20060525_23300000.mpg System.Data.SQLite.SQLiteException: SQLite error
no such table: RECORDING_TABLE
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at ArchiveVideosPlugin.VideoFileInfoDialog.RemoveRecording()
06/13/06 11:50:47:904 PM[15] Error removing recording record for file C:\MyVideos\The Colbert Report\The Colbert Report_20060525_23300000.mpg System.Data.SQLite.SQLiteException: SQLite error
no such table: RECORDING_TABLE
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at ArchiveVideosPlugin.VideoFileInfoDialog.RemoveRecording()
06/13/06 11:50:53:482 PM[15] Error removing recording record for file C:\MyVideos\The Colbert Report\The Colbert Report_20060530_23300000.mpg System.Data.SQLite.SQLiteException: SQLite error
no such table: RECORDING_TABLE
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at ArchiveVideosPlugin.VideoFileInfoDialog.RemoveRecording()

[Jeff]

I think I found the mistake. I have just posted an update to the wiki.

Jeff

[paperchaser]

unfortunately the latest versions don't seem to do the trick. I'll have to test some more and post the logs.

[paperchaser]

Jeff-
It seems that recordings being made after the new plugin are deleted ok. But old listings with no underlying .mpg or .avi are still there. Here is the log as I try to delete 2 old shows:
06/16/06 07:31:03:203 PM[15] Deleting file C:\MyVideos\The Colbert Report\The Colbert Report_20060530_23300000.mpg
06/16/06 07:31:03:203 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060530_23300000.mpg to remove
06/16/06 07:31:03:203 PM[15] Removed from the filemap for directory Colbert Report
06/16/06 07:31:03:250 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060530_23300000.txt to remove
06/16/06 07:31:03:250 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060530_23300000.d2a to remove
06/16/06 07:31:03:250 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060530_23300000.edl to remove
06/16/06 07:31:03:250 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060530_23300000.log to remove
06/16/06 07:31:03:250 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060530_23300000.csv to remove
06/16/06 07:31:03:250 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060530_23300000.wme to remove
06/16/06 07:31:03:250 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060530_23300000.logo.txt to remove
06/16/06 07:31:09:484 PM[15] Deleting file C:\MyVideos\The Colbert Report\The Colbert Report_20060525_23300000.mpg
06/16/06 07:31:09:484 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060525_23300000.mpg to remove
06/16/06 07:31:09:484 PM[15] Removed from the filemap for directory Colbert Report
06/16/06 07:31:09:531 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060525_23300000.txt to remove
06/16/06 07:31:09:531 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060525_23300000.d2a to remove
06/16/06 07:31:09:531 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060525_23300000.edl to remove
06/16/06 07:31:09:531 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060525_23300000.log to remove
06/16/06 07:31:09:531 PM[15] Could not find file C:\MyVideos\The Colbert Report\The Colbert Report_20060525_23300000.csv to remove


The first listing deletes, then the second but then the folder refreshes and both listings are there again. I may just find a way to manually delete them from the database, which should hopefully solve the problem for a while.

[Jeff]

I know you've sent me your email address before, but can you send me a PM with it again? I think I have a fix (for real this time) that I'd like you to try.


Jeff

[paperchaser]

sorry but i hosed video-archive.mdb by trying to delete wrong listings using access. i reinstalled the plugin, which cured the problem. but i must have done something to cause it in the first place, if i can figure out what it was i'll let you know again.

i learned my lesson.

[Jeff]

Glad it works now. I'll post the update to the wiki site after working on a few more things. That way if the problem ever comes up again it should fix itself.

Jeff