Errors were found in the Zotero database! (false warning again?)

land
Hello.

After using the "Check Database Integrity" of zotero, the message showed up:
"Errors were found in the Zotero database!"

Then I opened zotero.sqlite with the sqlite3 command line client:

sqlite> PRAGMA integrity_check;

it said "ok".

Is it a false warning that Zotero gave me? I remember the same situation back to 2007.

OS:Ubuntu10.04
Firefox 9.0.1 installed from PPA

Thanks for the reply.
  • dstillman
    The integrity check in the preferences now checks for more things than actual database corruption, since the repair tool also corrects problems due to bugs in earlier versions, etc.

    (If you get that message immediately after running the database through the repair tool, we'd want to know.)
  • land
    Then probably there are other things wrong than database.
    Because I don't use the repair tool online, I only follow the manual repair instructions. I don't like to upload my database, why don't we include the repair tool in Zotero extension or standlone version?

    Anyway, thanks.
  • dstillman
    The manual instructions include all the commands needed to fix the database.
  • dstillman
    edited January 24, 2012
    why don't we include the repair tool in Zotero extension or standlone version?
    Not really possible (or very complicated, at least) technically.

    Most users should never need to use the repair tool/steps. Frequent use is an indication of a more serious problem with the disk or system.

    Most of the non-corruption-related cleanup commands are run automatically in database upgrade steps or at other times if necessary (and most of the things those commands fix cause problems only in rare situations).
  • land
    Ok, then. I think I can calm down and continue using my Zotero now?
  • dstillman
    Unless you're experiencing problems you don't really need to worry about it, but if you have an SQLite client handy you might as well run the block of commands on the manual instructions page. (Don't worry about the rebuilding steps if your database already passes "PRAGMA integrity_check".) The check in the prefs should no longer give you an error after you run those commands.

This is an old discussion that has not been active in a long time. Before commenting here, you should strongly consider starting a new discussion instead. If you think the content of this discussion is still relevant, you can link to it from your new discussion.

Sign In or Register to comment.