[Feature] 将特定md文件导入Zotero某条目下为子笔记，然后交由同步管理器管理；增加从Zotero中快速打开导出本地文件的选项

[xjtusjtu]

Is there an existing issue for this?

• I have searched the existing issues

Environment

• OS: windows 10
• Zotero Version: 7.0.11
• Plugin Version: 2.2.7

Describe the feature request

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Why do you need this feature?
wind佬，我曾经用很多其它插件产生了很多文献的Markdown笔记，存在本地某个文件夹，Zotero不知道存在这些文件，时间长了，我也忘了那些文献是有文献笔记的，除非我手动添加“有本地笔记”的标签；

Describe the solution you'd like

The solution you'd like

后来 better notes 有了双向同步功能，我现在希望这些本地笔记能够 单个地 导入回Zotero对应的条目下，然后借助 BN 的同步管理器管理

此外，我希望增加从Zotero中快速打开导出本地文件的选项，借助外部编辑器更好地编辑笔记。如果可以的话，还希望可以提供具体的API，这样可以使用 action and tags 插件配置快捷键。

感谢wind佬！

Anything else?

No response

[windingwind]

我现在希望这些本地笔记能够 单个地 导入回Zotero对应的条目下，然后借助 BN 的同步管理器管理

无法自动地知道笔记和条目的对应关系，需要你根据自己笔记中存储的信息自行确定，手动或编程导入

我希望增加从Zotero中快速打开导出本地文件的选项，借助外部编辑器更好地编辑笔记

这个可考虑实现

[xjtusjtu]

感谢wind 佬考虑！

第一个feature 我想的也不是自动寻找对应关系，我觉得大概有以下步骤

1. zotero 中唤醒资源管理器管理，选择需要导入的单个 md

2. zotero 中选择目标条目

3. 将这个本地笔记反过来导入到指定条目下

或者说，BN 对子笔记和本地md 同步依赖的三个元数据是如何获取的？$libraryID 是文献数据库的编号，$itemkey 是Zotero 子笔记的 itemkey，尤其是 $version 的数字 是如何获取呢？

我有可能通过编写bn 模板，通过根据模板创建子笔记实现这一过程吗？

[windingwind]

zotero 中唤醒资源管理器管理，选择需要导入的单个 md

[xjtusjtu]

感谢wind佬，我试了下这个功能，结果显示可导入的笔记为空？

[windingwind]

检查一下debug output是否有错误

[xjtusjtu]

这是导入不成功的日志输出

Submit…
Clear
1740245396952	addons.xpi-utils	WARN	disabling legacy extension mdnotes@mdnotes.github.io

1740245396952	addons.xpi-utils	WARN	disabling legacy extension Backup-Plugin-for-Zotero@iShareStuff.com

1740245396952	addons.xpi-utils	WARN	disabling legacy extension zoteroif@qnscholar

[JavaScript Error: "The connection was refused when attempting to contact wss://stream.zotero.org/."]

[JavaScript Error: "WebSocket connection closed: 1006 "]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "TypeError: window.goBuildEditContextMenu is not a function" {file: "chrome://zotero/content/elements/noteEditor.js" line: 92}]
connectedCallback@chrome://zotero/content/elements/noteEditor.js:92:14
connectedCallback@chrome://zotero/content/elements/base.js:44:12
connectedCallback@chrome://betternotes/content/scripts/customElements.js:1434:15
initWorkspace@jar:file:///C:/Users/Xiaobu/AppData/Roaming/Zotero/Zotero/Profiles/hocqehh3.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/BetterNotes.js:32302:15


[JavaScript Error: "Security Error: Content at moz-nullprincipal:{8586021d-0e22-40f8-95c5-48dc5d4bf9d6} may not load or link to chrome://betternotes/content/treeView.html."]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

[JavaScript Error: "Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead"]

appName => Zotero, version => 7.0.11 (x64), os => Windows 10.0 19044, locale => zh-CN, extensions => Zotero Debug Bridge (53.0, extension), Jasminum (1.0.0-20, extension), Actions and Tags for Zotero (2.1.0, extension), Easier Citation (0.4.9, extension), Linter for Zotero (1.22.5, extension), Translate for Zotero (2.1.5, extension), Zotero Attanger (1.3.1, extension), Ethereal Reference (1.4.0, extension), Magic for Zotero (2.0.2, extension), Ethereal Style (5.4.3, extension), Awesome GPT (1.7.5, extension), Better Notes for Zotero (2.2.9, extension), Mdnotes for Zotero (0.2.3, extension, disabled), Backup-Plugin-for-Zotero (1.0.2, extension, disabled), Zotero IF Pro Max (4.7.3, extension, disabled), 蒲公英 (1.0.6, extension, disabled), Wandering File (0.2.8, extension, disabled), Del Item With Attachment (0.3.3, extension, disabled), PDF Figure (0.2.6, extension, disabled), Better BibTex for Zotero (7.0.5, extension, disabled), MarkDB-Connect (0.1.5, extension, disabled)
(3)(+0144900): [Ethereal Style] isCurrent {"current":["title","year","firstCreator","publicationTitle","dateAdded","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"],"view":["title","year","firstCreator","publicationTitle","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"]} false

(3)(+0000000): [Ethereal Style] isCurrent {"current":["title","year","firstCreator","publicationTitle","dateAdded","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"],"view":["title","year","firstCreator","publicationTitle","zoterostyle-polygon-org-publicationTags"]} false

(3)(+0000001): [Ethereal Style] isCurrent {"current":["title","year","firstCreator","publicationTitle","dateAdded","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"],"view":["title","year","firstCreator","publicationTitle","dateModified","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"]} false

(3)(+0000818): itemTree.render(). Displaying Item Tree

(3)(+0024072): itemTree.render(). Displaying Item Tree

(3)(+0000935): itemTree.render(). Displaying Item Tree

(3)(+0001370): [Ethereal Style] isCurrent {"current":["title","year","firstCreator","publicationTitle","dateAdded","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"],"view":["title","year","firstCreator","publicationTitle","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"]} false

(3)(+0000001): [Ethereal Style] isCurrent {"current":["title","year","firstCreator","publicationTitle","dateAdded","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"],"view":["title","year","firstCreator","publicationTitle","zoterostyle-polygon-org-publicationTags"]} false

(3)(+0000000): [Ethereal Style] isCurrent {"current":["title","year","firstCreator","publicationTitle","dateAdded","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"],"view":["title","year","firstCreator","publicationTitle","dateModified","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"]} false

(4)(+0010242): Saving data for new item to database

(4)(+0000000): Beginning DB transaction Z6uIuunE

(4)(+0000028): INSERT INTO items (itemID, libraryID, key, clientDateModified, itemTypeID, dateAdded, dateModified) VALUES (?,?,?,?,?,?,?) [19022, 1, '7F2ZKPWF', '2025-02-22 17:32:58', 27, '2025-02-22 17:32:58', '2025-02-22 17:32:58']

(3)(+0000002): Notifier.trigger('add', 'item', [19022], {}) queued

(4)(+0000000): SELECT COUNT(*) FROM itemNotes WHERE itemID=? [19022]

(4)(+0000004): INSERT INTO itemNotes (itemID, parentItemID, note, title) VALUES (?,NULL,?,?) [19022, '<div class="zotero-note znv1"></div>', '']

(4)(+0000002): 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=? [19022]

(4)(+0000115): Committed DB transaction Z6uIuunE

(3)(+0000000): Committing notifier event queue [add-item: 1]

(3)(+0000000): Notifier.trigger('add', 'item', [19022], {"19022":{}}) called [observers: 37]

(3)(+0000000): Yielding for refresh promise

(3)(+0000001): Sorting items list by title, dateModified, firstCreator, date, dateAdded ascending for 1 item

(3)(+0000003): Sorted 1 item in 3 ms

(4)(+0000001): Beginning DB transaction 1ABnjnvQ

(3)(+0000001): Reloading tags box

(3)(+0000170): Yielding for select promise

(3)(+0000010): Getting contents of jar:file:///C:/Users/Xiaobu/AppData/Roaming/Zotero/Zotero/Profiles/hocqehh3.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/editorScript.js

(1)(+0000000): Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead

(3)(+0000000): HTTP GET jar:file:///C:/Users/Xiaobu/AppData/Roaming/Zotero/Zotero/Profiles/hocqehh3.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/editorScript.js

(3)(+0000001): [Actions and Tags for Zotero] notify add item [19022] {"19022":{}}

(4)(+0000001): Waiting for DB transaction 1ABnjnvQ to finish to start 9B4mmrBL

(5)(+0000000): Zotero.DBConnection.prototype.waitForTransaction@chrome://zotero/content/xpcom/db.js:579:43 Zotero.DBConnection.prototype.executeTransaction@chrome://zotero/content/xpcom/db.js:443:18 applyAction@jar:file:///C:/Users/Xiaobu/AppData/Roaming/Zotero/Zotero/Profiles/hocqehh3.default/extensions/zoterotag@euclpts.com.xpi!/chrome/content/scripts/zoterotag.js:5677:21 dispatchActionByEvent@jar:file:///C:/Users/Xiaobu/AppData/Roaming/Zotero/Zotero/Profiles/hocqehh3.default/extensions/zoterotag@euclpts.com.xpi!/chrome/content/scripts/zoterotag.js:6914:13 onNotify@jar:file:///C:/Users/Xiaobu/AppData/Roaming/Zotero/Zotero/Profiles/hocqehh3.default/extensions/zoterotag@euclpts.com.xpi!/chrome/content/scripts/zoterotag.js:5948:41

(4)(+0000001): 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 [513, 'https://kns.cnki.net/kcms/detail/detail.aspx?dbcode=CAPJ&dbname=CAPJLAST&filename=LKGP20220509000&uniplatform=NZKPT&v=VIbbzDF5eSutom-KXGdEuoBBwYjVU_goBWffEqix0BZFvjRy5ETKRsKt-l3BNdAs']

(3)(+0000001): [Jasminum] notify add item [19022] {"19022":{}}

(3)(+0000000): [Linter for Zotero] notify add item [19022] {"19022":{}}

(3)(+0000000): [Zotero Attanger] add item {"19022":{}}

(3)(+0000000): [Ethereal Style] TabManager add item

(4)(+0000000): 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 (DATE(dateAdded, 'localtime')>DATE('NOW', 'localtime', ?))) ['-7 days']

(4)(+0000001): DROP TABLE IF EXISTS tmpSearchResults_zE1Kz7jF

(4)(+0000042): 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 [513, 'https://kns.cnki.net/kcms/detail/detail.aspx?dbcode=CAPJ&dbname=CAPJLAST&filename=LKGP20220509000&uniplatform=NZKPT&v=VIbbzDF5eSutom-KXGdEuoBBwYjVU_goBWffEqix0BZFvjRy5ETKRsKt-l3BNdAs']

(4)(+0000019): DROP TABLE IF EXISTS tmpSearchResults_r0ZlgvtN

(4)(+0000001): Committed DB transaction 1ABnjnvQ

(4)(+0000000): DROP TABLE IF EXISTS tmpSearchResults_r0ZlgvtN

(4)(+0000032): DROP TABLE IF EXISTS tmpSearchResults_Gg8gxojw

(4)(+0000001): DROP TABLE IF EXISTS tmpSearchResults_Gg8gxojw

(3)(+0000010): HTTP GET jar:file:///C:/Users/Xiaobu/AppData/Roaming/Zotero/Zotero/Profiles/hocqehh3.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/editorScript.js succeeded with 200

(3)(+0000000): Getting contents of jar:file:///C:/Users/Xiaobu/AppData/Roaming/Zotero/Zotero/Profiles/hocqehh3.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/styles/editor.css

(1)(+0000000): Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead

(3)(+0000000): HTTP GET jar:file:///C:/Users/Xiaobu/AppData/Roaming/Zotero/Zotero/Profiles/hocqehh3.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/styles/editor.css

(4)(+0000002): Beginning DB transaction 9B4mmrBL

(3)(+0000002): Getting contents of D:\Markdown directory\Spaces\Research\Reading notes\ZhangJiaCheng.QiGuiJie.ea2022.md

(4)(+0000001): Updating database with new item data

(4)(+0000000): UPDATE items SET synced=?, clientDateModified=?, dateModified=? WHERE itemID=? [0, '2025-02-22 17:32:59', '2025-02-22 17:32:59', 19022]

(3)(+0000000): HTTP GET jar:file:///C:/Users/Xiaobu/AppData/Roaming/Zotero/Zotero/Profiles/hocqehh3.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/styles/editor.css succeeded with 200

(3)(+0000015): Notifier.trigger('modify', 'item', [19022], {}) queued

(4)(+0000000): INSERT OR REPLACE INTO itemTags (itemID, tagID, type) VALUES (?, ?, ?) [19022, 56, 1]

(3)(+0000126): [Better Notes for Zotero] import {"meta":"<div data-schema-version=\"9\">","content":"","tail":"</div>","lastmodify":"2025-02-22T17:32:58.000Z"}

(4)(+0000001): Updating database with new item data

(4)(+0000000): Waiting for DB transaction 9B4mmrBL to finish to start tyGviD9a

(5)(+0000000): Zotero.DBConnection.prototype.waitForTransaction@chrome://zotero/content/xpcom/db.js:579:43 Zotero.DBConnection.prototype.executeTransaction@chrome://zotero/content/xpcom/db.js:443:18 Zotero.DataObject.prototype.save<@chrome://zotero/content/xpcom/data/dataObject.js:939:32

(3)(+0000000): Notifier.trigger('add', 'item-tag', [19022-56], {"19022-56":{"libraryID":1,"tag":"/reading","type":1}}) queued

(4)(+0000001): 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=? [19022]

(3)(+0000002): [Better Notes for Zotero] [Warning] Creating element button with no namespace specified. Found multiply namespace matches.

(3)(+0000001): [Better Notes for Zotero] {}

(3)(+0000019): Loading note for 1 item in 我的文库

(4)(+0000000): SELECT itemID, note FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID IN (19022) [1]

(3)(+0000001): itemTree.render(). Displaying Item Tree

(4)(+0000002): SELECT itemID FROM items WHERE libraryID=? AND itemID IN (19022) AND itemTypeID IN (?, ?) AND itemID NOT IN (SELECT itemID FROM itemNotes) [1, 27, 3]

(3)(+0000000): Loaded note in 我的文库 in 3 ms

(3)(+0000001): Loading tags for 1 item in 我的文库

(4)(+0000000): SELECT itemID, name, type FROM items LEFT JOIN itemTags USING (itemID) LEFT JOIN tags USING (tagID) WHERE libraryID=? AND itemID IN (19022) [1]

(3)(+0000000): Loaded tags in 我的文库 in 0 ms

(4)(+0000107): Committed DB transaction 9B4mmrBL

(3)(+0000000): Committing notifier event queue [modify-item: 1] [add-item-tag: 1]

(3)(+0000000): Notifier.trigger('modify', 'item', [19022], {"19022":{}}) called [observers: 37]

(3)(+0000002): Yielding for refresh promise

(3)(+0000000): Sorting items list by title, dateModified, firstCreator, date, dateAdded ascending for 1 item

(3)(+0000001): Sorted 1 item in 1 ms

(3)(+0000064): Yielding for select promise

(3)(+0000000): [Actions and Tags for Zotero] notify modify item [19022] {"19022":{}}

(3)(+0000000): [Better Notes for Zotero] updateNoteLinkRelation 19022

(4)(+0000001): 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 [513, 'https://kns.cnki.net/kcms/detail/detail.aspx?dbcode=CAPJ&dbname=CAPJLAST&filename=LKGP20220509000&uniplatform=NZKPT&v=VIbbzDF5eSutom-KXGdEuoBBwYjVU_goBWffEqix0BZFvjRy5ETKRsKt-l3BNdAs']

(3)(+0000001): [Jasminum] notify modify item [19022] {"19022":{}}

(3)(+0000000): [Linter for Zotero] notify modify item [19022] {"19022":{}}

(3)(+0000000): [Zotero Attanger] modify item {"19022":{}}

(3)(+0000000): [Ethereal Style] TabManager modify item

(3)(+0000001): Notifier.trigger('add', 'item-tag', [19022-56], {"19022-56":{"libraryID":1,"tag":"/reading","type":1}}) called [observers: 6]

(3)(+0000000): Yielding for refresh promise

(3)(+0000003): Updating tag selector after tag change

(4)(+0000001): CREATE TEMPORARY TABLE tmpSearchResults_bfxrakcc AS 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 NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAnnotations WHERE parentItemID IS NOT NULL)) AND (itemID IN (SELECT itemID FROM items WHERE libraryID=?)) [1]

(4)(+0000016): 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 [513, 'https://kns.cnki.net/kcms/detail/detail.aspx?dbcode=CAPJ&dbname=CAPJLAST&filename=LKGP20220509000&uniplatform=NZKPT&v=VIbbzDF5eSutom-KXGdEuoBBwYjVU_goBWffEqix0BZFvjRy5ETKRsKt-l3BNdAs']

(3)(+0000004): Notifier.trigger('updateBNRelation', 'item', [19022], {}) called [observers: 37]

(3)(+0000001): Yielding for refresh promise

(3)(+0000064): [Actions and Tags for Zotero] notify updateBNRelation item [19022] {}

(3)(+0000001): [Jasminum] notify updateBNRelation item [19022] {}

(3)(+0000000): [Linter for Zotero] notify updateBNRelation item [19022] {}

(3)(+0000000): [Zotero Attanger] updateBNRelation item {}

(3)(+0000000): [Ethereal Style] TabManager updateBNRelation item

(4)(+0000008): CREATE INDEX tmpSearchResults_bfxrakcc_itemID ON tmpSearchResults_bfxrakcc(itemID)

(4)(+0000001): 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 COALESCE(IAnT.parentItemID, itemID) FROM itemTags LEFT JOIN itemAnnotations IAnT USING (itemID) WHERE (tagID IN (SELECT tagID FROM tags WHERE name=?)))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_bfxrakcc) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_bfxrakcc)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_bfxrakcc))) [1, 'ObsCite']

(4)(+0000017): DROP TABLE IF EXISTS tmpSearchResults_bfxrakcc

(3)(+0000001): Creating tmpSearchResults_zvhOyTkX with 127 items

(4)(+0000000): CREATE UNIQUE INDEX tmpSearchResults_zvhOyTkX_itemID ON tmpSearchResults_zvhOyTkX(itemID)

(4)(+0000001): SELECT DISTINCT tagID || ':' || type FROM itemTags JOIN tags USING (tagID) WHERE 1 AND itemID IN (SELECT itemID FROM tmpSearchResults_zvhOyTkX UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_zvhOyTkX)) AND type IN (?) AND tagID IN (56) ORDER BY name COLLATE NOCASE [1]

(4)(+0000001): SELECT DISTINCT tagID || ':' || type FROM itemTags JOIN tags USING (tagID) JOIN items USING (itemID) WHERE libraryID = ? AND tagID IN (56) ORDER BY name COLLATE NOCASE [1]

(3)(+0000001): Sorted tags in 0 ms

(4)(+0000001): Beginning DB transaction tyGviD9a

(3)(+0000001): [Actions and Tags for Zotero] applyAction {"event":7,"operation":1,"data":"/reading","shortcut":"","enabled":true,"menu":"","name":"Add Reading","showInMenu":{"item":false,"collection":false,"tools":false,"reader":false,"readerAnnotation":false}} {"itemID":19022,"triggerType":7}

(3)(+0000030): Rendering tag selector

(3)(+0000002): Rendering tag list

(3)(+0000001): Tag selector updated

(4)(+0000006): UPDATE items SET synced=?, clientDateModified=?, dateModified=? WHERE itemID=? [0, '2025-02-22 17:32:59', '2025-02-22 17:32:59', 19022]

(3)(+0000001): Notifier.trigger('modify', 'item', [19022], {"autoSyncDelay":15}) queued

(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=? [19022]

(4)(+0000078): Committed DB transaction tyGviD9a

(3)(+0000000): Committing notifier event queue [modify-item: 1]

(3)(+0000000): Notifier.trigger('modify', 'item', [19022], {"19022":{},"autoSyncDelay":15}) called [observers: 37]

(3)(+0000001): Yielding for refresh promise

(3)(+0000001): Sorting items list by title, dateModified, firstCreator, date, dateAdded ascending for 1 item

(3)(+0000001): Sorted 1 item in 1 ms

(3)(+0000089): Yielding for select promise

(3)(+0000000): [Actions and Tags for Zotero] notify modify item [19022] {"19022":{},"autoSyncDelay":15}

(3)(+0000000): [Better Notes for Zotero] updateNoteLinkRelation 19022

(4)(+0000001): 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 [513, 'https://kns.cnki.net/kcms/detail/detail.aspx?dbcode=CAPJ&dbname=CAPJLAST&filename=LKGP20220509000&uniplatform=NZKPT&v=VIbbzDF5eSutom-KXGdEuoBBwYjVU_goBWffEqix0BZFvjRy5ETKRsKt-l3BNdAs']

(3)(+0000001): [Jasminum] notify modify item [19022] {"19022":{},"autoSyncDelay":15}

(3)(+0000001): [Linter for Zotero] notify modify item [19022] {"19022":{},"autoSyncDelay":15}

(3)(+0000000): [Zotero Attanger] modify item {"19022":{},"autoSyncDelay":15}

(3)(+0000000): [Ethereal Style] TabManager modify item

(4)(+0000001): DROP TABLE IF EXISTS tmpSearchResults_zvhOyTkX

(4)(+0000014): 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 [513, 'https://kns.cnki.net/kcms/detail/detail.aspx?dbcode=CAPJ&dbname=CAPJLAST&filename=LKGP20220509000&uniplatform=NZKPT&v=VIbbzDF5eSutom-KXGdEuoBBwYjVU_goBWffEqix0BZFvjRy5ETKRsKt-l3BNdAs']

(3)(+0000003): Creating string pref 'extensions.zotero.Knowledge4Zotero.syncDetail-19022'

(3)(+0000012): Notifier.trigger('updateBNRelation', 'item', [19022], {}) called [observers: 37]

(3)(+0000000): Yielding for refresh promise

(3)(+0000070): [Actions and Tags for Zotero] notify updateBNRelation item [19022] {}

(3)(+0000002): [Jasminum] notify updateBNRelation item [19022] {}

(3)(+0000000): [Linter for Zotero] notify updateBNRelation item [19022] {}

(3)(+0000000): [Zotero Attanger] updateBNRelation item {}

(3)(+0000000): [Ethereal Style] TabManager updateBNRelation item

(3)(+0000008): itemTree.render(). Displaying Item Tree

(3)(+0010563): itemTree.render(). Displaying Item Tree

(3)(+0057542): Viewing item

(3)(+0000006): Refreshing item box

(3)(+0000062): Setting mode to 'edit'

(3)(+0000001): Reloading tags box

(4)(+0000024): 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 [393, 'https://kns.cnki.net/KCMS/detail/detail.aspx?dbcode=CJFD&dbname=CJFDLAST2020&filename=LKGP202005007&v=']

(4)(+0000001): 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 [393, 'https://kns.cnki.net/KCMS/detail/detail.aspx?dbcode=CJFD&dbname=CJFDLAST2020&filename=LKGP202005007&v=']

(3)(+0000060): BlockingObserver: Removed observer

(3)(+0000172): BlockingObserver: Added observer

(3)(+0000321): Got MIME type application/pdf from extension 'pdf'

(3)(+0000092): itemTree.render(). Displaying Item Tree

(3)(+0000280): itemTree.render(). Displaying Item Tree

(3)(+0000582): Viewing item

(3)(+0000004): Refreshing item box

(3)(+0000001): Setting mode to 'edit'

(3)(+0000293): itemTree.render(). Displaying Item Tree

(3)(+0000798): itemTree.render(). Displaying Item Tree

(3)(+0000965): [Better Notes for Zotero] {}

(3)(+0000879): itemTree.render(). Displaying Item Tree

(3)(+0000360): Viewing item

(3)(+0000005): Refreshing item box

(3)(+0000001): Setting mode to 'edit'

(3)(+0000323): itemTree.render(). Displaying Item Tree

(3)(+0000752): itemTree.render(). Displaying Item Tree

(3)(+0001357): Viewing item

(3)(+0000006): Refreshing item box

(3)(+0000058): Setting mode to 'edit'

(3)(+0000001): Reloading tags box

(4)(+0000027): 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 [513, 'https://kns.cnki.net/kcms/detail/detail.aspx?dbcode=CAPJ&dbname=CAPJLAST&filename=LKGP20220509000&uniplatform=NZKPT&v=VIbbzDF5eSutom-KXGdEuoBBwYjVU_goBWffEqix0BZFvjRy5ETKRsKt-l3BNdAs']

(4)(+0000001): 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 [513, 'https://kns.cnki.net/kcms/detail/detail.aspx?dbcode=CAPJ&dbname=CAPJLAST&filename=LKGP20220509000&uniplatform=NZKPT&v=VIbbzDF5eSutom-KXGdEuoBBwYjVU_goBWffEqix0BZFvjRy5ETKRsKt-l3BNdAs']

(3)(+0000072): BlockingObserver: Removed observer

(3)(+0000105): BlockingObserver: Added observer

(3)(+0000245): Got MIME type application/pdf from extension 'pdf'

(3)(+0000018): itemTree.render(). Displaying Item Tree

(3)(+0000384): itemTree.render(). Displaying Item Tree

(3)(+0001762): [Ethereal Style] isCurrent {"current":["title","year","firstCreator","publicationTitle","dateAdded","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"],"view":["title","year","firstCreator","publicationTitle","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"]} false

(3)(+0000001): [Ethereal Style] isCurrent {"current":["title","year","firstCreator","publicationTitle","dateAdded","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"],"view":["title","year","firstCreator","publicationTitle","zoterostyle-polygon-org-publicationTags"]} false

(3)(+0000001): [Ethereal Style] isCurrent {"current":["title","year","firstCreator","publicationTitle","dateAdded","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"],"view":["title","year","firstCreator","publicationTitle","dateModified","zoterostyle-polygon-org-textTags","zoterostyle-polygon-org-rating","zoterostyle-polygon-org-remark"]} false

---

但是有时候又能成功导入，但是无法点击这个笔记右上角菜单栏里面的”立即同步“，进程会卡着不动，需要手动重启Zotero，然后能双向同步成功（我想打印这个日志，但是把Zotero卡死了，没有成功打印）

[windingwind]

感谢反馈。对于同步后卡住的笔记，是否可以稳定复现？（再次同样操作是否仍然卡住）

[xjtusjtu]

感谢反馈。对于同步后卡住的笔记，是否可以稳定复现？（再次同样操作是否仍然卡住）

是的。在成功导入的情况下，立即点击笔记右上角 更多选项【立即同步】，一般都会出现卡在 “确认合并 1/1 ...” 这一步，可以稳定复现。可以重启Zotero，再次点击右上角 更多选项【立即同步】，此时则不会卡住，合并成功

[windingwind]

若方便，请分享一个导入后会卡住的markdown文件（如有附件图片也请一并打包），谢谢

[xjtusjtu]

卡住.zip

好的，请查收

(一直卡住不动)

若方便，请分享一个导入后会卡住的markdown文件（如有附件图片也请一并打包），谢谢

[github-actions]

This issue is stale because it has been open for 30 days with no activity.

[github-actions]

This issue was closed because it has been inactive for 7 days since being marked as stale.