SQLITE_CANTOPEN With Mixxx 2.2.4

[TolleyLikesRice]

On Windows 10, C:\Users\USER\AppData\Local\Mixxx\mixxxdb.sqlite is present.

[TolleyLikesRice]

Also, tried running as admin, and checked various permissions

[TolleyLikesRice]

Updated to latest Mixxx, same issue

[erikrichardlarson]

Hmmm let me test this a bit and get back to you, likely an issue with the path.

[GroovePanda]

Hiya. Sorry to necro this issue, but I'm having the exact same error come up with a recent install. Mixxx 2.3.1 Any possible resolution?

[erikrichardlarson]

Will look into this today and see if I can find anything, will post here with my updates.

[gjr354]

on windows i think the mixxx db file is at \AppData\Local\Mixxx\mixxxdb.sqlite

[Dlay2017]

Issue is still unresolved using Mixxx 2.3.2.. please help

The path in poller.js seems to be ok.. let mixxxDatabasePath = process.platform != 'darwin' ? process.env.HOME + '\\AppData\\Local\\Mixxx\\mixxxdb.sqlite' : process.env.HOME + '/Library/Application Support' + '/Mixxx/mixxxdb.sqlite';

I have replaced process.env.HOME with require('os').homedir() and that works, but now another error shows up

[erikrichardlarson]

Oh nice will update the code to use the os module instead of the HOME var, the error you're getting now usually means the artist or track data is empty for the recent track you've played, can you check to make sure the metadata is correct on the track you played?

[Dlay2017]

Oh nice will update the code to use the os module instead of the HOME var, the error you're getting now usually means the artist or track data is empty for the recent track you've played, can you check to make sure the metadata is correct on the track you played?

Well, yes, today i tried, and it works well, so thats the solution for mixxx ! :-)