Upgrade StorageZotero time out issue - Report ID: 2024509045
I made many changes to the Journal Abbreviation fields in my Groups libraries, as well as emptied all Trash folders and left some Group Library folders. Then I tried to sync Zotero on the desktop, but I keep getting this error message: "Transaction timeout, most likely caused by unresolved pending work."
_____________________
[JavaScript Error: "Transaction timeout, most likely caused by unresolved pending work." {file: "resource://gre/modules/Sqlite.sys.mjs" line: 1140}]
[JavaScript Error: "Transaction timeout, most likely caused by unresolved pending work." {file: "resource://gre/modules/Sqlite.sys.mjs" line: 1140}]
[JavaScript Error: "Error(s) encountered during statement execution: no such table: tmpSearchResults_L3OPi54v [QUERY: SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT COALESCE(IA.parentItemID, itemID) AS itemID FROM items LEFT JOIN itemAnnotations IA USING (itemID) WHERE (itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM deletedItems)))) AND (itemID IN (SELECT itemID FROM items WHERE libraryID=?))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_L3OPi54v) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_L3OPi54v)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_L3OPi54v)))] [PARAMS: 15] [ERROR: no such table: tmpSearchResults_L3OPi54v]" {file: "chrome://zotero/content/xpcom/db.js" line: 762}]
appName => Zotero, version => 7.0.24 (x64), os => Windows 11 26100, locale => en-US, extensions =>
_____________________
[JavaScript Error: "Transaction timeout, most likely caused by unresolved pending work." {file: "resource://gre/modules/Sqlite.sys.mjs" line: 1140}]
[JavaScript Error: "Transaction timeout, most likely caused by unresolved pending work." {file: "resource://gre/modules/Sqlite.sys.mjs" line: 1140}]
[JavaScript Error: "Error(s) encountered during statement execution: no such table: tmpSearchResults_L3OPi54v [QUERY: SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT COALESCE(IA.parentItemID, itemID) AS itemID FROM items LEFT JOIN itemAnnotations IA USING (itemID) WHERE (itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM deletedItems)))) AND (itemID IN (SELECT itemID FROM items WHERE libraryID=?))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_L3OPi54v) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_L3OPi54v)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_L3OPi54v)))] [PARAMS: 15] [ERROR: no such table: tmpSearchResults_L3OPi54v]" {file: "chrome://zotero/content/xpcom/db.js" line: 762}]
appName => Zotero, version => 7.0.24 (x64), os => Windows 11 26100, locale => en-US, extensions =>