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.

• http://kb.mozillazine.org/Bookmarks_history_and_toolbar_buttons_not_working_-_Firefox

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?

See:

• /questions/692831

• SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/

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

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