sql error trying to delete history

Report & discuss bugs found in SABnzbd
Forum rules
Help us help you:
  • Are you using the latest stable version of SABnzbd? Downloads page.
  • Tell us what system you run SABnzbd on.
  • Adhere to the forum rules.
  • Do you experience problems during downloading?
    Check your connection in Status and Interface settings window.
    Use Test Server in Config > Servers.
    We will probably ask you to do a test using only basic settings.
  • Do you experience problems during repair or unpacking?
    Enable +Debug logging in the Status and Interface settings window and share the relevant parts of the log here using [ code ] sections.
Post Reply
kevinj29
Newbie
Newbie
Posts: 1
Joined: May 26th, 2010, 1:46 pm

sql error trying to delete history

Post 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.
User avatar
shypike
Administrator
Administrator
Posts: 19774
Joined: January 18th, 2008, 12:49 pm

Re: sql error trying to delete history

Post 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
jat80
Newbie
Newbie
Posts: 8
Joined: March 10th, 2011, 7:34 pm

Re: sql error trying to delete history

Post 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?
Post Reply