X
Tryk her for at gå til webstedets mobilversion.
Scheduled maintenance: Thursday, April 2, between 3pm and 5pm UTC. This site will have limited functionality while we undergo maintenance to improve your experience. If an article doesn’t solve your issue and you want to ask a question, we have our support community waiting to help you at @firefox on Twitter

Supportforum

Restoring history items in places.sqlite

Skrevet

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
Citér

Yderligere systemdetaljer

Installerede plugins

AdBlock

Program

  • User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0

Yderligere information

Luk
cor-el
  • Top 10 Contributor
  • Moderator
17856 løsninger 161585 svar

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>

Ændret af cor-el den

Fandt du dette nyttigt?
Citér

Spørgsmålsstiller

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...
Fandt du dette nyttigt?
Citér
Stil et spørgsmål

Du skal logge ind på din konto for at svare på et indlæg. Start et nyt spørgsmål, hvis du ikke har en konto endnu.