Groups in EPG

[dougfoot]

Installed latest version of NextPVR on a Windows 7 Ultimate x64, 16 gb RAM, 120gb SSD drive.
The only thing not working is setting up groups in the EPG.

No error given, however, looking at the log file NPVR.log, this error shows up:
2015-09-04 15:12:41.185 [ERROR][1] Unexpected error in Channel.SaveAll(): System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
table CHANNEL_GROUP has no column named sort
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.Channel.SaveGroupMemberships(String group, List`1 channels)

Attached should be my log files. Thank you for your assistance.

[johnsonx42]

nextpvr.exe -updatedb

(actually maybe that won't work if this was a new install... but it won't hurt anything either)

[johnsonx42]

sub, I think you screwed up somewheres... the 3.5.7 installer has an "empty.db3" dated 9/19/2014, and it doesn't have the sort column in the CHANNEL_GROUP table

(whereas the empty.db3 in my npvr directory is dated 6/5/2015 (or maybe 5/6/2015 for you backwards-date folks ), and does have the sort column)

[johnsonx42]

I'm not sure if this will work (but again won't hurt), but it may be sufficient to copy the correct version of the empty.db3 (attached) into your c:\user\public\npvr and then run the nextpvr.exe -updatedb command (I've always assumed that the updatedb command tells it to look at the structure of empty.db3 to make changes to the live database, but I may be wrong about how that works).

[dougfoot]

Running nextpvr.exe -updatedb did the trick. Thank you for the assistance.

[sub]

sub, I think you screwed up somewheres... the 3.5.7 installer has an "empty.db3" dated 9/19/2014, and it doesn't have the sort column in the CHANNEL_GROUP table

Oops. Right you are. I've fixed the installer to include this.

[pwzred]

Oops. Right you are. I've fixed the installer to include this.

Thank you! I just ran into the same problem and this fixed it. PZ