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

Why can SQLite Manager see my history but Firefox 4.0.1 cannot?

more options

Just upgraded to FireFox 4.0.1 from I forget which 3.. and have all the bookmarks (or so it seems) but the places.sqlite file (which says it was made back in 2006!) is not being consulted for the history, just the bookmarks. History shows today's work but no prior days.

All Replies (4)

more options

If the file is that old then it is possible that the database structure is not compatible with the currently used structure or that the index is corrupted and in that case it is better to trash the file and let Firefox create a new places.sqlite.

more options

Thanks but the rest of the file's content is working and I really use history, a lot! Things that did not seem on point at the time jump out later and I need to dig back... Any body know of a fixing/importing exporting utility or some guidance on how to work SQLite to do that job?

more options

See:


  1. Open places.sqlite
  2. Hit the Execute SQL tab
  3. Use a Select like this:
SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url, moz_places.title
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id
  1. Click the Action button to Save the results to a CSV file

You can also select some records and use the right-click context menu to copy the selected records as CSV to the clipboard.

You can also create a Temporary view:

  1. View > Create View : [X ]Temporary Name: Enter a Name for the view
  2. Use the same Select as above
  3. View > Export View : Database > Temp

Modified by cor-el

more options

ohhhhh me like! I'll give it a go. thanks! (and I'll come back and add to those impressive solved stats!)

Modified by paulbostwick