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

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.