Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Fatal Error executing UPDATE descriptions SET Content = ?, LastUpdated = ?, Summary = ? WHERE ArtistID = ? :: database disk image is malformed #1676

Closed
Katmassive opened this issue May 25, 2014 · 3 comments
Labels

Comments

@Katmassive
Copy link

Win7 x64 Python27

Error: "Fatal Error executing UPDATE descriptions SET Content = ?, LastUpdated = ?, Summary = ? WHERE ArtistID = ? :: database disk image is malformed"

@Katmassive
Copy link
Author

500 Internal Server Error

The server encountered an unexpected condition which prevented it from fulfilling the request.

Traceback (most recent call last):
File "C:\Users\Server\Downloads_Headphones\lib/cherrypy_cprequest.py", line 656, in respond
response.body = self.handler()
File "C:\Users\Server\Downloads_Headphones\lib/cherrypy\lib\encoding.py", line 188, in call
self.body = self.oldhandler(_args, *_kwargs)
File "C:\Users\Server\Downloads_Headphones\lib/cherrypy_cpdispatch.py", line 34, in call
return self.callable(_self.args, *_self.kwargs)
File "C:\Users\Server\Downloads_Headphones\headphones\webserve.py", line 399, in upcoming
upcoming = myDB.select("SELECT * from albums WHERE ReleaseDate > date('now') order by ReleaseDate ASC")
File "C:\Users\Server\Downloads_Headphones\headphones\db.py", line 90, in select
sqlResults = self.action(query, args).fetchall()
File "C:\Users\Server\Downloads_Headphones\headphones\db.py", line 68, in action
sqlResult = self.connection.execute(query)
DatabaseError: database disk image is malformed

@piejanssens piejanssens added the Bug label Jul 4, 2014
@piejanssens
Copy link
Collaborator

Do you still have this issue?

@piejanssens
Copy link
Collaborator

Possible fix:
install sqlite3 if not already installed.
cd into your headphonesdirectory
Run the command
CODE: SELECT ALL
mv headphones.db headphones.db.bak
Run the command
CODE: SELECT ALL
sqlite3 headphones.db.bak .dump | sqlite3 headphones.db

Otherwise reinstall is my suggestion.

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants