Avatar for Username

ძიება მხარდაჭერაში

ნუ გაებმებით თაღლითების მახეში მხარდაჭერის საიტზე. აქ არასდროს მოგთხოვენ სატელეფონო ნომერზე დარეკვას, შეტყობინების გამოგზავნას ან პირადი მონაცემების გაზიარებას. გთხოვთ, გვაცნობოთ რამე საეჭვოს შემჩნევისას „დარღვევაზე მოხსენების“ მეშვეობით.

ვრცლად

ეს თემა დაარქივებულია. დასვით ახალი კითხვა, თუ დახმარება გესაჭიროებათ.

Restoring history items in places.sqlite

  • 2 პასუხი
  • 1 მომხმარებელი წააწყდა მსგავს სიძნელეს
  • 9 ნახვა
  • ბოლოს გამოეხმაურა Factotum Industries

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

ყველა პასუხი (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

ჩასწორების თარიღი: , ავტორი: cor-el

Factotum Industries
Factotum Industries კითხვის დამსმელი
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...