X
Tap here to go to the mobile version of the site.

Support Forum

Bookmarks not backing up will not export or sync

Posted

My Firefox bookmarks have not automatically backed up in more than 6 months. I can go through the steps to export or backup my bookmarks, but no file is ever created. I have tried this multiple times over the last few months, always using the latest version of Firefox (currently 67.0 64 Bit) and OS (Mac OS 10.14.5).

My Firefox bookmarks have not automatically backed up in more than 6 months. I can go through the steps to export or backup my bookmarks, but no file is ever created. I have tried this multiple times over the last few months, always using the latest version of Firefox (currently 67.0 64 Bit) and OS (Mac OS 10.14.5).

Chosen solution

Well, the good news may be that the file that is messed up is the one that stores bookmark icons, and not the rest of the data. You can remove that icons file and let Firefox start rebuilding it as you browse. I realize that isn't ideal, but I think it's worth a try. Here's how:

Open your current Firefox settings (AKA Firefox profile) folder using either

  • "3-bar" menu button > "?" Help > Troubleshooting Information
  • (menu bar) Help > Troubleshooting Information
  • type or paste about:support in the address bar and press Return

In the first table on the page, on the Profile Folder row, click the "Show in Finder" button. If Finder highlights an icon with a semi-random name like a1b2c3d4.default, double-click it to display the contents of that profile folder.

Leaving that window open, switch back to Firefox and Exit, either:

  • "3-bar" menu button > Quit
  • (menu bar) Firefox > Quit

Pause while Firefox finishes its cleanup, then rename favicons.sqlite to something like faviconsOLD.sqlite. If you see temporary files that Firefox didn't reconcile into the main database named favicons.sqlite-shm and/or favicons.sqlite-wal, you can remove those.

Start Firefox back up again. Can you backup/export now?

Read this answer in context 1
Quote

Additional System Details

Installed Plug-ins

  • Shockwave Flash 32.0 r0

Application

  • User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:67.0) Gecko/20100101 Firefox/67.0

More Information

jscher2000
  • Top 10 Contributor
8687 solutions 71011 answers

Helpful Reply

Hmm, that makes me nervous.

Could you check for error messages in the "Browser Console" that might be related to this problem.

You can open the separate Browser Console window using either:

  • "3-bar" menu button > Web Developer > Browser Console
  • (menu bar) Tools > Web Developer > Browser Console
  • (Mac) Command+Shift+j

Click the trash can icon at the upper left to clear the window, then switch back over to your Library window and try the Backup or Export again.

Then switch back over to the console window. Did Firefox log any errors related to that action?

More info on the Browser Console: https://developer.mozilla.org/docs/Tools/Browser_Console

Hmm, that makes me nervous. Could you check for error messages in the "Browser Console" that might be related to this problem. You can open the separate Browser Console window using either: * "3-bar" menu button > Web Developer > Browser Console * (menu bar) Tools > Web Developer > Browser Console * (Mac) Command+Shift+j Click the trash can icon at the upper left to clear the window, then switch back over to your Library window and try the Backup or Export again. Then switch back over to the console window. Did Firefox log any errors related to that action? More info on the Browser Console: https://developer.mozilla.org/docs/Tools/Browser_Console
Was this helpful to you? 1
Quote

Question owner

Thanks very much for that. I did get the following error;

Error(s) encountered during statement execution: database disk image is malformed Sqlite.jsm:815

Any further suggestions?

Thanks very much for that. I did get the following error; Error(s) encountered during statement execution: database disk image is malformed Sqlite.jsm:815 Any further suggestions?
Was this helpful to you?
Quote
jscher2000
  • Top 10 Contributor
8687 solutions 71011 answers

Helpful Reply

Unfortunately, malformed is not what we want to hear!

First, could you make a backup of the places.sqlite database file before we try anything else? Either of these articles will get you into your currently active Firefox profile folder so you can find that file:

Second, try the "Verify Integrity" function to see whether that can repair the database. That's here:

Open Firefox's Troubleshooting Information page using any of these methods:

  • "3-bar" menu button > "?" Help > Troubleshooting Information
  • (menu bar) Help > Troubleshooting Information
  • type or paste about:support in the address bar and press Return

Near the bottom, there is a section titled Places Database -- that's the file which stores history and bookmarks. Click the button labeled Verify Integrity. There may be a 10-15 second delay before results appear.

If all is well, the report that appears below the button should start with:

> Task: checkIntegrity
+ The places.sqlite database is sane
+ The favicons.sqlite database is sane

Then there would be various tasks completing successfully (or failing). What does yours say? You can select and copy the report, and then paste it into a reply for review and comment.

And meanwhile, try the Backup/Export again to see whether there was any improvement.

Unfortunately, malformed is not what we want to hear! First, could you make a backup of the '''places.sqlite''' database file before we try anything else? Either of these articles will get you into your currently active Firefox profile folder so you can find that file: * [[Profiles - Where Firefox stores your bookmarks, passwords and other user data]] * [[Back up and restore information in Firefox profiles]] Second, try the "Verify Integrity" function to see whether that can repair the database. That's here: Open Firefox's Troubleshooting Information page using any of these methods: * "3-bar" menu button > "?" Help > Troubleshooting Information * (menu bar) Help > Troubleshooting Information * type or paste '''about:support''' in the address bar and press Return Near the bottom, there is a section titled '''Places Database''' -- that's the file which stores history and bookmarks. Click the button labeled '''Verify Integrity'''. There may be a 10-15 second delay before results appear. If all is well, the report that appears below the button should start with: > Task: checkIntegrity + The places.sqlite database is sane + The favicons.sqlite database is sane Then there would be various tasks completing successfully (or failing). What does yours say? You can select and copy the report, and then paste it into a reply for review and comment. And meanwhile, try the Backup/Export again to see whether there was any improvement.
Was this helpful to you? 1
Quote
jscher2000
  • Top 10 Contributor
8687 solutions 71011 answers

To clarify, when I said to make a backup of the places.sqlite file, I simply meant to make a copy somewhere else that Firefox won't mess with, such as your desktop.

To clarify, when I said to make a backup of the '''places.sqlite''' file, I simply meant to make a copy somewhere else that Firefox won't mess with, such as your desktop.
Was this helpful to you? 1
Quote

Question owner

Here's what the Verify Integrity task reported (doesn't look good to this novice);

> Task: checkIntegrity - Unable to check favicons.sqlite integrity: Error: Error(s) encountered during statement execution: > Task: invalidateCaches - The task queue was cleared by an error in another task. > Task: checkCoherence - The task queue was cleared by an error in another task. > Task: expire - The task queue was cleared by an error in another task. > Task: originFrecencyStats - The task queue was cleared by an error in another task. > Task: vacuum - The task queue was cleared by an error in another task. > Task: stats - The task queue was cleared by an error in another task. > Task: _refreshUI - The task queue was cleared by an error in another task.

Backup/Export unchanged, which given the above report is probably as expected.

Here's what the Verify Integrity task reported (doesn't look good to this novice); > Task: checkIntegrity - Unable to check favicons.sqlite integrity: Error: Error(s) encountered during statement execution: > Task: invalidateCaches - The task queue was cleared by an error in another task. > Task: checkCoherence - The task queue was cleared by an error in another task. > Task: expire - The task queue was cleared by an error in another task. > Task: originFrecencyStats - The task queue was cleared by an error in another task. > Task: vacuum - The task queue was cleared by an error in another task. > Task: stats - The task queue was cleared by an error in another task. > Task: _refreshUI - The task queue was cleared by an error in another task. Backup/Export unchanged, which given the above report is probably as expected.
Was this helpful to you?
Quote
jscher2000
  • Top 10 Contributor
8687 solutions 71011 answers

Chosen Solution

Well, the good news may be that the file that is messed up is the one that stores bookmark icons, and not the rest of the data. You can remove that icons file and let Firefox start rebuilding it as you browse. I realize that isn't ideal, but I think it's worth a try. Here's how:

Open your current Firefox settings (AKA Firefox profile) folder using either

  • "3-bar" menu button > "?" Help > Troubleshooting Information
  • (menu bar) Help > Troubleshooting Information
  • type or paste about:support in the address bar and press Return

In the first table on the page, on the Profile Folder row, click the "Show in Finder" button. If Finder highlights an icon with a semi-random name like a1b2c3d4.default, double-click it to display the contents of that profile folder.

Leaving that window open, switch back to Firefox and Exit, either:

  • "3-bar" menu button > Quit
  • (menu bar) Firefox > Quit

Pause while Firefox finishes its cleanup, then rename favicons.sqlite to something like faviconsOLD.sqlite. If you see temporary files that Firefox didn't reconcile into the main database named favicons.sqlite-shm and/or favicons.sqlite-wal, you can remove those.

Start Firefox back up again. Can you backup/export now?

Well, the good news may be that the file that is messed up is the one that stores bookmark icons, and not the rest of the data. You can remove that icons file and let Firefox start rebuilding it as you browse. I realize that isn't ideal, but I think it's worth a try. Here's how: Open your current Firefox settings (AKA Firefox profile) folder using either * "3-bar" menu button > "?" Help > Troubleshooting Information * (menu bar) Help > Troubleshooting Information * type or paste '''about:support''' in the address bar and press Return In the first table on the page, on the Profile Folder row, click the "Show in Finder" button. If Finder highlights an icon with a semi-random name like a1b2c3d4.default, double-click it to display the contents of that profile folder. Leaving that window open, switch back to Firefox and Exit, either: * "3-bar" menu button > Quit * (menu bar) Firefox > Quit Pause while Firefox finishes its cleanup, then rename '''favicons.sqlite''' to something like '''faviconsOLD.sqlite'''. If you see temporary files that Firefox didn't reconcile into the main database named '''favicons.sqlite-shm''' and/or '''favicons.sqlite-wal''', you can remove those. Start Firefox back up again. Can you backup/export now?
Was this helpful to you? 1
Quote

Question owner

Thank you so much! If you ever find yourself in Australia let me buy you a drink. Everything working fine again.

Cheers

Thank you so much! If you ever find yourself in Australia let me buy you a drink. Everything working fine again. Cheers
Was this helpful to you?
Quote
jscher2000
  • Top 10 Contributor
8687 solutions 71011 answers

Thank you for the report back, and Cheers!

Thank you for the report back, and Cheers!
Was this helpful to you?
Quote
Ask a question

You must log in to your account to reply to posts. Please start a new question, if you do not have an account yet.