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
Additional System Details
- Shockwave Flash 14.0 r0
- Adobe PDF Plug-In For Firefox and Netscape 10.1.11
- Facebook Video Calling Plugin
- DivX Web Player version 184.108.40.206
- Next Generation Java Plug-in 10.65.2 for Mozilla browsers
- NPRuntime Script Plug-in Library for Java(TM) Deploy
- Google Update
- DivX VOD Helper Plug-in
- npsitesafety (Official)
- VLC media player Web Plugin 2.1.3
- The QuickTime Plugin allows you to view a wide variety of multimedia content in Web pages. For more information, visit the QuickTime Web site.
- Uplay PC Plugin
- iTunes Detector Plug-in
- Pando Web Plugin
- User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Firefox/31.0
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
Modified by cor-el
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:
Modified by jscher2000
You can also look a this utility: