Zotero Standalone Corrupted Program

smweyers
Hello,

I received the following error message: "The Zotero database 'zotero.sqlite' appears to have become corrupted. Your data was restored from the last automatic backup made on 1/12/2016 at 1:58:53 PM. The damaged file was saved in your Zotero directory."

I clicked 'OK' and received the next error message: "The Zotero database 'zotero' appears to have become corrupted. Please restart Zotero to attempt an automatic restore from the last backup."

I clicked "restart now" but nothing happens. Any help to troubleshoot this problem is greatly appreciated. Thank you!
  • adamsmith
    First, I'd try to figure out why this is happening. Anything unusual about your setup? Is the Zotero database in a custom location such as a network folder or a dropbox-type syncing folder?

    If so, revert it back to it's default location.

    Then, to fix the issue at hand, I'd try to run one of the .sqlite.damaged files that you'll almost certainly find in your zotero data directory: https://www.zotero.org/support/zotero_data through the database repair tool and see if that helps:
    https://www.zotero.org/utils/dbfix/
  • MrDCFP
    Hi,

    I'm running the Zotero standalone on Mac (10.11) and am having the exact same problem. I checked the database integrity, and it passed. Then I ran the Zotero Database Repair Tool and replaced the zotero.sqlite with the repaired file, but get the same error message. I also tried repairing it manually through Terminal with no success.

    The only thing unusual about my setup is I'm running Better BibTex.
  • MrDCFP
    Solved the problem. It turned out that it was my Better BibTex database that had been corrupted when I had to force-quit out of Zotero:

    https://github.com/retorquere/zotero-better-bibtex/issues/488
  • emilianoeheyns
    I won't deny that this was a nasty error, but for completeness, BBT didn't actually corrupt the Zotero DB. BBT did attach a DB on the Zotero.DB connection, and the attached DB got corrupted, but there was no way Zotero could tell that this was the case.

    I don't know how the SQLite DB got corrupted, but BBT no longer attaches a DB. Instead, it opens its own connection, to prevent this from happening again.
  • MrDCFP
    And, for the sake of completeness, Emiliano took care of my problem in about two seconds, and now everything is working great. Thank you!
Sign In or Register to comment.