Places.sqlite file is corrupted when I log out of linux
I'm running Fedora 13 and have just installed Firefox 23, leaving the RPM-supplied version in place (as I plan on upgrading Fedora sooner or later anyway). I created a second profile for the new installation, and imported bookmarks and other configuration. When I close Firefox and re-start, no problems; when I log out of Linux, though, and log on again, I find a places.sqlite.corrupt file in my profile directory (containing my real bookmarks) and a tiny places.sqlite containing default bookmarks. Obviously renaming the "corrupt" file to the right name gets my bookmarks back.
Wybrane rozwiązanie
Did you try to make Firefox generate a new places.sqlite file by removing all places files?
That should make Firefox use a JSON backup in the bookmarkbackups folder to create a new places.sqlite database file.
Przeczytaj tę odpowiedź w całym kontekście 👍 1Wszystkie odpowiedzi (3)
Wybrane rozwiązanie
Did you try to make Firefox generate a new places.sqlite file by removing all places files?
That should make Firefox use a JSON backup in the bookmarkbackups folder to create a new places.sqlite database file.
Aha! Yes, that worked. (My formhistory.sqlite was also getting corrupted, as I discovered shortly after posting this, and the same trick worked for it too.) Thank you!
It is possible that the current Firefox version uses a more recent SQLite version then was used in older SQLite database files and then things can go wrong (there is usually migration code when updating).