Page 1 of 1

No History Displayed.

Posted: June 14th, 2010, 7:59 am
by 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.

Re: No History Displayed.

Posted: June 14th, 2010, 8:32 am
by jcfp
Try again with logging set to 'debug'.

Re: No History Displayed.

Posted: June 14th, 2010, 9:31 am
by cowfodder
Duh, first rule.

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

http://pastebin.com/3g7WUxA1

Re: No History Displayed.

Posted: June 14th, 2010, 11:53 am
by shypike
Looks like a corrupt history1.db file in the admin folder.
What happens if you stop SABnzbd, remove the file and restart SABnzbd?

Re: No History Displayed.

Posted: June 14th, 2010, 1:03 pm
by cowfodder
shypike wrote: 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!

Re: No History Displayed.

Posted: March 11th, 2011, 2:41 am
by 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.