Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

為了改善您的使用體驗,本網站正在進行維護,部分功能暫時無法使用。若本站的文件無法解決您的問題,想要向社群發問的話,請到 Twitter 上的 @FirefoxSupport 或 Reddit 上的 /r/firefox 發問,我們的社群成員將很快會回覆您的疑問。

搜尋 Mozilla 技術支援網站

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

了解更多

How can i prevent Firefox from overriding identical history entries?

  • 1 回覆
  • 2 有這個問題
  • 1 次檢視
  • 最近回覆由 cor-el

more options

I'm using Firefox v12, and whenever it records a history entry that is identical to an older one, it deletes the old one and keeps the new one. For example, if i visited, "www.suchandsuch.com" on 1/15/2012, and then again today, it would delete the old entry and replace it with the new one for today.

Is there a way to change this? I've only just realized this feature and now understand why i've lost 1000's of history entries over the past year. I've looked on the "about:config" page, but i'd rather not fiddle with anything for fear of worsening the problem.

I'm using Firefox v12, and whenever it records a history entry that is identical to an older one, it deletes the old one and keeps the new one. For example, if i visited, "www.suchandsuch.com" on 1/15/2012, and then again today, it would delete the old entry and replace it with the new one for today. Is there a way to change this? I've only just realized this feature and now understand why i've lost 1000's of history entries over the past year. I've looked on the "about:config" page, but i'd rather not fiddle with anything for fear of worsening the problem.

由 cor-el 於 修改

所有回覆 (1)

more options

Firefox keeps those older history entries and doesn't delete them because they are needed to calculate the visit count.
In the history list you only see the most recent visit and the other are hidden.

You can inspect the places.sqlite file with the SQLite Manager extension to see all visits.

  1. Open Profile Directory -> places.sqlite -> Go
  2. Hit the Execute SQL tab
  3. Use a Select like this:
SELECT datetime(visit_date/1000000,'unixepoch') AS visit_date, url, title, visit_count, frecency
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id AND typed LIKE '1'
ORDER BY url, visit_date DESC

More examples for the WHERE clause:

  • WHERE moz_places.id = moz_historyvisits.place_id AND url LIKE '%google%'
  • WHERE moz_places.id = moz_historyvisits.place_id AND url LIKE '%youtube%' AND typed LIKE '1'
  • WHERE moz_places.id = moz_historyvisits.place_id AND visit_date BETWEEN strftime('%s','YYYY-MM-DD')*1000000 AND strftime('%s','YYYY-MM-DD')*1000000