Resume doesn't work anymore

[johnvk]

Hi,

Seems that the resume-function has been broken, although setting in config file are correct (atleast imho)

Code:

<PromptForResume>true</PromptForResume>
  <UseMenuResumeButton>true</UseMenuResumeButton>
  <StoreResumeStartExclusion>0</StoreResumeStartExclusion>
  <StoreResumeEndExclusion>0</StoreResumeEndExclusion>

Inspecting the logfiles yield the following. Any help to fix this would be appreciated;
[HTML]
2008-09-24 08:56:24.781 VERBOSE [6] MVP request processed
2008-09-24 08:56:24.781 VERBOSE [6] MVP waiting for data
2008-09-24 08:56:24.859 VERBOSE [6] MVP data read: 1 (4)
2008-09-24 08:56:24.859 VERBOSE [6] User pressed: 27
2008-09-24 08:56:24.859 VERBOSE [6] about to call OnKeyDown()
2008-09-24 08:56:24.859 VERBOSE [6] PlaybackPositionManager.storeLastPlaybackPosition(\\Atlas\Movies\TV-opnamen\Bridget Joness diary\Bridget Joness diary_20080831_21402325.mpg, 11)
2008-09-24 08:56:24.859 WARNING [6] Unexpected error updating PLAYBACK_POSITION: System.Data.SQLite.SQLiteException: SQLite error
table PLAYBACK_POSITION has no column named duration
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.x38d54e470ed17baf.storeLastPlaybackPosition(String filename, Int32 lastKnownPosition, Int32 duration)
2008-09-24 08:56:24.859 VERBOSE [6] VideoPlayer.Stop()
2008-09-24 08:56:24.859 VERBOSE [6] VideoPlayer.Stop()@2
2008-09-24 08:56:24.859 VERBOSE [6] VideoPlayer.Stop()@3
2008-09-24 08:56:24.859 VERBOSE [6] MVPSendStopRequest()[/HTML]

Thanks in advance

John

[sub]

You'll need to use a tool like SQLiteSpy to execute the following statements against the gbpvr.db3 file.

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

[johnvk]

Works like a charm. Thanks!

John