2011-10-22, 10:21 PM
Since upgrading to 2.2.6, recording import has failed. An excerpt from NPVR.log is included below. I do not recall any problems during the install and everything else seems to be behaving. It was not until I tried to import a number of shows that I encountered the problem. Did I miss a DB update or something?
2011-10-22 15:12:32.367 [DEBUG][1] Import Recordings: Z:\Support\recording-dump.xml
2011-10-22 15:12:32.443 [DEBUG][1] Importing old-style GBPVR recordings-dump
2011-10-22 15:12:32.443 [DEBUG][1] - adding:Y:\90210\90210 S04E01.avi
2011-10-22 15:12:32.443 [DEBUG][1] Importing : Y:\90210\90210 S04E01.avi
2011-10-22 15:12:32.457 [ERROR][1] Unexpected error saving scheduled recording: System.Data.SQLite.SQLiteException: SQLite error
14 values for 13 columns
at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, 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(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at NUtility.ScheduledRecording.Save()
2011-10-22 15:12:32.367 [DEBUG][1] Import Recordings: Z:\Support\recording-dump.xml
2011-10-22 15:12:32.443 [DEBUG][1] Importing old-style GBPVR recordings-dump
2011-10-22 15:12:32.443 [DEBUG][1] - adding:Y:\90210\90210 S04E01.avi
2011-10-22 15:12:32.443 [DEBUG][1] Importing : Y:\90210\90210 S04E01.avi
2011-10-22 15:12:32.457 [ERROR][1] Unexpected error saving scheduled recording: System.Data.SQLite.SQLiteException: SQLite error
14 values for 13 columns
at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, 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(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at NUtility.ScheduledRecording.Save()