Join the Mozilla’s Test Days event from Dec 2–8 to test the new Firefox address bar on Firefox Beta 134 and get a chance to win Mozilla swag vouchers! 🎁

Поиск в Поддержке

Избегайте мошенников, выдающих себя за службу поддержки. Мы никогда не попросим вас позвонить, отправить текстовое сообщение или поделиться личной информацией. Сообщайте о подозрительной активности, используя функцию «Пожаловаться».

Подробнее

Real date is moved to current if history entry is clicked

  • 2 ответа
  • 1 имеет эту проблему
  • 1 просмотр
  • Последний ответ от 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)

more options

Выбранное решение

See these threads:

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