Error returned on DB repair

jhopkins
I tried to repair my DB as it has been throwing synching errors, although overall it seems to be functioning okay. The DB is too large for the online repair (zipped +300 Mb), so I followed the Terminal instructions and got errors in two lines:

@cgs-monsoon Zotero % sqlite3 zotero.sqlite .recover > dump.sql
jhop@cgs-monsoon Zotero % mv zotero.sqlite zotero.sqlite.old
jhop@cgs-monsoon Zotero % sqlite3 zotero.sqlite < dump.sql

Error: near line 44557: stepping, UNIQUE constraint failed: itemDataValues.value (19)
Error: near line 44558: stepping, UNIQUE constraint failed: itemDataValues.value (19)

jhop@cgs-monsoon Zotero %

Any help on this -- could I use a code editor (like BBEdit?) to fix the error??

Thanks!
John
Sign In or Register to comment.