Upgrade Storageerror
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, 22, 48, 91, 109, 6, 2023, 2025, 1182, 1183, 1184, 1185, 1186, 1188, 1202, 1211, 1214, 1216, 1218, 1246, 1247, 1265, 1270, 1279, 1285, 1287, 1310, 1313, 1316, 1322, 1324, 1331, 1334] [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, 22, 48, 91, 109, 6, 2023, 2025, 1182, 1183, 1184, 1185, 1186, 1188, 1202, 1211, 1214, 1216, 1218, 1246, 1247, 1265, 1270, 1279, 1285, 1287, 1310, 1313, 1316, 1322, 1324, 1331, 1334] [ERROR: column index out of range]
-
poettlihttps://forums.zotero.org/discussion/comment/468986/#Comment_468986