Upgrade StorageStart Zotero get Errors during statement execution,ID: D1993564521
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
AND libraryID = ?
AND itemTypeID = ?
AND fieldID IN (?, ?, ?, ?)
AND SUBSTR(value, 1, 4) >= '?'
AND SUBSTR(value, 1, 4) <= '?'
AND itemID IN (?, ?, ?);] [PARAMS: 1, 40, 48, 91, 109, 6, 2024, 2026, 5303, 50, 5297] [ERROR: column index out of range]
FROM itemDataValues
JOIN itemData USING (valueID)
JOIN items USING (itemID)
LEFT JOIN deletedItems USING (itemID)
WHERE deletedItems.itemID IS NULL
AND libraryID = ?
AND itemTypeID = ?
AND fieldID IN (?, ?, ?, ?)
AND SUBSTR(value, 1, 4) >= '?'
AND SUBSTR(value, 1, 4) <= '?'
AND itemID IN (?, ?, ?);] [PARAMS: 1, 40, 48, 91, 109, 6, 2024, 2026, 5303, 50, 5297] [ERROR: column index out of range]
If that fixes it, you'll need to identify the plugin that's causing it and then report the problem to the plugin's developer.
If not, check your database integrity from the Advanced → Files and Folders pane of the Zotero settings and see if it still happens. If so, provide a Debug ID for Zotero startup through reproducing this, using the "Restart with Logging Enabled…" option.