API tools faq
paste
Advertisement
Guest User

log

a guest
Oct 23rd, 2018
78
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.76 KB | None | 0 0
raw download clone embed print report
  1. [.....]
  2. version => 5.0.55, platform => Linux x86_64, oscpu => Linux x86_64, locale => en-US, appName => Zotero, appVersion => 5.0.55, extensions => zotxt (5.0.2, extension), Zotero LibreOffice Integration (5.0.14.SA.5.0.55, extension), ZotFile (5.0.8, extension), Zotero Voyant Export (0.0.4, extension), Shockwave Flash (31.0.0.108, plugin)
  3.  
  4. (3)(+0000000): zotero-voyant-export loaded.
  5.  
  6. (3)(+0018602): Collection selection hasn't changed
  7.  
  8. (4)(+0000498): Unregistering notifier observer in notifier with id 'itemTreeView_yu'
  9.  
  10. (3)(+0000000): Creating items view with id 3G8rxCzD
  11.  
  12. (3)(+0000002): Setting tree for C25 items view 3G8rxCzD
  13.  
  14. (3)(+0000002): Refreshing items list for 3G8rxCzD
  15.  
  16. (4)(+0000004): Collection 19 has not changed
  17.  
  18. (4)(+0000008): CREATE TEMPORARY TABLE tmpSearchResults_Eacriwcq AS SELECT itemID FROM items WHERE (itemID NOT IN (SELECT itemID FROM deletedItems) AND itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND 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 IN (SELECT itemID FROM items WHERE (libraryID=?)) AND itemID IN (SELECT itemID FROM collectionItems WHERE (collectionID IN (25))) [1]
  19.  
  20. (4)(+0000008): CREATE INDEX tmpSearchResults_Eacriwcq_itemID ON tmpSearchResults_Eacriwcq(itemID)
  21.  
  22. (4)(+0000000): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT itemID FROM items WHERE (itemID NOT IN (SELECT itemID FROM deletedItems) AND itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems))) AND itemID IN (SELECT itemID FROM items WHERE (libraryID=?))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_Eacriwcq) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_Eacriwcq)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_Eacriwcq))) [1]
  23.  
  24. (4)(+0000002): DROP TABLE IF EXISTS tmpSearchResults_Eacriwcq
  25.  
  26. (3)(+0000006): Sorting items list by title, firstCreator, date, dateAdded ascending for 22 items
  27.  
  28. (3)(+0000004): Sorted 22 items in 4 ms
  29.  
  30. (3)(+0000000): Refreshed open parents in 0 ms
  31.  
  32. (3)(+0000000): Updating tag selector with current tags
  33.  
  34. (3)(+0000002): Creating tmpSearchResults_1orradUI with 28 items
  35.  
  36. (4)(+0000002): CREATE UNIQUE INDEX tmpSearchResults_1orradUI_itemID ON tmpSearchResults_1orradUI(itemID)
  37.  
  38. (4)(+0000002): SELECT DISTINCT name AS tag, type FROM itemTags JOIN tags USING (tagID) WHERE itemID IN (SELECT itemID FROM tmpSearchResults_1orradUI)
  39.  
  40. (3)(+0000002): Refreshing tags selector
  41.  
  42. (3)(+0000000): Sorting tags
  43.  
  44. (3)(+0000000): Sorted tags in 0 ms
  45.  
  46. (3)(+0000000): Loaded tag selector in 0 ms
  47.  
  48. (3)(+0000002): Set tree for items view 3G8rxCzD in 44 ms
  49.  
  50. (3)(+0001672): doExport: collection Selected, 22 items
  51.  
  52. (3)(+0014616): doExport: saving to /home/tohigu/Sync/VoyantCollection/Selected.zip
  53.  
  54. (3)(+0000002): doExport: tmp dir is /tmp/collection-1
  55.  
  56. (4)(+0000010): 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 [240, 3, '']
  57.  
  58. (4)(+0000002): 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 [243, 3, '']
  59.  
  60. (4)(+0000002): 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 [247, 3, 'http://mitpress.universitypressscholarship.com/view/10.7551/mitpress/9780262042499.001.0001/upso-9780262042499-chapter-8']
  61.  
  62. (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 [254, 3, '']
  63.  
  64. (3)(+0000030): doExport: saving item 240
  65.  
  66. (3)(+0000008): doExport: saving item 243
  67.  
  68. (3)(+0000006): doExport: saving item 247
  69.  
  70. (3)(+0000002): doExport: saving item 254
  71.  
  72. (4)(+0001024): 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 [243, 3, '']
  73.  
  74. (4)(+0000000): 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 [254, 3, '']
  75.  
  76. (4)(+0000002): 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 [247, 3, 'http://mitpress.universitypressscholarship.com/view/10.7551/mitpress/9780262042499.001.0001/upso-9780262042499-chapter-8']
  77.  
  78. (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 [240, 3, '']
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!