<solved> [NPVR 2.3.6] Database related problem after installation of NPVR 2.3.6

[ShiningDragon]

Hi,

i have a little problem after switching from 2.2.6 to 2.3.6.
I uninstalled the 2.2.6 completely, and removed the folder in the public one. I removed even any registry entry. The only thing i left was the npvr.db.
Then i did a clean installation of NPVR 2.3.6 without any further plugins. I can't start the recordingservice anymore because of this error:

Code:

Der Dienst kann nicht gestartet werden. System.Data.SQLite.SQLiteException: SQLite error
no such table: EPG_GENRE
   bei System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   bei System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   bei System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
   bei System.Data.Common.DbCommand.ExecuteReader()
   bei NShared.EPGManager..ctor()
   bei NShared.RecordingService..ctor()
   bei NRecord.RecordingService.OnStart(String[] args)
   bei System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

Any hint how i could insert the missing table without messing too much around on the server? Without deleting npvr.db? ^^

[sub]

Run "NextPVR.exe -updatedb" to fix it.

I uninstalled the 2.2.6 completely, and removed the folder in the public one. I removed even any registry entry. The only thing i left was the npvr.db.

If it's doing an upgrade, it expects to find config.xml and other files, so it knows the version of the database etc. I think by deleting these files, but leaving your npvr.db3 you've effectively had it use a database from an old version without the doing the database upgrade. This is not the normal way someone would upgrade.

[ShiningDragon]

Run "NextPVR.exe -updatedb" to fix it.

Great, this fixed it. Thank you!

If it's doing an upgrade, it expects to find config.xml and other files, so it knows the version of the database etc. I think by deleting these files, but leaving your npvr.db3 you've effectively had it use a database from an old version without the doing the database upgrade. This is not the normal way someone would upgrade.

Ah, ok. Good to know. I'll try to make any update clean as possible (without db, i am too lazy to make new channelscans and sorting them) so that i could identify new problems faster.