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

How can I locate a log of dated activity on a mozilla firefox where I know I should have entries in my history yet they do no show - and without being deleted?

  • 4 replies
  • 2 have this problem
  • 1179 views
  • Last reply by cor-el

more options

In summary, on the date of 8/17/2014 in the evening, I experienced some very bad internet connectivity and virtually any website I visited was having difficulty loading. I know I had visited a couple of websites between the hours of 6:30pm or 6:45pm (EST) up to roughly an hour or two, and now (even though I had NOT chosen to delete even one (let alone hours of history entries) there is a chunk of mozilla history missing where I did not delete. I am seeking some assisstance finding the log of ALL of this browser's activity that day, especially a record of any alterations to browser's history. I know that I did not physically delete hours worth of activity and there must be some way of bringing this truth to light. Thank you for your time

All Replies (4)

more options

You can use the SQLite Manager extension to create the list.

  • Open Profile Directory -> places.sqlite -> Go
  • Hit the "Execute SQL" tab
  • Use a Select like this:
SELECT datetime(visit_date/1000000,'unixepoch','localtime') AS visit_date, url, title
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id AND visit_date BETWEEN strftime('%s','YYYY-MM-DD HH:MM:SS')*1000000 AND strftime('%s','YYYY-MM-DD HH:MM:SS')*1000000
ORDER BY url, visit_date DESC

Change the strftime parameter list to the wanted date/time range, times in UTC. Leave out the ORDER BY line to order by the first column (visit_date) or use ORDER BY visit_date DESC

Modified by cor-el

more options

I apologize for my inability to find which profile directory was mentioned in the bulleted-list.. I tried finding a profile directory within the new plugin after being installed, my own windows user profile directories, and lastly I searched through mozilla firefox' directories as well and found no places.sqlite. Please help me find the correct directory if possible, and I should be able to locate the "Execute SQL" tab once I find the right button to give me what I imagine is the plugin containers dialogue box of GUI if you will.... again, sorry for the hassle!! I suppose after all these years using firefox I am still a novice.

more options

In the SQLite Manager window, on the toolbar, look for a side wide button that says "(Select Profile Database)".

Edit: Here's a screenshot:

Modified by jscher2000

more options