Missing history url and cannot modify bookmark
Hi
I don't know why but its been 3 days since i cant updated my bookmark and i cant see my url history
my history is just went empty (sceenshot bellow)
im also cannot modify existing bookmark (both item or folder) , usually i just drag the url from url bar into my bookmark folder ..now when i drag url it does nothing...i think this all happen after firefox self updating
now...i did searching for answer before i posted this question but i still having issue https://support.mozilla.org/en-US/questions/1265898
on about:support options, verify database options gave me this
> Task: checkIntegrity - Unable to check places.sqlite integrity: Error: Error(s) encountered during statement execution: > Task: invalidateCaches - The task queue was cleared by an error in another task. > Task: checkCoherence - The task queue was cleared by an error in another task. > Task: expire - The task queue was cleared by an error in another task. > Task: originFrecencyStats - The task queue was cleared by an error in another task. > Task: vacuum - The task queue was cleared by an error in another task. > Task: stats - The task queue was cleared by an error in another task. > Task: _refreshUI - The task queue was cleared by an error in another task.
被選擇的解決方法
@fredmcd yes i have more than one profile, my profile (firefox customization setting) is continuation since my first time i used firefox
but anyway i managed to solve the issue .. in case other facing similar issue ..the detail solution is explained here https://superuser.com/questions/111998/how-do-i-repair-a-corrupted-firefox-places-sqlite-database thanks to user bwDraco
you need to download this zip file and extract it to your profile folder https://www.sqlite.org/2021/sqlite-tools-win32-x86-3370000.zip if you go to sqlite website just remember to download the one with size 1.8mb not 500KB
then you need to execute some query like on this screenshot, during the last query just remember your user.version
sqlite> PRAGMA user_version; 59
Mine return 59, your might not same as mine..then replicate it on our cloned places.sqlite ,chek if everything OK then delete the corrupted places.sqlite, rename cloned places.sqlite
type about:support ...in Places Database click verify integrity
> 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 61440KiB + The database has been vacuumed + Final database size is 56320KiB > Task: stats + Places.sqlite size is 56320KiB + Favicons.sqlite size is 5120KiB + pragma_user_version is 59 + 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 136771 unique pages + Table moz_origins has 8552 records + Table moz_places has 100382 records + Table moz_historyvisits has 206599 records + Table moz_inputhistory has 610 records + Table moz_bookmarks has 23262 records + Table moz_bookmarks_deleted has 19 records + Table moz_keywords has 0 records + Table sqlite_sequence has 1 records + Table moz_anno_attributes has 3 records + Table moz_annos has 413 records + Table moz_items_annos has 0 records + Table moz_meta has 3 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 + Pages sequentiality: 35.7 + sqlite_schema: 32KiB (0.1%), 27.3% eff. + moz_inputhistory: 32KiB (0.1%), 63.6% eff. + sqlite_autoindex_moz_inputhistory_1: 32KiB (0.1%), 49.6% eff. + moz_bookmarks_deleted: 32KiB (0.1%), 1.6% eff. + sqlite_autoindex_moz_bookmarks_deleted_1: 32KiB (0.1%), 1.1% eff. + moz_keywords: 32KiB (0.1%), 0% eff. + sqlite_autoindex_moz_keywords_1: 32KiB (0.1%), 0% eff. + sqlite_sequence: 32KiB (0.1%), 0.1% eff. + moz_anno_attributes: 32KiB (0.1%), 0.3% eff. + sqlite_autoindex_moz_anno_attributes_1: 32KiB (0.1%), 0.3% eff. + moz_items_annos: 32KiB (0.1%), 0% eff. + moz_meta: 32KiB (0.1%), 0.3% eff. + moz_places_metadata: 32KiB (0.1%), 0% eff. + moz_places_metadata_search_queries: 32KiB (0.1%), 0% eff. + sqlite_autoindex_moz_places_metadata_search_queries_1: 32KiB (0.1%), 0% eff. + moz_places_metadata_snapshots: 32KiB (0.1%), 0% eff. + moz_places_metadata_snapshots_extra: 32KiB (0.1%), 0% eff. + moz_places_metadata_snapshots_groups: 32KiB (0.1%), 0% eff. + moz_places_metadata_groups_to_snapshots: 32KiB (0.1%), 0% eff. + moz_session_metadata: 32KiB (0.1%), 0% eff. + sqlite_autoindex_moz_session_metadata_1: 32KiB (0.1%), 0% eff. + moz_session_to_places: 32KiB (0.1%), 0% eff. + moz_keywords_placepostdata_uniqueindex: 32KiB (0.1%), 0% eff. + moz_annos_placeattributeindex: 32KiB (0.1%), 16.2% eff. + moz_items_annos_itemattributeindex: 32KiB (0.1%), 0% eff. + moz_places_metadata_placecreated_uniqueindex: 32KiB (0.1%), 0% eff. + moz_annos: 96KiB (0.2%), 40.3% eff. + moz_bookmarks_itemindex: 288KiB (0.5%), 83.9% eff. + moz_origins: 352KiB (0.6%), 86.4% eff. + sqlite_autoindex_moz_origins_1: 320KiB (0.6%), 88.5% eff. + moz_bookmarks_parentindex: 320KiB (0.6%), 87% eff. + moz_bookmarks_dateaddedindex: 416KiB (0.7%), 87.4% eff. + moz_bookmarks_itemlastmodifiedindex: 480KiB (0.9%), 87.9% eff. + moz_bookmarks_guid_uniqueindex: 512KiB (0.9%), 88.7% eff. + moz_places_visitcount: 928KiB (1.7%), 96.5% eff. + moz_places_frecencyindex: 1024KiB (1.8%), 95.3% eff. + moz_places_originidindex: 1120KiB (2%), 94.4% eff. + moz_places_url_hashindex: 1504KiB (2.7%), 97.2% eff. + moz_places_lastvisitdateindex: 1696KiB (3%), 96.8% eff. + moz_places_guid_uniqueindex: 2112KiB (3.8%), 97.1% eff. + moz_bookmarks: 2272KiB (4.1%), 98.5% eff. + moz_historyvisits_fromindex: 2272KiB (4.1%), 98.1% eff. + moz_places_hostindex: 2656KiB (4.7%), 97.9% eff. + moz_historyvisits_dateindex: 3488KiB (6.2%), 98.4% eff. + moz_historyvisits_placedateindex: 4224KiB (7.5%), 99.3% eff. + moz_historyvisits: 5312KiB (9.5%), 98.9% eff. + moz_places: 23840KiB (42.5%), 99.3% eff. > Task: _refreshUI
i lost some data but ,history and bookmark now working correctly ..history from the past 5 days( span time when my history still broken) gone
從原來的回覆中察看解決方案 👍 0所有回覆 (6)
If any errors are reported: https://support.mozilla.org/en-US/kb/fix-bookmarks-and-history-will-not-be-functional
The places.sqlite file contains your History and Bookmarks. And it looks like it is corrupted.
Type about:support<enter> in the address box.
Under the page logo on the left side, you will see Application Basics. Under this find Profile Folder. To its right press the button Show Folder. This will open your file browser to the current Firefox profile. Now Close Firefox.
Locate the above file. Then rename or delete it. Restart Firefox. The browser should then create a new place.sqlite and recover your bookmarks from the backup files.
Note: Your history is not backed up and will be lost.
If you use Sync then best is to disconnect Sync temporarily during troubleshooting.
This could be a problem with the places.sqlite and favicons.sqlite files in the Firefox profile folder.
- use the "Places Database" -> "Verify Integrity" button on the "Help -> More Troubleshooting Information" (about:support) page
If errors are reported with "Verify Integrity", close and restart Firefox or reboot and retry.
If "Verify Integrity" cannot repair places.sqlite, rename/remove all places.sqlite and favicons.sqlite files in the Firefox profile folder with Firefox closed. Firefox will rebuild places.sqlite and restore the bookmarks from the most recent JSON backup in the bookmarkbackups folder.
- keep a backup copy of places.sqlite in case a new places.sqlite database has to be created
- you lose the history when a new places.sqlite is created
You may have to restore an older bookmarks backup in the bookmarkbackups folder via the Bookmarks Manager (Library).
- Bookmarks -> Show All Bookmarks -> Import & Backup -> Restore
- https://support.mozilla.org/en-US/kb/restore-bookmarks-from-backup-or-move-them
See also:
- https://support.mozilla.org/en-US/kb/fix-bookmarks-and-history-will-not-be-functional
- https://support.mozilla.org/en-US/kb/cant-add-change-or-save-bookmarks
You can use the button on the "Help -> More Troubleshooting Information" (about:support) page to go to the current Firefox profile folder or use the about:profiles page (Root directory).
- Help -> More Troubleshooting Information -> Profile Folder/Directory:
Windows: Open Folder; Linux: Open Directory; Mac: Show in Finder - https://support.mozilla.org/en-US/kb/profiles-where-firefox-stores-user-data
@cor-el yes, i used my account to sync everything into my firefox account so i could just load the setting each time i used firefox on different computer (new OS instalation for example)
My apologize if i kinda slow to "Digest" everything :D , just to make sure...so i go to my profile folder ,copy places.sqlite, create backup of places.sqlite..delete the file and restart firefox?but i already did that and the items are gone (bookmark and url history) but the bookmark folder are still present, it just they're all empty
Do you possibly have more than one profile? Deleting the places.sqlite file should make the browser create a new one from the backup folder.
Restore Bookmark Backups
Firefox automatically makes backups of the bookmarks. These are stored in the bookmarkbackups folder.
Open the Bookmarks Manager; Press the Alt or F10 key to bring up the toolbar, and select Bookmarks. Hot key is <Control> (Mac=<Command>) <Shift> B. Firefox 84+ <Control> (Mac=<Command>) <Shift> O.
Once the window is open, at the top of the page, press the button labeled Import and Backup. Select Restore. From the list, pick the file you want and click it.
The backups are stored in a jsonlz4 file named something like this; bookmarks-2016-06-29_1424_enD1GTH ya0JmicnYWg4V4g==.jsonlz4
In this example; 2016-06-29 = date created, 1424 = number of entries.
https://support.mozilla.org/en-US/kb/restore-bookmarks-from-backup-or-move-them
https://support.mozilla.org/en-US/kb/recover-lost-or-missing-bookmarks
https://support.mozilla.org/kb/forum-response-recover-bookmarks-after-update
選擇的解決方法
@fredmcd yes i have more than one profile, my profile (firefox customization setting) is continuation since my first time i used firefox
but anyway i managed to solve the issue .. in case other facing similar issue ..the detail solution is explained here https://superuser.com/questions/111998/how-do-i-repair-a-corrupted-firefox-places-sqlite-database thanks to user bwDraco
you need to download this zip file and extract it to your profile folder https://www.sqlite.org/2021/sqlite-tools-win32-x86-3370000.zip if you go to sqlite website just remember to download the one with size 1.8mb not 500KB
then you need to execute some query like on this screenshot, during the last query just remember your user.version
sqlite> PRAGMA user_version; 59
Mine return 59, your might not same as mine..then replicate it on our cloned places.sqlite ,chek if everything OK then delete the corrupted places.sqlite, rename cloned places.sqlite
type about:support ...in Places Database click verify integrity
> 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 61440KiB + The database has been vacuumed + Final database size is 56320KiB > Task: stats + Places.sqlite size is 56320KiB + Favicons.sqlite size is 5120KiB + pragma_user_version is 59 + 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 136771 unique pages + Table moz_origins has 8552 records + Table moz_places has 100382 records + Table moz_historyvisits has 206599 records + Table moz_inputhistory has 610 records + Table moz_bookmarks has 23262 records + Table moz_bookmarks_deleted has 19 records + Table moz_keywords has 0 records + Table sqlite_sequence has 1 records + Table moz_anno_attributes has 3 records + Table moz_annos has 413 records + Table moz_items_annos has 0 records + Table moz_meta has 3 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 + Pages sequentiality: 35.7 + sqlite_schema: 32KiB (0.1%), 27.3% eff. + moz_inputhistory: 32KiB (0.1%), 63.6% eff. + sqlite_autoindex_moz_inputhistory_1: 32KiB (0.1%), 49.6% eff. + moz_bookmarks_deleted: 32KiB (0.1%), 1.6% eff. + sqlite_autoindex_moz_bookmarks_deleted_1: 32KiB (0.1%), 1.1% eff. + moz_keywords: 32KiB (0.1%), 0% eff. + sqlite_autoindex_moz_keywords_1: 32KiB (0.1%), 0% eff. + sqlite_sequence: 32KiB (0.1%), 0.1% eff. + moz_anno_attributes: 32KiB (0.1%), 0.3% eff. + sqlite_autoindex_moz_anno_attributes_1: 32KiB (0.1%), 0.3% eff. + moz_items_annos: 32KiB (0.1%), 0% eff. + moz_meta: 32KiB (0.1%), 0.3% eff. + moz_places_metadata: 32KiB (0.1%), 0% eff. + moz_places_metadata_search_queries: 32KiB (0.1%), 0% eff. + sqlite_autoindex_moz_places_metadata_search_queries_1: 32KiB (0.1%), 0% eff. + moz_places_metadata_snapshots: 32KiB (0.1%), 0% eff. + moz_places_metadata_snapshots_extra: 32KiB (0.1%), 0% eff. + moz_places_metadata_snapshots_groups: 32KiB (0.1%), 0% eff. + moz_places_metadata_groups_to_snapshots: 32KiB (0.1%), 0% eff. + moz_session_metadata: 32KiB (0.1%), 0% eff. + sqlite_autoindex_moz_session_metadata_1: 32KiB (0.1%), 0% eff. + moz_session_to_places: 32KiB (0.1%), 0% eff. + moz_keywords_placepostdata_uniqueindex: 32KiB (0.1%), 0% eff. + moz_annos_placeattributeindex: 32KiB (0.1%), 16.2% eff. + moz_items_annos_itemattributeindex: 32KiB (0.1%), 0% eff. + moz_places_metadata_placecreated_uniqueindex: 32KiB (0.1%), 0% eff. + moz_annos: 96KiB (0.2%), 40.3% eff. + moz_bookmarks_itemindex: 288KiB (0.5%), 83.9% eff. + moz_origins: 352KiB (0.6%), 86.4% eff. + sqlite_autoindex_moz_origins_1: 320KiB (0.6%), 88.5% eff. + moz_bookmarks_parentindex: 320KiB (0.6%), 87% eff. + moz_bookmarks_dateaddedindex: 416KiB (0.7%), 87.4% eff. + moz_bookmarks_itemlastmodifiedindex: 480KiB (0.9%), 87.9% eff. + moz_bookmarks_guid_uniqueindex: 512KiB (0.9%), 88.7% eff. + moz_places_visitcount: 928KiB (1.7%), 96.5% eff. + moz_places_frecencyindex: 1024KiB (1.8%), 95.3% eff. + moz_places_originidindex: 1120KiB (2%), 94.4% eff. + moz_places_url_hashindex: 1504KiB (2.7%), 97.2% eff. + moz_places_lastvisitdateindex: 1696KiB (3%), 96.8% eff. + moz_places_guid_uniqueindex: 2112KiB (3.8%), 97.1% eff. + moz_bookmarks: 2272KiB (4.1%), 98.5% eff. + moz_historyvisits_fromindex: 2272KiB (4.1%), 98.1% eff. + moz_places_hostindex: 2656KiB (4.7%), 97.9% eff. + moz_historyvisits_dateindex: 3488KiB (6.2%), 98.4% eff. + moz_historyvisits_placedateindex: 4224KiB (7.5%), 99.3% eff. + moz_historyvisits: 5312KiB (9.5%), 98.9% eff. + moz_places: 23840KiB (42.5%), 99.3% eff. > Task: _refreshUI
i lost some data but ,history and bookmark now working correctly ..history from the past 5 days( span time when my history still broken) gone
Thank you for letting us know.