Page 1 of 1

No history all of a sudden

Posted: December 24th, 2014, 11:15 am
by jang430
I'm using SABnzbd Version: 0.7.20. All of a sudden, history doesn't show all successful and unsuccessful downloads. It's all clean. I've restarted sabnzbd on unraid machine. I've stopped, and started the app. I wasn't even on SABnzbd Version: 0.7.20 before, and updated it to this current version. Still the same problem.

Please help.

Re: No history all of a sudden

Posted: December 24th, 2014, 11:39 am
by shypike
Try deleting the history1.db file in SABnzbd's profile folder.

Re: No history all of a sudden

Posted: December 24th, 2014, 9:18 pm
by jang430
Not sure if the same, I deleted the file from here, \\tower\cache\.apps\sabnzbd_config\admin, still having the same results.

There are these warnings though

2014-12-25 10:17:40,433 ERROR: SQL Command Failed, see log
2014-12-25 10:17:40,409 ERROR: SQL Command Failed, see log

Re: No history all of a sudden

Posted: December 24th, 2014, 11:07 pm
by jang430
btw, merry christmas!

Re: No history all of a sudden

Posted: December 27th, 2014, 8:27 am
by shypike
Thanks, I was mostly off-line during Christmas.
So you're getting the error even with a fresh sql database?
It could mean an incompatibility between the installed SQLite, Python and/or SABnzbd.
I think I had a look at unraid before, but it doesn't support visualization,
making it too hard for me to test.
I'll soon get back to you about debugging options.

Re: No history all of a sudden

Posted: December 27th, 2014, 12:21 pm
by sander
Out of curiosity: what is the file size of your history1.db? Here's mine:

Code: Select all

-rw-r--r-- 1 sander sander  17408 dec 27 17:47 history1.db
On Linux, I can watch the contents (and thus correctness of the file) with:

Code: Select all

sqlitebrowser history1.db
HTH