Problems with SQlite database, not saving history and renaming folders

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
manks
Newbie
Newbie
Posts: 36
Joined: January 22nd, 2008, 7:47 am

Problems with SQlite database, not saving history and renaming folders

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

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

Post 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
manks
Newbie
Newbie
Posts: 36
Joined: January 22nd, 2008, 7:47 am

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

Post by manks »

Thanks that sorted it perfectly!
Post Reply