Page 1 of 1

sql error trying to delete history

Posted: May 28th, 2010, 1:21 pm
by kevinj29
hi i am getting this error every few minutes any ideas?

2010-05-27 15:42:09,170::ERROR::[database:90] SQL Command Failed, see log
2010-05-27 15:42:09,171::DEBUG::[database:91] SQL: select count(*) from History WHERE name LIKE ?
2010-05-27 15:42:09,171::DEBUG::[database:92] Traceback:
Traceback (most recent call last):
  File "sabnzbd\database.pyo", line 83, in execute
OperationalError: no such table: History
this only appears when the queue is empty.

Re: sql error trying to delete history

Posted: May 28th, 2010, 1:50 pm
by shypike
Looks like a corrupted database file.
If you don't mind loosing your download history, the simplest repair is this:
Stop SABnzbd.
Delete the file history1.db
Start SABnzbd.

Since you didn't tell what operating system you are using,
lookup the location of the file here:
Windows XP: c:\documents and settings\user\local data\application data\sabnzbd\admin
Windows Vista or 7: c:\Users\user\AppData\Local\sabnzbd\admin
Unix :  $HOME/.sabnzbd/admin
OSX: /home/user/Library/Application Support/SABnzbd/admin

Re: sql error trying to delete history

Posted: March 11th, 2011, 2:42 am
by jat80
How would I access sabnzbd via my Synology NAS via telnet or SSH?  I have the same problem and need to delete the history1.db file as well.  What commands do I enter in terminal on my mac?