Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Funky/Corrupted bookmarks? - Involves Linux and Firefox Sync

  • No replies
  • 0 have this problem
  • 11 views
more options

Hi folks. Currently I am using Firefox Sync to sync my bookmarks between an andriod, Linux laptop and Linux desktop. At times I have difficulty relocating a bookmark to a given position on my desktop or laptop, but my biggest problem centers around bookmarks that I relocate in a different place in the "Unsorted" folder or to a different folder not always appearing in the new position on the other machines. In an attempt to troubleshoot this further I went to my Linux desktop, signed out of FF sync, backed up my 2000+ bookmarks, exported my bookmarks (both to local directories), exited firefox and then renamed the places.sqlite. When I then attempted to restore from json file and when I input bookmarks from the html file I saw all my bookmark directories recreated but all my files were dumped into the "Unsorted Bookmarks" folder. I finally had to put the places.sqlite file back in place in order to continue working, however, my original problems remains. When I attempt to verify the places database I get the following, but clearly something is out of whack. How best can I create a cleaner bookmarks database?


> Task: checkIntegrity + The places.sqlite database is sane + The favicons.sqlite database is sane > Task: invalidateCaches + The caches have been invalidated > Task: checkCoherence + The database is coherent > Task: expire + Database cleaned up > Task: originFrecencyStats + Recalculated origin frecency stats > Task: vacuum + Initial database size is 5120KiB + The database has been vacuumed + Final database size is 5120KiB > Task: stats + Places.sqlite size is 5120KiB + Favicons.sqlite size is 13600KiB + pragma_user_version is 69 + pragma_page_size is 32768 + pragma_cache_size is -2048 + pragma_journal_mode is wal + pragma_synchronous is 1 + History can store a maximum of 74615 unique pages + Table moz_origins has 1722 records + Table moz_places has 4244 records + Table moz_historyvisits has 4542 records + Table moz_inputhistory has 3 records + Table moz_bookmarks has 2039 records + Table moz_bookmarks_deleted has 0 records + Table moz_keywords has 0 records + Table sqlite_sequence has 1 records + Table moz_anno_attributes has 2 records + Table moz_annos has 6 records + Table moz_items_annos has 0 records + Table moz_meta has 6 records + Table moz_places_metadata has 0 records + Table moz_places_metadata_search_queries has 0 records + Table moz_places_metadata_snapshots has 0 records + Table moz_places_metadata_snapshots_extra has 0 records + Table moz_places_metadata_snapshots_groups has 0 records + Table moz_places_metadata_groups_to_snapshots has 0 records + Table moz_session_metadata has 0 records + Table moz_session_to_places has 0 records + Table moz_previews_tombstones has 0 records + Table sqlite_stat1 has 16 records + Pages sequentiality: 60.3 + sqlite_schema: 32KiB (0.8%), 30.4% eff. + moz_inputhistory: 32KiB (0.8%), 0.3% eff. + sqlite_autoindex_moz_inputhistory_1: 32KiB (0.8%), 0.2% eff. + moz_bookmarks_deleted: 32KiB (0.8%), 0% eff. + sqlite_autoindex_moz_bookmarks_deleted_1: 32KiB (0.8%), 0% eff. + moz_keywords: 32KiB (0.8%), 0% eff. + sqlite_autoindex_moz_keywords_1: 32KiB (0.8%), 0% eff. + sqlite_sequence: 32KiB (0.8%), 0.1% eff. + moz_anno_attributes: 32KiB (0.8%), 0.2% eff. + sqlite_autoindex_moz_anno_attributes_1: 32KiB (0.8%), 0.2% eff. + moz_annos: 32KiB (0.8%), 1.8% eff. + moz_items_annos: 32KiB (0.8%), 0% eff. + moz_meta: 32KiB (0.8%), 1% eff. + moz_places_metadata: 32KiB (0.8%), 0% eff. + moz_places_metadata_search_queries: 32KiB (0.8%), 0% eff. + sqlite_autoindex_moz_places_metadata_search_queries_1: 32KiB (0.8%), 0% eff. + moz_places_metadata_snapshots: 32KiB (0.8%), 0% eff. + moz_places_metadata_snapshots_extra: 32KiB (0.8%), 0% eff. + moz_places_metadata_snapshots_groups: 32KiB (0.8%), 0% eff. + moz_places_metadata_groups_to_snapshots: 32KiB (0.8%), 0% eff. + moz_session_metadata: 32KiB (0.8%), 0% eff. + sqlite_autoindex_moz_session_metadata_1: 32KiB (0.8%), 0% eff. + moz_session_to_places: 32KiB (0.8%), 0% eff. + moz_previews_tombstones: 32KiB (0.8%), 0% eff. + sqlite_stat1: 32KiB (0.8%), 2.7% eff. + moz_bookmarks_itemindex: 32KiB (0.8%), 67.7% eff. + moz_bookmarks_parentindex: 32KiB (0.8%), 73.6% eff. + moz_bookmarks_dateaddedindex: 32KiB (0.8%), 99.5% eff. + moz_keywords_placepostdata_uniqueindex: 32KiB (0.8%), 0% eff. + moz_annos_placeattributeindex: 32KiB (0.8%), 0.2% eff. + moz_items_annos_itemattributeindex: 32KiB (0.8%), 0% eff. + moz_places_metadata_placecreated_uniqueindex: 32KiB (0.8%), 0% eff. + moz_places_metadata_referrerindex: 32KiB (0.8%), 0% eff. + moz_places_metadata_snapshots_pinnedindex: 32KiB (0.8%), 0% eff. + moz_places_metadata_snapshots_extra_typeindex: 32KiB (0.8%), 0% eff. + moz_origins: 96KiB (2.3%), 63.8% eff. + sqlite_autoindex_moz_origins_1: 96KiB (2.3%), 59.5% eff. + moz_places_url_hashindex: 96KiB (2.3%), 60.4% eff. + moz_places_visitcount: 96KiB (2.3%), 34.7% eff. + moz_places_frecencyindex: 96KiB (2.3%), 40% eff. + moz_places_originidindex: 96KiB (2.3%), 42.2% eff. + moz_historyvisits_fromindex: 96KiB (2.3%), 41.3% eff. + moz_bookmarks_itemlastmodifiedindex: 96KiB (2.3%), 39.1% eff. + moz_bookmarks_guid_uniqueindex: 96KiB (2.3%), 41.5% eff. + moz_places_lastvisitdateindex: 128KiB (3%), 51.3% eff. + moz_places_guid_uniqueindex: 128KiB (3%), 64.7% eff. + moz_historyvisits_placedateindex: 128KiB (3%), 65.7% eff. + moz_historyvisits_dateindex: 128KiB (3%), 55.4% eff. + moz_historyvisits: 160KiB (3.8%), 71.4% eff. + moz_places_hostindex: 160KiB (3.8%), 66.4% eff. + moz_bookmarks: 256KiB (6.1%), 81% eff. + moz_places: 1152KiB (27.3%), 96.1% eff. > Task: _refreshUI


So, any ideas how I can move forward and get my bookmarks working between between all my machines?

Thanks very much for your time, John C

Hi folks. Currently I am using Firefox Sync to sync my bookmarks between an andriod, Linux laptop and Linux desktop. At times I have difficulty relocating a bookmark to a given position on my desktop or laptop, but my biggest problem centers around bookmarks that I relocate in a different place in the "Unsorted" folder or to a different folder not always appearing in the new position on the other machines. In an attempt to troubleshoot this further I went to my Linux desktop, signed out of FF sync, backed up my 2000+ bookmarks, exported my bookmarks (both to local directories), exited firefox and then renamed the places.sqlite. When I then attempted to restore from json file and when I input bookmarks from the html file I saw all my bookmark directories recreated but all my files were dumped into the "Unsorted Bookmarks" folder. I finally had to put the places.sqlite file back in place in order to continue working, however, my original problems remains. When I attempt to verify the places database I get the following, but clearly something is out of whack. How best can I create a cleaner bookmarks database? > Task: checkIntegrity + The places.sqlite database is sane + The favicons.sqlite database is sane > Task: invalidateCaches + The caches have been invalidated > Task: checkCoherence + The database is coherent > Task: expire + Database cleaned up > Task: originFrecencyStats + Recalculated origin frecency stats > Task: vacuum + Initial database size is 5120KiB + The database has been vacuumed + Final database size is 5120KiB > Task: stats + Places.sqlite size is 5120KiB + Favicons.sqlite size is 13600KiB + pragma_user_version is 69 + pragma_page_size is 32768 + pragma_cache_size is -2048 + pragma_journal_mode is wal + pragma_synchronous is 1 + History can store a maximum of 74615 unique pages + Table moz_origins has 1722 records + Table moz_places has 4244 records + Table moz_historyvisits has 4542 records + Table moz_inputhistory has 3 records + Table moz_bookmarks has 2039 records + Table moz_bookmarks_deleted has 0 records + Table moz_keywords has 0 records + Table sqlite_sequence has 1 records + Table moz_anno_attributes has 2 records + Table moz_annos has 6 records + Table moz_items_annos has 0 records + Table moz_meta has 6 records + Table moz_places_metadata has 0 records + Table moz_places_metadata_search_queries has 0 records + Table moz_places_metadata_snapshots has 0 records + Table moz_places_metadata_snapshots_extra has 0 records + Table moz_places_metadata_snapshots_groups has 0 records + Table moz_places_metadata_groups_to_snapshots has 0 records + Table moz_session_metadata has 0 records + Table moz_session_to_places has 0 records + Table moz_previews_tombstones has 0 records + Table sqlite_stat1 has 16 records + Pages sequentiality: 60.3 + sqlite_schema: 32KiB (0.8%), 30.4% eff. + moz_inputhistory: 32KiB (0.8%), 0.3% eff. + sqlite_autoindex_moz_inputhistory_1: 32KiB (0.8%), 0.2% eff. + moz_bookmarks_deleted: 32KiB (0.8%), 0% eff. + sqlite_autoindex_moz_bookmarks_deleted_1: 32KiB (0.8%), 0% eff. + moz_keywords: 32KiB (0.8%), 0% eff. + sqlite_autoindex_moz_keywords_1: 32KiB (0.8%), 0% eff. + sqlite_sequence: 32KiB (0.8%), 0.1% eff. + moz_anno_attributes: 32KiB (0.8%), 0.2% eff. + sqlite_autoindex_moz_anno_attributes_1: 32KiB (0.8%), 0.2% eff. + moz_annos: 32KiB (0.8%), 1.8% eff. + moz_items_annos: 32KiB (0.8%), 0% eff. + moz_meta: 32KiB (0.8%), 1% eff. + moz_places_metadata: 32KiB (0.8%), 0% eff. + moz_places_metadata_search_queries: 32KiB (0.8%), 0% eff. + sqlite_autoindex_moz_places_metadata_search_queries_1: 32KiB (0.8%), 0% eff. + moz_places_metadata_snapshots: 32KiB (0.8%), 0% eff. + moz_places_metadata_snapshots_extra: 32KiB (0.8%), 0% eff. + moz_places_metadata_snapshots_groups: 32KiB (0.8%), 0% eff. + moz_places_metadata_groups_to_snapshots: 32KiB (0.8%), 0% eff. + moz_session_metadata: 32KiB (0.8%), 0% eff. + sqlite_autoindex_moz_session_metadata_1: 32KiB (0.8%), 0% eff. + moz_session_to_places: 32KiB (0.8%), 0% eff. + moz_previews_tombstones: 32KiB (0.8%), 0% eff. + sqlite_stat1: 32KiB (0.8%), 2.7% eff. + moz_bookmarks_itemindex: 32KiB (0.8%), 67.7% eff. + moz_bookmarks_parentindex: 32KiB (0.8%), 73.6% eff. + moz_bookmarks_dateaddedindex: 32KiB (0.8%), 99.5% eff. + moz_keywords_placepostdata_uniqueindex: 32KiB (0.8%), 0% eff. + moz_annos_placeattributeindex: 32KiB (0.8%), 0.2% eff. + moz_items_annos_itemattributeindex: 32KiB (0.8%), 0% eff. + moz_places_metadata_placecreated_uniqueindex: 32KiB (0.8%), 0% eff. + moz_places_metadata_referrerindex: 32KiB (0.8%), 0% eff. + moz_places_metadata_snapshots_pinnedindex: 32KiB (0.8%), 0% eff. + moz_places_metadata_snapshots_extra_typeindex: 32KiB (0.8%), 0% eff. + moz_origins: 96KiB (2.3%), 63.8% eff. + sqlite_autoindex_moz_origins_1: 96KiB (2.3%), 59.5% eff. + moz_places_url_hashindex: 96KiB (2.3%), 60.4% eff. + moz_places_visitcount: 96KiB (2.3%), 34.7% eff. + moz_places_frecencyindex: 96KiB (2.3%), 40% eff. + moz_places_originidindex: 96KiB (2.3%), 42.2% eff. + moz_historyvisits_fromindex: 96KiB (2.3%), 41.3% eff. + moz_bookmarks_itemlastmodifiedindex: 96KiB (2.3%), 39.1% eff. + moz_bookmarks_guid_uniqueindex: 96KiB (2.3%), 41.5% eff. + moz_places_lastvisitdateindex: 128KiB (3%), 51.3% eff. + moz_places_guid_uniqueindex: 128KiB (3%), 64.7% eff. + moz_historyvisits_placedateindex: 128KiB (3%), 65.7% eff. + moz_historyvisits_dateindex: 128KiB (3%), 55.4% eff. + moz_historyvisits: 160KiB (3.8%), 71.4% eff. + moz_places_hostindex: 160KiB (3.8%), 66.4% eff. + moz_bookmarks: 256KiB (6.1%), 81% eff. + moz_places: 1152KiB (27.3%), 96.1% eff. > Task: _refreshUI So, any ideas how I can move forward and get my bookmarks working between between all my machines? Thanks very much for your time, John C