Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

This thread was archived. Please ask a new question if you need help.

Breaking out the visit count of a bookmark, so I can see when I visited it across the space of an evening.

  • 3 replies
  • 1 has this problem
  • 2 views
  • Last reply by cor-el

jayanglais
jayanglais
more options

I need to prove that on Wednesday night (19 Sept) I could not access a particular careers website. I found the error message url in my history and made the mistake of opening it, it therefore read 11pm today (21 Sept) as the last time it was visited. There is, however, a visit count of 14 which is in line with the amount of times I tried to get onto this site on Wednesday night. I could show the break down of visits on that date it would prove that I was not able to access the said site and could, therefore, not submit my application. Any help would be most appreciated!

I need to prove that on Wednesday night (19 Sept) I could not access a particular careers website. I found the error message url in my history and made the mistake of opening it, it therefore read 11pm today (21 Sept) as the last time it was visited. There is, however, a visit count of 14 which is in line with the amount of times I tried to get onto this site on Wednesday night. I could show the break down of visits on that date it would prove that I was not able to access the said site and could, therefore, not submit my application. Any help would be most appreciated!

All Replies (3)

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

You can see all dates that you've visited a website by using inspecting the places.sqlite database file with the SQLite Manager extension.

Modify the AND url LIKE '%google.com%' part to select which URL to see or leave out that part to get the complete history.
See also http://www.sqlite.org/lang_select.html

  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'), url, title, visit_count, frecency
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id AND url LIKE '%google.com%'
ORDER BY url, visit_date DESC

Modified by cor-el

jayanglais
jayanglais Question owner
more options

Hi, thank you for the help.

I managed to download the addon, then got to the profile page, selected places.sqlite and the Execute SQL tab.

In terms of the programming you suggested, am I just supposed to fill in the gaps? I typed the following into the Enter SQL field:

ELECT www.careers.un.org/Install/UnderConstruction.htm, 14 FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id AND www.careers.un.org/Install/UnderConstruction.htm LIKE '%google.com%' ORDER BY www.careers.un.org/Install/UnderConstruction.htm, 09/19/12 DESC

Am I on the right track at all? Sorry, this is somewhat above my level of understanding. The site url is as above, the date I need is 09/19/12 and the time was from 8:30pm onwards. I can see from my firefox history that I hit the same page 12 times but I can't show the exactly when. You can see the screen shot showing the url and the last time I opened it (Friday at 11pm).

Cheers,

James.

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

No, that is not the correct code for the SQLite query.
You only need to specify the domain or URL in the "like" field and don't make any changes elsewhere.
The first SELECT line specifies which columns to show in the results and you can lweave out the ones that you do not need. 

SELECT datetime(visit_date/1000000,'unixepoch'), url, title, visit_count, frecency
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id AND url LIKE '%www.careers.un.org%'
ORDER BY url, visit_date DESC