Avatar for Username

搜尋 Mozilla 技術支援網站

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

了解更多

此討論串已被封存。 如果您有需要幫助，請新增一個新問題

Real date is moved to current if history entry is clicked

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

zoom2d
zoom2d
more options

So I have a little bit weird problem. I need to recover original date of my browsing history entry because it moved to "today" and doesn't show up anymore where it was originally(3/3) after i clicked it to verify that it was a correct URL I was looking for. It should've simple added an entry for the same URL, so that i have both old and new.

Why I need it is because my landlord tries to charge me late fees for not paying on time, even though i actually did and my history indicates it(the entry i am looking for is a payment confirmation that all of a sudden moved to "today" when i checked it)> I need to show the original date to prove that payment was done on my side and it's their system failure.

So I have a little bit weird problem. I need to recover original date of my browsing history entry because it moved to "today" and doesn't show up anymore where it was originally(3/3) after i clicked it to verify that it was a correct URL I was looking for. It should've simple added an entry for the same URL, so that i have both old and new. Why I need it is because my landlord tries to charge me late fees for not paying on time, even though i actually did and my history indicates it(the entry i am looking for is a payment confirmation that all of a sudden moved to "today" when i checked it)> I need to show the original date to prove that payment was done on my side and it's their system failure.

被選擇的解決方法

See these threads:

從原來的回覆中察看解決方案 👍 1

所有回覆 (2)

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

選擇的解決方法

See these threads:

zoom2d
zoom2d 提出問題者
more options

Thank you for help. Running this query in SQLite Manager definitely works:)

Copying your answer for question 931864 to make it visible from this one.

Solution from cor-el: Firefox only shows the last time that you've visited an URL and a visit count.

You will have to use the SQLite Manager extension to see all visit dates.

You can use this query and change url LIKE '%google.com%' to the URL that you want to check. A percent symbol ("%") in the LIKE pattern matches any sequence of zero or more characters in the string. 

   SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/ 

   Open Profile Directory -> places.sqlite -> Go
   Hit the Execute SQL tab
   Use a Select like this:

SELECT datetime(visit_date/1000000,'unixepoch') AS visit_date, url, title FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id AND url LIKE '%google.com%' 

   Click Run SQL to generate a results list
   Click the Action button to Save the results to a CSV file