X
Tippen Sie hierhin, um die Version dieser Website für Mobilgeräte aufzurufen.

Hilfeforum

Restoring history items in places.sqlite

Veröffentlicht

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
Zitieren
cor-el
  • Top 10 Contributor
  • Moderator
17862 Lösungen 161642 Antworten
Veröffentlicht

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
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 <b>LIKE '0'</b> with bookmarkbackups to get a list of visited pages. I used <b>AND url LIKE 'https://support.mozilla.org%'</b> to limit the list only for this forum. <pre><nowiki>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</nowiki></pre>

Geändert am von cor-el

Hat Ihnen das weitergeholfen?
Zitieren

Fragesteller

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...

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...
Hat Ihnen das weitergeholfen?
Zitieren
Stellen Sie eine Frage

Sie müssen sich mit Ihrem Benutzerkonto anmelden, um auf Beiträge zu antworten. Bitte stellen Sie eine neue Frage, wenn Sie noch kein Benutzerkonto haben.