http://wiki.strawberrymusicplayer.org/index.php?title=Database_integrity_check&feed=atom&action=history
Database integrity check - Revision history
2024-03-29T15:43:19Z
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
Jonas at 16:05, 13 September 2022
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;">"</ins>pragma integrity_check<ins style="font-weight: bold; text-decoration: none;">"</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
Jonas: 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..."
2022-08-16T16:47:35Z
<p>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..."</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 "%PROGRAMFILES%\Strawberry Music Player\"<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