Where did you install Firefox from? Help Mozilla uncover 3rd party websites that offer problematic Firefox installation by taking part in our campaign. There will be swag, and you'll be featured in our blog if you manage to report at least 10 valid reports!

Avatar for Username

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

This thread was archived. Please ask a new question if you need help.

Restoring history items in places.sqlite

Factotum Industries
Factotum Industries
more options

I use Piriform CCleaner.

The most recent update ignored the settings to exclude Firefox and cleared my History.

I do have a backup but it isn't recent as I'd like.

I did have a look at the places.sqlite file with an editor - interestingly all the history is still there. So how is it "enabled / disabled" as far as Firefox is concerned?

I did a fair amount of Googling but can't see an explanation.

Your input would be appreciated! Adb

I use Piriform CCleaner. The most recent update ignored the settings to exclude Firefox and cleared my History. I do have a backup but it isn't recent as I'd like. I did have a look at the places.sqlite file with an editor - interestingly all the history is still there. So how is it "enabled / disabled" as far as Firefox is concerned? I did a fair amount of Googling but can't see an explanation. Your input would be appreciated! Adb

All Replies (2)

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

Maybe check the places.sqlite in a SQLite manager to see whether you still have at least the URLs in the moz_places table. It is possible that only the moz_historyvisits table got cleared, but that moz_places still has the url and title with a visit count of 0 (zero) and no last_visit_date. So you could possibly get a list of URLs, but no way to get real visit_date although the place 'id' might give some indication.

I'm not very good with SQL, so i tried something simple: Replace LIKE '0' with bookmarkbackups to get a list of visited pages. I used AND url LIKE 'https://support.mozilla.org%' to limit the list only for this forum. 

SELECT  url, title, id, visit_count, datetime(last_visit_date/1000000,'unixepoch','localtime')
FROM moz_places WHERE visit_count LIKE '0' AND url LIKE 'https://support.mozilla.org%'
ORDER BY url

Modified by cor-el

Factotum Industries
Factotum Industries Question owner
more options

Sorry I should have been more specific :

The moz_places table still has the URLs.

Will see if I can execute what you have suggested...