Firefox 78.1.0esr Can't clear history or export bookmarks
I can't export bookmarks or clear/delete history. If I delete places.sqlite, everything is gone.
All Replies (4)
Did you already remove places.sqlite or did you bring it back?
Could you let us know what you get when you run the "Verify Integrity" function. That's here:
Open Firefox's Troubleshooting Information page using any of these methods:
- "3-bar" menu button > "?" Help > Troubleshooting Information
- (menu bar) Help > Troubleshooting Information
- type or paste about:support in the address bar and press Enter
Near the bottom, there is a section titled Places Database -- that's the file which stores history and bookmarks. Click the button labeled Verify Integrity. There may be a 10-15 second delay before results appear.
If all is well, the report that appears below the button should start with:
> Task: checkIntegrity + The places.sqlite database is sane + The favicons.sqlite database is sane
Does yours say that, or something else? You can select and copy the report, and then paste it into a reply for review and comment.
Here is the integrity report; other remarks below: > Task: checkIntegrity - Unable to fix corruption, places.sqlite will be replaced on next startup > Task: invalidateCaches - The task queue was cleared by an error in another task. > Task: checkCoherence - The task queue was cleared by an error in another task. > Task: expire - The task queue was cleared by an error in another task. > Task: originFrecencyStats - The task queue was cleared by an error in another task. > Task: vacuum - The task queue was cleared by an error in another task. > Task: stats - The task queue was cleared by an error in another task. > Task: _refreshUI - The task queue was cleared by an error in another task.
I had saved a profile and restored it and the problem was solved. So I tried restoring the bad profile and just replacing places.sqlite and it failed. Conclusion is that there was another bad file, but there is too many to just start replacing one at a time and testing.
Backups are great!
The other file that sometimes goes bad is favicons.sqlite, but it looks like there was a problem with places.sqlite that couldn't be fixed, or perhaps one of its temporary journaling files (places.sqlite-shm and places.sqlite-wal).
If it wasn't for backups, I would be totally lost.
You know more about FF then I do, I just click and go.