Resume/Firefly oddities

[TheSneak]

On certain files in my video library, the resume option will not work. Also, clicking pause/ff/rew on the firefly remote does not work until after I click the "Help" button. Weird. This is in pvrx2.exe.

[sub]

2008-07-03 13:51:29.748 WARNING [1] Unexpected error updating PLAYBACK_POSITION: System.Data.SQLite.SQLiteException: SQLite error
no such column: duration

It doesnt look like one of the database updates applied on your installed.

You probably need to use a tool like SQLiteSpy to execute the following statements:

Code:

alter table PLAYBACK_POSITION add column duration int
alter table PLAYBACK_POSITION add column last_watched DATETIME
update PLAYBACK_POSITION set last_watched = DATETIME('NOW') where last_watched is null

[TheSneak]

Thanks, sub. I restored my db from a previous install. I guess that was a bad idea. But your sql commands did the trick for resume.

Any idea why I have to click menu on my remote before the ff/rew/pause buttons will work? no big deal if you don't know.

[sub]

I dont know. It sounds like maybe something is stealing the focus from the application, so your firefly remote doesnt see it as the current application, causing the ff/rew/pause buttons etc to not be sent to the GB-PVR.

Using the offical divx decoder has been known to do this in the past. (as it creates a tray icon and switches the focus to it)