no longer getting prompted to resume?

[wannabepvr]

Upgraded to 1.2.13 and everything seemed well - but I just noticed that I am no longer getting prompted to resume.

Config.xml settings below.

[HTML] <!-- Misc Video Recording settings -->
<RecycleUSBUIRT>false</RecycleUSBUIRT>
<SkipInsteadOfFFRW>false</SkipInsteadOfFFRW>
<SkipInsteadOfFFRWSeconds>10</SkipInsteadOfFFRWSeconds>
<AudioSkipSeconds>10</AudioSkipSeconds>
<DefaultSkipSecondsForward>170</DefaultSkipSecondsForward>
<DefaultSkipSecondsBack>30</DefaultSkipSecondsBack>
<ManualSkipTimebase>Minutes</ManualSkipTimebase>
<AutoCreateFolders>true</AutoCreateFolders>
<PromptForResume>true</PromptForResume>
<UseMenuResumeButton>false</UseMenuResumeButton>
<StoreResumeStartExclusion>0</StoreResumeStartExclusion>
<StoreResumeEndExclusion>0</StoreResumeEndExclusion>
<WhatsNewDayCount>7</WhatsNewDayCount>
<PreShowPadding>4</PreShowPadding>[/HTML]

[sub]

Is there any errors appearing in your pvxr2.exe.log?

[wannabepvr]

Sure is: Hopefully you know what it means.
This occurs on all the different recordings I tried.


[HTML]2008-05-28 14:10:30.860 VERBOSE [1] PlaybackPositionManager.storeLastPlaybackPosition(S:\new_recordings\Good Game\Good Game_20080523_23550025.dvr-ms, 689)
2008-05-28 14:10:31.001 WARNING [1] 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-05-28 14:10:31.376 VERBOSE [1] EnableScreenSaver()[/HTML]

[sub]

Did you restore your gbpvr.db3 file after installing 1.2.13? If so, you shouldnt have. Your database seems to have reverted to an older 1.2.9 format and is missing the new 1.2.13 columns.

You can update it by excuting the following three statements in a tool like SQLiteSpy:

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

[wannabepvr]

Strange, I updated to 1.2.13 then deleted the database as I expected it would have carried over an old glitch (some old unused channels)
Then let the pvrX2 executable program create a new DB and set up my tuners from scratch.

[sub]

Odd. I just checked the empty.db3 file that is distributed with the application and it definitely has the new database columns, so I cant think why you wouldnt have had them if the app had to recreate the database.

...anyway, try executing those statements from above and you should be ok.

[wannabepvr]

Thank you so much for the help!

[wannabepvr]

When I look at either the empty.db3 or the new gbpvr.db3 created by pvrx2.exe, either seem to contain the extra fields? (The 'empty,db3' DB is dated 20feb08)

When I look at a fresh install on another machine the DB does have 5 columns for playback position.

(Please be gentile if I am being stupid and am very week when it comes do databases)\

The execute line in the non commercial version of SQLiteSpy seems to be greyed out. But it is only a few minutes to rescan my channels etc.

Anyway this is just filling you in on what I have found. I will fix my DB with one from the fresh install.

Thanks again.

[sub]

When I look at a fresh install on another machine the DB does have 5 columns for playback position.

But it is only a few minutes to rescan my channels etc.

Best bet is probably to copy the empty.db3 file from that other machine.

[wannabepvr]

Best bet is probably to copy the empty.db3 file from that other machine.

I think this is exactly the problem. I suspect you updated the default gbpvr.db3 to the new format, but left the old empty.db3 (20feb08) - because even the 'other machine' still had the old style DB in the empty.db3.

So when I deleted by new DB, pvrx2.exe copied and renamed empty.db3 and thats how I got the old 3 column position field.

Man that was confusing to type??!??! :confused:

Anyway I am all fixed now.