Location IS NOT NULL :: database disk image is malformed

[jakapo261]

Been receiving this message every time my music library is scanned. This error only started after hte my last update. I'm on the following Version: 6b4fbe0

Please help!

I'm really not looking forward to dumping the db and starting fresh... it's nearly 300mb in size. Took 2 and a half days to scan it initially.

2014-11-01 21:37:41 ERROR Uncaught exception: Traceback (most recent call last):
File "D:\HTPC\headphones\headphones\logger.py", line 204, in new_run
old_run(_args, *_kwargs)
File "E:\Program Files\Python27\lib\threading.py", line 504, in run
self.__target(_self.__args, *_self.__kwargs)
File "D:\HTPC\headphones\headphones\librarysync.py", line 53, in libraryScan
tracks = myDB.select('SELECT Location from alltracks WHERE Location IS NOT NULL UNION SELECT Location from tracks WHERE Location IS NOT NULL')
File "D:\HTPC\headphones\headphones\db.py", line 85, in select
sqlResults = self.action(query, args).fetchall()
File "D:\HTPC\headphones\headphones\db.py", line 66, in action
sqlResult = c.execute(query)
DatabaseError: database disk image is malformed
2014-11-01 21:37:41 ERROR Fatal Error executing SELECT Location from alltracks WHERE Location IS NOT NULL UNION SELECT Location from tracks WHERE Location IS NOT NULL :: database disk image is malformed

[AdeHub]

Have a look at these:
#1178
#1053
#1676

[jakapo261]

Thanks AbeHub, I had tried searching the issues log initially for this malformed error but only found one instance that spoke to a set of "" in the config file causing an issue but this is obviously not the issue I am experiencing.

I will give the recommended solution a go and supply feedback once done.

[jakapo261]

Tried the solution recommended above and it worked. Tip for windows users who are really not technical.

Download sqllte3 + the .dll from here: http://www.sqlite.org/download.html .
Download Cygwin from here http://cygwin.com/install.html

Install Cygwin to a directory of your choice. Once done unpack the two Sqlite .zip files to the bin folder within the Cygwin install directory. For me this was: E:\cygwin64\bin\

Stop HP
Run Cygwin
From within the CMD Line
CD to your Headphones directory
mv headphones.db headphones.db.bak
sqlite3 headphones.db.bak .dump | sqlite3 headphones.db (note the full stop in front of "dump")

Cheers
Lyle

[basilfx]

I have added this to the Troubleshooting wiki. Thanks for the guide.