Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Places.sqlite file is corrupted when I log out of linux

  • 3 replies
  • 1 has this problem
  • 8 views
  • Last reply by cor-el

more options

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.

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.

Chosen solution

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.

Read this answer in context 👍 1

All Replies (3)

more options

Chosen Solution

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.

more options

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!

more options

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).