Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: NPVR Recording Service - Unable to start service...

  1. #11
    Join Date
    Nov 2003
    Location
    NextPVR HQ, Wellington, New Zealand
    Posts
    76,171
    I dont know.

    Maybe try googling 'repair sqlite database file'

  2. #12
    Join Date
    Mar 2008
    Location
    USA
    Posts
    375
    I was able to "kind of" recreate my npvr.db3 file using these directions...

    http://structured-solutions.net/FixSqliteDatabase

    I used an older version of SQLite (http://www.sqlite.org/sqlite-3_6_16.zip) that was the current version when the directions were written as I had issues with the current SQLite version.

    I say "kind of" because everything appears to be fine, but the npvr.db3 file is smaller now. It's currently 41.7 MBs after an EPG update so it's almost half the size of the original. All channel names, recurring recordings, older recordings, decoders, etc. are listed as they were and appear to work fine so I am not sweating it at the moment. I still have a copy of the old npvr.db3 file that is corrupted.

  3. #13
    Join Date
    Jan 2011
    Location
    North Gloucestershire, England
    Posts
    523
    Try Firefox with the SQLite Manager add on. It is one of the best and easy to use SQLite managers and also has functions to check the integrity of the database.

  4. #14
    Join Date
    Nov 2005
    Location
    East Yorkshire, England
    Posts
    4,268
    Quote Originally Posted by jcjefferies View Post
    Try Firefox with the SQLite Manager add on. It is one of the best and easy to use SQLite managers and also has functions to check the integrity of the database.
    +1 for that one.


  5. #15
    Join Date
    Mar 2008
    Location
    USA
    Posts
    375
    This is what I get with that add on. I am not sure how to fix it though...

    Code:
    *** in database main ***
    Page 57927: unable to get the page. error code=266
    On tree page 79329 cell 42: Child page depth differs
    On tree page 79329 cell 43: Child page depth differs
    Page 57928: unable to get the page. error code=266
    On tree page 76648 cell 20: Child page depth differs
    On tree page 76648 cell 21: Child page depth differs
    Page 57925: unable to get the page. error code=266

  6. #16
    Join Date
    Mar 2008
    Location
    USA
    Posts
    375
    I gave this a try as well in Admin Command Prompt with SQLite3...

    Code:
    C:\Users\Public\NPVR>sqlite3.exe OLD_npvr.db3
    SQLite version 3.6.22
    Enter ".help" for instructions
    Enter SQL statements terminated with a ";"
    sqlite> pragma integrity_check;
    *** in database main ***
    Page 57927: unable to get the page. error code=266
    On tree page 79329 cell 42: Child page depth differs
    On tree page 79329 cell 43: Child page depth differs
    Page 57928: unable to get the page. error code=266
    On tree page 76648 cell 20: Child page depth differs
    On tree page 76648 cell 21: Child page depth differs
    Page 57925: unable to get the page. error code=266
    Error: disk I/O error
    sqlite>
    I guess there is no command to simply repair it

    HOWEVER, this still appears to be working fine...

    http://forums.gbpvr.com/showthread.p...749#post435749

    Code:
    C:\Users\Public\NPVR>sqlite3.exe npvr.db3
    SQLite version 3.6.22
    Enter ".help" for instructions
    Enter SQL statements terminated with a ";"
    sqlite> pragma integrity_check;
    ok
    sqlite>
    Last edited by BTJustice; 2012-05-01 at 11:45 PM.

  7. #17
    Join Date
    Nov 2005
    Location
    East Yorkshire, England
    Posts
    4,268
    I think what I would do is to export the whole database to a text file, rename the database to save it, startup and exit NPVR to create a new, blank database and then import the saved text backup. This is assuming your data is valid and just some of the internals are a bit iffy.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •