I have a unique issue, I got NzbDrone updated to the newest version and got everything setup and working. On one series I added the automatic search gave back an error about exceeding the retention limit, so I went in and changed the retention limit to an unnecessarily large number to test (9999999999). Now that same series says retention limit too large, and when I try to go to the settings to change it I get the loading animation indefinitely on each setting page. For hours. So I cannot change a single setting now through the GUI, does anybody know how to set the retention limit any other way?
You’ll have to change it in the database directly, in the Settings table, in the Config Table you want to change the “Retention” key. Setting the retention to 0 will set it to infinite (the default).
The DB is in C:\ProgramData\zbDrone
Thank you that is exactly what I was looking for, however forgive my ignorance but what program can I use to open that database? I tried a SQLliteManager program and it said the file was encrypted and required a password. I found the key opening it in Notepad++ but changing it with that didn’t work either. This is on a Windows 7 x64 machine.
I use http://fishcodelib.com/Database.htm - its not encrypted or password protected.
Thank you very much that did it, I appreciate all your help.