Foreign key constraint error when trying to clear index

ngirard · July 22, 2019

Using Zotero 5.0.71, trying to clear the database index leads to the following error:

Error: Error(s) encountered during statement execution: FOREIGN KEY constraint failed [QUERY: DELETE FROM fulltextWords] [PARAMS: ] [ERROR: FOREIGN KEY constraint failed]

dstillman · July 22, 2019

Check your database integrity from the Advanced → Files and Folders pane of the preferences.

ngirard · July 22, 2019

Thanks for your feedback.

No integrity errors were reported.

Also, after restarting Zotero, the index is reported to be empty.