X
Tap here to go to the mobile version of the site.

Support Forum

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?

Posted

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

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

Installed Plug-ins

  • Shockwave Flash 14.0 r0
  • Adobe PDF Plug-In For Firefox and Netscape 10.1.11
  • Facebook Video Calling Plugin
  • DivX Web Player version 3.2.2.4
  • 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.
  • GEPlugin
  • 5.1.20513.0
  • Uplay PC Plugin
  • 0.3
  • iTunes Detector Plug-in
  • NPWLPG
  • Pando Web Plugin

Application

  • User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Firefox/31.0

More Information

cor-el
  • Top 10 Contributor
  • Moderator
17472 solutions 157920 answers

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

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: <pre><nowiki> 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 </nowiki></pre> 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

Question owner

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.

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.
jscher2000
  • Top 10 Contributor
8693 solutions 71058 answers

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

Edit: Here's a screenshot:

In the SQLite Manager window, on the toolbar, look for a <s>side</s> <u>wide</u> button that says "(Select Profile Database)". ''Edit: Here's a screenshot:''

Modified by jscher2000

cor-el
  • Top 10 Contributor
  • Moderator
17472 solutions 157920 answers
You can also look a this utility: *http://www.nirsoft.net/utils/browsing_history_view.html