搜尋 Mozilla 技術支援網站

防止技術支援詐騙。我們絕對不會要求您撥打電話或發送簡訊,或是提供個人資訊。請用「回報濫用」功能回報可疑的行為。

Learn More

Unable to check places.sqlite integrity: Error: Error(s) encountered during statement execution: database disk image is malformed

more options

In linux Centos7 I found that all my bookmarks disapeared. In about:support if I select verify integrity I get this-

> Task: checkIntegrity - Unable to check places.sqlite integrity: Error: Error(s) encountered during statement execution: database disk image is malformed > 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

How can it be fixed? Thanks for any help!

所有回覆 (1)

more options

"database disk image is malformed" generally means the file is corrupted. To rule out a locked file, you could do a regular Firefox exit, and a regular shut down and restart of your system. But assuming the problem continues, we generally suggest giving up on the file and starting fresh. Firefox will migrate your last bookmark backup but you won't have any history. I'll give the steps for that in a moment.

Meanwhile, if you are a tinkerer, you could look at the following article: https://developer.mozilla.org/docs/Mozilla/Tech/Places/places.sqlite_Database_Troubleshooting


Open your current Firefox settings (AKA Firefox profile) folder using either

  • "3-bar" menu button > "?" Help > Troubleshooting Information
  • (menu bar) Help > Troubleshooting Information
  • type or paste about:support in the address bar and press Enter/Return

In the first table on the page, on the Profile Folder row, click the "Open Directory" button (the label on this button may vary). This should launch a new window listing various files and folders in your file browser.

Leaving that window open, switch back to Firefox and Exit/Quit, either:

  • "3-bar" menu button > Exit/Quit
  • (menu bar) File > Exit/Quit

Pause while Firefox finishes its cleanup, then rename places.sqlite to something like placesBAD.sqlite. If you see journaling files named places.sqlite-shm and/or places.sqlite-wal, I think it's best to remove those or similarly hide them by renaming.

Start Firefox back up again. Does Firefox recover your bookmarks?