Avatar for Username

Zoeken in Support

Vermijd ondersteuningsscams. We zullen u nooit vragen een telefoonnummer te bellen, er een sms naar te sturen of persoonlijke gegevens te delen. Meld verdachte activiteit met de optie ‘Misbruik melden’.

Learn More

Deze conversatie is gearchiveerd. Stel een nieuwe vraag als u hulp nodig hebt.

Real date is moved to current if history entry is clicked

  • 2 antwoorden
  • 1 heeft dit probleem
  • 3 weergaven
  • Laatste antwoord van 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.

Gekozen oplossing

See these threads:

Dit antwoord in context lezen 👍 1

Alle antwoorden (2)

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

Gekozen oplossing

See these threads:

zoom2d
zoom2d Vraageigenaar
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