http://wiki.strawberrymusicplayer.org/index.php?action=history&feed=atom&title=Database_integrity_check 2026-05-24T14:18:13Z Revision history for this page on the wiki MediaWiki 1.38.1 http://wiki.strawberrymusicplayer.org/index.php?title=Database_integrity_check&diff=36&oldid=prev 2022-09-13T16:05:42Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:05, 13 September 2022</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l9">Line 9:</td> <td colspan="2" class="diff-lineno">Line 9:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Open a terminal windows.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Open a terminal windows.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>   sqlite3 ~/.local/share/strawberry/strawberry/strawberry.db</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>   sqlite3 ~/.local/share/strawberry/strawberry/strawberry.db <ins style="font-weight: bold; text-decoration: none;">&quot;</ins>pragma integrity_check<ins style="font-weight: bold; text-decoration: none;">&quot;</ins></div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">  </del>pragma integrity_check<del style="font-weight: bold; text-decoration: none;">;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> </table>

Jonas http://wiki.strawberrymusicplayer.org/index.php?title=Database_integrity_check&diff=9&oldid=prev 2022-08-16T16:47:35Z

<p>Created page with &quot;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...&quot;</p> <p><b>New page</b></p><div>Database integrity check<br /> <br /> Any problems listing songs in collection or playlists can be caused by a corrupt database.<br /> Run an integrity check on your database to make sure it is functional.<br /> <br /> <br /> == Linux and other Unix systems except macOS ==<br /> <br /> Open a terminal windows.<br /> <br /> sqlite3 ~/.local/share/strawberry/strawberry/strawberry.db<br /> pragma integrity_check;<br /> <br /> <br /> == macOS ==<br /> <br /> Open a terminal window.<br /> <br /> sqlite3 ~/Library/Application\ Support/Strawberry/Strawberry/strawberry.db<br /> pragma integrity_check;<br /> <br /> == Windows ==<br /> <br /> Open the command prompt.<br /> <br /> cd &quot;%PROGRAMFILES%\Strawberry Music Player\&quot;<br /> sqlite3 %LOCALAPPDATA%\Strawberry\Strawberry\strawberry.db<br /> pragma integrity_check;<br /> <br /> <br /> 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.<br /> <br /> If you still experience database corruption, it could be a faulty hard drive.</div>

Jonas