搜尋 Mozilla 技術支援網站

防止技術支援詐騙。我們絕對不會要求您撥打電話或發送簡訊,或是提供個人資訊。請用「回報濫用」功能回報可疑的行為。

了解更多

Missing history url and cannot modify bookmark

  • 6 回覆
  • 1 有這個問題
  • 4 次檢視
  • 最近回覆由 Paul

more options

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)

https://ibb.co/9bdjrdN

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

https://ibb.co/vhHzZCK

> 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.

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) https://ibb.co/9bdjrdN 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 https://ibb.co/vhHzZCK > 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)

more options

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.

more options

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).

See also:

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).

more options

@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

more options

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

more options

選擇的解決方法

@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

more options

Thank you for letting us know.