history1.db - sql error

Get help with all aspects of 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
Symbiot
Newbie
Newbie
Posts: 15
Joined: March 1st, 2010, 3:40 am

history1.db - sql error

Post by Symbiot »

Hi

I can't seem to fix this:

Code: Select all

2013-07-06 09:30:06,837::DEBUG::[database:112] SQL: select count(*) from History WHERE name LIKE ?
2013-07-06 09:30:06,838::INFO::[database:113] Traceback: 
Traceback (most recent call last):
  File "/usr/share/sabnzbdplus/sabnzbd/database.py", line 104, in execute
    self.c.execute(command, args)
OperationalError: no such table: History
2013-07-06 09:30:06,850::ERROR::[database:111] SQL Command Failed, see log
2013-07-06 09:30:06,851::DEBUG::[database:112] SQL: SELECT * FROM history WHERE name LIKE ? ORDER BY completed desc LIMIT ?, ?
2013-07-06 09:30:06,851::INFO::[database:113] Traceback: 
Traceback (most recent call last):
  File "/usr/share/sabnzbdplus/sabnzbd/database.py", line 104, in execute
    self.c.execute(command, args)
OperationalError: no such table: history
2013-07-06 09:30:08,833::ERROR::[database:111] SQL Command Failed, see log
2013-07-06 09:30:08,834::DEBUG::[database:112] SQL: select count(*) from History WHERE name LIKE ?
2013-07-06 09:30:08,834::INFO::[database:113] Traceback: 
Traceback (most recent call last):
  File "/usr/share/sabnzbdplus/sabnzbd/database.py", line 104, in execute
    self.c.execute(command, args)
OperationalError: no such table: History
2013-07-06 09:30:08,852::ERROR::[database:111] SQL Command Failed, see log
2013-07-06 09:30:08,853::DEBUG::[database:112] SQL: SELECT * FROM history WHERE name LIKE ? ORDER BY completed desc LIMIT ?, ?
2013-07-06 09:30:08,853::INFO::[database:113] Traceback: 
Traceback (most recent call last):
  File "/usr/share/sabnzbdplus/sabnzbd/database.py", line 104, in execute
    self.c.execute(command, args)
OperationalError: no such table: history
I tried removing the history file.. I tried removing the admin dir.. and of course restarting sab
but nothing seems to help..

Sab is running on lubuntu on VMware. Admin folder is on WS2012 via shared folder.
The security on the folder/files in admin are set so all users have read/write/execute..

What else can I try?
User avatar
shypike
Administrator
Administrator
Posts: 19773
Joined: January 18th, 2008, 12:49 pm

Re: history1.db - sql error

Post by shypike »

Have you tried to put "admin" in a local folder?
I suspect that SQLite uses locking methods that aren't available on a shared drive.
Symbiot
Newbie
Newbie
Posts: 15
Joined: March 1st, 2010, 3:40 am

Re: history1.db - sql error

Post by Symbiot »

so far.. that seems to have worked.. Though I am giving it some more time ..then I'll move the dir again :-)
Thanks Shypike
Post Reply