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
    edited June 5, 2024
    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.
Sign In or Register to comment.