SABnzbd Forums

Posted: **July 6th, 2013, 2:32 am**

Hi

I can't seem to fix this:

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?

Posted: **July 6th, 2013, 4:23 am**

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.

Posted: **July 7th, 2013, 3:31 am**

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

SABnzbd Forums

history1.db - sql error

history1.db - sql error

Re: history1.db - sql error

Re: history1.db - sql error