Are you using the latest Zotero and the latest plugin?
[X] I have confirmed I'm using the latest Zotero and the latest plugin
Environment
OS: Macos
Zotero Version: 7.0.2-beta.3+182bfb9a3
Plugin Version: 2.0.0
Describe the bug
能正常翻译
Debug Output
1724235782868 addons.xpi WARN Checking /Applications/Zotero 2.app/Contents/Resources/distribution/extensions for addons
1724235783174 addons.webextension.pdfpreview@windingwind.com WARN Loading extension 'pdfpreview@windingwind.com': Reading manifest: Warning processing version: version must be a version string consisting of at most 4 integers of at most 9 digits without leading zeros, and separated with dots
1724235783563 addons.xpi WARN Addon with ID undefined already installed, older version will be disabled
[JavaScript Error: "Error: Addon must include an id, version, and type" {file: "resource://gre/modules/addons/XPIProvider.jsm" line: 1723}]
[JavaScript Error: "Error: Addon must include an id, version, and type" {file: "resource://gre/modules/addons/XPIProvider.jsm" line: 1723}]
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
[JavaScript Error: "Translator f895aa0d-f28e-47fe-b247-2ea77c6ed583 not found"]
[JavaScript Error: "Translator f895aa0d-f28e-47fe-b247-2ea77c6ed583 not found"]
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
No chrome package registered for chrome://betternotes/content/icons/favicon.png
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
[JavaScript Error: "Error running bootstrap method 'shutdown' on pdfpreview@windingwind.com"]
[JavaScript Error: "ztoolkit.getGlobal(...).querySelector(...) is null" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/pdfpreview@windingwind.com.xpi!/chrome/content/scripts/pdfpreview.js" line: 1996}]
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
appName => Zotero, version => 7.0.2-beta.3+182bfb9a3 (ARM64), os => macOS 14.5, locale => zh-CN, extensions => Translate for Zotero (2.0.0, extension), ZotFile (5.1.2, extension, disabled), Mdnotes for Zotero (0.2.3, extension, disabled), Zotero IF (1.5.0, extension, disabled), Zotero PDF Preview (1.0.0-4, extension, disabled), Zotero Attanger (1.2.4, extension, disabled), Obsidian Note for Zotero (1.0.1, extension, disabled), MarkDB-Connect (0.1.1, extension, disabled), Zoplicate (3.0.3, extension, disabled), Zotero Reading List (1.5.0, extension, disabled), Better Notes for Zotero (2.0.0, extension, disabled), Actions and Tags for Zotero (2.0.0, extension, disabled), Zotero 插件市场 (1.6.15, extension, disabled), Chartero (2.9.4, extension, disabled), Better BibTex for Zotero (6.7.222, extension, disabled), Awesome GPT (1.1.8, extension, disabled), Ethereal Reference (0.9.6, extension, disabled), Ethereal Style (4.7.9, extension, disabled)
(3)(+0026193): Writing reader state to /Users/chenyilong/Zotero/storage/VMR38MKR/.zotero-reader-state
(3)(+0000935): [Ethereal Reference] null
(3)(+0000053): [Ethereal Reference] null
(3)(+0000054): [Ethereal Reference] null
(3)(+0000050): [Ethereal Reference] null
(3)(+0000052): [Ethereal Reference] null
(3)(+0000051): [Ethereal Reference] null
(3)(+0000054): [Ethereal Reference] null
(3)(+0000051): [Ethereal Reference] null
(3)(+0000050): [Ethereal Reference] null
(3)(+0000053): [Ethereal Reference] null
(3)(+0000055): [Ethereal Reference] null
(3)(+0000051): [Ethereal Reference] null
(3)(+0000052): [Ethereal Reference] null
(3)(+0000054): [Ethereal Reference] null
(3)(+0000055): [Ethereal Reference] null
(3)(+0000052): [Ethereal Reference] null
(3)(+0000053): [Ethereal Reference] null
(3)(+0000052): [Ethereal Reference] null
(3)(+0000241): [Translate for Zotero] runTranslationTask {}
(3)(+0000001): [Translate for Zotero] try itemLanguage en
(3)(+0000000): [Translate for Zotero] use autoDetect en
(3)(+0000002): [Translate for Zotero] try auto detect language
(3)(+0000000): [Translate for Zotero] try itemLanguage en
(3)(+0000000): [Translate for Zotero] use autoDetect en
(3)(+0000001): [Translate for Zotero] {"id":"nFZWvfrx-1724236038386","type":"text","raw":"Comparison of (Q)PiSSA and (Q)LoRA across models from 7B to 70B","result":"","audio":[],"service":"googleapi","candidateServices":[],"itemId":7958,"status":"processing","extraTasks":[],"langfrom":"en","langto":"zh-CN","callerID":"zoteropdftranslate@euclpts.com","secret":""}
(3)(+0000001): [Translate for Zotero] try itemLanguage en
(3)(+0000000): [Translate for Zotero] use autoDetect en
(3)(+0000751): Creating notifier queue ee2Nz8TJ
(4)(+0000001): SELECT O.itemID, O.dateAdded, O.dateModified, O.version, O.synced, createdByUserID, lastModifiedByUserID, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1))) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 等' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, (CASE O.itemTypeID WHEN 3 THEN IAP.itemID WHEN 27 THEN INoP.itemID WHEN 1 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 3 THEN IAP.key WHEN 27 THEN INoP.key WHEN 1 THEN IAnP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID)LEFT JOIN groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.key=? AND O.libraryID=? ['AWN4TW2J', 1]
(4)(+0000047): Tags haven't changed
(4)(+0000000): Saving data for new item to database
(3)(+0000001): Notifier.trigger('add', 'item', [8020], {"instanceID":"4vykHNev","skipSelect":true}) added to queue ee2Nz8TJ
(3)(+0000000): Notifier.trigger('modify', 'item', [7958], {}) added to queue ee2Nz8TJ
(4)(+0000000): REPLACE INTO itemAnnotations (itemID, parentItemID, type, authorName, text, comment, color, pageLabel, sortIndex, position, isExternal) VALUES (?, ?, ?, NULL, ?, NULL, ?, ?, ?, ?, ?) [8020, 7958, 1, 'Comparison of (Q)PiSSA and (Q)LoRA across models from 7B to 70B', '#ffd400', '8', '00007|001260|00556', '{"pageIndex":7,"rects":[[182.19,226.98,466.662,235.618]]}', 0]
(3)(+0000001): Loading primaryData for 1 item in 我的文库
(4)(+0000000): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, createdByUserID, lastModifiedByUserID, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1))) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 等' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, PI.itemID IS NOT NULL AS inPublications, (CASE O.itemTypeID WHEN 3 THEN IAP.itemID WHEN 27 THEN INoP.itemID WHEN 1 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 3 THEN IAP.key WHEN 27 THEN INoP.key WHEN 1 THEN IAnP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID)LEFT JOIN groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? AND O.itemID IN (7958) [1]
(3)(+0000001): Loaded primaryData in 我的文库 in 1 ms
(3)(+0000000): Loading childItems for 1 item in 我的文库
(4)(+0000000): SELECT parentItemID, A.itemID, value AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAttachments A JOIN items I ON (A.parentItemID=I.itemID) LEFT JOIN itemData ID ON (fieldID=1 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (7958) ORDER BY parentItemID [1]
(4)(+0000001): SELECT parentItemID, N.itemID, title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemNotes N JOIN items I ON (N.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (7958) ORDER BY parentItemID [1]
(4)(+0000000): SELECT parentItemID, IAn.itemID, text || ' - ' || comment AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAnnotations IAn JOIN items I ON (IAn.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (7958) ORDER BY parentItemID, sortIndex [1]
(4)(+0000000): SELECT itemID FROM items I WHERE libraryID=? AND itemID IN (7958) [1]
(3)(+0000001): Loaded childItems in 我的文库 in 2 ms
(4)(+0000000): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, createdByUserID, lastModifiedByUserID, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1))) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 等' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, PI.itemID IS NOT NULL AS inPublications, (CASE O.itemTypeID WHEN 3 THEN IAP.itemID WHEN 27 THEN INoP.itemID WHEN 1 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 3 THEN IAP.key WHEN 27 THEN INoP.key WHEN 1 THEN IAnP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID)LEFT JOIN groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID=? [8020]
(3)(+0000001): Loading annotation for 1 item in 我的文库
(4)(+0000000): SELECT itemID, IA.parentItemID, IA.type, IA.authorName, IA.text, IA.comment, IA.color, IA.sortIndex, IA.isExternal FROM items JOIN itemAnnotations IA USING (itemID) WHERE libraryID=? AND itemID IN (8020) [1]
(3)(+0000000): Loaded annotation in 我的文库 in 0 ms
(3)(+0000000): Loading annotationDeferred for 1 item in 我的文库
(4)(+0000000): SELECT itemID, IA.position, IA.pageLabel FROM items JOIN itemAnnotations IA USING (itemID) WHERE libraryID=? AND itemID IN (8020) [1]
(3)(+0000000): Loaded annotationDeferred in 我的文库 in 0 ms
(3)(+0000000): Notifier.trigger('add', 'item', [8020], {"8020":{"instanceID":"4vykHNev","skipSelect":true}}) called [observers: 39]
(3)(+0000001): Yielding for refresh promise
(3)(+0000011): [Zoplicate] itemsView.onSelect []
(3)(+0000000): [Zoplicate] Element with id zoplicate-bulk-merge-button-inner not found
(3)(+0000000): [Zoplicate] Element with id zoplicate-bulk-merge-button-external not found
(3)(+0000000): [Zoplicate] Element with id non-duplicates-button-inner not found
(3)(+0000000): [Zoplicate] Element with id non-duplicates-button-external not found
(3)(+0000001): Cancelling auto-sync timer
(3)(+0000000): Setting auto-sync timeout to 3 seconds
(4)(+0000001): Unregistering notifier observer in notifier with id 'Z8'
(4)(+0000000): Unregistering notifier observer in notifier with id 'Rt'
(4)(+0000000): Unregistering notifier observer in notifier with id 'h4'
(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [7957, 'http://arxiv.org/abs/2404.02948']
(3)(+0000000): Notifier.trigger('modify', 'item', [7958], {"7958":{}}) called [observers: 36]
(3)(+0000001): Yielding for refresh promise
(3)(+0000009): [Zoplicate] itemsView.onSelect []
(3)(+0000000): [Zoplicate] Element with id zoplicate-bulk-merge-button-inner not found
(3)(+0000000): [Zoplicate] Element with id zoplicate-bulk-merge-button-external not found
(3)(+0000000): [Zoplicate] Element with id non-duplicates-button-inner not found
(3)(+0000000): [Zoplicate] Element with id non-duplicates-button-external not found
(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [7957, 'http://arxiv.org/abs/2404.02948']
(3)(+0000001): Cancelling auto-sync timer
(3)(+0000000): Setting auto-sync timeout to 3 seconds
(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [7957, 'http://arxiv.org/abs/2404.02948']
(3)(+0001100): {better-bibtex error:} autoexport failed: {"path":"/Users/chenyilong/Library/CloudStorage/OneDrive-yichen/Zotero/zoterolibrary.json"} Zotero.BetterBibTeX is undefined
(3)(+0000001): {better-bibtex error:} autoexport failed: {"path":"/Users/chenyilong/Library/CloudStorage/OneDrive-yichen/Zotero/\u6211\u7684\u6587\u5e93.json"} Zotero.BetterBibTeX is undefined
(3)(+0001907): Notifier.trigger('start', 'sync', []) called [observers: 3]
(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000000): Local groups:
(3)(+0000000): []
(3)(+0000000): Final libraries to sync:
(3)(+0000000): [ "0": 1 ]
(3)(+0000000): Starting data sync for 我的文库
(4)(+0000001): SELECT setting, value FROM syncedSettings WHERE synced=0 AND libraryID=? [1]
(3)(+0000000): [ConcurrentCaller] All tasks are done
(3)(+0000000): No settings to upload in 我的文库
(4)(+0000000): SELECT O.collectionID FROM collections O WHERE libraryID=? AND synced=0 [1]
(4)(+0000000): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'collection']
(3)(+0000001): No collections to upload in 我的文库
(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 1]
(3)(+0000000): No collection deletions to upload in 我的文库
(4)(+0000000): SELECT O.savedSearchID FROM savedSearches O WHERE libraryID=? AND synced=0 [1]
(4)(+0000000): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'search']
(3)(+0000000): No searches to upload in 我的文库
(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 4]
(3)(+0000001): No search deletions to upload in 我的文库
(4)(+0000000): SELECT O.itemID FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) WHERE libraryID=? AND synced=0 AND (IAn.isExternal IS NULL OR IAN.isExternal=0) [1]
(4)(+0000000): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'item']
(3)(+0000000): 1 item to upload in library 1
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 3]
(3)(+0000000): No item deletions to upload in 我的文库
(3)(+0000000): {"item":[8020]}
(4)(+0000000): Registering notifier observer 'itemsUpload_T4' for [item]
(4)(+0000000): Beginning DB transaction YOyGZ1Ge
(4)(+0000001): Committed DB transaction YOyGZ1Ge
(3)(+0000000): UPLOAD BATCH:
(3)(+0000000): [ "0": { "key": "AWN4TW2J" "version": 0 "itemType": "annotation" "parentItem": "VMR38MKR" "annotationType": "highlight" "annotationAuthorName": "" "annotationText": "Comparison of (Q)PiSSA and (Q)LoRA across models from 7B to 70B" "annotationComment": "" "annotationColor": "#ffd400" "annotationPageLabel": "8" "annotationSortIndex": "00007|001260|00556" "annotationPosition": "{\"pageIndex\":7,\"rects\":[[182.19,226.98,466.662,235.618]]}" "tags": [] "relations": {} "dateAdded": "2024-08-21T10:27:19Z" "dateModified": "2024-08-21T10:27:19Z" } ]
(3)(+0000000): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000001): HTTP POST "[{"key":"AWN4TW2J","version":0,"itemType":"annotation","parentItem":"VMR38MKR","annotationType":"highlight","annotationAuthorName":"","annotationText":"Comparison of (Q)PiSSA and (Q)LoRA across models from 7B to 70B","annotationComment":"","annotationColor":"#ffd400","annotationPageLabel":"8","annotationSortIndex":"00007|001260|00556","annotationPosition":"{\"pageIndex\":7,\"rects\":[[182.19,226.98,466.662,235.618]]}","tags":[],"relations":{},"dateAdded":"2024-08-21T10:27:19Z","dateModified":"2024-08-21T10:27:19Z"}]" to https://api.zotero.org/users/10067378/items
(3)(+0000001): [ConcurrentCaller] All tasks are done
(4)(+0000002): Beginning DB transaction q8N04MaX
(4)(+0000001): Item 8020 has not changed
(4)(+0000000): Updating database with new library data
(4)(+0000000): UPDATE libraries SET version=?, storageVersion=? WHERE libraryID=? [29669, 29669, 1]
(4)(+0000000): UPDATE items SET version=29669 WHERE itemID IN (?) [8020]
(4)(+0000000): UPDATE items SET synced=1 WHERE itemID IN (?) [8020]
(4)(+0000001): Committed DB transaction q8N04MaX
(4)(+0000000): DELETE FROM syncCache WHERE ROWID IN (SELECT SC.ROWID FROM syncCache SC LEFT JOIN items O USING (libraryID, key, version) WHERE syncObjectTypeID=? AND SC.libraryID=? AND (O.libraryID IS NULL OR SC.version < O.version)) [3, 1]
(2)(+0000006): Failed: 0
(4)(+0000000): Unregistering notifier observer in notifier with id 'itemsUpload_T4'
(3)(+0000000): Done uploading items in library 1
(3)(+0000000): {}
(4)(+0000000): Upload result is 1
(4)(+0000000): Updating database with new library data
(4)(+0000000): Beginning DB transaction iOsrRBEt
(4)(+0000000): UPDATE libraries SET lastSync=? WHERE libraryID=? [1724236044, 1]
(4)(+0000001): Committed DB transaction iOsrRBEt
(3)(+0000000): Done syncing 我的文库
(4)(+0000000): REPLACE INTO version (schema, version) VALUES ('lastsync', ?) [1724236045]
(3)(+0000000): Starting file syncing
(3)(+0000000): Starting file sync for 我的文库
(3)(+0000000): WebDAV credentials are already cached
(4)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE libraryID=? AND linkMode IN (?,?) AND syncState IN (?) AND storageModTime>=? [1, 0, 1, 2, 1724225244532]
(3)(+0000000): Zotero.Libraries.getName() is deprecated. Use Zotero.Library.prototype.name instead
(3)(+0000000): No files to check for local changes
(4)(+0000000): SELECT itemID, version FROM items JOIN itemAttachments USING (itemID) WHERE libraryID=? AND syncState=? [1, 5]
(4)(+0000001): SELECT COUNT(*) FROM items JOIN itemAttachments USING (itemID) WHERE libraryID=? AND syncState=? [1, 4]
(3)(+0000002): No remote storage changes for 我的文库 -- skipping file downloads
(4)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE libraryID=? AND syncState IN (?,?) AND linkMode IN (?,?,?) [1, 0, 3, 0, 1, 4]
Is there an existing issue for this?
Have you checked the FAQ (https://github.com/windingwind/zotero-pdf-translate/issues/6)?
Are you using the latest Zotero and the latest plugin?
Environment
Describe the bug
能正常翻译
Debug Output
1724235782868 addons.xpi WARN Checking /Applications/Zotero 2.app/Contents/Resources/distribution/extensions for addons
1724235783174 addons.webextension.pdfpreview@windingwind.com WARN Loading extension 'pdfpreview@windingwind.com': Reading manifest: Warning processing version: version must be a version string consisting of at most 4 integers of at most 9 digits without leading zeros, and separated with dots
1724235783563 addons.xpi WARN Addon with ID undefined already installed, older version will be disabled
[JavaScript Error: "Error: Addon must include an id, version, and type" {file: "resource://gre/modules/addons/XPIProvider.jsm" line: 1723}]
[JavaScript Error: "Error: Addon must include an id, version, and type" {file: "resource://gre/modules/addons/XPIProvider.jsm" line: 1723}]
PAC file installed from http://pac.internal.baidu.com/bdnew.pac
[JavaScript Error: "TypeError: this.collectionsView.selection is undefined" {file: "chrome://zotero/content/zoteroPane.js" line: 5088}] ZoteroPane</this.canEdit@chrome://zotero/content/zoteroPane.js:5088:7 ZoteroPane</this.updateAddAttachmentMenu@chrome://zotero/content/zoteroPane.js:1979:15 onpopupshowing@chrome://zotero/content/zoteroPane.xhtml:1:12
[JavaScript Error: "TypeError: this.collectionsView.selection is undefined" {file: "chrome://zotero/content/zoteroPane.js" line: 5088}] ZoteroPane</this.canEdit@chrome://zotero/content/zoteroPane.js:5088:7 ZoteroPane</this.updateNewNoteMenu@chrome://zotero/content/zoteroPane.js:2009:40 onpopupshowing@chrome://zotero/content/zoteroPane.xhtml:1:18
1724235784124 addons.xpi-utils WARN disabling legacy extension zotfile@columbia.edu
1724235784124 addons.xpi-utils WARN disabling legacy extension mdnotes@mdnotes.github.io
1724235784124 addons.xpi-utils WARN disabling legacy extension zoteroif@qnscholar
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
[JavaScript Error: "Translator f895aa0d-f28e-47fe-b247-2ea77c6ed583 not found"]
[JavaScript Error: "TypeError: emptyListMessage is null" {file: "chrome://zotero/content/standalone/standalone.js" line: 687}] ZoteroStandalone</this.updateAddonsPane/<@chrome://zotero/content/standalone/standalone.js:687:7
[JavaScript Error: "Translator f895aa0d-f28e-47fe-b247-2ea77c6ed583 not found"]
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
No chrome package registered for chrome://betternotes/content/icons/favicon.png
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
[JavaScript Error: "Error running bootstrap method 'shutdown' on pdfpreview@windingwind.com"]
[JavaScript Error: "ztoolkit.getGlobal(...).querySelector(...) is null" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/pdfpreview@windingwind.com.xpi!/chrome/content/scripts/pdfpreview.js" line: 1996}]
[JavaScript Error: "a is undefined" {file: "jar:file:///Users/chenyilong/Library/Application%20Support/Zotero/Profiles/gqqbh7vu.default/extensions/zoteroattanger@polygon.org.xpi!/chrome/content/scripts/zoteroattanger.js" line: 195}]
appName => Zotero, version => 7.0.2-beta.3+182bfb9a3 (ARM64), os => macOS 14.5, locale => zh-CN, extensions => Translate for Zotero (2.0.0, extension), ZotFile (5.1.2, extension, disabled), Mdnotes for Zotero (0.2.3, extension, disabled), Zotero IF (1.5.0, extension, disabled), Zotero PDF Preview (1.0.0-4, extension, disabled), Zotero Attanger (1.2.4, extension, disabled), Obsidian Note for Zotero (1.0.1, extension, disabled), MarkDB-Connect (0.1.1, extension, disabled), Zoplicate (3.0.3, extension, disabled), Zotero Reading List (1.5.0, extension, disabled), Better Notes for Zotero (2.0.0, extension, disabled), Actions and Tags for Zotero (2.0.0, extension, disabled), Zotero 插件市场 (1.6.15, extension, disabled), Chartero (2.9.4, extension, disabled), Better BibTex for Zotero (6.7.222, extension, disabled), Awesome GPT (1.1.8, extension, disabled), Ethereal Reference (0.9.6, extension, disabled), Ethereal Style (4.7.9, extension, disabled)
(3)(+0026193): Writing reader state to /Users/chenyilong/Zotero/storage/VMR38MKR/.zotero-reader-state
(3)(+0000935): [Ethereal Reference] null
(3)(+0000053): [Ethereal Reference] null
(3)(+0000054): [Ethereal Reference] null
(3)(+0000050): [Ethereal Reference] null
(3)(+0000052): [Ethereal Reference] null
(3)(+0000051): [Ethereal Reference] null
(3)(+0000054): [Ethereal Reference] null
(3)(+0000051): [Ethereal Reference] null
(3)(+0000050): [Ethereal Reference] null
(3)(+0000053): [Ethereal Reference] null
(3)(+0000055): [Ethereal Reference] null
(3)(+0000051): [Ethereal Reference] null
(3)(+0000052): [Ethereal Reference] null
(3)(+0000054): [Ethereal Reference] null
(3)(+0000055): [Ethereal Reference] null
(3)(+0000052): [Ethereal Reference] null
(3)(+0000053): [Ethereal Reference] null
(3)(+0000052): [Ethereal Reference] null
(3)(+0000241): [Translate for Zotero] runTranslationTask {}
(3)(+0000001): [Translate for Zotero] try itemLanguage en
(3)(+0000000): [Translate for Zotero] use autoDetect en
(3)(+0000002): [Translate for Zotero] try auto detect language
(3)(+0000000): [Translate for Zotero] try itemLanguage en
(3)(+0000000): [Translate for Zotero] use autoDetect en
(3)(+0000001): [Translate for Zotero] {"id":"nFZWvfrx-1724236038386","type":"text","raw":"Comparison of (Q)PiSSA and (Q)LoRA across models from 7B to 70B","result":"","audio":[],"service":"googleapi","candidateServices":[],"itemId":7958,"status":"processing","extraTasks":[],"langfrom":"en","langto":"zh-CN","callerID":"zoteropdftranslate@euclpts.com","secret":""}
(3)(+0000000): HTTP GET https://translate.googleapis.com/translate_a/single?client=gtx&sl=en&tl=zh-CN&hl=zh-CN&dt=at&dt=bd&dt=ex&dt=ld&dt=md&dt=qca&dt=rw&dt=rm&dt=ss&dt=t&source=bh&ssel=0&tsel=0&kc=1&tk=655106.1035126&q=Comparison%20of%20(Q)PiSSA%20and%20(Q)LoRA%20across%20models%20from%207B%20to%2070B
(3)(+0000663): HTTP GET https://translate.googleapis.com/translate_a/single?client=gtx&sl=en&tl=zh-CN&hl=zh-CN&dt=at&dt=bd&dt=ex&dt=ld&dt=md&dt=qca&dt=rw&dt=rm&dt=ss&dt=t&source=bh&ssel=0&tsel=0&kc=1&tk=655106.1035126&q=Comparison%20of%20(Q)PiSSA%20and%20(Q)LoRA%20across%20models%20from%207B%20to%2070B succeeded with 200
(3)(+0000001): [Translate for Zotero] try itemLanguage en
(3)(+0000000): [Translate for Zotero] use autoDetect en
(3)(+0000751): Creating notifier queue ee2Nz8TJ
(4)(+0000001): SELECT O.itemID, O.dateAdded, O.dateModified, O.version, O.synced, createdByUserID, lastModifiedByUserID, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1))) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 等' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, (CASE O.itemTypeID WHEN 3 THEN IAP.itemID WHEN 27 THEN INoP.itemID WHEN 1 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 3 THEN IAP.key WHEN 27 THEN INoP.key WHEN 1 THEN IAnP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID)LEFT JOIN groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.key=? AND O.libraryID=? ['AWN4TW2J', 1]
(4)(+0000047): Tags haven't changed
(4)(+0000000): Saving data for new item to database
(4)(+0000000): Beginning DB transaction XYpxsMSK
(3)(+0000001): [Zoplicate] Parent item 7958 deleted? false
(4)(+0000000): INSERT INTO items (itemID, libraryID, key, clientDateModified, itemTypeID, dateAdded, dateModified) VALUES (?,?,?,?,?,?,?) [8020, 1, 'AWN4TW2J', '2024-08-21 10:27:19', 1, '2024-08-21 10:27:19', '2024-08-21 10:27:19']
(3)(+0000001): Notifier.trigger('add', 'item', [8020], {"instanceID":"4vykHNev","skipSelect":true}) added to queue ee2Nz8TJ
(3)(+0000000): Notifier.trigger('modify', 'item', [7958], {}) added to queue ee2Nz8TJ
(4)(+0000000): REPLACE INTO itemAnnotations (itemID, parentItemID, type, authorName, text, comment, color, pageLabel, sortIndex, position, isExternal) VALUES (?, ?, ?, NULL, ?, NULL, ?, ?, ?, ?, ?) [8020, 7958, 1, 'Comparison of (Q)PiSSA and (Q)LoRA across models from 7B to 70B', '#ffd400', '8', '00007|001260|00556', '{"pageIndex":7,"rects":[[182.19,226.98,466.662,235.618]]}', 0]
(3)(+0000001): Loading primaryData for 1 item in 我的文库
(4)(+0000000): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, createdByUserID, lastModifiedByUserID, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1))) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 等' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, PI.itemID IS NOT NULL AS inPublications, (CASE O.itemTypeID WHEN 3 THEN IAP.itemID WHEN 27 THEN INoP.itemID WHEN 1 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 3 THEN IAP.key WHEN 27 THEN INoP.key WHEN 1 THEN IAnP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID)LEFT JOIN groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? AND O.itemID IN (7958) [1]
(3)(+0000001): Loaded primaryData in 我的文库 in 1 ms
(3)(+0000000): Loading childItems for 1 item in 我的文库
(4)(+0000000): SELECT parentItemID, A.itemID, value AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAttachments A JOIN items I ON (A.parentItemID=I.itemID) LEFT JOIN itemData ID ON (fieldID=1 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (7958) ORDER BY parentItemID [1]
(4)(+0000001): SELECT parentItemID, N.itemID, title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemNotes N JOIN items I ON (N.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (7958) ORDER BY parentItemID [1]
(4)(+0000000): SELECT parentItemID, IAn.itemID, text || ' - ' || comment AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAnnotations IAn JOIN items I ON (IAn.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (7958) ORDER BY parentItemID, sortIndex [1]
(4)(+0000000): SELECT itemID FROM items I WHERE libraryID=? AND itemID IN (7958) [1]
(3)(+0000001): Loaded childItems in 我的文库 in 2 ms
(4)(+0000000): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, createdByUserID, lastModifiedByUserID, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1))) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' 等' ) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT PRINTF('%s和%s', (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1), (SELECT '' || lastName || '' FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) )) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' 等' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT() FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT() FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, PI.itemID IS NOT NULL AS inPublications, (CASE O.itemTypeID WHEN 3 THEN IAP.itemID WHEN 27 THEN INoP.itemID WHEN 1 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 3 THEN IAP.key WHEN 27 THEN INoP.key WHEN 1 THEN IAnP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID)LEFT JOIN groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID=? [8020]
(3)(+0000001): Loading annotation for 1 item in 我的文库
(4)(+0000000): SELECT itemID, IA.parentItemID, IA.type, IA.authorName, IA.text, IA.comment, IA.color, IA.sortIndex, IA.isExternal FROM items JOIN itemAnnotations IA USING (itemID) WHERE libraryID=? AND itemID IN (8020) [1]
(3)(+0000000): Loaded annotation in 我的文库 in 0 ms
(3)(+0000000): Loading annotationDeferred for 1 item in 我的文库
(4)(+0000000): SELECT itemID, IA.position, IA.pageLabel FROM items JOIN itemAnnotations IA USING (itemID) WHERE libraryID=? AND itemID IN (8020) [1]
(3)(+0000000): Loaded annotationDeferred in 我的文库 in 0 ms
(4)(+0000005): Committed DB transaction XYpxsMSK
(3)(+0000000): Committing notifier event queues [add-item: 1] [modify-item: 1] [queues: ee2Nz8TJ]
(3)(+0000000): Notifier.trigger('add', 'item', [8020], {"8020":{"instanceID":"4vykHNev","skipSelect":true}}) called [observers: 39]
(3)(+0000001): Yielding for refresh promise
(3)(+0000011): [Zoplicate] itemsView.onSelect []
(3)(+0000000): [Zoplicate] Element with id zoplicate-bulk-merge-button-inner not found
(3)(+0000000): [Zoplicate] Element with id zoplicate-bulk-merge-button-external not found
(3)(+0000000): [Zoplicate] Element with id non-duplicates-button-inner not found
(3)(+0000000): [Zoplicate] Element with id non-duplicates-button-external not found
(3)(+0000001): Cancelling auto-sync timer
(3)(+0000000): Setting auto-sync timeout to 3 seconds
(4)(+0000001): Unregistering notifier observer in notifier with id 'Z8'
(4)(+0000000): Unregistering notifier observer in notifier with id 'Rt'
(4)(+0000000): Unregistering notifier observer in notifier with id 'h4'
(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [7957, 'http://arxiv.org/abs/2404.02948']
(3)(+0000000): Notifier.trigger('modify', 'item', [7958], {"7958":{}}) called [observers: 36]
(3)(+0000001): Yielding for refresh promise
(3)(+0000009): [Zoplicate] itemsView.onSelect []
(3)(+0000000): [Zoplicate] Element with id zoplicate-bulk-merge-button-inner not found
(3)(+0000000): [Zoplicate] Element with id zoplicate-bulk-merge-button-external not found
(3)(+0000000): [Zoplicate] Element with id non-duplicates-button-inner not found
(3)(+0000000): [Zoplicate] Element with id non-duplicates-button-external not found
(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [7957, 'http://arxiv.org/abs/2404.02948']
(3)(+0000001): Cancelling auto-sync timer
(3)(+0000000): Setting auto-sync timeout to 3 seconds
(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [7957, 'http://arxiv.org/abs/2404.02948']
(3)(+0001100): {better-bibtex error:} autoexport failed: {"path":"/Users/chenyilong/Library/CloudStorage/OneDrive-yichen/Zotero/zoterolibrary.json"} Zotero.BetterBibTeX is undefined
(3)(+0000001): {better-bibtex error:} autoexport failed: {"path":"/Users/chenyilong/Library/CloudStorage/OneDrive-yichen/Zotero/\u6211\u7684\u6587\u5e93.json"} Zotero.BetterBibTeX is undefined
(3)(+0001907): Notifier.trigger('start', 'sync', []) called [observers: 3]
(3)(+0000001): Stopping full-text content processor
(3)(+0000002): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000000): HTTP GET https://api.zotero.org/keys/current
(3)(+0000923): HTTP GET https://api.zotero.org/keys/current succeeded with 200
(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000000): { "userID": 10067378 "username": "yichen616" "displayName": "" "access": { "user": { "library": true "files": true "notes": true "write": true } "groups": { "all": { "library": true "write": true } } } }
(4)(+0000001): Beginning DB transaction mPUEuXFo
(3)(+0000000): [ConcurrentCaller] All tasks are done
(4)(+0000000): Committed DB transaction mPUEuXFo
(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000000): HTTP GET https://api.zotero.org/users/10067378/groups?format=versions
(3)(+0000295): HTTP GET https://api.zotero.org/users/10067378/groups?format=versions succeeded with 200
(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000000): Local groups:
(3)(+0000000): []
(3)(+0000000): Final libraries to sync:
(3)(+0000000): [ "0": 1 ]
(3)(+0000000): Starting data sync for 我的文库
(4)(+0000001): SELECT setting, value FROM syncedSettings WHERE synced=0 AND libraryID=? [1]
(3)(+0000000): [ConcurrentCaller] All tasks are done
(3)(+0000000): No settings to upload in 我的文库
(4)(+0000000): SELECT O.collectionID FROM collections O WHERE libraryID=? AND synced=0 [1]
(4)(+0000000): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'collection']
(3)(+0000001): No collections to upload in 我的文库
(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 1]
(3)(+0000000): No collection deletions to upload in 我的文库
(4)(+0000000): SELECT O.savedSearchID FROM savedSearches O WHERE libraryID=? AND synced=0 [1]
(4)(+0000000): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'search']
(3)(+0000000): No searches to upload in 我的文库
(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 4]
(3)(+0000001): No search deletions to upload in 我的文库
(4)(+0000000): SELECT O.itemID FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) WHERE libraryID=? AND synced=0 AND (IAn.isExternal IS NULL OR IAN.isExternal=0) [1]
(4)(+0000000): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'item']
(3)(+0000000): 1 item to upload in library 1
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 3]
(3)(+0000000): No item deletions to upload in 我的文库
(3)(+0000000): {"item":[8020]}
(4)(+0000000): Registering notifier observer 'itemsUpload_T4' for [item]
(4)(+0000000): Beginning DB transaction YOyGZ1Ge
(4)(+0000001): Committed DB transaction YOyGZ1Ge
(3)(+0000000): UPLOAD BATCH:
(3)(+0000000): [ "0": { "key": "AWN4TW2J" "version": 0 "itemType": "annotation" "parentItem": "VMR38MKR" "annotationType": "highlight" "annotationAuthorName": "" "annotationText": "Comparison of (Q)PiSSA and (Q)LoRA across models from 7B to 70B" "annotationComment": "" "annotationColor": "#ffd400" "annotationPageLabel": "8" "annotationSortIndex": "00007|001260|00556" "annotationPosition": "{\"pageIndex\":7,\"rects\":[[182.19,226.98,466.662,235.618]]}" "tags": [] "relations": {} "dateAdded": "2024-08-21T10:27:19Z" "dateModified": "2024-08-21T10:27:19Z" } ]
(3)(+0000000): Uploading 1 item
(3)(+0000000): Sending If-Unmodified-Since-Version: 29668
(3)(+0000000): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000001): HTTP POST "[{"key":"AWN4TW2J","version":0,"itemType":"annotation","parentItem":"VMR38MKR","annotationType":"highlight","annotationAuthorName":"","annotationText":"Comparison of (Q)PiSSA and (Q)LoRA across models from 7B to 70B","annotationComment":"","annotationColor":"#ffd400","annotationPageLabel":"8","annotationSortIndex":"00007|001260|00556","annotationPosition":"{\"pageIndex\":7,\"rects\":[[182.19,226.98,466.662,235.618]]}","tags":[],"relations":{},"dateAdded":"2024-08-21T10:27:19Z","dateModified":"2024-08-21T10:27:19Z"}]" to https://api.zotero.org/users/10067378/items
(3)(+0000387): HTTP POST https://api.zotero.org/users/10067378/items succeeded with 200
(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(4)(+0000001): Tags haven't changed
(4)(+0000000): Relations have not changed for item 1/AWN4TW2J
(4)(+0000001): Field 'dateAdded' has not changed
(4)(+0000000): Field 'dateModified' has not changed
(3)(+0000000): Saving to sync cache:
(3)(+0000000): [ "0": { "key": "AWN4TW2J" "version": 29669 "library": { "type": "user" "id": 10067378 "name": "yichen616" "links": { "alternate": { "href": "https://www.zotero.org/yichen616" "type": "text/html" } } } "links": { "self": { "href": "https://api.zotero.org/users/10067378/items/AWN4TW2J" "type": "application/json" } "alternate": { "href": "https://www.zotero.org/yichen616/items/AWN4TW2J" "type": "text/html" } "up": { "href": "https://api.zotero.org/users/10067378/items/VMR38MKR" "type": "application/json" } } "meta": {} "data": { "key": "AWN4TW2J" "version": 29669 "parentItem": "VMR38MKR" "itemType": "annotation" "annotationType": "highlight" "annotationText": "Comparison of (Q)PiSSA and (Q)LoRA across models from 7B to 70B" "annotationComment": "" "annotationColor": "#ffd400" "annotationPageLabel": "8" "annotationSortIndex": "00007|001260|00556" "annotationPosition": "{\"pageIndex\":7,\"rects\":[[182.19,226.98,466.662,235.618]]}" "tags": [] "relations": {} "dateAdded": "2024-08-21T10:27:19Z" "dateModified": "2024-08-21T10:27:19Z" } } ]
(4)(+0000000): INSERT OR REPLACE INTO syncCache (libraryID, key, syncObjectTypeID, version, data) VALUES (?, ?, ?, ?, ?) [1, 'AWN4TW2J', 3, 29669, '{"key":"AWN4TW2J","version":29669,"library":{"type":"user","id":10067378,"name":"yichen616","links":{"alternate":{"href":"https://www.zotero.org/yichen616","type":"text/html"}}},"links":{"self":{"href":"https://api.zotero.org/users/10067378/items/AWN4TW2J","type":"application/json"},"alternate":{"href":"https://www.zotero.org/yichen616/items/AWN4TW2J","type":"text/html"},"up":{"href":"https://api.zotero.org/users/10067378/items/VMR38MKR","type":"application/json"}},"meta":{},"data":{"key":"AWN4TW2J","version":29669,"parentItem":"VMR38MKR","itemType":"annotation","annotationType":"highlight","annotationText":"Comparison of (Q)PiSSA and (Q)LoRA across models from 7B to 70B","annotationComment":"","annotationColor":"#ffd400","annotationPageLabel":"8","annotationSortIndex":"00007|001260|00556","annotationPosition":"{\"pageIndex\":7,\"rects\":[[182.19,226.98,466.662,235.618]]}","tags":[],"relations":{},"dateAdded":"2024-08-21T10:27:19Z","dateModified":"2024-08-21T10:27:19Z"}}']
(3)(+0000001): [ConcurrentCaller] All tasks are done
(4)(+0000002): Beginning DB transaction q8N04MaX
(4)(+0000001): Item 8020 has not changed
(4)(+0000000): Updating database with new library data
(4)(+0000000): UPDATE libraries SET version=?, storageVersion=? WHERE libraryID=? [29669, 29669, 1]
(4)(+0000000): UPDATE items SET version=29669 WHERE itemID IN (?) [8020]
(4)(+0000000): UPDATE items SET synced=1 WHERE itemID IN (?) [8020]
(4)(+0000001): Committed DB transaction q8N04MaX
(4)(+0000000): DELETE FROM syncCache WHERE ROWID IN (SELECT SC.ROWID FROM syncCache SC LEFT JOIN items O USING (libraryID, key, version) WHERE syncObjectTypeID=? AND SC.libraryID=? AND (O.libraryID IS NULL OR SC.version < O.version)) [3, 1]
(2)(+0000006): Failed: 0
(4)(+0000000): Unregistering notifier observer in notifier with id 'itemsUpload_T4'
(3)(+0000000): Done uploading items in library 1
(3)(+0000000): {}
(4)(+0000000): Upload result is 1
(4)(+0000000): Updating database with new library data
(4)(+0000000): Beginning DB transaction iOsrRBEt
(4)(+0000000): UPDATE libraries SET lastSync=? WHERE libraryID=? [1724236044, 1]
(4)(+0000001): Committed DB transaction iOsrRBEt
(3)(+0000000): Done syncing 我的文库
(4)(+0000000): REPLACE INTO version (schema, version) VALUES ('lastsync', ?) [1724236045]
(3)(+0000000): Starting file syncing
(3)(+0000000): Starting file sync for 我的文库
(3)(+0000000): WebDAV credentials are already cached
(4)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE libraryID=? AND linkMode IN (?,?) AND syncState IN (?) AND storageModTime>=? [1, 0, 1, 2, 1724225244532]
(3)(+0000000): Zotero.Libraries.getName() is deprecated. Use Zotero.Library.prototype.name instead
(3)(+0000000): No files to check for local changes
(4)(+0000000): SELECT itemID, version FROM items JOIN itemAttachments USING (itemID) WHERE libraryID=? AND syncState=? [1, 5]
(4)(+0000001): SELECT COUNT(*) FROM items JOIN itemAttachments USING (itemID) WHERE libraryID=? AND syncState=? [1, 4]
(3)(+0000002): No remote storage changes for 我的文库 -- skipping file downloads
(4)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE libraryID=? AND syncState IN (?,?) AND linkMode IN (?,?,?) [1, 0, 3, 0, 1, 4]
(3)(+0000002): No files to upload for 我的文库
(3)(+0000000): File download sync finished for 我的文库 (0 succeeded, 0 failed)
(3)(+0000000): File upload sync finished for 我的文库 (0 succeeded, 0 failed)
(4)(+0000000): No data changed in library 1 -- not saving
(3)(+0000000): Purging deleted storage files
(4)(+0000000): SELECT key FROM storageDeleteLog WHERE libraryID=? [1]
(3)(+0000000): No files to delete remotely
(3)(+0000000): No local changes made during file sync
(3)(+0000000): Done with file sync for 我的文库
(3)(+0000000): Done with file syncing
(3)(+0000000): Starting full-text syncing
(3)(+0000001): Starting full-text sync for 我的文库
(4)(+0000000): SELECT version FROM version WHERE schema=? ['fulltext_1']
(3)(+0000000): Downloading full-text content for 我的文库
(3)(+0000000): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000000): HTTP GET https://api.zotero.org/users/10067378/fulltext?format=versions&since=29668
(3)(+0000391): HTTP GET https://api.zotero.org/users/10067378/fulltext?format=versions&since=29668 succeeded with 200
(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(4)(+0000001): REPLACE INTO version VALUES (?, ?) ['fulltext_1', '29669']
(3)(+0000000): [ConcurrentCaller] All tasks are done
Anything else?
No response