4 hours ago
Hi folks!
Frustratingly, I discovered last night that my DVR hasn't been working correctly for a few days now, and that the Recordings database has somehow become corrupted. Recordings that I have made in the past have disappeared from both NextPVR and Kodi, new recordings aren't working, the whole nine.
(Oh: Windows 11 PC, NextPVR as the backend, Kodi as the front, HDHomeRun Prime as the tuner. All updated fully.)
On the upside, the file themselves (the .ts, and .xml, and thumbnail and timing for more recent recordings) still exist for everything.
I'm thinking NextTool is the way to go to get my recording database cleaned and rebuilt. Problem is when I ran it the first time (with "nexttool --import <path to my Recordings folder which has no spaces>", and yes, I backed up the NPVR-Data folder first), it appeared to run, and it looks like it may have fixed some things, but it missed some folders in there, which leads me to believe that there is still some corruption in my Recordings database and that I'm best served recreating that from go, especially considering I have all of the proper metadata to do it right.
Other weirdness: the NextPVR web client can't find any files to play back, while Kodi and the NPVR desktop apps play back what it found just fine. It just either didn't find everything in my Recordings folder (even though the logs say they were processed), or there is still DB corruption.
I would rather not blow the whole npvr.db3 out and have to set everything up from scratch. How can I clear out just the recordings DB so that NextTool can rebuild my recordings directory? I am not afraid to go in there with DB Browser if I have instructions as to what to do.
Thanks much for the help!
-- Chris
Frustratingly, I discovered last night that my DVR hasn't been working correctly for a few days now, and that the Recordings database has somehow become corrupted. Recordings that I have made in the past have disappeared from both NextPVR and Kodi, new recordings aren't working, the whole nine.
(Oh: Windows 11 PC, NextPVR as the backend, Kodi as the front, HDHomeRun Prime as the tuner. All updated fully.)
On the upside, the file themselves (the .ts, and .xml, and thumbnail and timing for more recent recordings) still exist for everything.
I'm thinking NextTool is the way to go to get my recording database cleaned and rebuilt. Problem is when I ran it the first time (with "nexttool --import <path to my Recordings folder which has no spaces>", and yes, I backed up the NPVR-Data folder first), it appeared to run, and it looks like it may have fixed some things, but it missed some folders in there, which leads me to believe that there is still some corruption in my Recordings database and that I'm best served recreating that from go, especially considering I have all of the proper metadata to do it right.
Other weirdness: the NextPVR web client can't find any files to play back, while Kodi and the NPVR desktop apps play back what it found just fine. It just either didn't find everything in my Recordings folder (even though the logs say they were processed), or there is still DB corruption.
I would rather not blow the whole npvr.db3 out and have to set everything up from scratch. How can I clear out just the recordings DB so that NextTool can rebuild my recordings directory? I am not afraid to go in there with DB Browser if I have instructions as to what to do.
Thanks much for the help!
-- Chris
