Created
January 24, 2017 23:22
-
-
Save mtd91429/970cede8bbfdd6e639f2fec204927845 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Security Error: Content at resource://zotero/tinymce/note.html?locale=en-US&dir=ltr may not load or link to zotero://select/items/0_PZJQAHCA. | |
Security Error: Content at resource://zotero/tinymce/note.html?locale=en-US&dir=ltr may not load or link to zotero://select/items/0_PZJQAHCA. | |
Security Error: Content at resource://zotero/tinymce/note.html?locale=en-US&dir=ltr may not load or link to zotero://select/items/0_PZJQAHCA. | |
Security Error: Content at resource://zotero/tinymce/note.html?locale=en-US&dir=ltr may not load or link to zotero://select/items/0_PZJQAHCA. | |
Security Error: Content at resource://zotero/tinymce/note.html?locale=en-US&dir=ltr may not load or link to zotero://select/items/0_PZJQAHCA. | |
Security Error: Content at resource://zotero/tinymce/note.html?locale=en-US&dir=ltr may not load or link to zotero://select/items/0_PZJQAHCA. | |
Security Error: Content at resource://zotero/tinymce/note.html?locale=en-US&dir=ltr may not load or link to zotero://select/items/0_PZJQAHCA. | |
Security Error: Content at resource://zotero/tinymce/note.html?locale=en-US&dir=ltr may not load or link to zotero://select/items/0_PZJQAHCA. | |
Security Error: Content at resource://zotero/tinymce/note.html?locale=en-US&dir=ltr may not load or link to zotero://select/items/0_PZJQAHCA. | |
version => 5.0-beta.120+3415aae, platform => Win32, oscpu => Windows NT 6.1; WOW64, locale => en-US, appName => Zotero, appVersion => 5.0-beta.120+3415aae, extensions => Zutilo Utility for Zotero (2.0.2, extension), Zotero LibreOffice Integration (3.5.12.SA.5.0-beta.120+3415aae, extension), Zotero Word for Windows Integration (3.5.6.SA.5.0-beta.120+3415aae, extension), ZotFile (5.0.0b2, extension), AdobeAAMDetect (3.0.0.0, plugin), Adobe Acrobat (15.23.20053.15062, plugin), Google Update (1.3.32.7, plugin), NVIDIA 3D VISION (7.17.13.5445, plugin), NVIDIA 3D Vision (7.17.13.5445, plugin), Microsoft Office 2016 (16.0.4266.1001, plugin), Silverlight Plug-In (5.1.50901.0, plugin), NPLastPass (4.1.2.0, plugin), Intel® Identity Protection Technology (4.0.5.0, plugin), Intel® Identity Protection Technology (4.0.5.0, plugin), Shockwave Flash (24.0.0.186, plugin), PDF-XChange Viewer (2.5.214.2, plugin) | |
========================================================= | |
(4)(+1062960): Note hasn't changed | |
(4)(+0000000): Unregistering notifier observer in notifier with id 'Li' | |
(4)(+0000000): Unregistering notifier observer in notifier with id 'relatedbox_AV' | |
(4)(+0000000): Unregistering notifier observer in notifier with id 'noteeditor_Dn' | |
(4)(+0000000): Unregistering notifier observer in notifier with id 'tagsbox_Ts' | |
(4)(+0002553): Updating database with new item data | |
(4)(+0000001): Beginning DB transaction 0g1Ht3a8 | |
(4)(+0000002): UPDATE items SET libraryID=?, key=?, synced=?, clientDateModified=?, itemTypeID=?, dateAdded=?, dateModified=? WHERE itemID=? [1, '5T899593', 0, '2017-01-24 23:15:33', 1, '2014-08-17 17:24:55', '2017-01-24 23:15:33', 1319] | |
(3)(+0000002): Notifier.trigger('modify', 'item', [1319], {"noteEditorID":"vjWVgRuk"}) queued | |
(4)(+0000001): SELECT COUNT(*) FROM itemNotes WHERE itemID=? [1319] | |
(4)(+0000001): UPDATE itemNotes SET parentItemID=?, note=?, title=? WHERE itemID=? [683, '<div class="zotero-note znv1"><p><a href="%20zotero://select/items/0_PZJQAHCA"> zotero://select/items/0_PZJQAHCA</a></p> | |
<p><a href="http://zotero.org">http://zotero.org</a></p></div>', ' zotero://select/items/0_PZJQAHCA', 1319] | |
(3)(+0000001): Loading primaryData for 1 item in My Library | |
(4)(+0000001): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, 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 (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) || ' and ' || (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 IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (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 IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, (SELECT COUNT(*) FROM itemNotes INo WHERE parentItemID=O.itemID AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT COUNT(*) FROM itemNotes INo WHERE parentItemID=O.itemID AND INo.itemID IN (SELECT itemID FROM deletedItems)) AS numNotesTrashed, (SELECT COUNT(*) FROM itemAttachments IA JOIN itemNotes USING (itemID) WHERE IA.parentItemID=O.itemID AND note!='' AND note!='<div class="zotero-note znv1"></div>' AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotesEmbedded, (SELECT COUNT(*) FROM itemAttachments IA JOIN itemNotes USING (itemID) WHERE IA.parentItemID=O.itemID AND note!='' AND note!='<div class="zotero-note znv1"></div>' AND IA.itemID IN (SELECT itemID FROM deletedItems)) AS numNotesEmbeddedTrashed, (SELECT COUNT(*) FROM itemAttachments IA WHERE parentItemID=O.itemID AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numAttachments, (SELECT COUNT(*) FROM itemAttachments IA WHERE parentItemID=O.itemID AND IA.itemID IN (SELECT itemID FROM deletedItems)) AS numAttachmentsTrashed, (CASE O.itemTypeID WHEN 14 THEN IAP.itemID WHEN 1 THEN INoP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 14 THEN IAP.key WHEN 1 THEN INoP.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, 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 deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? AND O.itemID IN (683) [1] | |
(3)(+0000001): Loaded primaryData in My Library in 2 ms | |
(3)(+0000001): Loading childItems for 1 item in My Library | |
(4)(+0000000): SELECT parentItemID, A.itemID, value AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAttachments A JOIN items I ON (A.parentItemID=I.itemID) LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (683) [1] | |
(4)(+0000003): SELECT parentItemID, N.itemID, title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemNotes N JOIN items I ON (N.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (683) [1] | |
(4)(+0000001): SELECT itemID FROM items I WHERE libraryID=? AND itemID IN (683) AND itemID NOT IN (SELECT itemID FROM itemAttachments UNION SELECT itemID FROM itemNotes) [1] | |
(3)(+0000002): Loaded childItems in My Library in 6 ms | |
(4)(+0000003): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, 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 (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) || ' and ' || (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 IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (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 IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, (SELECT COUNT(*) FROM itemNotes INo WHERE parentItemID=O.itemID AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT COUNT(*) FROM itemNotes INo WHERE parentItemID=O.itemID AND INo.itemID IN (SELECT itemID FROM deletedItems)) AS numNotesTrashed, (SELECT COUNT(*) FROM itemAttachments IA JOIN itemNotes USING (itemID) WHERE IA.parentItemID=O.itemID AND note!='' AND note!='<div class="zotero-note znv1"></div>' AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotesEmbedded, (SELECT COUNT(*) FROM itemAttachments IA JOIN itemNotes USING (itemID) WHERE IA.parentItemID=O.itemID AND note!='' AND note!='<div class="zotero-note znv1"></div>' AND IA.itemID IN (SELECT itemID FROM deletedItems)) AS numNotesEmbeddedTrashed, (SELECT COUNT(*) FROM itemAttachments IA WHERE parentItemID=O.itemID AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numAttachments, (SELECT COUNT(*) FROM itemAttachments IA WHERE parentItemID=O.itemID AND IA.itemID IN (SELECT itemID FROM deletedItems)) AS numAttachmentsTrashed, (CASE O.itemTypeID WHEN 14 THEN IAP.itemID WHEN 1 THEN INoP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 14 THEN IAP.key WHEN 1 THEN INoP.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, 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 deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID=? [1319] | |
(3)(+0000001): Loading note for 1 item in My Library | |
(4)(+0000001): SELECT itemID, note FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID IN (1319) [1] | |
(4)(+0000001): SELECT itemID FROM items WHERE libraryID=? AND itemID IN (1319) AND itemTypeID IN (?, ?) AND itemID NOT IN (SELECT itemID FROM itemNotes) [1, 1, 14] | |
(3)(+0000001): Loaded note in My Library in 3 ms | |
(4)(+0000017): Committed DB transaction 0g1Ht3a8 | |
(3)(+0000000): Committing notifier event queue [modify-item: 1] | |
(3)(+0000001): Notifier.trigger('modify', 'item', [1319], {"1319":{"noteEditorID":"vjWVgRuk"}}) called [observers: 13] | |
(3)(+0000000): Yielding for refresh promise | |
(3)(+0000001): Refreshing hash map | |
(3)(+0000001): Refreshing hash map | |
(3)(+0000002): Yielding for select promise | |
(3)(+0000003): Cancelling auto-sync timer | |
(3)(+0000000): Setting auto-sync timeout to 15 seconds | |
(4)(+0000005): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [683, 3, ''] | |
(4)(+0005746): Note hasn't changed | |
(3)(+0000001): Viewing item in pane 0 | |
(3)(+0000000): Refreshing item box | |
(3)(+0000004): DATE: could not apply algorithms | |
(3)(+0000000): DATE: got year (2014, [{"part":"August ","before":true},{"part":""}]) | |
(3)(+0000001): DATE: got month (7, [{"part":"","before":"m"},{"part":"","after":"m"},{"part":""}]) | |
(3)(+0000841): Refreshing note editor | |
(3)(+0000002): Textbox value hasn't changed | |
(3)(+0008412): [ConcurrentCaller] Running function (0/1 running, 0 queued) | |
(3)(+0000000): Notifier.trigger('start', 'sync', []) called [observers: 2] | |
(4)(+0000002): Beginning DB transaction eqeNy5T2 | |
(4)(+0000003): Committed DB transaction eqeNy5T2 | |
(4)(+0000001): Beginning DB transaction M2rl4sTl | |
(4)(+0000002): Committed DB transaction M2rl4sTl | |
(4)(+0000001): Beginning DB transaction 56vJtPD6 | |
(4)(+0000003): Committed DB transaction 56vJtPD6 | |
(3)(+0000004): [ConcurrentCaller] Running function (0/4 running, 0 queued) | |
(3)(+0000000): HTTP GET https://api.zotero.org/keys/current | |
(3)(+0000027): HTTP GET https://api.zotero.org/keys/current succeeded with 200 | |
(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued) | |
(3)(+0000002): { | |
"userID": 563487 | |
"username": "mtd91429" | |
"access": { | |
"user": { | |
"library": true | |
"files": true | |
"notes": true | |
"write": true | |
} | |
"groups": { | |
"all": { | |
"library": true | |
"write": true | |
} | |
} | |
} | |
} | |
(4)(+0000002): Beginning DB transaction 98pb21sD | |
(3)(+0000001): [ConcurrentCaller] All tasks are done | |
(4)(+0000001): Committed DB transaction 98pb21sD | |
(3)(+0000002): [ConcurrentCaller] Running function (0/4 running, 0 queued) | |
(3)(+0000000): HTTP GET https://api.zotero.org/users/563487/groups?format=versions | |
(3)(+0000033): HTTP GET https://api.zotero.org/users/563487/groups?format=versions succeeded with 200 | |
(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued) | |
(3)(+0000002): Starting data sync for My Library | |
(4)(+0000001): SELECT setting, value FROM syncedSettings WHERE synced=0 AND libraryID=? [1] | |
(3)(+0000004): [ConcurrentCaller] All tasks are done | |
(3)(+0000001): No settings to upload in My Library | |
(4)(+0000000): SELECT O.collectionID FROM collections O WHERE libraryID=? AND synced=0 [1] | |
(4)(+0000002): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'collection'] | |
(3)(+0000001): No collections to upload in My Library | |
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 1] | |
(3)(+0000000): No collection deletions to upload in My Library | |
(4)(+0000001): SELECT O.savedSearchID FROM savedSearches O WHERE libraryID=? AND synced=0 [1] | |
(4)(+0000000): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'search'] | |
(3)(+0000001): No searches to upload in My Library | |
(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 4] | |
(3)(+0000001): No search deletions to upload in My Library | |
(4)(+0000000): SELECT O.itemID FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) WHERE libraryID=? AND synced=0 ORDER BY COALESCE(IA.parentItemID, INo.parentItemID) [1] | |
(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'item'] | |
(3)(+0000000): 1 item to upload in library 1 | |
(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 3] | |
(3)(+0000001): No item deletions to upload in My Library | |
(3)(+0000001): {"item":[1319]} | |
(4)(+0000000): Beginning DB transaction r0SbdW50 | |
(4)(+0000002): SELECT data FROM syncCache WHERE libraryID=? AND key=? AND version=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, '5T899593', 6499, 'item'] | |
(4)(+0000002): Committed DB transaction r0SbdW50 | |
(3)(+0000000): UPLOAD BATCH: | |
(3)(+0000000): [ | |
"0": { | |
"key": "5T899593" | |
"version": 6499 | |
"note": "<p><a href=\"%20zotero://select/items/0_PZJQAHCA\"> zotero://select/items/0_PZJQAHCA</a></p>\n<p><a href=\"http://zotero.org\">http://zotero.org</a></p>" | |
"dateModified": "2017-01-24T23:15:33Z" | |
} | |
] | |
(3)(+0000000): Uploading 1 item | |
(3)(+0000000): Sending If-Unmodified-Since-Version: 6499 | |
(3)(+0000002): [ConcurrentCaller] Running function (0/4 running, 0 queued) | |
(3)(+0000000): HTTP POST "[{"key":"5T899593","version":6499,"note":"<p><a href=\"%20zotero://select/items/0_PZJQAHCA\"> zotero://select/items/0_PZJQAHCA</a></p>\n<p><a href=\"http://zotero.org\">http://zotero.org</a></p>","dateModified":"2017-01-24T23:15:33Z"}]" to https://api.zotero.org/users/563487/items | |
(3)(+0000203): HTTP POST https://api.zotero.org/users/563487/items succeeded with 200 | |
(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued) | |
(4)(+0000001): Tags haven't changed | |
(4)(+0000000): Relations have not changed for item 1/5T899593 | |
(4)(+0000001): Field 'dateAdded' has not changed | |
(4)(+0000000): Field 'dateModified' has not changed | |
(3)(+0000001): Saving to sync cache: | |
(3)(+0000000): [ | |
"0": { | |
"key": "5T899593" | |
"version": 6500 | |
"library": { | |
"type": "user" | |
"id": 563487 | |
"name": "mtd91429" | |
"links": { | |
"alternate": { | |
"href": "https://www.zotero.org/mtd91429" | |
"type": "text/html" | |
} | |
} | |
} | |
"links": { | |
"self": { | |
"href": "https://api.zotero.org/users/563487/items/5T899593" | |
"type": "application/json" | |
} | |
"alternate": { | |
"href": "https://www.zotero.org/mtd91429/items/5T899593" | |
"type": "text/html" | |
} | |
"up": { | |
"href": "https://api.zotero.org/users/563487/items/NUZEHNCX" | |
"type": "application/json" | |
} | |
} | |
"meta": {} | |
"data": { | |
"key": "5T899593" | |
"version": 6500 | |
"parentItem": "NUZEHNCX" | |
"itemType": "note" | |
"note": "<p><a> zotero://select/items/0_PZJQAHCA</a></p>\n<p><a href=\"http://zotero.org\">http://zotero.org</a></p>" | |
"tags": [] | |
"relations": {} | |
"dateAdded": "2014-08-17T17:24:55Z" | |
"dateModified": "2017-01-24T23:15:33Z" | |
} | |
} | |
] | |
(4)(+0000000): Beginning DB transaction RUTTbArz | |
(3)(+0000005): [ConcurrentCaller] All tasks are done | |
(4)(+0000001): INSERT OR REPLACE INTO syncCache (libraryID, key, syncObjectTypeID, version, data) VALUES (?, ?, ?, ?, ?) [1, '5T899593', 3, 6500, '{"key":"5T899593","version":6500,"library":{"type":"user","id":563487,"name":"mtd91429","links":{"alternate":{"href":"https://www.zotero.org/mtd91429","type":"text/html"}}},"links":{"self":{"href":"https://api.zotero.org/users/563487/items/5T899593","type":"application/json"},"alternate":{"href":"https://www.zotero.org/mtd91429/items/5T899593","type":"text/html"},"up":{"href":"https://api.zotero.org/users/563487/items/NUZEHNCX","type":"application/json"}},"meta":{},"data":{"key":"5T899593","version":6500,"parentItem":"NUZEHNCX","itemType":"note","note":"<p><a> zotero://select/items/0_PZJQAHCA</a></p>\n<p><a href=\"http://zotero.org\">http://zotero.org</a></p>","tags":[],"relations":{},"dateAdded":"2014-08-17T17:24:55Z","dateModified":"2017-01-24T23:15:33Z"}}'] | |
(4)(+0000024): Committed DB transaction RUTTbArz | |
(4)(+0000000): Beginning DB transaction re2lHFOL | |
(4)(+0000002): Updating database with new item data | |
(4)(+0000000): UPDATE items SET libraryID=?, key=?, clientDateModified=?, itemTypeID=?, dateAdded=? WHERE itemID=? [1, '5T899593', '2017-01-24 23:15:49', 1, '2014-08-17 17:24:55', 1319] | |
(3)(+0000001): Notifier.trigger('modify', 'item', [1319], {"skipSelect":true}) queued | |
(4)(+0000000): SELECT COUNT(*) FROM itemNotes WHERE itemID=? [1319] | |
(4)(+0000001): UPDATE itemNotes SET parentItemID=?, note=?, title=? WHERE itemID=? [683, '<div class="zotero-note znv1"><p><a> zotero://select/items/0_PZJQAHCA</a></p> | |
<p><a href="http://zotero.org">http://zotero.org</a></p></div>', ' zotero://select/items/0_PZJQAHCA', 1319] | |
(3)(+0000000): Loading primaryData for 1 item in My Library | |
(4)(+0000001): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, 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 (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) || ' and ' || (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 IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (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 IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, (SELECT COUNT(*) FROM itemNotes INo WHERE parentItemID=O.itemID AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT COUNT(*) FROM itemNotes INo WHERE parentItemID=O.itemID AND INo.itemID IN (SELECT itemID FROM deletedItems)) AS numNotesTrashed, (SELECT COUNT(*) FROM itemAttachments IA JOIN itemNotes USING (itemID) WHERE IA.parentItemID=O.itemID AND note!='' AND note!='<div class="zotero-note znv1"></div>' AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotesEmbedded, (SELECT COUNT(*) FROM itemAttachments IA JOIN itemNotes USING (itemID) WHERE IA.parentItemID=O.itemID AND note!='' AND note!='<div class="zotero-note znv1"></div>' AND IA.itemID IN (SELECT itemID FROM deletedItems)) AS numNotesEmbeddedTrashed, (SELECT COUNT(*) FROM itemAttachments IA WHERE parentItemID=O.itemID AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numAttachments, (SELECT COUNT(*) FROM itemAttachments IA WHERE parentItemID=O.itemID AND IA.itemID IN (SELECT itemID FROM deletedItems)) AS numAttachmentsTrashed, (CASE O.itemTypeID WHEN 14 THEN IAP.itemID WHEN 1 THEN INoP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 14 THEN IAP.key WHEN 1 THEN INoP.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, 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 deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? AND O.itemID IN (683) [1] | |
(3)(+0000001): Loaded primaryData in My Library in 2 ms | |
(3)(+0000000): Loading childItems for 1 item in My Library | |
(4)(+0000000): SELECT parentItemID, A.itemID, value AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAttachments A JOIN items I ON (A.parentItemID=I.itemID) LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (683) [1] | |
(4)(+0000001): SELECT parentItemID, N.itemID, title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemNotes N JOIN items I ON (N.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (683) [1] | |
(4)(+0000001): SELECT itemID FROM items I WHERE libraryID=? AND itemID IN (683) AND itemID NOT IN (SELECT itemID FROM itemAttachments UNION SELECT itemID FROM itemNotes) [1] | |
(3)(+0000002): Loaded childItems in My Library in 4 ms | |
(4)(+0000001): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, 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 (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) || ' and ' || (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 IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (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 IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, (SELECT COUNT(*) FROM itemNotes INo WHERE parentItemID=O.itemID AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT COUNT(*) FROM itemNotes INo WHERE parentItemID=O.itemID AND INo.itemID IN (SELECT itemID FROM deletedItems)) AS numNotesTrashed, (SELECT COUNT(*) FROM itemAttachments IA JOIN itemNotes USING (itemID) WHERE IA.parentItemID=O.itemID AND note!='' AND note!='<div class="zotero-note znv1"></div>' AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotesEmbedded, (SELECT COUNT(*) FROM itemAttachments IA JOIN itemNotes USING (itemID) WHERE IA.parentItemID=O.itemID AND note!='' AND note!='<div class="zotero-note znv1"></div>' AND IA.itemID IN (SELECT itemID FROM deletedItems)) AS numNotesEmbeddedTrashed, (SELECT COUNT(*) FROM itemAttachments IA WHERE parentItemID=O.itemID AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numAttachments, (SELECT COUNT(*) FROM itemAttachments IA WHERE parentItemID=O.itemID AND IA.itemID IN (SELECT itemID FROM deletedItems)) AS numAttachmentsTrashed, (CASE O.itemTypeID WHEN 14 THEN IAP.itemID WHEN 1 THEN INoP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 14 THEN IAP.key WHEN 1 THEN INoP.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, 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 deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID=? [1319] | |
(3)(+0000001): Loading note for 1 item in My Library | |
(4)(+0000000): SELECT itemID, note FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID IN (1319) [1] | |
(4)(+0000001): SELECT itemID FROM items WHERE libraryID=? AND itemID IN (1319) AND itemTypeID IN (?, ?) AND itemID NOT IN (SELECT itemID FROM itemNotes) [1, 1, 14] | |
(3)(+0000001): Loaded note in My Library in 2 ms | |
(4)(+0000000): Updating database with new library data | |
(4)(+0000000): UPDATE libraries SET version=? WHERE libraryID=? [6500, 1] | |
(4)(+0000001): UPDATE items SET version=6500 WHERE itemID IN (?) [1319] | |
(4)(+0000001): UPDATE items SET synced=1 WHERE itemID IN (?) [1319] | |
(4)(+0000015): Committed DB transaction re2lHFOL | |
(3)(+0000001): Committing notifier event queue [modify-item: 1] | |
(3)(+0000000): Notifier.trigger('modify', 'item', [1319], {"1319":{"skipSelect":true}}) called [observers: 14] | |
(3)(+0000000): Yielding for refresh promise | |
(3)(+0000001): Refreshing hash map | |
(3)(+0000001): Refreshing hash map | |
(3)(+0000002): Yielding for select promise | |
(3)(+0000001): Refreshing note editor | |
(3)(+0000014): Setting content to <p><a> zotero://select/items/0_PZJQAHCA</a></p> | |
<p><a href="http://zotero.org">http://zotero.org</a></p> | |
(2)(+0000006): Failed: 0 | |
(4)(+0000000): Unregistering notifier observer in notifier with id 'itemsUpload_cN' | |
(3)(+0000000): Done uploading items in library 1 | |
(3)(+0000000): {} | |
(4)(+0000000): Upload result is 1 | |
(4)(+0000001): Updating database with new library data | |
(4)(+0000000): Beginning DB transaction NcoeW9ti | |
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [683, 3, ''] | |
(4)(+0000011): UPDATE libraries SET lastSync=? WHERE libraryID=? [1485299749, 1] | |
(3)(+0000009): WebSocket message: {"event":"topicUpdated","topic":"/users/563487"} | |
(3)(+0000001): [ConcurrentCaller] Already at 1 -- queueing for later | |
(4)(+0000013): Committed DB transaction NcoeW9ti | |
(3)(+0000001): Done syncing My Library | |
(4)(+0000000): REPLACE INTO version (schema, version) VALUES ('lastsync', ?) [1485299749] | |
(3)(+0000013): Starting file syncing | |
(3)(+0000000): Starting file sync for My Library | |
(4)(+0000001): Updating database with new library data | |
(4)(+0000000): Beginning DB transaction UsESOdls | |
(4)(+0000001): UPDATE libraries SET storageVersion=? WHERE libraryID=? [6500, 1] | |
(4)(+0000012): Committed DB transaction UsESOdls | |
(4)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE libraryID=? AND linkMode IN (?,?) AND syncState IN (?) AND storageModTime>=? [1, 0, 1, 2, 1485288949368] | |
(3)(+0000000): Zotero.Libraries.getName() is deprecated. Use Zotero.Library.prototype.name instead | |
(3)(+0000001): No files to check for local changes | |
(4)(+0000000): SELECT itemID, version FROM items JOIN itemAttachments USING (itemID) WHERE libraryID=? AND syncState=? [1, 5] | |
(4)(+0000001): SELECT COUNT(*) FROM items JOIN itemAttachments USING (itemID) WHERE libraryID=? AND syncState=? [1, 4] | |
(3)(+0000001): No remote storage changes for My Library -- skipping file downloads | |
(4)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE libraryID=? AND syncState IN (?,?) AND linkMode IN (?,?) [1, 0, 3, 0, 1] | |
(3)(+0000001): No files to upload for My Library | |
(3)(+0000000): File download sync finished for My Library (0 succeeded, 0 failed) | |
(3)(+0000001): File upload sync finished for My Library (0 succeeded, 0 failed) | |
(4)(+0000000): No data changed in library 1 -- not saving | |
(4)(+0000000): SELECT value FROM settings WHERE setting=? AND key=? ['storage', 'zfsPurge'] | |
(3)(+0000001): No local changes made during file sync | |
(3)(+0000000): Done with file sync for My Library | |
(3)(+0000000): Done with file syncing | |
(3)(+0000000): Starting full-text syncing | |
(3)(+0000000): Starting full-text sync for My Library | |
(4)(+0000000): SELECT version FROM version WHERE schema=? ['fulltext_1'] | |
(3)(+0000001): Downloading full-text content for My Library | |
(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued) | |
(3)(+0000000): HTTP GET https://api.zotero.org/users/563487/fulltext?format=versions&since=6499 | |
(3)(+0000051): HTTP GET https://api.zotero.org/users/563487/fulltext?format=versions&since=6499 succeeded with 200 | |
(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued) | |
(4)(+0000002): REPLACE INTO version VALUES (?, ?) ['fulltext_1', '6500'] | |
(3)(+0000001): [ConcurrentCaller] All tasks are done | |
(3)(+0000015): Uploading full-text content for My Library | |
(4)(+0000000): SELECT itemID, indexedChars, totalChars, indexedPages, totalPages FROM fulltextItems FI JOIN items I USING (itemID) WHERE libraryID=? AND FI.synced=? AND I.synced=1 ORDER BY itemID DESC [1, 0] | |
(2)(+0000001): Full-text content cache file doesn't exist for item 1/JCKRF9AU | |
(2)(+0000001): Full-text content cache file doesn't exist for item 1/KB4AQ7RP | |
(2)(+0000000): Full-text content cache file doesn't exist for item 1/QBWTXPBU | |
(3)(+0000000): Done with full-text syncing | |
(3)(+0000001): Done syncing | |
(3)(+0000000): Notifier.trigger('finish', 'sync', []) called [observers: 2] | |
(4)(+0000000): 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)(+0000001): [ConcurrentCaller] Done with function (0/1 running, 1 queued) | |
(3)(+0000000): Running update for feeds: | |
(3)(+0000000): All feed updates done | |
(3)(+0000000): Scheduling next feed update | |
(4)(+0000000): 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)(+0000006): [ConcurrentCaller] Running function (0/1 running, 0 queued) | |
(3)(+0000001): Notifier.trigger('start', 'sync', []) called [observers: 2] | |
(4)(+0000001): Beginning DB transaction AUMjXZqJ | |
(3)(+0000001): Next feed check in 1798 seconds | |
(4)(+0000001): Committed DB transaction AUMjXZqJ | |
(4)(+0000000): Beginning DB transaction Kxf6zpnO | |
(4)(+0000003): Committed DB transaction Kxf6zpnO | |
(4)(+0000000): Beginning DB transaction KoHBqvem | |
(4)(+0000002): Committed DB transaction KoHBqvem | |
(3)(+0000002): [ConcurrentCaller] Running function (0/4 running, 0 queued) | |
(3)(+0000001): HTTP GET https://api.zotero.org/keys/current | |
(3)(+0000037): HTTP GET https://api.zotero.org/keys/current succeeded with 200 | |
(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued) | |
(3)(+0000001): { | |
"userID": 563487 | |
"username": "mtd91429" | |
"access": { | |
"user": { | |
"library": true | |
"files": true | |
"notes": true | |
"write": true | |
} | |
"groups": { | |
"all": { | |
"library": true | |
"write": true | |
} | |
} | |
} | |
} | |
(4)(+0000001): Beginning DB transaction CgIlZ4vl | |
(3)(+0000001): [ConcurrentCaller] All tasks are done | |
(4)(+0000000): Committed DB transaction CgIlZ4vl | |
(3)(+0000002): [ConcurrentCaller] Running function (0/4 running, 0 queued) | |
(3)(+0000000): HTTP GET https://api.zotero.org/users/563487/groups?format=versions | |
(3)(+0000034): HTTP GET https://api.zotero.org/users/563487/groups?format=versions succeeded with 200 | |
(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued) | |
(3)(+0000002): Starting data sync for My Library | |
(4)(+0000000): SELECT setting, value FROM syncedSettings WHERE synced=0 AND libraryID=? [1] | |
(3)(+0000001): [ConcurrentCaller] All tasks are done | |
(3)(+0000000): No settings to upload in My Library | |
(4)(+0000000): SELECT O.collectionID FROM collections O WHERE libraryID=? AND synced=0 [1] | |
(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'collection'] | |
(3)(+0000000): No collections to upload in My Library | |
(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 1] | |
(3)(+0000001): No collection deletions to upload in My Library | |
(4)(+0000000): SELECT O.savedSearchID FROM savedSearches O WHERE libraryID=? AND synced=0 [1] | |
(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'search'] | |
(3)(+0000000): No searches to upload in My Library | |
(4)(+0000001): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 4] | |
(3)(+0000000): No search deletions to upload in My Library | |
(4)(+0000000): SELECT O.itemID FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) WHERE libraryID=? AND synced=0 ORDER BY COALESCE(IA.parentItemID, INo.parentItemID) [1] | |
(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'item'] | |
(3)(+0000001): No items to upload in My Library | |
(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 3] | |
(3)(+0000000): No item deletions to upload in My Library | |
(4)(+0000000): Upload result is 2 | |
(3)(+0000002): [ConcurrentCaller] Running function (0/4 running, 0 queued) | |
(3)(+0000000): HTTP GET https://api.zotero.org/users/563487/settings?since=6500 | |
(3)(+0000036): HTTP GET https://api.zotero.org/users/563487/settings?since=6500 succeeded with 304 | |
(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued) | |
(3)(+0000001): Library 1 hasn't been modified -- skipping further object downloads | |
(4)(+0000000): Download result is 3 | |
(4)(+0000000): Updating database with new library data | |
(4)(+0000000): Beginning DB transaction gZyaMZup | |
(3)(+0000001): [ConcurrentCaller] All tasks are done | |
(4)(+0000001): UPDATE libraries SET lastSync=? WHERE libraryID=? [1485299749, 1] | |
(4)(+0000021): Committed DB transaction gZyaMZup | |
(3)(+0000000): Done syncing My Library | |
(4)(+0000000): REPLACE INTO version (schema, version) VALUES ('lastsync', ?) [1485299750] | |
(3)(+0000012): Starting file syncing | |
(3)(+0000001): Starting file sync for My Library | |
(4)(+0000000): No data changed in library 1 -- not saving | |
(4)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE libraryID=? AND linkMode IN (?,?) AND syncState IN (?) AND storageModTime>=? [1, 0, 1, 2, 1485288949628] | |
(3)(+0000001): Zotero.Libraries.getName() is deprecated. Use Zotero.Library.prototype.name instead | |
(3)(+0000000): No files to check for local changes | |
(4)(+0000000): SELECT itemID, version FROM items JOIN itemAttachments USING (itemID) WHERE libraryID=? AND syncState=? [1, 5] | |
(4)(+0000001): SELECT COUNT(*) FROM items JOIN itemAttachments USING (itemID) WHERE libraryID=? AND syncState=? [1, 4] | |
(3)(+0000000): No remote storage changes for My Library -- skipping file downloads | |
(4)(+0000001): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE libraryID=? AND syncState IN (?,?) AND linkMode IN (?,?) [1, 0, 3, 0, 1] | |
(3)(+0000001): No files to upload for My Library | |
(3)(+0000000): File download sync finished for My Library (0 succeeded, 0 failed) | |
(3)(+0000001): File upload sync finished for My Library (0 succeeded, 0 failed) | |
(4)(+0000000): No data changed in library 1 -- not saving | |
(4)(+0000001): SELECT value FROM settings WHERE setting=? AND key=? ['storage', 'zfsPurge'] | |
(3)(+0000002): No local changes made during file sync | |
(3)(+0000001): Done with file sync for My Library | |
(3)(+0000000): Done with file syncing | |
(3)(+0000000): Starting full-text syncing | |
(3)(+0000000): Starting full-text sync for My Library | |
(4)(+0000000): SELECT version FROM version WHERE schema=? ['fulltext_1'] | |
(3)(+0000001): Library version hasn't changed -- skipping full-text download | |
(3)(+0000000): Uploading full-text content for My Library | |
(4)(+0000000): SELECT itemID, indexedChars, totalChars, indexedPages, totalPages FROM fulltextItems FI JOIN items I USING (itemID) WHERE libraryID=? AND FI.synced=? AND I.synced=1 ORDER BY itemID DESC [1, 0] | |
(2)(+0000001): Full-text content cache file doesn't exist for item 1/JCKRF9AU | |
(2)(+0000001): Full-text content cache file doesn't exist for item 1/KB4AQ7RP | |
(2)(+0000000): Full-text content cache file doesn't exist for item 1/QBWTXPBU | |
(3)(+0000000): Done with full-text syncing | |
(3)(+0000001): Done syncing | |
(3)(+0000000): Notifier.trigger('finish', 'sync', []) called [observers: 2] | |
(4)(+0000000): 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)(+0000000): [ConcurrentCaller] Done with function (0/1 running, 0 queued) | |
(3)(+0000001): Running update for feeds: | |
(3)(+0000000): All feed updates done | |
(3)(+0000000): Scheduling next feed update | |
(4)(+0000000): 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)(+0000001): [ConcurrentCaller] All tasks are done | |
(3)(+0000000): Next feed check in 1798 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment