GPVR not playing from where I last watched

[zehd]

Damn. I'll have to play with this later. It don't run under Vista because of the increased file permissions.

(Quick overview, it keeps tripping the NoFiles section, even though they exist. I'll have to try turning UAC or something off.)

More than likely, you're right. If the files exist and everything from the zip is IN the GB-PVR folder, then it shouldn't trip to NOFILES...

I'm not versed in Vista (and probably never will be - I'm waiting for the next OS) but I understand it's something to do with a User folder that sort of mirrors the gb-pvr folder.

Anyone?

[whurlston]

More than likely, you're right. If the files exist and everything from the zip is IN the GB-PVR folder, then it shouldn't trip to NOFILES...

I'm not versed in Vista (and probably never will be - I'm waiting for the next OS) but I understand it's something to do with a User folder that sort of mirrors the gb-pvr folder.

Anyone?

"c:\users\<username>\appdata\local\virtualstore\program files\devnz\gbpvr"

[zehd]

"c:\users\<username>\appdata\local\virtualstore\program files\devnz\gbpvr"

Right... and vista users should delete that folder so that no one is confused....

[jksmurf]

I went from Prereleases of 1.2.x series, to final 1.2.13, to prereleases of 1.3.x to final 1.3.7

yes my problem is Recorded MPGs on an MVP. Playback position is not stored while viewing on MVP, though it will read and seek to, something that was set using the PC Gui.

I'm on 1.3.7 three machines, MVP same problem, no problem PC Client

I'll check structure before and after executing sql statements. And post if not fixed

Ohhh zehd .... you beauty, can't wait to try this, I assume it is a one-off fix? . I also have the same upgrade path (w/o the betas) and couldn't get a decent resume on the MVP. It gave me the button then went to the start of the file anyway. I've just been skipping forward manually ...

k.

[zehd]

Ohhh zehd .... you beauty, can't wait to try this, I assume it is a one-off fix? . I also have the same upgrade path (w/o the betas) and couldn't get a decent resume on the MVP. It gave me the button then went to the start of the file anyway. I've just been skipping forward manually ...

k.

You can do it a hundred times and it won't matter. It'll only need once... But remember, it does wipe out the table with existing playback positions. But then that should be OK. It'll be like watching everything new again...

[jksmurf]

Hmmm ... does the error about delete means it didn't work? Ran the bat as administrator in VISTA 32 Home Premium ..

k.

[HarryH3]

Windows/DOS doesn't understand the whole word delete. Just use del and the delete will happen.

[jksmurf]

Code:

@echo off


if not exist gbpvr.db3 goto NoFiles
if not exist pvrx2.exe goto NoFiles
if not exist sqlite3.exe goto NoFiles
if not exist sleep.exe goto NoFiles

rem creating the dated backup string
rem there is some logic errors in this code, the placeholders are whacked
rem but the reult is correct...

For /f "tokens=1-7 delims=:/-, " %%i in ('echo exit^|cmd /q /k"prompt $D $T"') do (
    For /f "tokens=2-4 delims=/-,() skip=1" %%a in ('echo.^|date') do (
        set dow=%%i
        set %%a=%%j
        set %%b=%%k
        set %%c=%%l
        set hh=%%m
        set min=%%n
        set ss=%%o
    )
)

set BackupFileame=%mm%-%dd%-%dow%--%yy%.%hh%.recording-dump.xml
set BackupDatabase=%mm%-%dd%-%dow%--%yy%.%hh%.gbpvr.db3

echo %BackupFileame%

cls
echo --------------------------------------------------------------------
echo This batch file will fix Resume for the MVP listings in ascending order...
echo --------------------------------------------------------------------
echo.
echo.
echo.
echo.
echo.



copy gbpvr.db3 %BackupDatabase%

echo.
sleep 2

net stop "GB-PVR Recording Service"


cls
echo Fixing tables in GB-PVR...

sqlite3 gbpvr.db3 "[B][color=Red]Delete [/color][/B]FROM PLAYBACK_POSITION;"
sqlite3 gbpvr.db3 "alter table PLAYBACK_POSITION add column duration int"
sqlite3 gbpvr.db3 "alter table PLAYBACK_POSITION add column last_watched DATETIME"
sqlite3 gbpvr.db3 "update PLAYBACK_POSITION set last_watched = DATETIME('NOW') where last_watched is null"


[color=red][B][COLOR="Red"]Delete [/color][/B][/COLOR]FROM PROGRAMME;
pause


sleep 2

net start "GB-PVR Recording Service"


rem ren xUpdateEPG.bat UpdateEPG.bat
rem ren xPostUpdateEPG.bat PostUpdateEPG.bat

echo.
echo.
echo All Done...
echo.
echo.
echo.
echo.
pause

goto eof

:NoFiles

echo.
echo ERROR!!!
echo.
echo ========================================================================================
echo You need to have this Batch File and 'sqlite3.exe' and 'sleep.exe' IN the GB-PVR folder...
echo ========================================================================================
echo.

pause

:eof

pause

OK, changed Delete to del, seems to have gone a bit further ... BUT now an error with the path?

[mpking]

Sorry, you didn't get farther, you just got a different syntax error.

Delete is not a DOS\windows command in this context, it's a SQL command.

I wonder if it's a case sensitivity problem. The correct syntax is DELETE (All caps)

[sub]

Hmmm ... does the error about delete means it didn't work?

It means your database already has had those changes made, so it cant reapply it.