X
Tap here to go to the mobile version of the site.
IMPORTANT ANNOUNCEMENT: We’re going through some system changes, that may have slowed responses to your questions. If you had asked a question in the last couple of months, please re-post it and the community will help you as soon as we can. If you’ve registered after February 7th, please register again, the accounts on the previous site were not migrated to this temporary site. If you joined us before February 7, please reset your password if you have trouble logging into this temporary site.

Support Forum

Real date is moved to current if history entry is clicked

Posted

So I have a little bit weird problem. I need to recover original date of my browsing history entry because it moved to "today" and doesn't show up anymore where it was originally(3/3) after i clicked it to verify that it was a correct URL I was looking for. It should've simple added an entry for the same URL, so that i have both old and new.

Why I need it is because my landlord tries to charge me late fees for not paying on time, even though i actually did and my history indicates it(the entry i am looking for is a payment confirmation that all of a sudden moved to "today" when i checked it)> I need to show the original date to prove that payment was done on my side and it's their system failure.

So I have a little bit weird problem. I need to recover original date of my browsing history entry because it moved to "today" and doesn't show up anymore where it was originally(3/3) after i clicked it to verify that it was a correct URL I was looking for. It should've simple added an entry for the same URL, so that i have both old and new. Why I need it is because my landlord tries to charge me late fees for not paying on time, even though i actually did and my history indicates it(the entry i am looking for is a payment confirmation that all of a sudden moved to "today" when i checked it)> I need to show the original date to prove that payment was done on my side and it's their system failure.

Chosen solution

See these threads:

Read this answer in context 1

Additional System Details

Installed Plug-ins

  • Google Update
  • IE Tab 2 Plug-in for Mozilla/Firefox
  • The QuickTime Plugin allows you to view a wide variety of multimedia content in Web pages. For more information, visit the QuickTime Web site.
  • 5.1.10411.0
  • Shockwave Flash 11.1 r102
  • iTunes Detector Plug-in
  • Adobe PDF Plug-In For Firefox and Netscape 10.1.3
  • Microsoft Lync 2010 Meeting Join Plug-in
  • The plug-in allows you to open and edit files using Microsoft Office applications

Application

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

More Information

{
"application": {
"name": "Firefox",
"version": "16.0.2",
"userAgent": "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0",
"supportURL": "http://support.mozilla.org/1/firefox/16.0.2/WINNT/en-US/"
},
"modifiedPreferences": {
"accessibility.typeaheadfind.casesensitive": 1,
"accessibility.typeaheadfind.flashBar": 0,
"browser.cache.disk.capacity": 1048576,
"browser.cache.disk.smart_size.first_run": false,
"browser.cache.disk.smart_size_cached_value": 1048576,
"browser.history_expire_days.mirror": 180,
"browser.places.importDefaults": false,
"browser.places.updateRecentTagsUri": false,
"browser.places.importBookmarksHTML": false,
"browser.places.smartBookmarksVersion": 4,
"browser.places.leftPaneFolderId": -1,
"browser.places.migratePostDataAnnotations": false,
"browser.search.update": false,
"browser.startup.homepage_override.mstone": "16.0.2",
"browser.startup.homepage": "https://in.nokia.com/",
"browser.startup.homepage_override.buildID": "20121024073032",
"browser.tabs.showSingleWindowModePrefs": true,
"dom.ipc.plugins.enabled.npietab2.dll": true,
"extensions.lastAppVersion": "16.0.2",
"general.autoScroll": false,
"gfx.direct3d.prefer_10_1": true,
"keyword.URL": "http://www.google.com/search?ie=UTF-8&oe=UTF-8&sourceid=navclient&gfns=1&q=",
"network.cookie.prefsMigrated": true,
"network.http.pipelining": true,
"network.http.proxy.pipelining": true,
"network.automatic-ntlm-auth.trusted-uris": "nokia.com",
"places.history.expiration.transient_current_max_pages": 104858,
"places.database.lastMaintenance": 1361909582,
"privacy.sanitize.migrateFx3Prefs": true,
"security.warn_viewing_mixed": false
},
"graphics": "Troubleshoot data provider failed: graphics\nTypeError: ext is null",
"javaScript": {
"incrementalGCEnabled": true
},
"accessibility": {
"isActive": false,
"forceDisabled": 0
},
"libraryVersions": {
"NSPR": {
"minVersion": "4.9.2",
"version": "4.9.2"
},
"NSS": {
"minVersion": "3.13.6.0 Basic ECC",
"version": "3.13.6.0 Basic ECC"
},
"NSSUTIL": {
"minVersion": "3.13.6.0",
"version": "3.13.6.0"
},
"NSSSSL": {
"minVersion": "3.13.6.0 Basic ECC",
"version": "3.13.6.0 Basic ECC"
},
"NSSSMIME": {
"minVersion": "3.13.6.0 Basic ECC",
"version": "3.13.6.0 Basic ECC"
}
},
"userJS": {
"exists": true
},
"extensions": [
{
"name": "Accept360 Launcher",
"version": "0.3",
"isActive": true,
"id": "jid1-nNJjgLaDAHqjAA@jetpack"
},
{
"name": "All-in-One Gestures",
"version": "0.25.1",
"isActive": true,
"id": "{8b86149f-01fb-4842-9dd8-4d7eb02fd055}"
},
{
"name": "Cookies Manager+",
"version": "1.5.1.1",
"isActive": true,
"id": "{bb6bc1bb-f824-4702-90cd-35e2fb24f25d}"
},
{
"name": "Firebug",
"version": "1.10.6",
"isActive": true,
"id": "firebug@software.joehewitt.com"
},
{
"name": "FirePath",
"version": "0.9.7",
"isActive": true,
"id": "FireXPath@pierre.tholence.com"
},
{
"name": "FromWhereToWhere",
"version": "0.25.2",
"isActive": true,
"id": "FromWhereToWhere@addons.mozilla.org"
},
{
"name": "IE Tab 2 (FF 3.6+)",
"version": "4.12.22.2",
"isActive": true,
"id": "{1BC9BA34-1EED-42ca-A505-6D2F1A935BBB}"
},
{
"name": "Live HTTP headers",
"version": "0.17",
"isActive": true,
"id": "{8f8fe09b-0bd3-4470-bc1b-8cad42b8203a}"
},
{
"name": "Selenium IDE",
"version": "1.10.0",
"isActive": true,
"id": "{a6fd85ed-e919-4a43-a5af-8da18bda539f}"
},
{
"name": "Selenium IDE: C# Formatters",
"version": "1.10.0",
"isActive": true,
"id": "csharpformatters@seleniumhq.org"
},
{
"name": "Selenium IDE: Java Formatters",
"version": "1.10.0",
"isActive": true,
"id": "javaformatters@seleniumhq.org"
},
{
"name": "Selenium IDE: Python Formatters",
"version": "1.10.0",
"isActive": true,
"id": "pythonformatters@seleniumhq.org"
},
{
"name": "Selenium IDE: Ruby Formatters",
"version": "1.10.0",
"isActive": true,
"id": "rubyformatters@seleniumhq.org"
},
{
"name": "Troubleshooter",
"version": "1.0a",
"isActive": true,
"id": "troubleshooter@mozilla.org"
},
{
"name": "User Agent Switcher",
"version": "0.7.3",
"isActive": true,
"id": "{e968fc70-8f95-4ab9-9e79-304de2a71ee1}"
},
{
"name": "VKontakte.ru Downloader",
"version": "0.3.5.1pre",
"isActive": true,
"id": "vk@sergeykolosov.mp"
},
{
"name": "wmlbrowser",
"version": "0.7.26",
"isActive": true,
"id": "{c4dc572a-3295-40eb-b30f-b54aa4cdc4b7}"
},
{
"name": "2YourFace",
"version": "1",
"isActive": false,
"id": "support@2yourface.com"
},
{
"name": "Ask Toolbar",
"version": "3.15.9.30496",
"isActive": false,
"id": "toolbar@ask.com"
},
{
"name": "Java Console",
"version": "6.0.29",
"isActive": false,
"id": "{CAFEEFAC-0016-0000-0029-ABCDEFFEDCBA}"
},
{
"name": "Skype Click to Call",
"version": "6.6.0.11664",
"isActive": false,
"id": "{82AF8DCA-6DE9-405D-BD5E-43525BDAD38A}"
},
{
"name": "Unified Functional Testing Extension",
"version": "11.50",
"isActive": false,
"id": "{9F17B1A2-7317-49ef-BCB7-7BB47BDE10F8}"
}
]
}

cor-el
  • Top 10 Contributor
  • Moderator
14851 solutions 134606 answers

Chosen Solution

See these threads:

See these threads: *[[/questions/931864]] Can I access all dates that a website has been visited? *[[/questions/945090]] How can i prevent Firefox from overiding identical history entries?

Question owner

Thank you for help. Running this query in SQLite Manager definitely works:)

Copying your answer for question 931864 to make it visible from this one.

Solution from cor-el: Firefox only shows the last time that you've visited an URL and a visit count.

You will have to use the SQLite Manager extension to see all visit dates.

You can use this query and change url LIKE '%google.com%' to the URL that you want to check. A percent symbol ("%") in the LIKE pattern matches any sequence of zero or more characters in the string.

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

   Click Run SQL to generate a results list
   Click the Action button to Save the results to a CSV file
Thank you for help. Running this query in SQLite Manager definitely works:) Copying your answer for question 931864 to make it visible from this one. Solution from cor-el: Firefox only shows the last time that you've visited an URL and a visit count. You will have to use the SQLite Manager extension to see all visit dates. You can use this query and change url LIKE '%google.com%' to the URL that you want to check. A percent symbol ("%") in the LIKE pattern matches any sequence of zero or more characters in the string. 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') AS visit_date, url, title FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id AND url LIKE '%google.com%' Click Run SQL to generate a results list Click the Action button to Save the results to a CSV file