No History Displayed.

[cowfodder]

Hi all!  Love the program, and having deb packages makes things so much easier, but recently I've run into a problem that has me stumped.  After having to reinstall everything on my HTPC/downloading box, Sabnzbd+ no longer shows history.  I've checked the log, and the only thing I see over and over is

Code: Select all

2010-06-12 00:28:26,747::ERROR::[database:90] SQL Command Failed, see log

If I check the error log it's blank.

Version is 0.5.3RC1 on Linux XBMCLive 2.6.31-20-generic #58-Ubuntu SMP Fri Mar 12 05:23:09 UTC 2010 i686 GNU/Linux

It's not that big of a deal, except for being able to monitor bandwidth.

Thanks for your help.

[jcfp]

Try again with logging set to 'debug'.

[cowfodder]

Duh, first rule.

Here is the part of the logs after reboot with debugging on.

http://pastebin.com/3g7WUxA1

[shypike]

Looks like a corrupt history1.db file in the admin folder.
What happens if you stop SABnzbd, remove the file and restart SABnzbd?

[cowfodder]

Looks like a corrupt history1.db file in the admin folder.
What happens if you stop SABnzbd, remove the file and restart SABnzbd?

Looks to have fixed it.  I'll try a small download really quick to check.

*Small download confirms.  Thank you!

[jat80]

I have the same problem, how do I access it via telnet or ssh on my synology NAS to delete the history1.db file?  I have no idea how to use terminal in MAC.