HD HomeRun recording problem

[wtg]

Thanks whurlston... the db helps a bunch so I can see if any other tables are screwed up.

[sub]

Ok, I think I found the problem. I opened the gbpvr.db3 file and looked in the BDA_Recording_Source table... it's completely empty. So I looked in Config.log:

Code:

2010-01-31 23:29:33.791    ERROR    [1]    Error saving CaptureSource: SQLite error
table BDA_RECORDING_SOURCE has no column named ci_enabled
2010-01-31 23:29:33.807    ERROR    [1]    Stack:
   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 GBPVR.Backend.Common.BDARecordingSource.Save(DbConnection connection, Int32 captureSourceOID)
   at GBPVR.Backend.Common.xda34526142ca690b.x35ca223d3ef12fee()

Not sure what happened, but maybe the 1.4.7 upgrade wasn't entirely successful? Would you mind posting the table structure so I can add the column myself?

It looks like you copied a database from a previous release over your 1.4.7 (or the database upgrade procedure didnt run during the install, but we havent seen that happen before)

[wtg]

The database wasn't copied from a previous release so it must have messed up whenever I upgraded. Or at least, I would assume that the ci_enabled column came from the 1.4.7 upgrade.

I exported the schema of my DB and the one whurlston sent me to compare them and see if there were any other differences and there weren't. If there were other DB changes in the 1.4.7 release perhaps that gives you a little bit more to go on. In any event, thanks for the help, both from you and whurlston.

[sub]

I think there was three changes in the 1.4.7 release:

alter table PLAYBACK_POSITION add column duration int
alter table PLAYBACK_POSITION add column last_watched DATETIME
alter table BDA_RECORDING_SOURCE add column ci_enabled int

[wtg]

Thanks for the details. The two PLAYBACK_POSITION columns already exist, so it appears at least part of the db upgrade was successful.