Version 1.4.7 New Install - New Recordings Missing from Recordings List

[donovan_ict]

I recently experienced a filesystem/bootsector crash on my tv pc, and took the opportunity to upgrade to windows 7. The system is running great and playing back all files I previously recorded, which were stored on other drives in the system.

Upon finishing install, I installed the latest GBPVR 1.4.7 and then copied over the config.xml gbpvr.db3 and recording-dump.xml from the crashed windows partition. I rebooted windows and GBPVR was up and running just as it was pre-crash.

Now I see a problem. I believe there may be some sort of lock on my database. The new recordings made this evening are not in the "Recordings" list. They do exist in the file structure, and playback on the screen.
I also just did a quick test of quick-recording a show, waiting a few minutes, cancelling the recording, and it did not show up in the "Recordings" listing.

I'm stumped!

D

[luttrell1962]

you can download sqlite database browser and look at RECORDING_SCHEDULE,
http://sourceforge.net/projects/sqlitebrowser/
Maybe you have corrupted entry that is preventing new recording from being entered. They are in order. I would backup my db3 file first and delete the last entry and see if that fixes the problem.

[luttrell1962]

Also if you look in pvrx2 you can see the last recording that shows up, it's probably the recording following that one that is corrupted. If thats whats going on.

[donovan_ict]

I opened the gbpvr.db3 file and nothing stands out as a corruption.
Is there a way to check the integrity of my database or validity of lists?
That table, RECORDING_SCHEDULE, was not in order. The beginning is, but not down the list.

I'd really like to not lose my recordings in the database. (Yes I know the files will still be there)

[mvallevand]

Copying files in Win7/Vista does require the you understand UAC. Perhaps you just copied them into the virtual store? Also if you copied after the install you could mess up any db conversion required going from one version to another. I do see the upgrade.ddl file is missing.

Martin

[donovan_ict]

I did not upgrade the GBPVR version. I was previously running 1.4.7

I'm guessing I'll just lose all my stuff and call my old database a loss, correct?

[luttrell1962]

It's not hopeless. With SQLite you can export your recording schedule to a csv file, I would do that. My recording schedules oid are in order. You said yours aren't that maybe the problem. If you have excel you can reorder them by oid and save that file (export) as csv.


Back up your database. Go in and delete and recording_schedule stuff and close the database. Open PVRX2 and make sure all your recordings are gone. try recording for a few minutes on something and see if it shows up on the recording section (if it does not you have a corrupted database) See below and get a fresh copy of it and reimport pertinent records . Reopen with SQLite and make sure that recording_schedule is still gone and then import the file the saved excel file. If you don't have excel download the trial software from microsoft or get by my some other means.

Reboot your computer. I'm not sure all the process's that need to be killed and restarted rebooting is easier

If still does not work export all the important records and then use a fresh copy of gbpvr.db3 then import the important stuff back in. reboot

Sample Excel Spreadsheet View

Code:

oid    programme_oid    capture_source_oid    status    filename    recording_type    recording_group    manual_start_time    manual_end_time    manual_channel_oid    quality_level    pre_pad_minutes    post_pad_minutes    priority
1    140321    5    4    Friends    5    1    30:00.0    30:00.0    178    1    1    2    1
2    140321    5    2    D:\livetv\Friends\Friends_20100205_17001730.avi    0    1    00:00.0    30:00.0    178    1    1    2    0
3    140322    5    4    That '70s Show    5    2    00:00.0    00:00.0    178    1    1    2    2
4    140322    5    2    D:\livetv\That 70s Show\That 70s Show_20100205_17301800.avi    0    2    30:00.0    00:00.0    178    1    1    2    0
5    140323    5    4    Family Guy    5    3    30:00.0    30:00.0    178    1    1    2    3
6    140323    5    2    D:\livetv\Family Guy\Family Guy_20100205_18001830.avi    0    3    00:00.0    30:00.0    178    1    1    2    0
7    140324    5    2    D:\livetv\Family Guy\Family Guy_20100205_18301900.avi    0    3    30:00.0    00:00.0    178    1    1    2    0
8    140325    5    4    Two and a Half Men    5    4    30:00.0    30:00.0    178    1    1    2    4
9    140325    5    2    D:\livetv\Two and a Half Men\Two and a Half Men_20100205_19001930.avi    0    4    00:00.0    30:00.0    178    1    1    2    0
10    140326    5    2    D:\livetv\Two and a Half Men\Two and a Half Men_20100205_19302000.ts    0    4    30:00.0    00:00.0    178    1    1    2    0
11    136573    5    4    Supernanny    5    5    30:00.0    30:00.0    174    1    1    2    5
12    136573    5    2    D:\livetv\Supernanny\Supernanny_20100205_20002100.ts    0    5    00:00.0    00:00.0    174    1    1    2    0
13    137415    5    4    Medium    5    6    30:00.0    30:00.0    175    1    1    2    6
14    137415    5    2    D:\livetv\Medium\Medium_20100205_21002200.avi    0    6    00:00.0    00:00.0    175    1    1    2    0
15    137416    5    4    NUMB3RS    5    7    30:00.0    30:00.0    175    1    1    2    7
16    137416    5    2    D:\livetv\NUMB3RS\NUMB3RS_20100205_22002300.ts    0    7    00:00.0    00:00.0    175    1    1    2    0
17    140330    5    4    Seinfeld    5    8    30:00.0    30:00.0    178    1    1    2    8
18    140330    5    2    D:\livetv\Seinfeld\Seinfeld_20100205_23002330.avi    0    8    00:00.0    30:00.0    178    1    1    2    0
19    140331    5    2    D:\livetv\Seinfeld\Seinfeld_20100205_23300000.avi    0    8    30:00.0    00:00.0    178    1    1    2    0
20    140332    5    4    The King of Queens    5    9    30:00.0    30:00.0    178    1    1    2    9
21    140332    5    2    D:\livetv\The King of Queens\The King of Queens_20100206_00000030.avi    0    9    00:00.0    30:00.0    178    1    1    2    0
22    140333    5    4    King of the Hill    5    10    00:00.0    00:00.0    178    1    1    2    10
23    140333    5    2    D:\livetv\King of the Hill\King of the Hill_20100206_00300100.avi    0    10    30:00.0    00:00.0    178    1    1    2    0
24    140334    5    4    Star Trek: The Next Generation    5    11    0001-01-01 00:00:00.0000000    0001-01-01 00:00:00.0000000    178    1    1    2    11
25    140334    5    2    D:\livetv\Star Trek The Next Generation\Star Trek The Next Generation_20100206_01000200.avi    0    11    00:00.0    00:00.0    178    1    1    2    0
26    140448    5    0    Star Trek: The Next Generation    0    11    00:00.0    00:00.0    178    1    1    2    0
27    141737    3    2    D:\livetv\Star Trek Enterprise\Star Trek Enterprise_20100205_16001700.mpg    0    0    00:00.0    00:00.0    102    0    1    2    0
28    141738    3    2    D:\livetv\Stargate Atlantis\Stargate Atlantis_20100205_17001800.mpg    0    0    00:00.0    00:00.0    102    0    1    2    0
29    143144    5    2    D:\livetv\Bob the Builder\Bob the Builder_20100206_09301000.avi    0    0    30:00.0    00:00.0    171    1    1    2    0
30    143305    5    2    D:\livetv\Barbecue University With Steven Raichlen\Barbecue University With Steven Raichlen_20100206_10001030.avi    0    0    00:00.0    30:00.0    172    1    1    2    0
31    147858    5    0    Star Trek: The Next Generation    0    11    00:00.0    00:00.0    178    1    1    2    0
32    146139    5    2    D:\livetv\The Matrix Reloaded\The Matrix Reloaded_20100206_15001800.ts    0    0    00:00.0    00:00.0    181    1    1    2    0
33    146140    5    1    D:\livetv\The Matrix Revolutions\The Matrix Revolutions_20100206_18002030.ts    0    0    00:00.0    30:00.0    181    1    1    2    0
34    147928    1    0    Two and a Half Men    0    0    00:00.0    30:00.0    38    1    1    2    0
35    147929    1    0    Two and a Half Men    0    0    30:00.0    00:00.0    38    1    1    2    0
36    147744    5    0    Seinfeld    0    0    00:00.0    30:00.0    178    1    1    2    0
37    147745    5    0    Seinfeld    0    0    30:00.0    00:00.0    178    1    1    2    0
38    145855    5    0    Desperate Housewives    0    0    30:00.0    30:00.0    177    1    1    2    0
39    145854    5    0    Boston Legal    0    0    30:00.0    30:00.0    177    1    1    2    0
40    143882    3    2    D:\livetv\The One\The One_20100206_11001300.mpg    0    0    00:00.0    13:22.0    153    1    1    2    0
41    143882    3    2    D:\livetv\The One\The One_20100206_11001300-2.mpg    0    0    00:00.0    15:10.0    153    0    1    2    0
42    143882    3    2    D:\livetv\The One\The One_20100206_11001300-2.avi    0    0    00:00.0    00:00.0    153    0    1    2    0
43    145303    5    2    D:\livetv\Barbecue America\Barbecue America_20100206_12001230.avi    0    0    00:00.0    30:00.0    172    1    1    2    0

Sorry I can't get the columns to line up in the view, I tried comma delimited text also same thing.

[mvallevand]

I did not upgrade the GBPVR version. I was previously running 1.4.7

I'm guessing I'll just lose all my stuff and call my old database a loss, correct?

Before giving up I'd check to make sure your files aren't in the Virtual Store

dir "%LOCALAPPDATA%\VirtualStore\Program Files\devnz\GBPVR"

Martin

[luttrell1962]

SQLite also has a compact feature that may repair the database without going through the hassle of exporting everything.

This would drive me nuts

On the brighter side if you want to change the location of your recordings say you add a new hard drive. You can export the recordings file and do a search and replace in excel to point to the new drive letter and path. Then import them back in. Useful information.

[donovan_ict]

Thanks for all the suggestions! I'll try the export, re-order, and import process.

mvallevand, I do not have any files in the virtual store. Thanks for that suggestion.