File Opened is not a Database

[LewE]

Recently I have been getting errors where PVRX2 blows itself away. This seems to happen only with the Community skin. If I switch back to Blue skin it doesn't seem to happen.

Today, I deleted the Community3 directory and reinstalled the community skin from scratch and still got the error.

In the PVRX2.exe log I get the following entries. Any idea of what is happening?

2008-11-14 10:54:15.487 VERBOSE [1] tv guide render took@1: 0.00390625
2008-11-14 10:54:15.487 VERBOSE [1] tv guide render took@2: 0.00390625
2008-11-14 10:54:15.487 VERBOSE [1] tv guide render took@3: 0.00390625
2008-11-14 10:54:15.550 VERBOSE [1] tv guide render took@final: 0.07421875
2008-11-14 10:54:16.206 VERBOSE [1] Key pressed: Down
2008-11-14 10:54:16.206 VERBOSE [1] Beginning animation....
2008-11-14 10:54:16.206 VERBOSE [1] getValue cached value: /settings/ActiveSkin : Community3
2008-11-14 10:54:16.268 VERBOSE [1] Creating new GBPVRUiElement (selected)
2008-11-14 10:54:16.581 VERBOSE [1] Completed animation....56600.8203125
2008-11-14 10:54:16.753 ERROR [15] FATAL UNHANDLED EXCEPTION:: System.Data.SQLite.SQLiteException: File opened that is not a database file
file is encrypted or is not a database
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.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader()
at System.Data.SQLite.SQLiteConnection.Schema_Catalogs(String strCatalog)
at System.Data.SQLite.SQLiteConnection.GetSchema(String collectionName, String[] restrictionValues)
at System.Data.SQLite.SQLiteConnection.GetSchema(String collectionName)
at System.Data.SQLite.SQLiteConnection..ctor(SQLiteConnection connection)
at System.Data.SQLite.SQLiteConnection.Clone()
at CommonGBPVRUtilities.ArchiveDB.AddOrUpdateRecordForFile(String filename, ArchiveRecord record)
at CommonGBPVRUtilities.ArchiveDB.GetRecordForFile(String filename, ArchiveRecord record, Boolean firstcall)
at CommonGBPVRUtilities.ArchiveDB.GetRecordForFile(String filename, ArchiveRecord record)
at JeffsTree.JeffsTreeNode.FillTreeFromWhatsNewList(String seasonString, SortOrderType sortOrder, String currentUser)
at JeffsTree.DisplayListTree.GetListOfNewFiles(JeffsTreeNode whatsNewNode)
at JeffsTree.DisplayListTree.FillFileList(JeffsTreeNode dirNode, Int32 level)
at JeffsTree.DisplayListTree.FillFileListFromThread()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
2008-11-14 10:54:17.362 VERBOSE [1] Key pressed: Return
2008-11-14 10:54:17.393 WARNING [1] requested skin file not found: C:\Program Files\Devnz\GBPVR\skin2\Community3\TV Recordings\mmc.xml
2008-11-14 10:54:17.425 VERBOSE [1] Skinhelper loading image from file: C:\Program Files\Devnz\GBPVR\skin2\Community3\TV Recordings\..\_CoreImages\button_normal.png
2008-11-14 10:54:17.425 VERBOSE [1] Skinhelper loading image from file: C:\Program Files\Devnz\GBPVR\skin2\Community3\TV Recordings\..\_CoreImages\button_selected.png
2008-11-14 10:54:17.487 VERBOSE [1] Skinhelper loading image from file: C:\Program Files\Devnz\GBPVR\skin2\Community3\TV Recordings\..\_CoreImages\ListView.png

[Hairy]

2008-11-14 10:54:17.393 WARNING [1] requested skin file not found: C:\Program Files\Devnz\GBPVR\skin2\Community3\TV Recordings\mmc.xml
2008-11-14 10:54:17.425 VERBOSE [1] Skinhelper loading image from file: C:\Program Files\Devnz\GBPVR\skin2\Community3\TV Recordings\..\_CoreImages\button_normal.png
2008-11-14 10:54:17.425 VERBOSE [1] Skinhelper loading image from file: C:\Program Files\Devnz\GBPVR\skin2\Community3\TV Recordings\..\_CoreImages\button_selected.png
2008-11-14 10:54:17.487 VERBOSE [1] Skinhelper loading image from file: C:\Program Files\Devnz\GBPVR\skin2\Community3\TV Recordings\..\_CoreImages\ListView.png

It could be related to the TV listings(/Recordings) plugin (?), try copying over the folder from the blue skin and see if that works.

[LewE]

It could be related to the TV listings(/Recordings) plugin (?), try copying over the folder from the blue skin and see if that works.

I found that the three "missing" png files were in the Community3/coreImages folder and didn't make any changes.

I copied an MMC.XML file from blue/NetRadio to Community3/netradio.

I then started PVRX2 and scheduled a program in TV Listings. After it seemed to take it PVRX2 blew itself away.

Below is from the PVRX2.exe log. I have to believe that the FATAL UNHANDLED EXCEPTION is the significant issue here.

2008-11-15 05:46:44.338 VERBOSE [11] TV Listings: Listings loader thread finished.
2008-11-15 05:46:44.619 VERBOSE [15] Skin file not found: C:\Program Files\Devnz\GBPVR\skin\archive\skin.xml
2008-11-15 05:46:44.619 VERBOSE [15] ...about to check default skin
2008-11-15 05:46:44.619 VERBOSE [15] Initializing skin helper for: C:\Program Files\Devnz\GBPVR\skin\Community3\archive\skin.xml
2008-11-15 05:46:44.634 VERBOSE [15] getValue cached value: /settings/ActiveSkin : Community3
2008-11-15 05:47:01.431 VERBOSE [6] Skin file not found: C:\Program Files\Devnz\GBPVR\skin\archive\skin.xml
2008-11-15 05:47:01.431 VERBOSE [6] ...about to check default skin
2008-11-15 05:47:01.431 VERBOSE [6] Initializing skin helper for: C:\Program Files\Devnz\GBPVR\skin\Community3\archive\skin.xml
2008-11-15 05:47:01.431 VERBOSE [6] getValue cached value: /settings/ActiveSkin : Community3
2008-11-15 05:47:01.447 VERBOSE [14] Skin file not found: C:\Program Files\Devnz\GBPVR\skin\archive\skin.xml
2008-11-15 05:47:01.447 VERBOSE [14] ...about to check default skin
2008-11-15 05:47:01.447 VERBOSE [14] Initializing skin helper for: C:\Program Files\Devnz\GBPVR\skin\Community3\archive\skin.xml
2008-11-15 05:47:01.447 VERBOSE [14] getValue cached value: /settings/ActiveSkin : Community3
2008-11-15 05:47:02.072 VERBOSE [1] No key mapping found for: D6
2008-11-15 05:47:02.338 VERBOSE [1] No key mapping found for: D9
2008-11-15 05:47:02.384 ERROR [16] FATAL UNHANDLED EXCEPTION:: System.Data.SQLite.SQLiteException: File opened that is not a database file
file is encrypted or is not a database
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.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader()
at System.Data.SQLite.SQLiteConnection.Schema_Catalogs(String strCatalog)
at System.Data.SQLite.SQLiteConnection.GetSchema(String collectionName, String[] restrictionValues)
at System.Data.SQLite.SQLiteConnection.GetSchema(String collectionName)
at System.Data.SQLite.SQLiteConnection..ctor(SQLiteConnection connection)
at System.Data.SQLite.SQLiteConnection.Clone()
at CommonGBPVRUtilities.ArchiveDB.AddOrUpdateRecordForFile(String filename, ArchiveRecord record)
at CommonGBPVRUtilities.ArchiveDB.GetRecordForFile(String filename, ArchiveRecord record, Boolean firstcall)
at CommonGBPVRUtilities.ArchiveDB.GetRecordForFile(String filename, ArchiveRecord record)
at JeffsTree.JeffsTreeNode.FillTreeFromWhatsNewList(String seasonString, SortOrderType sortOrder, String currentUser)
at JeffsTree.DisplayListTree.GetListOfNewFiles(JeffsTreeNode whatsNewNode)
at JeffsTree.DisplayListTree.FillFileList(JeffsTreeNode dirNode, Int32 level)
at JeffsTree.DisplayListTree.FillFileListFromThread()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
2008-11-15 05:47:08.369 VERBOSE [1] Creating new GBPVRUiElement (normal)
2008-11-15 05:47:08.369 VERBOSE [1] Creating new GBPVRUiElement (selected)
2008-11-15 05:47:08.806 VERBOSE [10] TV Listings: About to schedule recording 'Record Once, [1013025] Iron Chef America * (c_44, 11/16/2008 5:30 PM - 7:00 PM)' ...
2008-11-15 05:47:08.838 VERBOSE [10] Looking for capture source to record: Iron Chef America *
2008-11-15 05:47:08.994 VERBOSE [10] Possible capture device: DEVICE:Hauppauge PVR350:2
2008-11-15 05:47:08.994 VERBOSE [10] Possible capture device: DEVICE:Hauppauge PVR150MCE:1
2008-11-15 05:47:08.994 VERBOSE [10] Checking 'PVR-350' (DEVICE:Hauppauge PVR350:2)
2008-11-15 05:47:08.994 VERBOSE [10] canRecord@1



The last entries in the log are:

2008-11-15 05:47:09.009 VERBOSE [10] canRecord@3
2008-11-15 05:47:09.009 VERBOSE [10] canRecord@exit (possible)
2008-11-15 05:47:09.041 VERBOSE [10] RecordingFactory.save()
2008-11-15 05:47:09.228 VERBOSE [10] Save(): Inserted new scheduled recording
2008-11-15 05:47:09.228 VERBOSE [10] Requesting recording service schedule reload
2008-11-15 05:47:09.259 VERBOSE [10] TV Listings: Successfully scheduled recording '[1163] Iron Chef America * [1013025] (c_44, 11/16/2008 5:30 PM - 7:00 PM)'.
2008-11-15 05:47:09.275 VERBOSE [1] Skinhelper loading image from file: C:\Program Files\Devnz\GBPVR\skin2\Community3\TV Listings\pending.png
2008-11-15 05:47:09.931 VERBOSE [13] TV Listings: About to update recording schedule...
2008-11-15 05:47:10.041 VERBOSE [13] TV Listings: Finished updating recording schedule.
2008-11-15 05:47:14.978 VERBOSE [1] OnPaint()

[LewE]

I found additional information about "Jeff".

In thread http://forums.nextpvr.com/showthread.php...light=jeff it mentions that "Jeff " was a programmer who contributed plugins but has since left GBPVR.

What should I do to remove any of these unsupported plugins without impacting everything else? Can I just delete these two DLLs?

The relevant portion from that thread is below:

What happes when a programmer leaves GBPVR for another MediaCenter?
I guess someone else has to invent the functions again.
Programmers that have "left" GBPVR that I remeber are Reven and Jeff.
Both made great plguins that died...... and good code with them.
One problem is that the programmers distribute their common DLLs with the plugins,
so when a user downloads a plugin, he might get old "Common Libraries".
I download a code browser tool and had a look at the Classes in the DLLs to see
how often the wheel has been reinvented.
I can see that many programmers amd the same functions.

I suggest that you programmers work together and "donate" code into "Common Libaries"
thar are open source code with a "Code Project License"
This would help new programmers to get started and the Common Functions would have lifetime
that goes beyond the programmers presens on the forum. Perhaps we would see more plugins also?
Perhaps Sub and you bright guys could organize something like this and maybe the "CommonLibraries"
could be distributed with GBPVR and get better and better, just like EWA.

Which programmer will take the first step?

Suggestion that Libraries are separeted into functions.
CommonUILibrary.dll - for UI related stuff
CommonMetadataLibrary.dll - for internet and metadata download stuff
CommonInterfaceLibrary.dll - for interfacing hardware stuff



Common Libraries by plugin developers.

// Module: CommonGBPVRUtilities.dll - by Jeff that seems to have left GBPVR?
// Classes

CommonGBPVRUtilities._DeviceVolumeMonitor
CommonGBPVRUtilities.ArchiveDB
CommonGBPVRUtilities.ArchiveRecord
CommonGBPVRUtilities.ConfigFileUtilities
CommonGBPVRUtilities.DeviceVolumeMonitor
CommonGBPVRUtilities.DeviceVolumeMonitorException
CommonGBPVRUtilities.DirectoryRecord
CommonGBPVRUtilities.DvdUtilities
CommonGBPVRUtilities.EditDialog
CommonGBPVRUtilities.ErrorDialog
CommonGBPVRUtilities.FileMapRecord
CommonGBPVRUtilities.GBPVRInfo
CommonGBPVRUtilities.InternetInfoFetcher
CommonGBPVRUtilities.MP3File
CommonGBPVRUtilities.PanelMessage
CommonGBPVRUtilities.PanelWidget
CommonGBPVRUtilities.PhoneKeys
CommonGBPVRUtilities.ScreenBoxParams
CommonGBPVRUtilities.ScreenButton
CommonGBPVRUtilities.SkinUtilities
CommonGBPVRUtilities.StatusLog
CommonGBPVRUtilities.UiUtilities
CommonGBPVRUtilities.UpcomingRecording
CommonGBPVRUtilities.UpcomingRecordings
CommonGBPVRUtilities.UserAccess
CommonGBPVRUtilities.UserRecord
CommonGBPVRUtilities.VAPanel
CommonGBPVRUtilities.VAPanelException
CommonGBPVRUtilities.YesNoDialog

// Module: JeffTree.dll - by Jeff
// Classes

JeffsTree.DisplayItem
JeffsTree.DisplayListTree
JeffsTree.DisplayListTreeSortOrder
JeffsTree.EpisodeInfo
JeffsTree.JeffsTreeNode
JeffsTree.ShellLink
JeffsTree.ShellShortcut

[LewE]

It could be related to the TV listings(/Recordings) plugin (?), try copying over the folder from the blue skin and see if that works.

I think I may have solved the problem. I had to go into Windows Control Panel and remove the Video Archive plug-in.

So far, no problems. I will watch it to see if that really cleaned it up.