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?
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)
You can use the SQLite Manager extension to create the list.
- 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','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
Okulungisiwe
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.
In the SQLite Manager window, on the toolbar, look for a side wide button that says "(Select Profile Database)".
Edit: Here's a screenshot:
Okulungisiwe
You can also look a this utility: