Error Message during Manual Zotero Database Repair

hartmutboesch

Hi,

I tried to manually repair Zotero database file following the instruction on the webpage. In the last step, i get the following error message:

Zotero % sqlite3 zotero.sqlite < dump.sql

Runtime error near line 1396100: UNIQUE constraint failed: translatorCache.fileName (19)
Runtime error near line 1396102: UNIQUE constraint failed: translatorCache.fileName (19)
Runtime error near line 1396105: UNIQUE constraint failed: translatorCache.fileName (19)

Any suggestions how i can fix this problem. Thank you.

dstillman

You can likely ignore that — that's just a cache table for translators. If it starts up with the repaired database, you can reset translators from the Advanced → Files and Folders section of the Zotero settings.

hartmutboesch

Thanks for your quick response.

When i start zotero again, it gives me the same error message as before (corrupted database). I suspect that no repaired databased file has been created.

dstillman

I mean, if you follow the instructions to rename zotero.sqlite and then run sqlite3 zotero.sqlite < dump.sql, you'll either end up with a zotero.sqlite file or not, and if a file is created it will be structurally valid (even if the data may still be wrong). You can test with PRAGMA integrity_check;.

If there's a zotero.sqlite.is.corrupt file in the folder, you can try deleting that before starting Zotero.

If it's still not working, see Reporting Startup Errors.

hartmutboesch

It is working again. Thanks for your help.