search

rembo10 / headphones

Automatic music downloader for SABnzbd
GNU General Public License v3.0
3.39k stars 600 forks source link

Error: Can't connect to the database: file is encrypted or is not a database #3181

Closed vincentw56 closed 5 years ago

vincentw56 commented 5 years ago

I am getting this error below. It worked fine, but for now I cannot get it to run.

06-Jan-2019 16:21:29 - INFO :: MainThread : Checking to see if the database has all tables.... 06-Jan-2019 16:21:29 - ERROR :: MainThread : Can't connect to the database: file is encrypted or is not a database 06-Jan-2019 16:21:29 - INFO :: MainThread : Retrieving latest version information from GitHub 06-Jan-2019 16:21:31 - INFO :: MainThread : Comparing currently installed version with latest GitHub version 06-Jan-2019 16:21:31 - INFO :: MainThread : New version is available. You are 5 commits behind 06-Jan-2019 16:21:31 - INFO :: MainThread : Starting Headphones web server on http://0.0.0.0:8181/ 06-Jan-2019 16:21:34 - INFO :: MainThread : Scheduled background task: Search for Wanted 06-Jan-2019 16:21:34 - INFO :: MainThread : Scheduled background task: Download Scan 06-Jan-2019 16:21:34 - INFO :: MainThread : Scheduled background task: Library Scan 06-Jan-2019 16:21:34 - INFO :: MainThread : Scheduled background task: MusicBrainz Update 06-Jan-2019 16:21:34 - INFO :: MainThread : Scheduled background task: Check GitHub for updates 06-Jan-2019 16:21:34 - INFO :: MainThread : Scheduled background task: Torrent removal check

And this in the browser:

`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\Vincent\AppData\Roaming\Headphones\lib/cherrypy_cprequest.py", line 670, in respond response.body = self.handler() File "C:\Users\Vincent\AppData\Roaming\Headphones\lib/cherrypy\lib\encoding.py", line 217, in call self.body = self.oldhandler(*args, *kwargs) File "C:\Users\Vincent\AppData\Roaming\Headphones\lib/cherrypy_cpdispatch.py", line 61, in call return self.callable(self.args, **self.kwargs) File "C:\Users\Vincent\AppData\Roaming\Headphones\headphones\webserve.py", line 68, in home myDB = db.DBConnection() File "C:\Users\Vincent\AppData\Roaming\Headphones\headphones\db.py", line 49, in init self.connection.execute("PRAGMA synchronous = OFF") DatabaseError: file is encrypted or is not a database `

AdeHub commented 5 years ago

Could try this:

https://github.com/rembo10/headphones/wiki/Troubleshooting#database-problems

vincentw56 commented 5 years ago

@AdeHub I've already been to that page and nothing on there applies to my issue. I did look through all the links, but there is nothing in there to resolve the issue.

AdeHub commented 5 years ago

Have you tried it?

vincentw56 commented 5 years ago

Have I tried what? There is nothing there about not being able to connect to a database. I have no corruption. There are 4 referenced posts about different things.

vincentw56 commented 5 years ago

I followed the information here: https://github.com/rembo10/headphones/issues/1981#issuecomment-62213425. That seemed to fix the issue. I guess anytime there is a database issue, we should run that first. The first time, after many years, that I've ever had an issue with Headphones.