Locked or damaged places.sqlite: Difference between revisions

From MozillaZine Knowledge Base
Jump to navigationJump to search
m (removed duplicated info)
(Intro shortened; section headings" sqlite files -> Places database; added that Firefox 3.1 will include a notice when it is opened with a locked places database)
Line 1: Line 1:
''This article applies to Firefox 3''
''This article applies to Firefox 3''


[http://www.sqlite.org/ Sqlite] files are used to store certain data in the [[Profile folder - Firefox|Firefox profile folder]], including the  [[places.sqlite]] file for bookmarks and browsing history in Firefox 3 ([https://developer.mozilla.org/En/Places "Places"] storage).  If the [https://developer.mozilla.org/en/The_Places_database Places database] cannot be accessed because places.sqlite is locked or damaged, many Firefox functions will not work.  Depending upon the extent of the problem, the following symptoms may occur:  
[http://www.sqlite.org/ Sqlite] files are used for storing certain data in the [[Profile folder - Firefox|Firefox profile folder]].  Starting in Firefox 3, your bookmarks and browsing history are both stored in the  [https://developer.mozilla.org/en/The_Places_database Places database] file [[places.sqlite]].  If the Places database cannot be accessed because "places.sqlite" 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
*Firefox opens to a blank page instead of the home page
*Toolbar buttons such as Back/Forward are disabled
*Toolbar buttons such as Back/Forward are disabled
Line 10: Line 10:
*Unable to import bookmarks
*Unable to import bookmarks


==Firefox process locks sqlite files==
==Firefox process locks Places database==
If Firefox works normally when you first open it after starting up the computer but multiple symptoms appear after you close and later reopen Firefox, it's likely that a Firefox process from a previous session did not close properly. In some cases, this can "lock" the [[places.sqlite]] file that Firefox uses to store your bookmarks and history.  You can work around the issue by [[Kill application|closing Firefox completely]] and ending any Firefox processes (or rebooting the computer) before restarting Firefox.  If this is a recurring problem, see  [[Firefox hangs#Hang at exit|Firefox hangs - Hang at exit]] and check for [[problematic extensions]].
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 is locked.   (Starting in Firefox 3.1, you will be notified that the bookmarks and history system will not be functional when you open Firefox with a locked Places database. [https://bugzilla.mozilla.org/show_bug.cgi?id=414715].) You can work around the issue by [[Kill application|closing Firefox completely]] and ending any Firefox processes (or rebooting the computer) before restarting Firefox.  If this is a recurring problem, see  [[Firefox hangs#Hang at exit|Firefox hangs - Hang at exit]] and check for [[problematic extensions]].


If you use [[Firewalls#Norton 360|Norton 360 2.0]]  or  [[Firewalls#Norton Internet Security|Norton Internet Security 2008.5]],  this is a known issue.  [https://wiki.mozilla.org/QA/Firefox3/Investigation/Norton_360] Update to NIS 2009 or, if you use Norton 360,  [http://service1.symantec.com/SUPPORT/sharedtech.nsf/docid/2006060207314913 run Norton LiveUpdate] and install all updates (for more help, contact [http://www.symantec.com/norton/support/index.jsp Norton Support]).  If the problem persists,  either disable "Phishing Protection" in Norton's settings [https://bugzilla.mozilla.org/show_bug.cgi?id=452469#c60] or delete "coFFPlgn.dll" from the Firefox components folder (details [[Uninstalling toolbars#Other solutions|here]]) to remove the Norton anti-phishing toolbar from Firefox. [http://community.norton.com/norton/board/message?board.id=Norton_360&thread.id=2267&view=by_date_ascending&page=3]
If you use [[Firewalls#Norton 360|Norton 360 2.0]]  or  [[Firewalls#Norton Internet Security|Norton Internet Security 2008.5]],  this is a known issue.  [https://wiki.mozilla.org/QA/Firefox3/Investigation/Norton_360] Update to NIS 2009 or, if you use Norton 360,  [http://service1.symantec.com/SUPPORT/sharedtech.nsf/docid/2006060207314913 run Norton LiveUpdate] and install all updates (for more help, contact [http://www.symantec.com/norton/support/index.jsp Norton Support]).  If the problem persists,  either disable "Phishing Protection" in Norton's settings [https://bugzilla.mozilla.org/show_bug.cgi?id=452469#c60] or delete "coFFPlgn.dll" from the Firefox components folder (details [[Uninstalling toolbars#Other solutions|here]]) to remove the Norton anti-phishing toolbar from Firefox. [http://community.norton.com/norton/board/message?board.id=Norton_360&thread.id=2267&view=by_date_ascending&page=3]


==Damaged sqlite files==
==Damaged Places database==
If the symptoms described above occur even when you first start Firefox after rebooting the computer, the places.sqlite file may be damaged or missing essential information.  If you have a recent [[profile backup]] you can remove "places.sqlite" (and places.sqlite-journal, if found)  from the [[Profile folder - Firefox|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 bookmarks| export your bookmarks to an HTML file]] first, as a precaution.)  
If the symptoms described above occur even when you first start Firefox after rebooting the computer, the Places database 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 [[Profile folder - Firefox|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 bookmarks| export your bookmarks to an HTML file]] first, as a precaution.)  
#[[Kill application|Close Firefox completely]]  
#[[Kill application|Close Firefox completely]]  
#Open the [[Profile folder - Firefox|Firefox profile folder]]
#Open the [[Profile folder - Firefox|Firefox profile folder]]
Line 42: Line 42:
*[https://wiki.mozilla.org/QA/Firefox3/Investigation/Norton_360 QA/Firefox3/Investigation/Norton 360 (mozilla wiki)]
*[https://wiki.mozilla.org/QA/Firefox3/Investigation/Norton_360 QA/Firefox3/Investigation/Norton 360 (mozilla wiki)]
* [http://support.mozilla.com/tiki-view_forum_thread.php?comments_parentId=183742&forumId=3 Issue: Norton-like symptoms but not Norton 360 (Firefox Support Contributors forum topic)]
* [http://support.mozilla.com/tiki-view_forum_thread.php?comments_parentId=183742&forumId=3 Issue: Norton-like symptoms but not Norton 360 (Firefox Support Contributors forum topic)]
*[https://developer.mozilla.org/en/Places Places (MDC)]


===Related bug reports===
===Related bug reports===

Revision as of 22:14, 27 December 2008

This article applies to Firefox 3

Sqlite files are used for storing certain data in the Firefox profile folder. Starting in Firefox 3, your bookmarks and browsing history are both stored in the Places database file places.sqlite. If the Places database cannot be accessed because "places.sqlite" 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
  • Unable to import bookmarks

Firefox process locks 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 is locked. (Starting in Firefox 3.1, you will be notified that the bookmarks and history system will not be functional when you open Firefox with a locked Places database. [1].) You can work around the issue by closing Firefox completely and ending any Firefox processes (or rebooting the computer) before restarting Firefox. 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]

Damaged Places database

If the symptoms described above occur even when you first start Firefox after rebooting the computer, the Places database 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 recent browsing history will be lost. [5] [6] [7]

Note: In rare cases, your JSON bookmark backup files may also be damaged or missing essential information. 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".

Other solutions

  • There are reports that using PC Tools Spyware Doctor can result in various Firefox bookmarks problems, such as inability to delete, move, or edit bookmarks or the error, "Unable to process the backup file" when trying to restore a bookmark backup. You may wish to contact PC Tools support or stop using the software, then follow the above instructions for damaged sqlite files. [8] [9] [10]
  • A Windows user reports that running the CHKDSK utility resolves the issue. [11]
  • A Linux user suggests that you check file permissions within your profile directory (e.g. ~/.mozilla/firefox/ljzv2exp.default/). [12]
  • 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. [13]
  • Go through the standard diagnostic steps or create a new Firefox profile to see if that solves the problem. [14]

See also

External links

Related bug reports