Page 1 of 1
Unable to Update/Insert NZB/Data record
Posted:
Tue Jul 03, 2018 6:18 pm
by Murg
I just upgraded to 6.80 and am getting some headers not loading into the database with one of two errors:
ERROR Unable to Update NZB Data Record
ERROR Unable to Insert Data Record
Firstly, what's going on?
Secondly, how do I revert back to 6.73?
Re: Unable to Update/Insert NZB/Data record
Posted:
Wed Jul 04, 2018 2:27 pm
by Quade
1 - Probably a corrupt header database for that group. I'd probably wipe the group and re-download headers for it.
2 - Install and run it.
Re: Unable to Update/Insert NZB/Data record
Posted:
Wed Jul 04, 2018 6:29 pm
by Murg
I have over 10 years of headers in the groups affected, don't really want to re-download them.
Is there a way to repair the database?
I reinstalled 6.73. Now I'm getting these errors in 6.73, where I've haven't seen them before. Did 6.80 do something to the database?
Re: Unable to Update/Insert NZB/Data record
Posted:
Wed Jul 04, 2018 9:01 pm
by Quade
They're typically unrepairable. You can sometimes dump them out and re-create them. You can google for methods to dump and recreate Sqlite databases.
Unless many files are doing it, you might just ignore the error too. If it's not a huge group, it might be easier just to re-download the headers.
Re: Unable to Update/Insert NZB/Data record
Posted:
Thu Jul 05, 2018 6:55 pm
by Murg
Ok. I made a back up before I installed 6.80, so I'll restore that.
Unfortunately, the groups are large, and the headers with the problem are the ones I want. The spam, of course, is not having any problems.