cancel
Showing results for 
Search instead for 
Did you mean: 

Real date is moved to current if history entry is clicked

SOLVED
Highlighted
New User

Real date is moved to current if history entry is clicked

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Site Moderator

Re: Real date is moved to current if history entry is clicked

See these threads:

2 REPLIES
Site Moderator

Re: Real date is moved to current if history entry is clicked

See these threads:

New User

Re: Real date is moved to current if history entry is clicked

Thank you for help. Running this query in SQLite Manager definitely worksSmiley Happy

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