Database integrity check
Revision as of 16:47, 16 August 2022 by Jonas (talk | contribs) (Created page with "Database integrity check Any problems listing songs in collection or playlists can be caused by a corrupt database. Run an integrity check on your database to make sure it is functional. == Linux and other Unix systems except macOS == Open a terminal windows. sqlite3 ~/.local/share/strawberry/strawberry/strawberry.db pragma integrity_check; == macOS == Open a terminal window. sqlite3 ~/Library/Application\ Support/Strawberry/Strawberry/strawberry.db prag...")
Database integrity check
Any problems listing songs in collection or playlists can be caused by a corrupt database. Run an integrity check on your database to make sure it is functional.
Linux and other Unix systems except macOS
Open a terminal windows.
sqlite3 ~/.local/share/strawberry/strawberry/strawberry.db pragma integrity_check;
macOS
Open a terminal window.
sqlite3 ~/Library/Application\ Support/Strawberry/Strawberry/strawberry.db pragma integrity_check;
Windows
Open the command prompt.
cd "%PROGRAMFILES%\Strawberry Music Player\" sqlite3 %LOCALAPPDATA%\Strawberry\Strawberry\strawberry.db pragma integrity_check;
You can also remove the database file to start with a fresh new database, but you will then loose your collection setup and the playlists.
If you still experience database corruption, it could be a faulty hard drive.