Page 1 of 1

Problems with SQlite database, not saving history and renaming folders

Posted: September 26th, 2010, 9:19 am
by manks
Hi

Some how I've developed an error on SANnzbd.  Logging shows the following errors

FROM history
2010-09-26 15:04:20,551::INFO::[database:92] Traceback:
Traceback (most recent call last):
  File "/home/opt/share/SABnzbd/sabnzbd/database.py", line 85, in execute
    self.c.execute(command)
DatabaseError: database disk image is malformed


I haven't a clue what's causing the problem, how to fix it but its impacting my history and renaming of unpacked folders.  Any help gratefully appreciated . . .

Re: Problems with SQlite database, not saving history and renaming folders

Posted: September 26th, 2010, 10:31 am
by shypike
Highly unusual but your history database seems corrupted.
Stop SABnzbd.
Remove (or rename) the file history1.db in the "admin" folder.
This folder is a sub folder of where sabnzbd.ini is:
http://wiki.sabnzbd.org/configure-v2

Re: Problems with SQlite database, not saving history and renaming folders

Posted: September 26th, 2010, 10:53 am
by manks
Thanks that sorted it perfectly!