search

ViennaRSS / vienna-rss

Vienna is a free and open-source RSS/Atom newsreader for macOS.
https://www.vienna-rss.com
Apache License 2.0
1.85k stars 227 forks source link

Perform a sanity check on database at launch #1778

Closed barijaona closed 4 months ago

barijaona commented 4 months ago

Run sqlite's PRAGMA quick_check on app startup. Vienna will advise user to restart from a good backup if possible.

If this is not possible, I got a decent result by running the following commands in Terminal:

mv messages.db corrupt.db
sqlite3 corrupt.db ".recover" | sqlite3 messages.db
barijaona commented 4 months ago

It would probably good to create a section in the help book and add a "help" button to the alert so that users can find out what to do.

The FAQ section of the help book needs some reorganization. Will add this subject into it.