Display the following "Error(s) encountered during statement execution: column index out of range"

tiantao_1998 · 2025-07-01T03:12:15+00:00

Error(s) encountered during statement execution: column index out of range [QUERY: SELECT DISTINCT itemID
FROM itemDataValues
JOIN itemData USING (valueID)
JOIN items USING (itemID)
LEFT JOIN deletedItems USING (itemID)
WHERE deletedItems.itemID IS NULL

dstillman · 2025-07-01T03:12:53+00:00

See Reporting Problems for the things we would need in order to help you.

tiantao_1998 · 2025-07-01T03:19:13+00:00

Report ID：118006697

dstillman · 2025-07-01T03:21:50+00:00

That's one of the two things we ask for. The other is to provide steps to reproduce:

https://www.zotero.org/support/reporting_problems#provide_steps_to_reproduce

But if you're getting this error when you sync, you should restart in Troubleshooting Mode (Help → "Restart in Troubleshooting Mode…”), which temporarily disables all plugins, and see if it still occurs. If it does, provide a Debug ID (different from a Report ID) for a sync the triggers it.