Locked or damaged places.sqlite: Difference between revisions

From MozillaZine Knowledge Base
Jump to navigationJump to search
 
(41 intermediate revisions by 3 users not shown)
Line 1: Line 1:
''This article applies to Firefox 3''
Starting in Firefox 3, bookmarks and browsing history are stored in the [[places.sqlite]] file, located in the [[Profile folder - Firefox|Firefox profile folder]].   If the  [https://developer.mozilla.org/en/The_Places_database Places database]  is locked or damaged, many Firefox functions will not work and the following symptoms may occur:
 
*(Firefox 39) Cannot launch URLs from the address bar [http://forums.mozillazine.org/viewtopic.php?f=38&t=2944871] [https://bugzilla.mozilla.org/show_bug.cgi?id=1180419]
[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 8: Line 7:
*Bookmarking a page has no effect
*Bookmarking a page has no effect
*Unable to delete, move,  or edit certain bookmarks
*Unable to delete, move,  or edit certain bookmarks
*Unable to import bookmarks
*Periodic hangs and "Not responding" errors


==Firefox process locks Places database==
'''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#Hang_deleting_bookmarks_-_Firefox_3|Firefox hangs]].
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]
== 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 lockedTo work around the issue, [[Kill application|close Firefox completely]], end any Firefox processes (or reboot the computer)and restart Firefox.
 
If this is a recurring problem, see [[Firefox hangs#Hang at exit|Firefox hangs - Hang at exit]] and check for [[problematic extensions]].  '''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.'[https://bugzilla.mozilla.org/show_bug.cgi?id=414715]


==Damaged Places database==
==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 [[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 earlier occur even when you first start Firefox after rebooting the computer, the Places database ([[places.sqlite]] file)  may be damaged.
#[[Kill application|Close Firefox completely]]  
 
*As a first step (or if your problem is limited to periodic Firefox freezes) you may be able to essentially '''rebuild the Places database with an add-on'''.  Install and run the "[https://addons.mozilla.org/firefox/addon/places-maintenance/ Places Maintenance]" extension ([http://blog.bonardo.net/2011/09/30/is-your-firefor-freezing-at-regular-intervals see this blog post for details])The extension features several options, each of which will repair damage to the Places database while preserving the stored data.  You can run the extension with all of the options enabled.  This is one of the new  JetPack extensions so you can install it,  use it, and uninstall it, all without taking Firefox down.
 
*If you have a recent [[profile backup]], another possible solution is to  remove the "places.sqlite" file (and any other files named "places.sqlite*", e.g., "places.sqlite-journal", if found)  from the [[Profile folder - Firefox|Firefox profile folder]] and replace it with the "places.sqlite" backup file.   
 
Other solutions are listed below.
 
===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 [http://forums.mozillazine.org/viewtopic.php?f=38&p=4800245], try creating a new bookmark backup file in Firefox via "Bookmarks -> Show all (or Organize) Bookmarks -> Import and Backup -> Backup" and then [[Backing_up_and_restoring_bookmarks_-_Firefox#Restoring_bookmarks_from_backup|restore the new backup]], as an alternative to rebuilding the Places database.  This may work since the bookmark backup process bypasses certain invalid places.sqlite entries that may exist[https://bugzilla.mozilla.org/show_bug.cgi?id=448584]  and has the advantage of preserving your browsing history.  Using  [http://www.pctools.com/spyware-doctor/ 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.  [http://forums.mozillazine.org/viewtopic.php?f=38&t=968095] [http://forums.mozillazine.org/viewtopic.php?f=38&t=952555&p=5025405] [http://forums.mozillazine.org/viewtopic.php?f=38&t=966655]
===Rebuild Places database===
If the previous solutions and the "[https://addons.mozilla.org/firefox/addon/places-maintenance/ Places Maintenance]" extension ([[#Damaged Places database|see above]])  didn'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.)  
 
'''Warning:''' Deleting or renaming the places.sqlite file will result in rebuilding the places database and loss of all browsing history, which is used for features such as the [[Location Bar search|Location Bar Auto Complete drop-down (AwesomeBar) list]].  '''First try the other solutions given above.'''
 
#Open the [[Profile folder - Firefox|Firefox profile folder]]
#Open the [[Profile folder - Firefox|Firefox profile folder]]
#Delete or rename all files named "places.sqlite", including "places.sqlite-journal" and any "places.sqlite.corrupt" files, if found.  
#[[Kill application| Close Firefox completely]]
When you restart Firefox, "places.sqlite" will be rebuilt and your bookmarks will be automatically restored from the latest [[bookmarkbackups folder|JSON bookmark backup]]; however, your recent browsing history will be lost.  [http://forums.mozillazine.org/viewtopic.php?f=38&t=653460&p=4779265] [http://support.mozilla.com/tiki-view_forum_thread.php?&comments_parentId=158802&forumId=1] [http://forums.mozillazine.org/viewtopic.php?f=23&t=605038&p=3149325] 
#Delete or rename all files named "places.sqlite", including "places.sqlite-journal" and any "places.sqlite.corrupt" files, if found (but first, see below, [[#If a places.sqlite.corrupt file exists|if a places.sqlite.corrupt file exists]]).
When you restart Firefox, "places.sqlite" will be rebuilt and your bookmarks will be automatically restored from the latest [[bookmarkbackups folder|JSON bookmark backup]]; however, your browsing history will be lost.  [http://forums.mozillazine.org/viewtopic.php?f=38&t=653460&p=4779265]


'''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 [[Export bookmarks|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".
'''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. Check the creation date on your bookmarks.html as its use within Firefox was dropped starting with Firefox 3 and is now essentially used as a vehicle to transfer bookmarks between systems.  If you have a [[Export bookmarks|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".
 
===If a places.sqlite.corrupt file exists===
If your Firefox profile folder includes a "places.sqlite.corrupt" file,  one reported fix is to open the [[Profile folder - Firefox|Firefox profile folder]] and, after [[kill application|closing Firefox completely]], delete or rename the places.sqlite file and then rename "places.sqlite.corrupt" to "places.sqlite".  (If you see any other  places.sqlite* files, delete those as well, so that only one places.sqlite file remains.)  It is possible that certain security or "cleanup" software (e.g., CCleaner) is causing the places.sqlite file corruption.  It is also possible that  Firefox was not closed properly,  as might happen when your computer  loses power with Firefox running, which can cause a corrupt places.sqlite file.  Always make sure that you close Firefox properly (e.g., no Firefox processes in the Windows Task Manager) before shutting down the computer. [https://support.mozilla.org/questions/803069]
 
'''Note:'''  If you downgraded from Firefox 55 or above to Firefox 52 ESR, the places.sqlite corruption was probably the result of the fix for [https://bugzilla.mozilla.org/show_bug.cgi?id=1415133 Bug 1415133] - Downgrading Firefox 57 to 52 ESR loses bookmarks (quote)  ''The patch is trivial, it will just cause Places to consider the database corrupt if its schema version is too much in the future. On such corruption Places throws away the db and creates a new one, importing bookmarks from the last backup.'' [https://bugzilla.mozilla.org/show_bug.cgi?id=1415133#c9] [https://support.mozilla.org/en-US/questions/1187781]. The bug fix restored bookmarks from backup but results in loss of  history ([https://bugzilla.mozilla.org/show_bug.cgi?id=1416506 Bug 1416506] - Downgrading Firefox 57 to 52 ESR loses session)


==Other solutions==
==Other solutions==
*If certain bookmarks cannot be deleted, moved, or edited, create a new bookmark backup file ("Bookmarks -> Organize Bookmarks -> Import and Backup -> Backup")  and [[Lost bookmarks#Restoring bookmarks in Firefox 3|restore the backup]]. This may work in Firefox 3.0.5 and above since the backup process bypasses certain invalid places.sqlite entries that may exist.  [https://bugzilla.mozilla.org/show_bug.cgi?id=448584]  [http://www.pctools.com/spyware-doctor/ PC Tools Spyware Doctor] may cause the issue.  [http://forums.mozillazine.org/viewtopic.php?f=38&t=968095] [http://forums.mozillazine.org/viewtopic.php?f=38&t=952555&p=5025405] [http://forums.mozillazine.org/viewtopic.php?f=38&t=966655]
* Try  to recover from broken places.sqlite database using the steps given in [https://developer.mozilla.org/en-US/docs/Mozilla/Tech/Places/places.sqlite_Database_Troubleshooting this MDN article].
* A Windows user reports that running the [http://support.microsoft.com/?kbid=315265 CHKDSK] utility resolves the Places database issues. [http://support.mozilla.com/tiki-view_forum_thread.php?forumId=1&comments_threshold=0&comments_parentId=145347&comments_offset=40&comments_per_page=20]
* A Windows user reports that running the [http://support.microsoft.com/?kbid=315265 CHKDSK] utility fixed the Places database corruption that occurred after a crash.
*A Linux user suggests that you check file permissions within your profile directory (e.g. ~/.mozilla/firefox/ljzv2exp.default/). [http://support.mozilla.com/tiki-view_forum_thread.php?forumId=1&comments_parentId=145347&comments_offset=40&comments_per_page=20]
*A Linux user suggests that you check file permissions within your profile directory (e.g. ~/.mozilla/firefox/ljzv2exp.default/).
*Linux users report that updating Sqlite and then removing all places.sqlite* files resolves the issue.  For more information,  read [http://support.mozilla.com/tiki-view_forum_thread.php?&comments_parentId=181252&forumId=1 this Firefox Support topic] and [http://forums.mozillazine.org/viewtopic.php?f=38&t=703815&start=15 this forum thread].
*Linux users report that updating Sqlite and then removing all places.sqlite* files resolves the issue.  For more information,  read [http://forums.mozillazine.org/viewtopic.php?f=38&t=703815&start=15 this forum thread].
*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]
* 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==
*[[Bookmarks not saved]]
*[[Lost bookmarks]]
*[[Unable to process the backup file - Firefox]]
*[[Unable to process the backup file - Firefox]]
*[[Unable to export bookmarks to HTML file - Firefox]]
*[[Unable to export bookmarks to HTML file - Firefox]]
*[[Firefox hangs#Places database|Firefox hangs - Places database]]


==External links==
==External links==
*[http://support.mozilla.com/kb/Bookmarks+and+toolbar+buttons+not+working+after+upgrading Bookmarks and toolbar buttons not working after upgrading (Firefox Support)]
*[https://support.mozilla.org/kb/Bookmarks+and+toolbar+buttons+not+working+after+upgrading Bookmarks and toolbar buttons not working after upgrading (Firefox Support)]
*[https://wiki.mozilla.org/QA/Firefox3/Investigation/Norton_360 QA/Firefox3/Investigation/Norton 360 (mozilla wiki)]
*[https://wiki.mozilla.org/Places Places - MozillaWiki]
* [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 (MDN)]
*[https://developer.mozilla.org/en/Places Places (MDC)]
*[https://developer.mozilla.org/en/docs/The_Places_database The Places database (MDN)]
 
*[https://addons.mozilla.org/firefox/addon/places-maintenance/ Places Maintenance add-on] (see [http://blog.bonardo.net/2011/09/30/is-your-firefor-freezing-at-regular-intervals this blog post by the Mozilla developer] for details)
===Related bug reports===
===Related bug reports===
*[https://bugzilla.mozilla.org/show_bug.cgi?id=414715  Bug 414715 -  Notify the user if places.sqlite is locked and bookmarks and history will not work]
'''''Note:''' Many of these bugs have been fixed.  The bug reports are listed for informational purposes.''
*[https://bugzilla.mozilla.org/show_bug.cgi?id=414715  Bug 414715 -  Notify the user if places.sqlite is locked and bookmarks and history will not work]  
*[https://bugzilla.mozilla.org/show_bug.cgi?id=421482  Bug 421482 -  Firefox 3 uses fsync excessively]  
*[https://bugzilla.mozilla.org/show_bug.cgi?id=421482  Bug 421482 -  Firefox 3 uses fsync excessively]  
*[https://bugzilla.mozilla.org/show_bug.cgi?id=431558  Bug 431558 -  implement preventive maintenance for places.sqlite]  
*[https://bugzilla.mozilla.org/show_bug.cgi?id=431558  Bug 431558 -  implement preventive maintenance for places.sqlite]  
Line 54: Line 76:
*[https://bugzilla.mozilla.org/show_bug.cgi?id=462760  Bug 462760 -  Bookmarks and history do not work.]
*[https://bugzilla.mozilla.org/show_bug.cgi?id=462760  Bug 462760 -  Bookmarks and history do not work.]
*[https://bugzilla.mozilla.org/show_bug.cgi?id=464486  Bug 464486 -  lots of bookmark corruption reported via user support]
*[https://bugzilla.mozilla.org/show_bug.cgi?id=464486  Bug 464486 -  lots of bookmark corruption reported via user support]
*[https://bugzilla.mozilla.org/show_bug.cgi?id=465684  Bug 465684 -  Some Bookmarks and some folders have become corrupt and cannot be deleted]
*[https://bugzilla.mozilla.org/show_bug.cgi?id=666128 Bug 666128 - Frequent Firefox freeze and "Not responding" because the places database becomes corrupted] 
*[https://bugzilla.mozilla.org/show_bug.cgi?id=686025 Bug 686025 - nsNavHistory::AsyncExecuteLegacyQueries uses synchronous createStatement call instead of async createAsyncStatement call, blocks main thread]
*[https://bugzilla.mozilla.org/show_bug.cgi?id=691507 Bug 691507 - {meta} Periodic hangs in the UI due to Places]
*[https://bugzilla.mozilla.org/show_bug.cgi?id=1180419 Bug 1180419 - Cannot load URLs from the address bar if places.sqlite is corrupt]
*[https://bugzilla.mozilla.org/show_bug.cgi?id=1415133 Bug 1415133] - Downgrading Firefox 57 to 52 ESR loses bookmarks
*[https://bugzilla.mozilla.org/show_bug.cgi?id=1416506 Bug 1416506] - Downgrading Firefox 57 to 52 ESR loses session




[[Category:Issues (Firefox)]]
[[Category:Issues (Firefox)]]
[[Category:Bookmarks]]
[[Category:History]]

Latest revision as of 23:31, 30 November 2017

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 39) Cannot launch URLs from the address bar [1] [2]
  • 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
  • Periodic hangs and "Not responding" errors

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.

If this is a recurring problem, see Firefox hangs - Hang at exit and check for problematic extensions. 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. [3]

Damaged Places database

If the symptoms described earlier occur even when you first start Firefox after rebooting the computer, the Places database (places.sqlite file) may be damaged.

  • As a first step (or if your problem is limited to periodic Firefox freezes) you may be able to essentially rebuild the Places database with an add-on. Install and run the "Places Maintenance" extension (see this blog post for details). The extension features several options, each of which will repair damage to the Places database while preserving the stored data. You can run the extension with all of the options enabled. This is one of the new JetPack extensions so you can install it, use it, and uninstall it, all without taking Firefox down.
  • If you have a recent profile backup, another possible solution is to remove the "places.sqlite" file (and any other files named "places.sqlite*", e.g., "places.sqlite-journal", if found) from the Firefox profile folder and replace it with the "places.sqlite" backup file.

Other solutions are listed below.

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 [4], try creating a new bookmark backup file in Firefox via "Bookmarks -> Show all (or Organize) Bookmarks -> Import and Backup -> Backup" and then restore the new backup, as an alternative to rebuilding the Places database. This may work since the bookmark backup process bypasses certain invalid places.sqlite entries that may exist. [5] 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. [6] [7] [8]

Rebuild Places database

If the previous solutions and the "Places Maintenance" extension (see above) didn'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.)

Warning: Deleting or renaming the places.sqlite file will result in rebuilding the places database and loss of all browsing history, which is used for features such as the Location Bar Auto Complete drop-down (AwesomeBar) list. First try the other solutions given above.

  1. Open the Firefox profile folder
  2. Close Firefox completely
  3. Delete or rename all files named "places.sqlite", including "places.sqlite-journal" and any "places.sqlite.corrupt" files, if found (but first, see below, if a places.sqlite.corrupt file exists).

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. [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. Check the creation date on your bookmarks.html as its use within Firefox was dropped starting with Firefox 3 and is now essentially used as a vehicle to transfer bookmarks between systems. 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".

If a places.sqlite.corrupt file exists

If your Firefox profile folder includes a "places.sqlite.corrupt" file, one reported fix is to open the Firefox profile folder and, after closing Firefox completely, delete or rename the places.sqlite file and then rename "places.sqlite.corrupt" to "places.sqlite". (If you see any other places.sqlite* files, delete those as well, so that only one places.sqlite file remains.) It is possible that certain security or "cleanup" software (e.g., CCleaner) is causing the places.sqlite file corruption. It is also possible that Firefox was not closed properly, as might happen when your computer loses power with Firefox running, which can cause a corrupt places.sqlite file. Always make sure that you close Firefox properly (e.g., no Firefox processes in the Windows Task Manager) before shutting down the computer. [10]

Note: If you downgraded from Firefox 55 or above to Firefox 52 ESR, the places.sqlite corruption was probably the result of the fix for Bug 1415133 - Downgrading Firefox 57 to 52 ESR loses bookmarks (quote) The patch is trivial, it will just cause Places to consider the database corrupt if its schema version is too much in the future. On such corruption Places throws away the db and creates a new one, importing bookmarks from the last backup. [11] [12]. The bug fix restored bookmarks from backup but results in loss of history (Bug 1416506 - Downgrading Firefox 57 to 52 ESR loses session)

Other solutions

  • Try to recover from a broken places.sqlite database using the steps given in this MDN article.
  • A Windows user reports that running the CHKDSK utility fixed the Places database corruption that occurred after a crash.
  • A Linux user suggests that you check file permissions within your profile directory (e.g. ~/.mozilla/firefox/ljzv2exp.default/).
  • Linux users report that updating Sqlite and then removing all places.sqlite* files resolves the issue. For more information, read 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]
  • Firefox 3.5 implements preventative maintenance for places.sqlite [15] [16] so, you are still using Firefox 3.0, upgrade Firefox to the latest version, available here.

See also

External links

Related bug reports

Note: Many of these bugs have been fixed. The bug reports are listed for informational purposes.