Upgrade Storage报告ID:597745408
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: 4, 21, 47, 85, 103, 6, 2018, 2020, 1963, 1998, 2000, 2001, 2046, 2054] [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: 4, 21, 47, 85, 103, 6, 2018, 2020, 1963, 1998, 2000, 2001, 2046, 2054] [ERROR: column index out of range]
-
poettliAssuming you are on Zotero 7, do you see this in Troubleshooting Mode (Help → "Restart in Troubleshooting Mode…”)?