(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 e %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) || ' et al.' ) 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 e %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) || ' et al.' ) 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 e %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) || ' et al.' ) 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 28 THEN INoP.itemID WHEN 1 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 3 THEN IAP.key WHEN 28 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=? [21925]
(3)(+0000008): Loading collections for 1 item in lisboarocha_these
(4)(+0000000): SELECT itemID, collectionID FROM items LEFT JOIN collectionItems USING (itemID) WHERE libraryID=? AND itemID IN (21925) [3]
(3)(+0000002): Loaded collections in lisboarocha_these in 2 ms
(3)(+0000002): Notifier.trigger('add', 'item', [21925], {"21925":{},"autoSyncDelay":15}) called [observers: 24]
(3)(+0000001): Yielding for refresh promise
(3)(+0000007): Sorting items list by dateModified, firstCreator, date, title, dateAdded descending for 1 item
(3)(+0000022): Sorted 1 item in 24 ms
(4)(+0000002): Beginning DB transaction 08MSFlnk
(3)(+0000001): Reloading tags box
(3)(+0000070): Yielding for select promise
(3)(+0000014): Getting contents of jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/editorScript.js
(1)(+0000001): Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead
(3)(+0000000): HTTP GET jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/editorScript.js
(3)(+0000007): Cancelling auto-sync timer
(3)(+0000001): Setting auto-sync timeout to 15 seconds
(3)(+0000001): Notifier.trigger('add', 'collection-item', [191-21925], {"191-21925":{}}) called [observers: 3]
(3)(+0000000): Yielding for refresh promise
(3)(+0000028): Updating tag selector after tag change
(4)(+0000006): CREATE TEMPORARY TABLE tmpSearchResults_cnKhZ5xo 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=?)) AND itemID IN (SELECT itemID FROM collectionItems WHERE (collectionID IN (191, 208, 310, 217, 216, 308, 326, 325, 386, 385, 384, 393, 397, 392, 405, 404, 403, 402, 399, 394, 314, 389, 383, 378, 377, 382, 381, 388, 375, 400, 391, 331, 334, 332, 380, 379, 401, 372, 376, 343, 371, 390, 329, 368, 367, 340, 370, 339, 366, 387, 374, 373, 395, 337, 365, 341, 364, 369, 363, 356, 396, 398, 362, 328, 361, 359, 360, 358, 336, 357, 330, 355, 352, 347, 351, 350, 349, 354, 335, 344, 348, 353, 346, 327, 321, 333, 221, 281, 262, 264, 273, 278, 319, 295, 263, 316, 312, 257, 296, 259, 276, 313, 261, 231, 307, 282, 280, 265, 297, 274, 258, 230, 275, 267, 317, 256, 260, 203, 309, 232, 250, 249, 199, 255, 201))) [3]
(3)(+0000080): HTTP GET jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/editorScript.js succeeded with 200
(3)(+0000001): Getting contents of jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/styles/editor.css
(1)(+0000001): Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead
(3)(+0000000): HTTP GET jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/styles/editor.css
(4)(+0000004): CREATE INDEX tmpSearchResults_cnKhZ5xo_itemID ON tmpSearchResults_cnKhZ5xo(itemID)
(4)(+0000001): Committed DB transaction 08MSFlnk
(4)(+0000015): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT COALESCE(IA.parentItemID, itemID) AS itemID FROM items LEFT JOIN itemAnnotations IA USING (itemID) WHERE (itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM deletedItems)))) AND (itemID IN (SELECT itemID FROM items WHERE libraryID=?))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_cnKhZ5xo) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_cnKhZ5xo)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_cnKhZ5xo))) [3]
(3)(+0000004): HTTP GET jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/styles/editor.css succeeded with 200
(4)(+0000053): DROP TABLE IF EXISTS tmpSearchResults_cnKhZ5xo
(3)(+0000003): Creating tmpSearchResults_uxkpWV87 with 8342 items
(3)(+0000027): [Better Notes for Zotero] [Warning] Creating element button with no namespace specified. Found multiply namespace matches.
(4)(+0000025): CREATE UNIQUE INDEX tmpSearchResults_uxkpWV87_itemID ON tmpSearchResults_uxkpWV87(itemID)
(4)(+0000005): SELECT DISTINCT tagID || ':' || type FROM itemTags JOIN tags USING (tagID) WHERE 1 AND itemID IN (SELECT itemID FROM tmpSearchResults_uxkpWV87 UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_uxkpWV87)) ORDER BY name COLLATE NOCASE
(4)(+0000059): SELECT DISTINCT tagID || ':' || type FROM itemTags JOIN tags USING (tagID) JOIN items USING (itemID) WHERE libraryID = ? ORDER BY name COLLATE NOCASE [3]
(3)(+0000074): Tags haven't changed
(4)(+0000016): Item 21925 has not changed
(3)(+0000041): Rendering tag selector
(3)(+0000010): Rendering tag list
(3)(+0000007): Tag selector updated
(3)(+0000072): [Warning] Creating element title with no namespace specified. Found multiply namespace matches.
(3)(+0000002): {}
(3)(+0000001): [Warning] Creating element style with no namespace specified. Found multiply namespace matches.
(4)(+0000186): Registering notifier observer 'itemTreeView_CJ' for [item,collection-item,item-tag,share-items,bucket,feedItem,search,itemtree,collection] with priority 50
(3)(+0000001): Getting contents of C:\Users\Fábio\AppData\Roaming\Zotero\Zotero\Profiles\4zp4l8ei.default\treePrefs.json
(3)(+0000003): Writing column prefs of length 4334 to file C:\Users\Fábio\AppData\Roaming\Zotero\Zotero\Profiles\4zp4l8ei.default\treePrefs.json
(3)(+0000007): Getting contents of C:\Users\Fábio\AppData\Roaming\Zotero\Zotero\Profiles\4zp4l8ei.default\treePrefs.json
(3)(+0000004): Refreshing items list for item-tree-select-items-dialog-default
(4)(+0000008): CREATE TEMPORARY TABLE tmpSearchResults_7bXPGTUe 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=?)) AND itemID IN (SELECT itemID FROM collectionItems WHERE (collectionID IN (191, 208, 310, 217, 216, 308, 326, 325, 386, 385, 384, 393, 397, 392, 405, 404, 403, 402, 399, 394, 314, 389, 383, 378, 377, 382, 381, 388, 375, 400, 391, 331, 334, 332, 380, 379, 401, 372, 376, 343, 371, 390, 329, 368, 367, 340, 370, 339, 366, 387, 374, 373, 395, 337, 365, 341, 364, 369, 363, 356, 396, 398, 362, 328, 361, 359, 360, 358, 336, 357, 330, 355, 352, 347, 351, 350, 349, 354, 335, 344, 348, 353, 346, 327, 321, 333, 221, 281, 262, 264, 273, 278, 319, 295, 263, 316, 312, 257, 296, 259, 276, 313, 261, 231, 307, 282, 280, 265, 297, 274, 258, 230, 275, 267, 317, 256, 260, 203, 309, 232, 250, 249, 199, 255, 201))) [3]
(4)(+0000045): CREATE INDEX tmpSearchResults_7bXPGTUe_itemID ON tmpSearchResults_7bXPGTUe(itemID)
(4)(+0000003): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT COALESCE(IA.parentItemID, itemID) AS itemID FROM items LEFT JOIN itemAnnotations IA USING (itemID) WHERE (itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM deletedItems)))) AND (itemID IN (SELECT itemID FROM items WHERE libraryID=?))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_7bXPGTUe) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_7bXPGTUe)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_7bXPGTUe))) [3]
(4)(+0000053): DROP TABLE IF EXISTS tmpSearchResults_7bXPGTUe
(3)(+0000040): Sorting items list by title, firstCreator, date, dateAdded ascending for 4038 items
(3)(+0000078): Sorted 4038 items in 84 ms
(3)(+0000009): Refreshed open parents in 8 ms
(3)(+0000005): itemTree.render(). Displaying Item Tree
(4)(+0003647): 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 [7633, 'https://www.facebook.com/oquenaosainatv']
(4)(+0000796): 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 [8731, 'https://vermelho.org.br/2018/06/16/2013-o-estopim-do-golpe-de-2016/']
(3)(+0005750): Notifier.trigger('start', 'sync', []) called [observers: 3]
(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000002): Local groups:
(3)(+0000001): [ "0": 2191227 ]
(3)(+0000001): Final libraries to sync:
(3)(+0000002): [ "0": 3 ]
(3)(+0000002): Starting data sync for lisboarocha_these
(4)(+0000003): SELECT setting, value FROM syncedSettings WHERE synced=0 AND libraryID=? [3]
(3)(+0000001): [ConcurrentCaller] All tasks are done
(3)(+0000006): No settings to upload in lisboarocha_these
(4)(+0000002): SELECT O.collectionID FROM collections O WHERE libraryID=? AND synced=0 [3]
(4)(+0000046): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'collection']
(3)(+0000005): No collections to upload in lisboarocha_these
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 1]
(3)(+0000005): No collection deletions to upload in lisboarocha_these
(4)(+0000001): SELECT O.savedSearchID FROM savedSearches O WHERE libraryID=? AND synced=0 [3]
(4)(+0000002): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'search']
(3)(+0000002): No searches to upload in lisboarocha_these
(4)(+0000002): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 4]
(3)(+0000004): No search deletions to upload in lisboarocha_these
(4)(+0000001): 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) [3]
(4)(+0000002): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'item']
(3)(+0000002): 1 item to upload in library 3
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 3]
(3)(+0000003): No item deletions to upload in lisboarocha_these
(3)(+0000001): {"item":[21925]}
(4)(+0000001): Registering notifier observer 'itemsUpload_t7' for [item]
(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000002): HTTP POST "[{"key":"FJVKNPAZ","version":0,"itemType":"note","note":"","tags":[],"collections":["YTXVYFFM"],"relations":{},"dateAdded":"2024-08-28T12:42:36Z","dateModified":"2024-08-28T12:42:36Z"}]" to https://api.zotero.org/groups/2191227/items
(4)(+0000002): SELECT setting, value FROM syncedSettings WHERE synced=0 AND libraryID=? [3]
(3)(+0000005): No settings to upload in lisboarocha_these
(4)(+0000001): SELECT O.collectionID FROM collections O WHERE libraryID=? AND synced=0 [3]
(4)(+0000002): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'collection']
(3)(+0000001): No collections to upload in lisboarocha_these
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 1]
(3)(+0000004): No collection deletions to upload in lisboarocha_these
(4)(+0000002): SELECT O.savedSearchID FROM savedSearches O WHERE libraryID=? AND synced=0 [3]
(4)(+0000002): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'search']
(3)(+0000004): No searches to upload in lisboarocha_these
(4)(+0000002): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 4]
(3)(+0000002): No search deletions to upload in lisboarocha_these
(4)(+0000001): 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) [3]
(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'item']
(3)(+0000006): 1 item to upload in library 3
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 3]
(3)(+0000003): No item deletions to upload in lisboarocha_these
(3)(+0000002): {"item":[21925]}
(4)(+0000002): Registering notifier observer 'itemsUpload_mD' for [item]
(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000002): HTTP POST "[{"key":"FJVKNPAZ","version":0,"itemType":"note","note":"","tags":[],"collections":["YTXVYFFM"],"relations":{},"dateAdded":"2024-08-28T12:42:36Z","dateModified":"2024-08-28T12:42:36Z"}]" to https://api.zotero.org/groups/2191227/items
(4)(+0000010): 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, 3]
(2)(+0000030): Failed: 0
(4)(+0000001): Unregistering notifier observer in notifier with id 'itemsUpload_mD'
(3)(+0000000): Done uploading items in library 3
(3)(+0000001): {}
(4)(+0000001): Upload result is 1
(4)(+0000002): Updating database with new group data
(4)(+0000001): Beginning DB transaction kqI2aUOI
(4)(+0000003): UPDATE libraries SET lastSync=? WHERE libraryID=? [1724848974, 3]
(5)(+0000001): Group data did not change for group 2191227
(4)(+0000009): Committed DB transaction kqI2aUOI
(4)(+0000004): SELECT key FROM items LEFT JOIN groupItems GI USING (itemID) WHERE libraryID=? AND GI.itemID IS NULL ORDER BY itemID LIMIT 100 [3]
(3)(+0000012): Done syncing lisboarocha_these
(4)(+0000002): REPLACE INTO version (schema, version) VALUES ('lastsync', ?) [1724848975]
(3)(+0000008): Starting file syncing
(3)(+0000001): Done with file syncing
(3)(+0000002): Starting full-text syncing
(3)(+0000001): Done with full-text syncing
(3)(+0000001): Done syncing
(3)(+0000001): Notifier.trigger('finish', 'sync', []) called [observers: 3]
(4)(+0000001): SELECT libraryID AS id FROM feeds WHERE refreshInterval IS NOT NULL AND ( lastCheck IS NULL OR (julianday(lastCheck, 'utc') + (refreshInterval/1440.0) - julianday('now', 'utc')) <= 0 )
(3)(+0000005): Running update for feeds:
(3)(+0000002): All feed updates done
(3)(+0000000): Scheduling next feed update
(4)(+0000001): SELECT ( CASE WHEN lastCheck IS NULL THEN 0 ELSE strftime('%s', lastCheck) + refreshInterval * 60 - strftime('%s', 'now') END ) AS nextCheck FROM feeds WHERE refreshInterval IS NOT NULL ORDER BY nextCheck ASC LIMIT 1
Is there an existing issue for this?
Are you using the latest Zotero and the latest plugin?
Environment
Describe the bug
Hello,
When executing templates, I'm getting this:
Info about the system:
It works perfectly on my Linux machine.
Do you have any idea about that?
Thanks for this great job!
Debug Output
[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: this.editorView is undefined" {file: "resource://zotero/note-editor/editor.js" line: 6}]
[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: this.editorView is undefined" {file: "resource://zotero/note-editor/editor.js" line: 6}]
[JavaScript Error: "TypeError: tagRaw is null" {file: "jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/BetterNotes.js line 56012 > AsyncFunction" line: 7}]
[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: this.editorView is undefined" {file: "resource://zotero/note-editor/editor.js" line: 6}]
[JavaScript Error: "TypeError: tagRaw is null" {file: "jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/BetterNotes.js line 56012 > AsyncFunction" line: 7}]
appName => Zotero, version => 7.0.3 (x64), os => Windows 11 22631, locale => pt-BR, extensions => Better Notes for Zotero (2.0.3, extension)
(3)(+0215391): WebSocket message: {"event":"subscriptionsCreated","subscriptions":[{"apiKey":"****","topics":["/users/9891745","/users/9891745/publications","/groups/2191227","/groups/2081478"]},{"topics":["styles","translators"]}],"errors":[]}
(3)(+0019752): {}
(3)(+0000001): {}
(3)(+0000001): {}
(3)(+0000001): {}
(3)(+0000001): {}
(3)(+0000000): {}
(3)(+0000001): {}
(3)(+0001749): [Better Notes for Zotero] {"lastInputText":"","defaultText":{"placeholder":"Select a command...","empty":"No commands found."},"maxLineNum":12,"maxSuggestionNum":100,"commands":[{"name":"Template: [item] coleta","label":"BNotes Template","id":"Template: [item] coleta"}],"base":{"patchSign":"zotero-plugin-toolkit@2.0.0","_basicOptions":{"log":{"_type":"toolkitlog","disableConsole":false,"disableZLog":false,"prefix":""},"debug":{"_disableDebugBridgePassword":false},"api":{"pluginID":"zotero-plugin-toolkit@windingwind.com"},"listeners":{"callbacks":{"onMainWindowLoad":{},"onMainWindowUnload":{},"onPluginUnload":{}}}}},"ui":{"patchSign":"zotero-plugin-toolkit@2.0.0","_basicOptions":{"log":{"_type":"toolkitlog","disableConsole":false,"disableZLog":false,"prefix":""},"debug":{"_disableDebugBridgePassword":false},"api":{"pluginID":"zotero-plugin-toolkit@windingwind.com"},"listeners":{"callbacks":{"onMainWindowLoad":{},"onMainWindowUnload":{},"onPluginUnload":{}}},"ui":{"enableElementRecord":true,"enableElementJSONLog":false,"enableElementDOMLog":true}},"elementCache":[{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]},"promptNode":{},"inputNode":{}} [item] coleta
(4)(+0000003): Note hasn't changed
(4)(+0000002): Saving data for new item to database
(4)(+0000001): Beginning DB transaction uSQupYCQ
(4)(+0000014): INSERT INTO items (itemID, libraryID, key, clientDateModified, itemTypeID, dateAdded, dateModified) VALUES (?,?,?,?,?,?,?) [21925, 3, 'FJVKNPAZ', '2024-08-28 12:42:36', 28, '2024-08-28 12:42:36', '2024-08-28 12:42:36']
(3)(+0000004): Notifier.trigger('add', 'item', [21925], {"autoSyncDelay":15}) queued
(4)(+0000001): REPLACE INTO groupItems VALUES (?, ?, NULL) [21925, 9891745]
(4)(+0000003): SELECT COUNT(*) FROM itemNotes WHERE itemID=? [21925]
(4)(+0000001): INSERT INTO itemNotes (itemID, parentItemID, note, title) VALUES (?,NULL,?,?) [21925, '
', ''](4)(+0000004): SELECT IFNULL(MAX(orderIndex)+1, 0) FROM collectionItems WHERE collectionID=? [191]
(4)(+0000003): INSERT OR IGNORE INTO collectionItems (collectionID, itemID, orderIndex) VALUES (?, ?, ?) [191, 21925, 378]
(3)(+0000010): Notifier.trigger('add', 'collection-item', [191-21925], {}) queued
(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 e %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) || ' et al.' ) 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 e %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) || ' et al.' ) 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 e %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) || ' et al.' ) 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 28 THEN INoP.itemID WHEN 1 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 3 THEN IAP.key WHEN 28 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=? [21925]
(3)(+0000008): Loading collections for 1 item in lisboarocha_these
(4)(+0000000): SELECT itemID, collectionID FROM items LEFT JOIN collectionItems USING (itemID) WHERE libraryID=? AND itemID IN (21925) [3]
(3)(+0000002): Loaded collections in lisboarocha_these in 2 ms
(4)(+0000007): Committed DB transaction uSQupYCQ
(3)(+0000002): Committing notifier event queue [add-item: 1] [add-collection-item: 1]
(3)(+0000002): Notifier.trigger('add', 'item', [21925], {"21925":{},"autoSyncDelay":15}) called [observers: 24]
(3)(+0000001): Yielding for refresh promise
(3)(+0000007): Sorting items list by dateModified, firstCreator, date, title, dateAdded descending for 1 item
(3)(+0000022): Sorted 1 item in 24 ms
(4)(+0000002): Beginning DB transaction 08MSFlnk
(3)(+0000001): Reloading tags box
(3)(+0000070): Yielding for select promise
(3)(+0000014): Getting contents of jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/editorScript.js
(1)(+0000001): Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead
(3)(+0000000): HTTP GET jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/editorScript.js
(3)(+0000007): Cancelling auto-sync timer
(3)(+0000001): Setting auto-sync timeout to 15 seconds
(3)(+0000001): Notifier.trigger('add', 'collection-item', [191-21925], {"191-21925":{}}) called [observers: 3]
(3)(+0000000): Yielding for refresh promise
(3)(+0000028): Updating tag selector after tag change
(4)(+0000006): CREATE TEMPORARY TABLE tmpSearchResults_cnKhZ5xo 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=?)) AND itemID IN (SELECT itemID FROM collectionItems WHERE (collectionID IN (191, 208, 310, 217, 216, 308, 326, 325, 386, 385, 384, 393, 397, 392, 405, 404, 403, 402, 399, 394, 314, 389, 383, 378, 377, 382, 381, 388, 375, 400, 391, 331, 334, 332, 380, 379, 401, 372, 376, 343, 371, 390, 329, 368, 367, 340, 370, 339, 366, 387, 374, 373, 395, 337, 365, 341, 364, 369, 363, 356, 396, 398, 362, 328, 361, 359, 360, 358, 336, 357, 330, 355, 352, 347, 351, 350, 349, 354, 335, 344, 348, 353, 346, 327, 321, 333, 221, 281, 262, 264, 273, 278, 319, 295, 263, 316, 312, 257, 296, 259, 276, 313, 261, 231, 307, 282, 280, 265, 297, 274, 258, 230, 275, 267, 317, 256, 260, 203, 309, 232, 250, 249, 199, 255, 201))) [3]
(3)(+0000080): HTTP GET jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/scripts/editorScript.js succeeded with 200
(3)(+0000001): Getting contents of jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/styles/editor.css
(1)(+0000001): Passing a URI to Zotero.File.getContentsAsync() is deprecated -- use Zotero.HTTP.request() instead
(3)(+0000000): HTTP GET jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/styles/editor.css
(4)(+0000004): CREATE INDEX tmpSearchResults_cnKhZ5xo_itemID ON tmpSearchResults_cnKhZ5xo(itemID)
(4)(+0000001): Committed DB transaction 08MSFlnk
(4)(+0000015): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT COALESCE(IA.parentItemID, itemID) AS itemID FROM items LEFT JOIN itemAnnotations IA USING (itemID) WHERE (itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM deletedItems)))) AND (itemID IN (SELECT itemID FROM items WHERE libraryID=?))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_cnKhZ5xo) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_cnKhZ5xo)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_cnKhZ5xo))) [3]
(3)(+0000004): HTTP GET jar:file:///C:/Users/F%C3%A1bio/AppData/Roaming/Zotero/Zotero/Profiles/4zp4l8ei.default/extensions/Knowledge4Zotero@windingwind.com.xpi!/chrome/content/styles/editor.css succeeded with 200
(4)(+0000053): DROP TABLE IF EXISTS tmpSearchResults_cnKhZ5xo
(3)(+0000003): Creating tmpSearchResults_uxkpWV87 with 8342 items
(3)(+0000027): [Better Notes for Zotero] [Warning] Creating element button with no namespace specified. Found multiply namespace matches.
(4)(+0000025): CREATE UNIQUE INDEX tmpSearchResults_uxkpWV87_itemID ON tmpSearchResults_uxkpWV87(itemID)
(4)(+0000005): SELECT DISTINCT tagID || ':' || type FROM itemTags JOIN tags USING (tagID) WHERE 1 AND itemID IN (SELECT itemID FROM tmpSearchResults_uxkpWV87 UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_uxkpWV87)) ORDER BY name COLLATE NOCASE
(4)(+0000059): SELECT DISTINCT tagID || ':' || type FROM itemTags JOIN tags USING (tagID) JOIN items USING (itemID) WHERE libraryID = ? ORDER BY name COLLATE NOCASE [3]
(3)(+0000074): Tags haven't changed
(4)(+0000016): Item 21925 has not changed
(3)(+0000041): Rendering tag selector
(3)(+0000010): Rendering tag list
(3)(+0000007): Tag selector updated
(3)(+0000072): [Warning] Creating element title with no namespace specified. Found multiply namespace matches.
(3)(+0000002): {}
(3)(+0000001): [Warning] Creating element style with no namespace specified. Found multiply namespace matches.
(3)(+0000001): {}
(3)(+0000001): {}
(3)(+0000002): {}
(3)(+0000003): {}
(3)(+0000001): {}
(3)(+0000000): {}
(3)(+0000002): {}
(3)(+0000002): {}
(3)(+0000001): {}
(3)(+0000001): {}
(3)(+0000001): {}
(3)(+0000001): {}
(3)(+0000002): {}
(3)(+0003439): Initializing React ItemTree select-items-dialog
(4)(+0000186): Registering notifier observer 'itemTreeView_CJ' for [item,collection-item,item-tag,share-items,bucket,feedItem,search,itemtree,collection] with priority 50
(3)(+0000005): itemTree.render(). Displaying Item Pane Message
(3)(+0000007): React ItemTree select-items-dialog initialized
(3)(+0000002): Initializing React CollectionTree
(3)(+0000027): itemTree.render(). Displaying Item Pane Message
(4)(+0000005): Registering notifier observer 'collectionTree_Bp' for [collection,search,feed,share,group,trash,bucket] with priority 25
(3)(+0000024): Refreshing collections pane
(4)(+0000005): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [1]
(3)(+0000005): React CollectionTree initialized
(3)(+0000002): Refreshing collections pane
(4)(+0000007): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [1]
(4)(+0000030): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [2]
(4)(+0000012): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [2]
(4)(+0000011): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [3]
(4)(+0000022): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [3]
(3)(+0000029): CollectionTree.selectWait(): selectEventsSuppressed. Not waiting to select row 17
(3)(+0000027): CollectionTree.selectWait(): row 17 already selected
(3)(+0000110): itemTree.changeCollectionTreeRow(): C191
(3)(+0000001): Getting contents of C:\Users\Fábio\AppData\Roaming\Zotero\Zotero\Profiles\4zp4l8ei.default\treePrefs.json
(3)(+0000003): Writing column prefs of length 4334 to file C:\Users\Fábio\AppData\Roaming\Zotero\Zotero\Profiles\4zp4l8ei.default\treePrefs.json
(3)(+0000007): Getting contents of C:\Users\Fábio\AppData\Roaming\Zotero\Zotero\Profiles\4zp4l8ei.default\treePrefs.json
(3)(+0000004): Refreshing items list for item-tree-select-items-dialog-default
(4)(+0000008): CREATE TEMPORARY TABLE tmpSearchResults_7bXPGTUe 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=?)) AND itemID IN (SELECT itemID FROM collectionItems WHERE (collectionID IN (191, 208, 310, 217, 216, 308, 326, 325, 386, 385, 384, 393, 397, 392, 405, 404, 403, 402, 399, 394, 314, 389, 383, 378, 377, 382, 381, 388, 375, 400, 391, 331, 334, 332, 380, 379, 401, 372, 376, 343, 371, 390, 329, 368, 367, 340, 370, 339, 366, 387, 374, 373, 395, 337, 365, 341, 364, 369, 363, 356, 396, 398, 362, 328, 361, 359, 360, 358, 336, 357, 330, 355, 352, 347, 351, 350, 349, 354, 335, 344, 348, 353, 346, 327, 321, 333, 221, 281, 262, 264, 273, 278, 319, 295, 263, 316, 312, 257, 296, 259, 276, 313, 261, 231, 307, 282, 280, 265, 297, 274, 258, 230, 275, 267, 317, 256, 260, 203, 309, 232, 250, 249, 199, 255, 201))) [3]
(4)(+0000045): CREATE INDEX tmpSearchResults_7bXPGTUe_itemID ON tmpSearchResults_7bXPGTUe(itemID)
(4)(+0000003): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT COALESCE(IA.parentItemID, itemID) AS itemID FROM items LEFT JOIN itemAnnotations IA USING (itemID) WHERE (itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM deletedItems)UNION SELECT itemID FROM itemAnnotations WHERE parentItemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM deletedItems)))) AND (itemID IN (SELECT itemID FROM items WHERE libraryID=?))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_7bXPGTUe) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_7bXPGTUe)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_7bXPGTUe))) [3]
(4)(+0000053): DROP TABLE IF EXISTS tmpSearchResults_7bXPGTUe
(3)(+0000040): Sorting items list by title, firstCreator, date, dateAdded ascending for 4038 items
(3)(+0000078): Sorted 4038 items in 84 ms
(3)(+0000009): Refreshed open parents in 8 ms
(3)(+0000005): itemTree.render(). Displaying Item Tree
(2)(+0000004): Storing itemTree item-tree-select-items-dialog-default column prefs
(3)(+0000001): Columns title width 784
(3)(+0000001): Columns firstCreator width 184
(3)(+0000051): React CollectionTree loaded
(3)(+0000001): React CollectionTree loaded
(4)(+0003647): 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 [7633, 'https://www.facebook.com/oquenaosainatv']
(4)(+0000796): 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 [8731, 'https://vermelho.org.br/2018/06/16/2013-o-estopim-do-golpe-de-2016/']
(3)(+0005750): Notifier.trigger('start', 'sync', []) called [observers: 3]
(3)(+0000003): Stopping full-text content processor
(3)(+0000004): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000001): HTTP GET https://api.zotero.org/keys/current
(3)(+0000577): HTTP GET https://api.zotero.org/keys/current succeeded with 200
(3)(+0000002): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000002): { "userID": 9891745 "username": "fabio.paiva" "displayName": "" "access": { "user": { "library": true "files": true "notes": true "write": true } "groups": { "all": { "library": true "write": true } } } }
(4)(+0000003): Beginning DB transaction jrHcimPI
(3)(+0000002): [ConcurrentCaller] All tasks are done
(4)(+0000005): Committed DB transaction jrHcimPI
(4)(+0000002): DROP TABLE IF EXISTS tmpSearchResults_uxkpWV87
(3)(+0000008): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000004): HTTP GET https://api.zotero.org/users/9891745/groups?format=versions
(4)(+0000105): Unregistering notifier observer in notifier with id 'collectionTree_Bp'
(4)(+0000001): Unregistering notifier observer in notifier with id 'itemTreeView_CJ'
(3)(+0000000): Getting contents of C:\Users\Fábio\AppData\Roaming\Zotero\Zotero\Profiles\4zp4l8ei.default\treePrefs.json
(3)(+0000002): [Better Notes for Zotero] runTemplate: [item] coleta
(3)(+0000001): [Better Notes for Zotero] runTemplate: [item] coleta
(3)(+0000086): Writing column prefs of length 4334 to file C:\Users\Fábio\AppData\Roaming\Zotero\Zotero\Profiles\4zp4l8ei.default\treePrefs.json
(3)(+0000147): HTTP GET https://api.zotero.org/users/9891745/groups?format=versions succeeded with 200
(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000002): Local groups:
(3)(+0000001): [ "0": 2191227 ]
(3)(+0000001): Final libraries to sync:
(3)(+0000002): [ "0": 3 ]
(3)(+0000002): Starting data sync for lisboarocha_these
(4)(+0000003): SELECT setting, value FROM syncedSettings WHERE synced=0 AND libraryID=? [3]
(3)(+0000001): [ConcurrentCaller] All tasks are done
(3)(+0000006): No settings to upload in lisboarocha_these
(4)(+0000002): SELECT O.collectionID FROM collections O WHERE libraryID=? AND synced=0 [3]
(4)(+0000046): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'collection']
(3)(+0000005): No collections to upload in lisboarocha_these
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 1]
(3)(+0000005): No collection deletions to upload in lisboarocha_these
(4)(+0000001): SELECT O.savedSearchID FROM savedSearches O WHERE libraryID=? AND synced=0 [3]
(4)(+0000002): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'search']
(3)(+0000002): No searches to upload in lisboarocha_these
(4)(+0000002): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 4]
(3)(+0000004): No search deletions to upload in lisboarocha_these
(4)(+0000001): 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) [3]
(4)(+0000002): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'item']
(3)(+0000002): 1 item to upload in library 3
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 3]
(3)(+0000003): No item deletions to upload in lisboarocha_these
(3)(+0000001): {"item":[21925]}
(4)(+0000001): Registering notifier observer 'itemsUpload_t7' for [item]
(4)(+0000002): Beginning DB transaction gwO4vX8u
(4)(+0000008): Committed DB transaction gwO4vX8u
(3)(+0000003): UPLOAD BATCH:
(3)(+0000001): [ "0": { "key": "FJVKNPAZ" "version": 0 "itemType": "note" "note": "" "tags": [] "collections": [ "0": "YTXVYFFM" ] "relations": {} "dateAdded": "2024-08-28T12:42:36Z" "dateModified": "2024-08-28T12:42:36Z" } ]
(3)(+0000002): Uploading 1 item
(3)(+0000001): Sending If-Unmodified-Since-Version: 38016
(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000002): HTTP POST "[{"key":"FJVKNPAZ","version":0,"itemType":"note","note":"","tags":[],"collections":["YTXVYFFM"],"relations":{},"dateAdded":"2024-08-28T12:42:36Z","dateModified":"2024-08-28T12:42:36Z"}]" to https://api.zotero.org/groups/2191227/items
(3)(+0000188): HTTP POST https://api.zotero.org/groups/2191227/items succeeded with 412
(3)(+0000002): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(2)(+0000007): Server returned 412: Library has been modified since specified version (expected 38016, found 38017)
(4)(+0000010): Unregistering notifier observer in notifier with id 'itemsUpload_t7'
(4)(+0000009): Upload result is 3
(3)(+0000004): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000001): HTTP GET https://api.zotero.org/groups/2191227/settings?since=38016
(3)(+0000002): [ConcurrentCaller] Nothing left to run -- waiting for running tasks to complete
(3)(+0000193): HTTP GET https://api.zotero.org/groups/2191227/settings?since=38016 succeeded with 200
(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000001): No settings modified remotely since last check
(3)(+0000001): Checking for updated collections in lisboarocha_these
(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000001): HTTP GET https://api.zotero.org/groups/2191227/collections?format=versions&since=38016
(3)(+0000001): [ConcurrentCaller] Nothing left to run -- waiting for running tasks to complete
(3)(+0000205): HTTP GET https://api.zotero.org/groups/2191227/collections?format=versions&since=38016 succeeded with 200
(3)(+0000002): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000001): VERSIONS:
(3)(+0000001): {"libraryVersion":"38017","versions":{}}
(3)(+0000001): No collections modified remotely since last check
(4)(+0000001): SELECT key, lastCheck, tries FROM syncQueue WHERE libraryID=? AND syncObjectTypeID=? [3, 1]
(3)(+0000001): [ConcurrentCaller] All tasks are done
(3)(+0000004): Checking for updated searches in lisboarocha_these
(3)(+0000002): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000001): HTTP GET https://api.zotero.org/groups/2191227/searches?format=versions&since=38016
(3)(+0000221): HTTP GET https://api.zotero.org/groups/2191227/searches?format=versions&since=38016 succeeded with 200
(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000000): VERSIONS:
(3)(+0000001): {"libraryVersion":"38017","versions":{}}
(3)(+0000000): No searches modified remotely since last check
(4)(+0000001): SELECT key, lastCheck, tries FROM syncQueue WHERE libraryID=? AND syncObjectTypeID=? [3, 4]
(3)(+0000002): [ConcurrentCaller] All tasks are done
(3)(+0000002): Checking for updated top-level items in lisboarocha_these
(3)(+0000002): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000001): HTTP GET https://api.zotero.org/groups/2191227/items/top?format=versions&since=38016&includeTrashed=1
(3)(+0000214): HTTP GET https://api.zotero.org/groups/2191227/items/top?format=versions&since=38016&includeTrashed=1 succeeded with 200
(3)(+0000002): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000001): VERSIONS:
(3)(+0000000): {"libraryVersion":"38017","versions":{}}
(3)(+0000001): No items modified remotely since last check
(3)(+0000000): Checking for updated items in lisboarocha_these
(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000001): HTTP GET https://api.zotero.org/groups/2191227/items?format=versions&since=38016&includeTrashed=1
(3)(+0000001): [ConcurrentCaller] Nothing left to run -- waiting for running tasks to complete
(3)(+0000210): HTTP GET https://api.zotero.org/groups/2191227/items?format=versions&since=38016&includeTrashed=1 succeeded with 200
(3)(+0000002): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000002): VERSIONS:
(3)(+0000001): {"libraryVersion":"38017","versions":{}}
(3)(+0000001): No items modified remotely since last check
(4)(+0000001): SELECT key, lastCheck, tries FROM syncQueue WHERE libraryID=? AND syncObjectTypeID=? [3, 3]
(3)(+0000002): [ConcurrentCaller] All tasks are done
(3)(+0000005): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000001): HTTP GET https://api.zotero.org/groups/2191227/deleted?since=38016
(3)(+0000245): HTTP GET https://api.zotero.org/groups/2191227/deleted?since=38016 succeeded with 200
(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(3)(+0000001): No objects deleted remotely since last check
(4)(+0000003): Updating database with new group data
(4)(+0000001): Beginning DB transaction snnBvt5w
(3)(+0000002): [ConcurrentCaller] All tasks are done
(4)(+0000002): UPDATE libraries SET version=?, storageVersion=? WHERE libraryID=? [38017, 38017, 3]
(3)(+0000005): Notifier.trigger('modify', 'group', [2191227]) queued
(5)(+0000001): Group data did not change for group 2191227
(4)(+0000007): Committed DB transaction snnBvt5w
(3)(+0000002): Committing notifier event queue [modify-group: 1]
(3)(+0000001): Notifier.trigger('modify', 'group', [2191227], {}) called [observers: 4]
(3)(+0000003): Refreshing collections pane
(4)(+0000003): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [1]
(4)(+0000004): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE libraryID=? [1]
(4)(+0000002): SELECT collectionID FROM collections JOIN deletedCollections USING (collectionID) WHERE libraryID=? [1]
(4)(+0000002): SELECT savedSearchID FROM savedSearches JOIN deletedSearches USING (savedSearchID) WHERE libraryID=? [1]
(4)(+0000010): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [2]
(4)(+0000006): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [3]
(4)(+0000014): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE libraryID=? [3]
(4)(+0000005): SELECT collectionID FROM collections JOIN deletedCollections USING (collectionID) WHERE libraryID=? [3]
(4)(+0000001): SELECT savedSearchID FROM savedSearches JOIN deletedSearches USING (savedSearchID) WHERE libraryID=? [3]
(3)(+0000038): CollectionTree.selectWait(): row 19 already selected
(3)(+0000002): ZoteroPane.onCollectionSelected: Collection selection hasn't changed
(4)(+0000014): Download result is 3
(4)(+0000002): SELECT setting, value FROM syncedSettings WHERE synced=0 AND libraryID=? [3]
(3)(+0000005): No settings to upload in lisboarocha_these
(4)(+0000001): SELECT O.collectionID FROM collections O WHERE libraryID=? AND synced=0 [3]
(4)(+0000002): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'collection']
(3)(+0000001): No collections to upload in lisboarocha_these
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 1]
(3)(+0000004): No collection deletions to upload in lisboarocha_these
(4)(+0000002): SELECT O.savedSearchID FROM savedSearches O WHERE libraryID=? AND synced=0 [3]
(4)(+0000002): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'search']
(3)(+0000004): No searches to upload in lisboarocha_these
(4)(+0000002): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 4]
(3)(+0000002): No search deletions to upload in lisboarocha_these
(4)(+0000001): 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) [3]
(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [3, 'item']
(3)(+0000006): 1 item to upload in library 3
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [3, 3]
(3)(+0000003): No item deletions to upload in lisboarocha_these
(3)(+0000002): {"item":[21925]}
(4)(+0000002): Registering notifier observer 'itemsUpload_mD' for [item]
(4)(+0000001): Beginning DB transaction FCzc9WYA
(4)(+0000006): Committed DB transaction FCzc9WYA
(3)(+0000002): UPLOAD BATCH:
(3)(+0000001): [ "0": { "key": "FJVKNPAZ" "version": 0 "itemType": "note" "note": "" "tags": [] "collections": [ "0": "YTXVYFFM" ] "relations": {} "dateAdded": "2024-08-28T12:42:36Z" "dateModified": "2024-08-28T12:42:36Z" } ]
(3)(+0000002): Uploading 1 item
(3)(+0000001): Sending If-Unmodified-Since-Version: 38017
(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued)
(3)(+0000002): HTTP POST "[{"key":"FJVKNPAZ","version":0,"itemType":"note","note":"","tags":[],"collections":["YTXVYFFM"],"relations":{},"dateAdded":"2024-08-28T12:42:36Z","dateModified":"2024-08-28T12:42:36Z"}]" to https://api.zotero.org/groups/2191227/items
(3)(+0000258): HTTP POST https://api.zotero.org/groups/2191227/items succeeded with 200
(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued)
(4)(+0000005): Tags haven't changed
(4)(+0000001): Relations have not changed for item 3/FJVKNPAZ
(4)(+0000002): Field 'dateAdded' has not changed
(4)(+0000001): Field 'dateModified' has not changed
(3)(+0000001): Collections have not changed for item 21925
(4)(+0000002): Note hasn't changed
(3)(+0000001): Saving to sync cache:
(3)(+0000001): [ "0": { "key": "FJVKNPAZ" "version": 38018 "library": { "type": "group" "id": 2191227 "name": "lisboarocha_these" "links": { "alternate": { "href": "https://www.zotero.org/groups/2191227" "type": "text/html" } } } "links": { "self": { "href": "https://api.zotero.org/groups/2191227/items/FJVKNPAZ" "type": "application/json" } "alternate": { "href": "https://www.zotero.org/groups/2191227/items/FJVKNPAZ" "type": "text/html" } } "meta": { "createdByUser": { "id": 9891745 "username": "fabio.paiva" "name": "" "links": { "alternate": { "href": "https://www.zotero.org/fabio.paiva" "type": "text/html" } } } "numChildren": 0 } "data": { "key": "FJVKNPAZ" "version": 38018 "itemType": "note" "note": "" "tags": [] "collections": [ "0": "YTXVYFFM" ] "relations": {} "dateAdded": "2024-08-28T12:42:36Z" "dateModified": "2024-08-28T12:42:36Z" } } ]
(4)(+0000002): INSERT OR REPLACE INTO syncCache (libraryID, key, syncObjectTypeID, version, data) VALUES (?, ?, ?, ?, ?) [3, 'FJVKNPAZ', 3, 38018, '{"key":"FJVKNPAZ","version":38018,"library":{"type":"group","id":2191227,"name":"lisboarocha_these","links":{"alternate":{"href":"https://www.zotero.org/groups/2191227","type":"text/html"}}},"links":{"self":{"href":"https://api.zotero.org/groups/2191227/items/FJVKNPAZ","type":"application/json"},"alternate":{"href":"https://www.zotero.org/groups/2191227/items/FJVKNPAZ","type":"text/html"}},"meta":{"createdByUser":{"id":9891745,"username":"fabio.paiva","name":"","links":{"alternate":{"href":"https://www.zotero.org/fabio.paiva","type":"text/html"}}},"numChildren":0},"data":{"key":"FJVKNPAZ","version":38018,"itemType":"note","note":"","tags":[],"collections":["YTXVYFFM"],"relations":{},"dateAdded":"2024-08-28T12:42:36Z","dateModified":"2024-08-28T12:42:36Z"}}']
(3)(+0000001): [ConcurrentCaller] All tasks are done
(4)(+0000003): Beginning DB transaction nKPmkLuZ
(4)(+0000002): Item 21925 has not changed
(4)(+0000003): Updating database with new group data
(4)(+0000002): UPDATE libraries SET version=?, storageVersion=? WHERE libraryID=? [38018, 38018, 3]
(3)(+0000003): Notifier.trigger('modify', 'group', [2191227]) queued
(5)(+0000001): Group data did not change for group 2191227
(4)(+0000001): UPDATE items SET version=38018 WHERE itemID IN (?) [21925]
(4)(+0000001): UPDATE items SET synced=1 WHERE itemID IN (?) [21925]
(4)(+0000007): Committed DB transaction nKPmkLuZ
(3)(+0000001): Committing notifier event queue [modify-group: 1]
(3)(+0000000): Notifier.trigger('modify', 'group', [2191227], {}) called [observers: 4]
(3)(+0000004): Refreshing collections pane
(4)(+0000002): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [1]
(4)(+0000006): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE libraryID=? [1]
(4)(+0000003): SELECT collectionID FROM collections JOIN deletedCollections USING (collectionID) WHERE libraryID=? [1]
(4)(+0000002): SELECT savedSearchID FROM savedSearches JOIN deletedSearches USING (savedSearchID) WHERE libraryID=? [1]
(4)(+0000006): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [2]
(4)(+0000006): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [3]
(4)(+0000011): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE libraryID=? [3]
(4)(+0000007): SELECT collectionID FROM collections JOIN deletedCollections USING (collectionID) WHERE libraryID=? [3]
(4)(+0000002): SELECT savedSearchID FROM savedSearches JOIN deletedSearches USING (savedSearchID) WHERE libraryID=? [3]
(3)(+0000030): CollectionTree.selectWait(): row 19 already selected
(3)(+0000001): ZoteroPane.onCollectionSelected: Collection selection hasn't changed
(4)(+0000010): 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, 3]
(2)(+0000030): Failed: 0
(4)(+0000001): Unregistering notifier observer in notifier with id 'itemsUpload_mD'
(3)(+0000000): Done uploading items in library 3
(3)(+0000001): {}
(4)(+0000001): Upload result is 1
(4)(+0000002): Updating database with new group data
(4)(+0000001): Beginning DB transaction kqI2aUOI
(4)(+0000003): UPDATE libraries SET lastSync=? WHERE libraryID=? [1724848974, 3]
(5)(+0000001): Group data did not change for group 2191227
(4)(+0000009): Committed DB transaction kqI2aUOI
(4)(+0000004): SELECT key FROM items LEFT JOIN groupItems GI USING (itemID) WHERE libraryID=? AND GI.itemID IS NULL ORDER BY itemID LIMIT 100 [3]
(3)(+0000012): Done syncing lisboarocha_these
(4)(+0000002): REPLACE INTO version (schema, version) VALUES ('lastsync', ?) [1724848975]
(3)(+0000008): Starting file syncing
(3)(+0000001): Done with file syncing
(3)(+0000002): Starting full-text syncing
(3)(+0000001): Done with full-text syncing
(3)(+0000001): Done syncing
(3)(+0000001): Notifier.trigger('finish', 'sync', []) called [observers: 3]
(4)(+0000001): SELECT libraryID AS id FROM feeds WHERE refreshInterval IS NOT NULL AND ( lastCheck IS NULL OR (julianday(lastCheck, 'utc') + (refreshInterval/1440.0) - julianday('now', 'utc')) <= 0 )
(3)(+0000005): Running update for feeds:
(3)(+0000002): All feed updates done
(3)(+0000000): Scheduling next feed update
(4)(+0000001): SELECT ( CASE WHEN lastCheck IS NULL THEN 0 ELSE strftime('%s', lastCheck) + refreshInterval * 60 - strftime('%s', 'now') END ) AS nextCheck FROM feeds WHERE refreshInterval IS NOT NULL ORDER BY nextCheck ASC LIMIT 1
(3)(+0000002): No feeds with auto-update
(3)(+0002835): WebSocket message: {"event":"topicUpdated","topic":"/groups/2191227","version":38018}
(3)(+0000002): Library is already up to date
(3)(+0002887): [Better Notes for Zotero]
(3)(+0000003): [Better Notes for Zotero] runTemplate: [item] coleta
Anything else?
No response