Locked or damaged places.sqlite: Difference between revisions

From MozillaZine Knowledge Base
Jump to navigationJump to search
m (→‎Other solutions: removed "(in Beta at time of writing)" for Firefox 3.5 and fixed the link)
(→‎Other solutions: upgrade Firefox to the latest version)
Line 37: Line 37:
*A Mac user reports multiple problems with bookmarks and history if the environment variable <code>DYLD_LIBRARY_PATH</code> is set for the login via the file ''~/.MacOSX/environment.plist''.  Removing  "environment.plist" and then logging out and back in resolves the issue.  [https://bugzilla.mozilla.org/show_bug.cgi?id=462760#c3]
*A Mac user reports multiple problems with bookmarks and history if the environment variable <code>DYLD_LIBRARY_PATH</code> is set for the login via the file ''~/.MacOSX/environment.plist''.  Removing  "environment.plist" and then logging out and back in resolves the issue.  [https://bugzilla.mozilla.org/show_bug.cgi?id=462760#c3]
*Go through the [[Standard diagnostic - Firefox|standard diagnostic steps]] or [[Profile Manager|create a new Firefox profile]] to see if that solves the problem.  [http://forums.mozillazine.org/viewtopic.php?p=5026785#p5026785]
*Go through the [[Standard diagnostic - Firefox|standard diagnostic steps]] or [[Profile Manager|create a new Firefox profile]] to see if that solves the problem.  [http://forums.mozillazine.org/viewtopic.php?p=5026785#p5026785]
* Upgrade to Firefox 3.5 [http://www.mozilla.com/firefox/all.html], which implements preventative maintenance for places.sqlite   [https://bugzilla.mozilla.org/show_bug.cgi?id=465684#c11] [https://bugzilla.mozilla.org/show_bug.cgi?id=431558]
* Firefox 3.5 implements preventative maintenance for places.sqlite [https://bugzilla.mozilla.org/show_bug.cgi?id=465684#c11] [https://bugzilla.mozilla.org/show_bug.cgi?id=431558] so,  you are still using Firefox 3.0,  upgrade Firefox to the latest version, available [http://www.mozilla.com/en-US/firefox/all.html here].


==See also==
==See also==

Revision as of 04:58, 21 May 2010

This article applies to Firefox 3.0 and above.


Starting in Firefox 3, bookmarks and browsing history are stored in the places.sqlite file, located in the Firefox profile folder. If the Places database is locked or damaged, many Firefox functions will not work and the following symptoms may occur:

  • Firefox opens to a blank page instead of the home page
  • Toolbar buttons such as Back/Forward are disabled
  • Bookmarks and history are missing
  • URL is not updated in the Location Bar as you browse
  • Bookmarking a page has no effect
  • Unable to delete, move, or edit certain bookmarks

Note: For other solutions to missing bookmarks, see Lost bookmarks. If changes made to bookmarks are lost when you restart Firefox, see Bookmarks not saved. If deleting a large quantity of bookmarks is very slow or causes a hang, see Firefox hangs.

Locked Places database

If Firefox works normally when you first open it after starting up the computer but multiple symptoms arise after you close and later reopen Firefox, it's likely that a Firefox process from a previous session did not close properly and the Places database ("places.sqlite" file) is locked. To work around the issue, close Firefox completely, end any Firefox processes (or reboot the computer), and restart Firefox. [1]

If this is a recurring problem, see Firefox hangs - Hang at exit and check for problematic extensions. If you use Norton 360 2.0 or Norton Internet Security 2008.5, this is a known issue. [2] Update to NIS 2009 or, if you use Norton 360, run Norton LiveUpdate and install all updates (for more help, contact Norton Support). If the problem persists, either disable "Phishing Protection" in Norton's settings [3] or delete "coFFPlgn.dll" from the Firefox components folder (details here) to remove the Norton anti-phishing toolbar from Firefox. [4]

Note: Starting in Firefox 3.5, if you open Firefox and the Places database is locked you will see the message, The bookmarks and history system will not be functional because one of Firefox's files is in use by another application. Some security software can cause this problem. [5]

Damaged Places database

If the symptoms described above occur even when you first start Firefox after rebooting the computer, the Places database ("places.sqlite" file) may be damaged or missing essential information. If you have a recent profile backup you can remove the file "places.sqlite" (and "places.sqlite-journal", if found) from the Firefox profile folder and replace it with the "places.sqlite" backup. If you have no backup or if it doesn't resolve the problem, you can rebuild the Places database as follows: (You may wish to export your bookmarks to an HTML file first, as a precaution.)

  1. Close Firefox completely
  2. Open the Firefox profile folder
  3. Delete or rename all files named "places.sqlite", including "places.sqlite-journal" and any "places.sqlite.corrupt" files, if found.

When you restart Firefox, "places.sqlite" will be rebuilt and your bookmarks will be automatically restored from the latest JSON bookmark backup; however, your browsing history will be lost. [6] [7] [8] [9]

Note: In rare cases, your JSON bookmark backup files may also be damaged. You can optionally rebuild the Places database without using any JSON backups by also removing all "bookmarks-(date).json" files from the bookmarkbackups folder but this will result in missing bookmarks unless the profile folder contains a bookmarks.html file with your current bookmarks. If you have a bookmarks.html export or a saved copy of bookmarks.html, you can place it in the Firefox profile folder after removing the "places.sqlite*" and all JSON bookmark backups and Firefox will use those bookmarks to rebuild "places.sqlite".

Problems limited to bookmarks

If the Places database damage seems to be limited to bookmarks, for example, if certain bookmarks cannot be deleted, moved, or edited [10], try creating a new bookmark backup file in Firefox ("Bookmarks -> Organize Bookmarks -> Import and Backup -> Backup") and then restore the new backup, as an alternative to rebuilding the Places database. This may work in Firefox 3.0.5 or above, since the bookmark backup process now bypasses certain invalid places.sqlite entries that may exist. [11] and has the advantage of preserving your browsing history. Using PC Tools Spyware Doctor is reported to cause this type of bookmark damage so you should contact PC Tools support for a solution or else stop using the software. [12] [13] [14]

Other solutions

  • A Windows user reports that running the CHKDSK utility fixed the Places database corruption that occurred after a crash. [15]
  • A Linux user suggests that you check file permissions within your profile directory (e.g. ~/.mozilla/firefox/ljzv2exp.default/). [16]
  • Linux users report that updating Sqlite and then removing all places.sqlite* files resolves the issue. For more information, read this Firefox Support topic and this forum thread.
  • A Mac user reports multiple problems with bookmarks and history if the environment variable DYLD_LIBRARY_PATH is set for the login via the file ~/.MacOSX/environment.plist. Removing "environment.plist" and then logging out and back in resolves the issue. [17]
  • Go through the standard diagnostic steps or create a new Firefox profile to see if that solves the problem. [18]
  • Firefox 3.5 implements preventative maintenance for places.sqlite [19] [20] so, you are still using Firefox 3.0, upgrade Firefox to the latest version, available here.

See also

External links

Related bug reports