188BET靠谱吗Error Message during Manual Zotero Database Repair

hartmutboesch

Hi,

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

188BET靠谱吗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.188BET靠谱吗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.

188BET靠谱吗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

188BET靠谱吗I mean, if you follow the instructions to rename zotero.sqlite and then run 188BET靠谱吗sqlite3 zotero.sqlite < dump.sql188BET靠谱吗, 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;.

188BET靠谱吗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.