deleted recordings don't go away even with AutoRemoveMissingRecordings

[pvruser]

Hi!

using v1.2.9. I'm normally just watching the files by double-click but i'm trying to use an MVP and i see many of the old recordings that i manually deleted are still there (marked with failed). they look the same on the windows interface. i have these tags enabled:

<CheckForRenamedRecordings>true</CheckForRenamedRecordings>
<AutoRemoveMissingRecordings>true</AutoRemoveMissingRecordings>

i've noticed that recording-dump.xml is updated every time i refresh the EPG however i also see these kinds of tags there:

<recording>
<filename>Frasier</filename>
<channel>50.1 WKBDDT</channel>
<status>SEASON</status>
<group>157</group>
<prePadding>0</prePadding>
<postPadding>0</postPadding>
<startTime>0001-01-01 00:00:00</startTime>
<endTime>0001-01-01 00:00:00</endTime>
<title>Frasier</title>
<uid>EP00080939.0164</uid>
</recording>

how do i get rid of these so they dont show up as failed on the MVP/interface?

EDIT: looks like some of these "fantoms" are not even exported to the recording-dump.xml yet they show in the MVP/interface!

thanks!

[pvruser]

i downloaded "SQLite2008 Pro Enterprise Manager" which is a pretty good freeware admin tool for sqlite but i cant see where all the recordings are... the PROGRAMME and RECORDING_SCHEDULE tables appear to be empty for some reason. i even stopped the services to avoid locked tables and i still cant find anything close to recordings... although i did find the channel list and i may just remove those bogus unused ones.

anyone help please?

[sub]

Are you using a client PC? These settings relating to automatic recording removal are removed when you're just running a client PC.

Starting the app on the server PC would cause it to do the job.

[pvruser]

Are you using a client PC? These settings relating to automatic recording removal are removed when you're just running a client PC.

Starting the app on the server PC would cause it to do the job.

i only have 1 PC that i use for all home stuff including gbpvr and i ran this "SQLite2008 Pro Enterprise Manager" on it too by browsing to the standard location C:\Program Files\devnz\gbpvr\gbpvr.db3. any idea why i still see those recordings in the GUI but i dont see anything in the tool when i look at the DB directly or in the exports? if i open the db in notepad i can find those entries by direct text search but obviously that doesnt help me...

[sub]

I dont know anything about "SQLite2008 Pro Enterprise Manager", so cant really advise on how to use it. If you're on Vista, its possible you're not looking at the real database - it's VirtualStore can be tricky with background copies of the file elsewhere on disk.

[pvruser]

I dont know anything about "SQLite2008 Pro Enterprise Manager", so cant really advise on how to use it. If you're on Vista, its possible you're not looking at the real database - it's VirtualStore can be tricky with background copies of the file elsewhere on disk.

nope XP... i can search for some other sqlite DB admin. still doesnt quite explain why i'm seeing some additional recordings in the GUI...

i'll probably refresh the DB and start a new one or smth if nothing else helps.

[sub]

Any recordings showing in the Recordings screen definitely come out of the database, so you must be looking in the wrong place.

[pvruser]

Any recordings showing in the Recordings screen definitely come out of the database, so you must be looking in the wrong place.

yep that util is crap. i got another one from http://sqliteadmin.orbmu2k.de/ (SQLite Administrator) and this one is showing my recordings.

now i have an added problem: the app crashes during EPG update when it tries to do the recordings export because i removed those "non favorite" channels which probably had recordings attached to them... and of course i have no backup of the DB...

so i'll try to re-import the recodrings from the XML backup - hope that works...

[sub]

now i have an added problem: the app crashes during EPG update when it tries to do the recordings export because i removed those "non favorite" channels which probably had recordings attached to them... and of course i have no backup of the DB...

Never dick around in the database without backing up first... (this type of breakage isnt supported by me)

[pvruser]

Never dick around in the database without backing up first... (this type of breakage isnt supported by me)

yeah thats fine i was bored anyway i guess we'll never find out why those extra recordings were there...