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

Kërkoni te Asistenca

Shmangni karremëzime gjoja asistence. S’do t’ju kërkojmë kurrë të bëni një thirrje apo të dërgoni tekst te një numër telefoni, apo të na jepni të dhëna personale. Ju lutemi, raportoni veprimtari të dyshimtë duke përdorur mundësinë “Raportoni Abuzim”.

Learn More

Kjo rrjedhë është arkivuar. Ju lutemi, bëni një pyetje të re, nëse keni nevojë për ndihmë.

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

Krejt Përgjigjet (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

Ndryshuar nga cor-el

Factotum Industries
Factotum Industries I zoti i pyetjes
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...