sync error

rewa · October 21, 2017

hello: i've got a problem with syncing. message: zotero is not synching: Error(s) encountered during statement execution: database disk image is malformed [QUERY: DELETE FROM fulltextWords WHERE wordID NOT IN (SELECT wordID FROM fulltextItemWords)] [PARAMS: ] [ERROR: database disk image is malformed]

report 1804833325

dstillman · October 21, 2017

Your database is corrupted. You can try the DB Repair Tool.

rewa · October 21, 2017

ok, will try that

rewa · October 21, 2017

ok, that seems to have worked, thank you

andselisk · October 22, 2017

@dstillman
Out of curiosity, my `zotero.sqlite` is approx. 1.5 GB in size, whereas Zotero DB Repair Tool accepts files of max. 100 MB in size. If user with larger database receives similar error, how to handle it properly?

bwiernik · October 22, 2017

At the bottom of the page is a link to manual repair instructions. These are the commands the the tool runs. You can run them yourself on a larger library.

andselisk · October 22, 2017

@bwiernik
Thank you!