Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

Αναζήτηση στην υποστήριξη

Προσοχή στις απάτες! Δεν θα σας ζητήσουμε ποτέ να καλέσετε ή να στείλετε μήνυμα σε κάποιον αριθμό τηλεφώνου ή να μοιραστείτε προσωπικά δεδομένα. Αναφέρετε τυχόν ύποπτη δραστηριότητα μέσω της επιλογής «Αναφορά κατάχρησης».

Μάθετε περισσότερα

After trying to clear recent history places.sqlite corrupted

  • 3 απαντήσεις
  • 2 έχουν αυτό το πρόβλημα
  • 1 προβολή
  • Τελευταία απάντηση από Mewchu11

more options

Last night I cleared the last hour of my browsing history (all settings ticked). The clear finished instantly, which I found odd as there's usually a delay.

There were no immediate symptoms until after I turned on my computer today, all history/cookies/etc were gone.

I found a places.sqlite.corrupt with a filesize of 20,480 kB and a replacement places.sqlite with a filesize of 10,240 kB in my sole profile folder.

Because the corrupted file is exactly twice the size of the uncorrupted file I imagine that what happened is that some point early on in the clear recent history operation the contents were duplicated but for some reason the process didn't finish. I'm hoping that everything is still there but I cannot use the places.sqlite.corrupt to check.

I do not have any backups or sync to work with, and renaming the .corrupt file to places.sqlite (after deleting the replacement) does not work.

Any help would be greatly appreciated, I am willing and able to get down and dirty with sqlite repair, so do not shy away from overly technical solutions if you know any.

Last night I cleared the last hour of my browsing history (all settings ticked). The clear finished instantly, which I found odd as there's usually a delay. There were no immediate symptoms until after I turned on my computer today, all history/cookies/etc were gone. I found a places.sqlite.corrupt with a filesize of 20,480 kB and a replacement places.sqlite with a filesize of 10,240 kB in my sole profile folder. Because the corrupted file is exactly twice the size of the uncorrupted file I imagine that what happened is that some point early on in the clear recent history operation the contents were duplicated but for some reason the process didn't finish. I'm hoping that everything is still there but I cannot use the places.sqlite.corrupt to check. I do not have any backups or sync to work with, and renaming the .corrupt file to places.sqlite (after deleting the replacement) does not work. Any help would be greatly appreciated, I am willing and able to get down and dirty with sqlite repair, so do not shy away from overly technical solutions if you know any.

Όλες οι απαντήσεις (3)

more options

I've done a lot of work on the corrupted places.sqlite, but unfortunately it doesn't seem to have my history on it either.

Still if anyone has any ideas...

more options
more options

Attempted that already: It reported that the integrity_check was OK, which the guide says means the guide can't help you. Firefox just doesn't like the .sqlite for some reason.

Recompiling the .sqlite to .sql showed a file that had no ERROR statements. Strangely though I could not recompile the .sql back to .sqlite, it kept saying that the PRAGMA statements at the start of the file were invalid syntax.