- Archived
Deleted corrupt places.sqlite and it deleted all bookmarks, restore not working
Hi - I followed other threads to try to resolve the problem of not being able to delete old bookmarks. I used about:support and ran verify integrity to discover places.s… (read more)
Hi - I followed other threads to try to resolve the problem of not being able to delete old bookmarks.
I used about:support and ran verify integrity to discover places.sqlite was corrupt. So I closed down Firefox and deleted it based on advice. Reran it and it states:
> 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 77312KiB + pragma_user_version is 66 + 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 37810 unique pages + Table moz_origins has 179 records + Table moz_places has 1056 records + Table moz_historyvisits has 2574 records + Table moz_inputhistory has 0 records + Table moz_bookmarks has 100 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 0 records + Table moz_annos has 0 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 15 records + Pages sequentiality: 87.9 + sqlite_schema: 32KiB (1.5%), 30.1% eff. + moz_origins: 32KiB (1.5%), 20% eff. + sqlite_autoindex_moz_origins_1: 32KiB (1.5%), 18.8% eff. + moz_inputhistory: 32KiB (1.5%), 0% eff. + sqlite_autoindex_moz_inputhistory_1: 32KiB (1.5%), 0% eff. + moz_bookmarks: 32KiB (1.5%), 19.1% eff. + moz_bookmarks_deleted: 32KiB (1.5%), 0% eff. + sqlite_autoindex_moz_bookmarks_deleted_1: 32KiB (1.5%), 0% eff. + moz_keywords: 32KiB (1.5%), 0% eff. + sqlite_autoindex_moz_keywords_1: 32KiB (1.5%), 0% eff. + sqlite_sequence: 32KiB (1.5%), 0.1% eff. + moz_anno_attributes: 32KiB (1.5%), 0% eff. + sqlite_autoindex_moz_anno_attributes_1: 32KiB (1.5%), 0% eff. + moz_annos: 32KiB (1.5%), 0% eff. + moz_items_annos: 32KiB (1.5%), 0% eff. + moz_meta: 32KiB (1.5%), 0.7% eff. + moz_places_metadata: 32KiB (1.5%), 0% eff. + moz_places_metadata_search_queries: 32KiB (1.5%), 0% eff. + sqlite_autoindex_moz_places_metadata_search_queries_1: 32KiB (1.5%), 0% eff. + moz_places_metadata_snapshots: 32KiB (1.5%), 0% eff. + moz_places_metadata_snapshots_extra: 32KiB (1.5%), 0% eff. + moz_places_metadata_snapshots_groups: 32KiB (1.5%), 0% eff. + moz_places_metadata_groups_to_snapshots: 32KiB (1.5%), 0% eff. + moz_session_metadata: 32KiB (1.5%), 0% eff. + sqlite_autoindex_moz_session_metadata_1: 32KiB (1.5%), 0% eff. + moz_session_to_places: 32KiB (1.5%), 0% eff. + moz_previews_tombstones: 32KiB (1.5%), 0% eff. + sqlite_stat1: 32KiB (1.5%), 2.5% eff. + moz_places_url_hashindex: 32KiB (1.5%), 45.1% eff. + moz_places_hostindex: 32KiB (1.5%), 78.2% eff. + moz_places_visitcount: 32KiB (1.5%), 28% eff. + moz_places_frecencyindex: 32KiB (1.5%), 29.3% eff. + moz_places_lastvisitdateindex: 32KiB (1.5%), 51.5% eff. + moz_places_guid_uniqueindex: 32KiB (1.5%), 64.4% eff. + moz_places_originidindex: 32KiB (1.5%), 31.9% eff. + moz_historyvisits_fromindex: 32KiB (1.5%), 62.8% eff. + moz_bookmarks_itemindex: 32KiB (1.5%), 2.8% eff. + moz_bookmarks_parentindex: 32KiB (1.5%), 2.9% eff. + moz_bookmarks_itemlastmodifiedindex: 32KiB (1.5%), 4.9% eff. + moz_bookmarks_dateaddedindex: 32KiB (1.5%), 4.6% eff. + moz_bookmarks_guid_uniqueindex: 32KiB (1.5%), 5.8% eff. + moz_keywords_placepostdata_uniqueindex: 32KiB (1.5%), 0% eff. + moz_annos_placeattributeindex: 32KiB (1.5%), 0% eff. + moz_items_annos_itemattributeindex: 32KiB (1.5%), 0% eff. + moz_places_metadata_placecreated_uniqueindex: 32KiB (1.5%), 0% eff. + moz_places_metadata_referrerindex: 32KiB (1.5%), 0% eff. + moz_places_metadata_snapshots_pinnedindex: 32KiB (1.5%), 0% eff. + moz_places_metadata_snapshots_extra_typeindex: 32KiB (1.5%), 0% eff. + moz_historyvisits: 96KiB (4.5%), 57.7% eff. + moz_historyvisits_placedateindex: 96KiB (4.5%), 49.6% eff. + moz_historyvisits_dateindex: 96KiB (4.5%), 41.8% eff. + moz_places: 320KiB (14.9%), 84.4% eff. > Task: _refreshUI
Accessibility Activated false
All my bookmarks are gone, but the folders are still there. I tried to use the restore from several dates and it still shows only folders, no bookmarks. I checked my phone - I had made sure to turn off sync for bookmarks, etc, but didn't sign out of sync. Bookmarks were still there. So I turned on sync to try to get them back on my browser. Even though sync had been on, it hadn't synced every bookmark from the browser though. (?!) So it seems very weird that I wouldn't be able to delete some bookmarks that weren't even synced in the first place. So I didn't get back all my bookmarks. I turned off sync on my phone and tried again from the browser, this time signing out completely from sync. It gave me only the folders. I should also mention, I restarted my computer and then Firefox several times during this process. I'm scared to delete any more system files as it seems that it will further remove necessary information. I'm not a coder, but it seems my bookmarks are still there? I tried exporting them and importing in Chrome - only the folders showed up there.
Any ideas? Thanks - your help is appreciated!