From jonascj, 3 Years ago, written in Plain Text.
  1. zotero(3)(+0000000): Using data directory /home/jonas/.zotero/zotero/wkoovh9d.default/zotero
  2.  
  3. zotero(3)(+0000000): IPC: Initializing pipe at /home/jonas/.zotero/zotero/wkoovh9d.default/zotero/pipes/1432998024292
  4.  
  5. zotero(3)(+0000001): Loading in full mode
  6.  
  7. zotero(3)(+0000000): Opening database 'zotero'
  8.  
  9. zotero(5)(+0000006): PRAGMA locking_mode=EXCLUSIVE
  10.  
  11. zotero(3)(+0000001): IPC: Trying to broadcast "releaseLock /home/jonas/.zotero/zotero/wkoovh9d.default/zotero/zotero.sqlite" to instance 1432997996271
  12.  
  13. zotero(3)(+0000100): IPC: Removing defunct pipe 1432997996271
  14.  
  15. zotero(5)(+0000000): SELECT version FROM version WHERE schema='system'
  16.  
  17. zotero(5)(+0000000): SELECT version FROM version WHERE schema='userdata'
  18.  
  19. zotero(3)(+0000002): IPC: Received "test"
  20.  
  21. zotero(5)(+0000005): SELECT version FROM version WHERE schema='userdata2'
  22.  
  23. zotero(3)(+0000002): Proxy not required for http://zotero.org.s3.amazonaws.com/proxy-auth
  24.  
  25. zotero(5)(+0000003): Beginning DB transaction
  26.  
  27. zotero(3)(+0000000): Beginning Notifier event queue
  28.  
  29. zotero(3)(+0000001): Updating custom tables
  30.  
  31. zotero(5)(+0000000): DELETE FROM itemTypesCombined
  32.  
  33. zotero(5)(+0000001): DELETE FROM fieldsCombined
  34.  
  35. zotero(5)(+0000000): DELETE FROM itemTypeFieldsCombined
  36.  
  37. zotero(5)(+0000000): DELETE FROM baseFieldMappingsCombined
  38.  
  39. zotero(5)(+0000000): INSERT INTO itemTypesCombined SELECT itemTypeID, typeName, display, 0 AS custom FROM itemTypes UNION SELECT customItemTypeID + 10000 AS itemTypeID, typeName, display, 1 AS custom FROM customItemTypes
  40.  
  41. zotero(5)(+0000000): INSERT INTO fieldsCombined SELECT fieldID, fieldName, NULL AS label, fieldFormatID, 0 AS custom FROM fields UNION SELECT customFieldID + 10000 AS fieldID, fieldName, label, NULL, 1 AS custom FROM customFields
  42.  
  43. zotero(5)(+0000001): INSERT INTO itemTypeFieldsCombined SELECT itemTypeID, fieldID, hide, orderIndex FROM itemTypeFields UNION SELECT customItemTypeID + 10000 AS itemTypeID, COALESCE(fieldID, customFieldID + 10000) AS fieldID, hide, orderIndex FROM customItemTypeFields
  44.  
  45. zotero(5)(+0000003): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings
  46.  
  47. zotero(5)(+0000001): SELECT version FROM version WHERE schema='triggers'
  48.  
  49. zotero(5)(+0000003): Committing transaction
  50.  
  51. zotero(3)(+0000154): Resetting Notifier event queue
  52.  
  53. zotero(5)(+0000001): ATTACH ':memory:' AS 'indexing'
  54.  
  55. zotero(5)(+0000001): CREATE TABLE indexing.fulltextWords (word NOT NULL)
  56.  
  57. zotero(3)(+0000001): pdftotext-Linux-x86_64 not found -- PDF indexing disabled
  58.  
  59. zotero(5)(+0000000): SELECT * FROM fulltextItems LIMIT 1
  60.  
  61. zotero(3)(+0000000): Initializing full-text content ingester idle observer
  62.  
  63. zotero(3)(+0000001): Opening database 'zotero' for dummy statement
  64.  
  65. zotero(3)(+0000001): Initializing dummy statement for 'zotero'
  66.  
  67. zotero(3)(+0000000): Updating custom tables
  68.  
  69. zotero(5)(+0000000): DELETE FROM itemTypesCombined
  70.  
  71. zotero(5)(+0000103): DELETE FROM fieldsCombined
  72.  
  73. zotero(5)(+0000099): DELETE FROM itemTypeFieldsCombined
  74.  
  75. zotero(5)(+0000100): DELETE FROM baseFieldMappingsCombined
  76.  
  77. zotero(5)(+0000099): INSERT INTO itemTypesCombined SELECT itemTypeID, typeName, display, 0 AS custom FROM itemTypes UNION SELECT customItemTypeID + 10000 AS itemTypeID, typeName, display, 1 AS custom FROM customItemTypes
  78.  
  79. zotero(5)(+0000100): INSERT INTO fieldsCombined SELECT fieldID, fieldName, NULL AS label, fieldFormatID, 0 AS custom FROM fields UNION SELECT customFieldID + 10000 AS fieldID, fieldName, label, NULL, 1 AS custom FROM customFields
  80.  
  81. zotero(5)(+0000099): INSERT INTO itemTypeFieldsCombined SELECT itemTypeID, fieldID, hide, orderIndex FROM itemTypeFields UNION SELECT customItemTypeID + 10000 AS itemTypeID, COALESCE(fieldID, customFieldID + 10000) AS fieldID, hide, orderIndex FROM customItemTypeFields
  82.  
  83. zotero(5)(+0000132): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings
  84.  
  85. zotero(3)(+0000116): HTTP GET resource://zotero/schema/renamed-styles.json
  86.  
  87. zotero(3)(+0000002): HTTP server listening on  127.0.0.1:23119
  88.  
  89. zotero(4)(+0000001): Registering observer for [setting] in notifier with hash H0'
  90.  
  91. zotero(5)(+0000000): Beginning DB transaction
  92.  
  93. zotero(3)(+0000000): Beginning Notifier event queue
  94.  
  95. zotero(5)(+0000000): SELECT version FROM version WHERE schema='syncdeletelog'
  96.  
  97. zotero(5)(+0000000): Committing transaction
  98.  
  99. zotero(3)(+0000000): Resetting Notifier event queue
  100.  
  101. zotero(4)(+0000001): Registering observer for all types in notifier with hash WO'
  102.  
  103. zotero(4)(+0000000): Registering observer for all types in notifier with hash 3y'
  104.  
  105. zotero(3)(+0000000): Initializing sync idle observer
  106.  
  107. zotero(3)(+0000001): Registering URIContentListener
  108.  
  109. zotero(5)(+0000000): SELECT * FROM proxies
  110.  
  111. zotero(3)(+0000003): Triggering "zotero-loaded" event
  112.  
  113. zotero(3)(+0000000): Initialized in 1195 ms
  114.  
  115. zotero(3)(+0000014): Loading BBT
  116.  
  117. zotero(3)(+0000102): Setting mode to note
  118.  
  119. zotero(3)(+0000000): Setting mode to note
  120.  
  121. zotero(3)(+0000000): Setting mode to note
  122.  
  123. zotero(3)(+0000000): Setting mode to note
  124.  
  125. zotero(4)(+0000001): Registering observer for [item-tag,setting] in notifier with hash CS'
  126.  
  127. zotero(4)(+0000056): Registering observer for [collection,search,share,group,trash,bucket] in notifier with hash 3l'
  128.  
  129. zotero(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID IS NULL AND libraryID IS NULL
  130.  
  131. zotero(3)(+0000001): Reloading all collections
  132.  
  133. zotero(5)(+0000000): SELECT ROWID FROM collections
  134.  
  135. zotero(5)(+0000000): SELECT C.*, (SELECT COUNT(*) FROM collections WHERE parentCollectionID=C.collectionID)!=0 AS hasChildCollections, (SELECT COUNT(*) FROM collectionItems WHERE collectionID=C.collectionID)!=0 AS hasChildItems FROM collections C WHERE 1
  136.  
  137. zotero(5)(+0000001): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE
  138.  
  139. zotero(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =3
  140.  
  141. zotero(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE
  142.  
  143. zotero(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =4
  144.  
  145. zotero(5)(+0000000): No child collections of collection 4
  146.  
  147. zotero(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE
  148.  
  149. zotero(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =1
  150.  
  151. zotero(5)(+0000000): No child collections of collection 1
  152.  
  153. zotero(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE
  154.  
  155. zotero(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =6
  156.  
  157. zotero(5)(+0000000): No child collections of collection 6
  158.  
  159. zotero(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE
  160.  
  161. zotero(5)(+0000000): SELECT fieldName FROM fieldsCombined WHERE fieldName NOT IN ('accessDate', 'date', 'pages', 'section','seriesNumber','issue')
  162.  
  163. zotero(5)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined
  164.  
  165. zotero(1)(+0000001): Invalid item type nsfReviewer
  166.  
  167. zotero(1)(+0000000): Invalid item type nsfReviewer
  168.  
  169. zotero(5)(+0000000): SELECT DISTINCT fieldID FROM baseFieldMappingsCombined
  170.  
  171. zotero(5)(+0000000): SELECT * FROM fieldFormats
  172.  
  173. zotero(5)(+0000001): SELECT * FROM fieldsCombined
  174.  
  175. zotero(5)(+0000001): SELECT fieldID, itemTypeID FROM itemTypeFieldsCombined
  176.  
  177. zotero(5)(+0000005): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined
  178.  
  179. zotero(5)(+0000001): SELECT IT.itemTypeID, F.fieldID AS baseFieldID, BFM.fieldID FROM itemTypesCombined IT LEFT JOIN fieldsCombined F LEFT JOIN baseFieldMappingsCombined BFM ON (IT.itemTypeID=BFM.itemTypeID AND F.fieldID=BFM.baseFieldID)
  180.  
  181. zotero(5)(+0000040): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined
  182.  
  183. zotero(5)(+0000006): SELECT baseFieldID, fieldID, fieldName FROM baseFieldMappingsCombined JOIN fieldsCombined USING (fieldID)
  184.  
  185. zotero(5)(+0000003): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE libraryID IS NULL
  186.  
  187. zotero(5)(+0000000): SELECT I.*, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS firstCreator, (SELECT COUNT(*) FROM itemNotes INo WHERE sourceItemID=I.itemID AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT COUNT(*) FROM itemAttachments IA WHERE sourceItemID=I.itemID AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numAttachments, (CASE I.itemTypeID WHEN 14 THEN (SELECT sourceItemID FROM itemAttachments IA WHERE IA.itemID=I.itemID) WHEN 1 THEN (SELECT sourceItemID FROM itemNotes INo WHERE INo.itemID=I.itemID) END) AS sourceItemID FROM items I WHERE 1 AND I.itemID IN (64,80)
  188.  
  189. zotero(5)(+0000001): SELECT fieldID FROM itemTypeFieldsCombined WHERE itemTypeID=4 ORDER BY orderIndex
  190.  
  191. zotero(5)(+0000001): SELECT * FROM items LIMIT 1
  192.  
  193. zotero(5)(+0000000): SELECT groupID FROM groups ORDER BY name COLLATE locale
  194.  
  195. zotero(4)(+0000001): Registering observer for [item,collection-item,item-tag,share-items,bucket] in notifier with hash k7'
  196.  
  197. zotero(3)(+0000001): Refreshing items list
  198.  
  199. zotero(5)(+0000004): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE display IN (1,2)
  200.  
  201. zotero(5)(+0000008): SELECT subject FROM relations WHERE predicate != ? UNION SELECT object FROM relations WHERE predicate != ?
  202.  
  203. zotero(5)(+0000001): Binding parameter 1 of type string: "dc:isReplacedBy"
  204.  
  205. zotero(5)(+0000000): Binding parameter 2 of type string: "dc:isReplacedBy"
  206.  
  207. zotero(3)(+0000000): Purged data tables in 1 ms
  208.  
  209. zotero(3)(+0000063): ZoteroOpenOfficeIntegration: Communication server listening on 127.0.0.1:23116
  210.  
  211. zotero(3)(+0000000): ZoteroOpenOfficeIntegration: Registering shutdown listener
  212.  
  213. zotero(5)(+0000041): Beginning DB transaction
  214.  
  215. zotero(3)(+0000000): Beginning Notifier event queue
  216.  
  217. zotero(3)(+0000000): Caching fields [title,date,firstCreator,extra]
  218.  
  219. zotero(5)(+0000000): SELECT I.*, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS firstCreator, (SELECT COUNT(*) FROM itemNotes INo WHERE sourceItemID=I.itemID AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT COUNT(*) FROM itemAttachments IA WHERE sourceItemID=I.itemID AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numAttachments, (CASE I.itemTypeID WHEN 14 THEN (SELECT sourceItemID FROM itemAttachments IA WHERE IA.itemID=I.itemID) WHEN 1 THEN (SELECT sourceItemID FROM itemNotes INo WHERE INo.itemID=I.itemID) END) AS sourceItemID FROM items I WHERE 1
  220.  
  221. zotero(5)(+0000017): SELECT fieldID FROM itemTypeFieldsCombined WHERE itemTypeID=14 ORDER BY orderIndex
  222.  
  223. zotero(5)(+0000003): SELECT fieldID FROM itemTypeFieldsCombined WHERE itemTypeID=1 ORDER BY orderIndex
  224.  
  225. zotero(5)(+0000001): SELECT fieldID FROM itemTypeFieldsCombined WHERE itemTypeID=2 ORDER BY orderIndex
  226.  
  227. zotero(5)(+0000002): SELECT itemID FROM items
  228.  
  229. zotero(5)(+0000001): SELECT itemID, fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE fieldID IN (110,111,112,113,14,96,52,100,22)
  230.  
  231. zotero(5)(+0000005): SELECT itemID, title FROM itemNotes WHERE itemID NOT IN (SELECT itemID FROM itemAttachments)
  232.  
  233. zotero(5)(+0000002): Transaction in progress -- increasing level to 1
  234.  
  235. zotero(5)(+0000000): SELECT ROWID FROM collections WHERE libraryID IS NULL AND key=?
  236.  
  237. zotero(5)(+0000000): Binding parameter 1 of type string: "7TBRQSXC"
  238.  
  239. zotero(5)(+0000000): CREATE TEMPORARY TABLE tmpSearchResults_pX3UvKUz AS SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) ) AND (itemID NOT IN (SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL)) AND itemID IN (SELECT itemID FROM collectionItems WHERE (collectionID IN (?)))
  240.  
  241. zotero(5)(+0000000): Binding parameter 1 of type int: 6
  242.  
  243. zotero(5)(+0000001): CREATE INDEX tmpSearchResults_pX3UvKUz_itemID ON tmpSearchResults_pX3UvKUz(itemID)
  244.  
  245. zotero(5)(+0000000): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) )) AND (itemID IN (SELECT itemID FROM tmpSearchResults_pX3UvKUz) OR itemID IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_pX3UvKUz)) OR itemID IN (SELECT itemID FROM itemNotes WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_pX3UvKUz)))
  246.  
  247. zotero(5)(+0000001): DROP TABLE tmpSearchResults_pX3UvKUz
  248.  
  249. zotero(5)(+0000000): Decreasing transaction level to 0
  250.  
  251. zotero(5)(+0000000): Committing transaction
  252.  
  253. zotero(3)(+0000000): Resetting Notifier event queue
  254.  
  255. zotero(3)(+0000010): Updating tag selector with current tags
  256.  
  257. zotero(5)(+0000000): Beginning DB transaction
  258.  
  259. zotero(3)(+0000000): Beginning Notifier event queue
  260.  
  261. zotero(5)(+0000000): CREATE TEMPORARY TABLE tmpSearchResults_1ZmHZNtl (itemID INT)
  262.  
  263. zotero(5)(+0000001): INSERT INTO tmpSearchResults_1ZmHZNtl SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
  264.  
  265. zotero(5)(+0000000): INSERT INTO tmpSearchResults_1ZmHZNtl SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
  266.  
  267. zotero(5)(+0000000): CREATE INDEX tmpSearchResults_1ZmHZNtl_itemID ON tmpSearchResults_1ZmHZNtl(itemID)
  268.  
  269. zotero(5)(+0000000): Committing transaction
  270.  
  271. zotero(3)(+0000001): Resetting Notifier event queue
  272.  
  273. zotero(5)(+0000000): SELECT DISTINCT tagID, name, type FROM itemTags NATURAL JOIN tags WHERE itemID IN (SELECT itemID FROM tmpSearchResults_1ZmHZNtl)
  274.  
  275. zotero(4)(+0000000): Registering observer for [collection-item,item-tag,tag,setting] in notifier with hash Jt'
  276.  
  277. zotero(3)(+0000000): Refreshing tags selector
  278.  
  279. zotero(3)(+0000000): Set tree in 163 ms
  280.  
  281. zotero(5)(+0000001): SELECT value FROM syncedSettings WHERE setting=? AND libraryID=?
  282.  
  283. zotero(5)(+0000000): Binding parameter 1 of type string: "tagColors"
  284.  
  285. zotero(5)(+0000000): Binding parameter 2 of type int: 0
  286.  
  287. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE libraryID IS NULL AND type IN (0,1)
  288.  
  289. zotero(3)(+0000001): Reloading all tags
  290.  
  291. zotero(5)(+0000000): SELECT ROWID FROM tags
  292.  
  293. zotero(5)(+0000000): SELECT * FROM tags WHERE 1
  294.  
  295. zotero(5)(+0000028): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  296.  
  297. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  298.  
  299. zotero(5)(+0000003): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  300.  
  301. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  302.  
  303. zotero(3)(+0000540): No general proxy or PAC file found -- assuming direct connection
  304.  
  305. zotero(3)(+0000279): Getting Zotero sync password
  306.  
  307. zotero(5)(+0000020): SELECT subject FROM relations WHERE predicate != ? UNION SELECT object FROM relations WHERE predicate != ?
  308.  
  309. zotero(5)(+0000000): Binding parameter 1 of type string: "dc:isReplacedBy"
  310.  
  311. zotero(5)(+0000000): Binding parameter 2 of type string: "dc:isReplacedBy"
  312.  
  313. zotero(3)(+0000001): ===>false<===(boolean)
  314.  
  315. zotero(3)(+0000000): Notifier.trigger('redraw', 'collection', []) called [observers: 8]
  316.  
  317. zotero(4)(+0000000): Calling notify('redraw') on observer with hash '0y'
  318.  
  319. zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'H0'
  320.  
  321. zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'WO'
  322.  
  323. zotero(5)(+0000000): UPDATE syncObjectTypes SET name='relation' WHERE syncObjectTypeID=6 AND name='relations'
  324.  
  325. zotero(5)(+0000000): SELECT * FROM syncObjectTypes
  326.  
  327. zotero(5)(+0000000): Beginning DB transaction
  328.  
  329. zotero(3)(+0000000): Beginning Notifier event queue
  330.  
  331. zotero(5)(+0000000): Committing transaction
  332.  
  333. zotero(3)(+0000000): Resetting Notifier event queue
  334.  
  335. zotero(4)(+0000000): Calling notify('redraw') on observer with hash '3y'
  336.  
  337. zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'CS'
  338.  
  339. zotero(4)(+0000000): Calling notify('redraw') on observer with hash '3l'
  340.  
  341. zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'k7'
  342.  
  343. zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'Jt'
  344.  
  345. zotero(3)(+0000000): Session ID not available -- logging in
  346.  
  347. zotero(5)(+0000000): SELECT version FROM version WHERE schema='userdata'
  348.  
  349. zotero(3)(+0000000): HTTP POST version=9&username=jonascj&password=******** to https://sync.zotero.org/login
  350.  
  351. zotero(3)(+0000520): ===>false<===(boolean)
  352.  
  353. zotero(3)(+0000000): Notifier.trigger('redraw', 'collection', []) called [observers: 8]
  354.  
  355. zotero(4)(+0000001): Calling notify('redraw') on observer with hash '0y'
  356.  
  357. zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'H0'
  358.  
  359. zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'WO'
  360.  
  361. zotero(5)(+0000000): Beginning DB transaction
  362.  
  363. zotero(3)(+0000000): Beginning Notifier event queue
  364.  
  365. zotero(5)(+0000000): Committing transaction
  366.  
  367. zotero(3)(+0000000): Resetting Notifier event queue
  368.  
  369. zotero(4)(+0000000): Calling notify('redraw') on observer with hash '3y'
  370.  
  371. zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'CS'
  372.  
  373. zotero(4)(+0000000): Calling notify('redraw') on observer with hash '3l'
  374.  
  375. zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'k7'
  376.  
  377. zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'Jt'
  378.  
  379. zotero(3)(+0000000): Beginning server sync
  380.  
  381. zotero(5)(+0000000): SELECT version FROM version WHERE schema='lastremotesync'
  382.  
  383. zotero(5)(+0000000): SELECT version FROM version WHERE schema='lastlocalsync'
  384.  
  385. zotero(5)(+0000000): SELECT value FROM settings WHERE setting='fulltext' AND key='downloadAll'
  386.  
  387. zotero(5)(+0000000): SELECT itemID FROM fulltextItems WHERE synced=3
  388.  
  389. zotero(3)(+0000001): HTTP POST version=9&sessionid=********&lastsync=1432998000&ft=1 to https://sync.zotero.org/updated
  390.  
  391. zotero(3)(+0000294): <?xml version="1.0"?>
  392. <response version="9" timestamp="1432998028" userID="2204430" defaultLibraryID="1983720" updateKey="e3b1870a1e5672ccef5829539464ac37" earliest="1398841199"><updated/></response>
  393.  
  394.  
  395. zotero(5)(+0000000): Beginning DB transaction
  396.  
  397. zotero(3)(+0000000): Beginning Notifier event queue
  398.  
  399. zotero(5)(+0000001): SELECT value FROM settings WHERE setting='account' AND key='username'
  400.  
  401. zotero(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND key='userID'
  402.  
  403. zotero(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND key='libraryID'
  404.  
  405. zotero(5)(+0000001): Committing transaction
  406.  
  407. zotero(3)(+0000000): Resetting Notifier event queue
  408.  
  409. zotero(5)(+0000000): Beginning DB transaction
  410.  
  411. zotero(3)(+0000000): Beginning Notifier event queue
  412.  
  413. zotero(3)(+0000001): Getting updated local creators
  414.  
  415. zotero(5)(+0000000): SELECT ROWID FROM creators WHERE dateModified<?
  416.  
  417. zotero(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
  418.  
  419. zotero(5)(+0000001): SELECT ROWID FROM creators WHERE clientDateModified>?
  420.  
  421. zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"
  422.  
  423. zotero(3)(+0000000): Getting updated local items
  424.  
  425. zotero(5)(+0000001): SELECT ROWID FROM items WHERE dateModified<?
  426.  
  427. zotero(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
  428.  
  429. zotero(5)(+0000000): SELECT ROWID FROM items WHERE clientDateModified>?
  430.  
  431. zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"
  432.  
  433. zotero(3)(+0000000): Getting updated local collections
  434.  
  435. zotero(5)(+0000000): SELECT ROWID FROM collections WHERE dateModified<?
  436.  
  437. zotero(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
  438.  
  439. zotero(5)(+0000000): SELECT ROWID FROM collections WHERE clientDateModified>?
  440.  
  441. zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"
  442.  
  443. zotero(3)(+0000000): Getting updated local searches
  444.  
  445. zotero(5)(+0000000): SELECT ROWID FROM savedSearches WHERE dateModified<?
  446.  
  447. zotero(5)(+0000001): Binding parameter 1 of type string: "0000-00-00 00:00:00"
  448.  
  449. zotero(5)(+0000000): SELECT ROWID FROM savedSearches WHERE clientDateModified>?
  450.  
  451. zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"
  452.  
  453. zotero(3)(+0000000): Getting updated local tags
  454.  
  455. zotero(5)(+0000000): SELECT ROWID FROM tags WHERE dateModified<?
  456.  
  457. zotero(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
  458.  
  459. zotero(5)(+0000000): SELECT ROWID FROM tags WHERE clientDateModified>?
  460.  
  461. zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"
  462.  
  463. zotero(3)(+0000000): Getting updated local relations
  464.  
  465. zotero(5)(+0000000): SELECT ROWID FROM relations WHERE clientDateModified<?
  466.  
  467. zotero(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
  468.  
  469. zotero(5)(+0000000): SELECT ROWID FROM relations WHERE clientDateModified>?
  470.  
  471. zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"
  472.  
  473. zotero(5)(+0000000): SELECT version FROM version WHERE schema='syncdeletelog'
  474.  
  475. zotero(5)(+0000000): SELECT syncObjectTypeID, libraryID, key FROM syncDeleteLog WHERE timestamp>? ORDER BY timestamp
  476.  
  477. zotero(5)(+0000001): Binding parameter 1 of type int: 1432997999
  478.  
  479. zotero(3)(+0000000): No changes received from server
  480.  
  481. zotero(3)(+0000000): Processing locally changed creators
  482.  
  483. zotero(3)(+0000000): Processing locally changed items
  484.  
  485. zotero(3)(+0000000): Processing locally changed collections
  486.  
  487. zotero(3)(+0000000): Processing locally changed searches
  488.  
  489. zotero(3)(+0000000): Processing locally changed tags
  490.  
  491. zotero(3)(+0000000): Processing locally changed relations
  492.  
  493. zotero(3)(+0000000): Processing locally changed fulltexts
  494.  
  495. zotero(5)(+0000000): SELECT libraryID, setting, value FROM syncedSettings WHERE synced=0
  496.  
  497. zotero(5)(+0000001): SELECT itemID, indexedChars, totalChars, indexedPages, totalPages FROM fulltextItems JOIN items USING (itemID) WHERE synced=0 ORDER BY clientDateModified DESC
  498.  
  499. zotero(3)(+0000000): Processing locally deleted creators
  500.  
  501. zotero(3)(+0000000): Processing locally deleted items
  502.  
  503. zotero(3)(+0000000): Processing locally deleted collections
  504.  
  505. zotero(3)(+0000000): Processing locally deleted searches
  506.  
  507. zotero(3)(+0000000): Processing locally deleted tags
  508.  
  509. zotero(3)(+0000000): Processing locally deleted relations
  510.  
  511. zotero(3)(+0000000): Processing locally deleted settings
  512.  
  513. zotero(3)(+0000000): Processing locally deleted fulltexts
  514.  
  515. zotero(3)(+0000000): Nothing to upload to server
  516.  
  517. zotero(5)(+0000000): REPLACE INTO version VALUES ('lastremotesync', ?)
  518.  
  519. zotero(5)(+0000000): Binding parameter 1 of type string: "1432998028"
  520.  
  521. zotero(5)(+0000000): REPLACE INTO version VALUES ('lastlocalsync', ?)
  522.  
  523. zotero(5)(+0000000): Binding parameter 1 of type int: 1432998027
  524.  
  525. zotero(5)(+0000000): Committing transaction
  526.  
  527. zotero(3)(+0000133): Resetting Notifier event queue
  528.  
  529. zotero(3)(+0000000): Starting file sync
  530.  
  531. zotero(5)(+0000003): SELECT groupID FROM groups ORDER BY name COLLATE locale
  532.  
  533. zotero(3)(+0000000): HTTP GET https://jonascj:********@api.zotero.org/?auth=1
  534.  
  535. zotero(3)(+0001293): Credentials are cached
  536.  
  537. zotero(3)(+0000001): ZFS credentials are already cached
  538.  
  539. zotero(3)(+0000001): HTTP GET https://jonascj:********@api.zotero.org/users/2204430/laststoragesync
  540.  
  541. zotero(3)(+0000133): HTTP GET https://jonascj:********@api.zotero.org/users/2204430/laststoragesync succeeded with 200
  542.  
  543. zotero(3)(+0000001): 1432900157
  544.  
  545. zotero(3)(+0000001): Last successful ZFS sync for library 0 was Fri May 29 2015 13:49:17 GMT+0200 (CEST)
  546.  
  547. zotero(3)(+0000001): Checking for locally changed attachment files in library 0
  548.  
  549. zotero(5)(+0000000): Beginning DB transaction
  550.  
  551. zotero(3)(+0000000): Beginning Notifier event queue
  552.  
  553. zotero(5)(+0000000): SELECT itemID, linkMode, path, storageModTime, storageHash, syncState FROM itemAttachments JOIN items USING (itemID) WHERE linkMode IN (?,?) AND syncState IN (?,?) AND libraryID IS NULL
  554.  
  555. zotero(5)(+0000001): Binding parameter 1 of type int: 0
  556.  
  557. zotero(5)(+0000000): Binding parameter 2 of type int: 1
  558.  
  559. zotero(5)(+0000000): Binding parameter 3 of type int: 0
  560.  
  561. zotero(5)(+0000000): Binding parameter 4 of type int: 2
  562.  
  563. zotero(5)(+0000003): Committing transaction
  564.  
  565. zotero(3)(+0000000): Resetting Notifier event queue
  566.  
  567. zotero(3)(+0000000): Checking attachment file for item 0/INS4IWWK
  568.  
  569. zotero(3)(+0000004): Checking attachment file for item 0/N45BPH8D
  570.  
  571. zotero(3)(+0000006): Checking attachment file for item 0/F2Q59VCR
  572.  
  573. zotero(3)(+0000002): Checking attachment file for item 0/3868F68T
  574.  
  575. zotero(3)(+0000001): Checking attachment file for item 0/NJANSRPG
  576.  
  577. zotero(3)(+0000002): Checking attachment file for item 0/RXQAIPXB
  578.  
  579. zotero(3)(+0000001): Checking attachment file for item 0/7IU7AM5N
  580.  
  581. zotero(3)(+0000003): Checking attachment file for item 0/44ATPDTB
  582.  
  583. zotero(3)(+0000004): Checking attachment file for item 0/65AS5HEM
  584.  
  585. zotero(3)(+0000003): Checking attachment file for item 0/42W2IAP3
  586.  
  587. zotero(3)(+0000002): Checking attachment file for item 0/FCMK3CFZ
  588.  
  589. zotero(3)(+0000002): Checking attachment file for item 0/5H2NS9BK
  590.  
  591. zotero(3)(+0000001): Checking attachment file for item 0/T2CEIRG6
  592.  
  593. zotero(3)(+0000002): Checking attachment file for item 0/MJVP5BNP
  594.  
  595. zotero(3)(+0000001): Checking attachment file for item 0/B9ZKMCJZ
  596.  
  597. zotero(3)(+0000002): Checking attachment file for item 0/X3QTREE2
  598.  
  599. zotero(3)(+0000001): Checking attachment file for item 0/KCBN9RDR
  600.  
  601. zotero(3)(+0000004): Checking attachment file for item 0/TDVZHR9I
  602.  
  603. zotero(3)(+0000002): Checking attachment file for item 0/98C6FSAD
  604.  
  605. zotero(3)(+0000001): Checking attachment file for item 0/IPHCXGVR
  606.  
  607. zotero(3)(+0000001): Checking attachment file for item 0/78JXJB5K
  608.  
  609. zotero(3)(+0000002): Checking attachment file for item 0/RIXDHQJ7
  610.  
  611. zotero(3)(+0000002): Checking attachment file for item 0/2FZ5VU77
  612.  
  613. zotero(3)(+0000001): Checking attachment file for item 0/MTA9X7S6
  614.  
  615. zotero(3)(+0000001): Checking attachment file for item 0/RQSN3Q6H
  616.  
  617. zotero(3)(+0000002): Checking attachment file for item 0/SBS8T9B7
  618.  
  619. zotero(3)(+0000002): Checking attachment file for item 0/F39WRSK3
  620.  
  621. zotero(3)(+0000002): Checking attachment file for item 0/HTXJA8IA
  622.  
  623. zotero(3)(+0000001): Checking attachment file for item 0/5E4UM9ZR
  624.  
  625. zotero(3)(+0000002): Checking attachment file for item 0/QDJBXZEQ
  626.  
  627. zotero(3)(+0000001): Checking attachment file for item 0/M7236N7J
  628.  
  629. zotero(3)(+0000001): Checking attachment file for item 0/K68P68UV
  630.  
  631. zotero(3)(+0000002): Checking attachment file for item 0/6SXKPVNG
  632.  
  633. zotero(3)(+0000002): Checking attachment file for item 0/CU3ZCBHV
  634.  
  635. zotero(3)(+0000001): Checking attachment file for item 0/R2KZPFM5
  636.  
  637. zotero(3)(+0000002): Checking attachment file for item 0/GNH4PTG3
  638.  
  639. zotero(3)(+0000001): Checking attachment file for item 0/TE85FVCM
  640.  
  641. zotero(3)(+0000002): Checking attachment file for item 0/PCEM6K7E
  642.  
  643. zotero(3)(+0000001): Checking attachment file for item 0/7EB789QI
  644.  
  645. zotero(3)(+0000002): Checking attachment file for item 0/KWAZE72S
  646.  
  647. zotero(3)(+0000001): Checking attachment file for item 0/NB736JPW
  648.  
  649. zotero(3)(+0000002): Checking attachment file for item 0/MF5JGZ76
  650.  
  651. zotero(3)(+0000001): Checking attachment file for item 0/3BPHBKZM
  652.  
  653. zotero(3)(+0000002): Checking attachment file for item 0/JUQ7G4W8
  654.  
  655. zotero(3)(+0000002): Checking attachment file for item 0/CQTD2VXV
  656.  
  657. zotero(3)(+0000001): Checking attachment file for item 0/6BXE6XUK
  658.  
  659. zotero(3)(+0000002): Checking attachment file for item 0/I5ZPJFWI
  660.  
  661. zotero(3)(+0000001): Checking attachment file for item 0/BDDIA29J
  662.  
  663. zotero(3)(+0000004): Checking attachment file for item 0/AEHFFWUS
  664.  
  665. zotero(3)(+0000001): Checking attachment file for item 0/WFDM9UV7
  666.  
  667. zotero(3)(+0000002): Checking attachment file for item 0/KFN23SB8
  668.  
  669. zotero(3)(+0000001): Checking attachment file for item 0/H2W9T3SZ
  670.  
  671. zotero(3)(+0000001): Checking attachment file for item 0/BQBWBJZW
  672.  
  673. zotero(3)(+0000002): Checking attachment file for item 0/4WE7UZSV
  674.  
  675. zotero(3)(+0000001): Checking attachment file for item 0/6DJNQRGX
  676.  
  677. zotero(3)(+0000002): Checking attachment file for item 0/C2HWZDGW
  678.  
  679. zotero(3)(+0000001): Checking attachment file for item 0/67UJBTZP
  680.  
  681. zotero(3)(+0000002): Checking attachment file for item 0/86GQ25G3
  682.  
  683. zotero(3)(+0000001): Checking attachment file for item 0/WA92RRIK
  684.  
  685. zotero(3)(+0000002): Checking attachment file for item 0/HXTSPD3T
  686.  
  687. zotero(3)(+0000001): Checking attachment file for item 0/RN4USVKR
  688.  
  689. zotero(3)(+0000002): Checking attachment file for item 0/ZVXWC4JF
  690.  
  691. zotero(3)(+0000002): Checking attachment file for item 0/MF4WPJ77
  692.  
  693. zotero(3)(+0000001): Checking attachment file for item 0/EI4V54GM
  694.  
  695. zotero(3)(+0000002): Checking attachment file for item 0/87EN3HFH
  696.  
  697. zotero(3)(+0000001): No synced files have changed locally
  698.  
  699. zotero(3)(+0000000): Checked 65 files in library 0 in 116ms
  700.  
  701. zotero(5)(+0000000): SELECT COUNT(*) FROM items JOIN itemAttachments USING (itemID) WHERE libraryID IS NULL AND syncState=?
  702.  
  703. zotero(5)(+0000001): Binding parameter 1 of type int: 4
  704.  
  705. zotero(5)(+0000000): SELECT version FROM version WHERE schema=?
  706.  
  707. zotero(5)(+0000000): Binding parameter 1 of type string: "storage_zfs_0"
  708.  
  709. zotero(5)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE libraryID IS NULL AND syncState IN (?,?) AND path!=''
  710.  
  711. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  712.  
  713. zotero(5)(+0000000): Binding parameter 2 of type int: 1
  714.  
  715. zotero(5)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE syncState IN (?,?) AND linkMode IN (?,?) AND libraryID IS NULL
  716.  
  717. zotero(5)(+0000000): Binding parameter 1 of type int: 0
  718.  
  719. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  720.  
  721. zotero(5)(+0000000): Binding parameter 3 of type int: 0
  722.  
  723. zotero(5)(+0000000): Binding parameter 4 of type int: 1
  724.  
  725. zotero(3)(+0000000): Starting file sync queues for library 0
  726.  
  727. zotero(3)(+0000000): No files to sync for library 0
  728.  
  729. zotero(3)(+0000001): All storage queues are finished for library 0
  730.  
  731. zotero(3)(+0000000): Queue manager is finished
  732.  
  733. zotero(3)(+0000000): No local changes made during file sync
  734.  
  735. zotero(3)(+0000000): ZFS credentials are already cached
  736.  
  737. zotero(3)(+0000000): File sync is finished
  738.  
  739. zotero(5)(+0000357): SELECT version FROM version WHERE schema='delete'
  740.  
  741. zotero(5)(+0000001): SELECT version FROM version WHERE schema=?
  742.  
  743. zotero(5)(+0000000): Binding parameter 1 of type string: "translators"
  744.  
  745. zotero(3)(+0000000): Installed translators are up-to-date with translators.zip
  746.  
  747. zotero(5)(+0000002): SELECT version FROM version WHERE schema='delete'
  748.  
  749. zotero(5)(+0000000): SELECT version FROM version WHERE schema=?
  750.  
  751. zotero(5)(+0000000): Binding parameter 1 of type string: "styles"
  752.  
  753. zotero(3)(+0000000): Installed styles are up-to-date with styles.zip
  754.  
  755. zotero(5)(+0000001): SELECT version FROM version WHERE schema='lastcheck'
  756.  
  757. zotero(4)(+0000000): Not enough time since last update -- not checking repository
  758.  
  759. zotero(3)(+0000000): Setting repository check interval to 85790 seconds
  760.  
  761. zotero(5)(+0000818): DROP TABLE tmpSearchResults_1ZmHZNtl
  762.  
  763. zotero(3)(+0000001): Refreshing items list
  764.  
  765. zotero(5)(+0000001): Beginning DB transaction
  766.  
  767. zotero(3)(+0000000): Beginning Notifier event queue
  768.  
  769. zotero(3)(+0000000): Caching fields [title,date,firstCreator,extra]
  770.  
  771. zotero(5)(+0000004): Transaction in progress -- increasing level to 1
  772.  
  773. zotero(5)(+0000001): SELECT ROWID FROM collections WHERE libraryID IS NULL AND key=?
  774.  
  775. zotero(5)(+0000000): Binding parameter 1 of type string: "7TBRQSXC"
  776.  
  777. zotero(5)(+0000000): CREATE TEMPORARY TABLE tmpSearchResults_iIHICSWx AS SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) ) AND (itemID NOT IN (SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL)) AND itemID IN (SELECT itemID FROM collectionItems WHERE (collectionID IN (?)))
  778.  
  779. zotero(5)(+0000001): Binding parameter 1 of type int: 6
  780.  
  781. zotero(5)(+0000001): CREATE INDEX tmpSearchResults_iIHICSWx_itemID ON tmpSearchResults_iIHICSWx(itemID)
  782.  
  783. zotero(5)(+0000001): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) )) AND ((itemID IN (SELECT itemID FROM itemData WHERE (valueID IN (SELECT valueID FROM itemDataValues WHERE value LIKE ?))) OR itemID IN (SELECT itemID FROM itemTags WHERE (tagID IN (SELECT tagID FROM tags WHERE name LIKE ?))) OR itemID IN (SELECT itemID FROM itemNotes WHERE (note LIKE ?)) OR itemID IN (SELECT itemID FROM itemCreators WHERE (creatorID IN (SELECT creatorID FROM creators NATURAL JOIN creatorData WHERE TRIM(firstName || ' ' || lastName) LIKE ?)))))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_iIHICSWx) OR itemID IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_iIHICSWx)) OR itemID IN (SELECT itemID FROM itemNotes WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_iIHICSWx)))
  784.  
  785. zotero(5)(+0000000): Binding parameter 1 of type string: "%-%"
  786.  
  787. zotero(5)(+0000000): Binding parameter 2 of type string: "%-%"
  788.  
  789. zotero(5)(+0000000): Binding parameter 3 of type string: "%-%"
  790.  
  791. zotero(5)(+0000000): Binding parameter 4 of type string: "%-%"
  792.  
  793. zotero(5)(+0000004): DROP TABLE tmpSearchResults_iIHICSWx
  794.  
  795. zotero(5)(+0000000): Decreasing transaction level to 0
  796.  
  797. zotero(5)(+0000000): Committing transaction
  798.  
  799. zotero(3)(+0000000): Resetting Notifier event queue
  800.  
  801. zotero(5)(+0000001): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)
  802.  
  803. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  804.  
  805. zotero(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
  806.  
  807. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  808.  
  809. zotero(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)
  810.  
  811. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  812.  
  813. zotero(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
  814.  
  815. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  816.  
  817. zotero(3)(+0000002): Updating tag selector with current tags
  818.  
  819. zotero(5)(+0000000): Beginning DB transaction
  820.  
  821. zotero(3)(+0000000): Beginning Notifier event queue
  822.  
  823. zotero(5)(+0000000): CREATE TEMPORARY TABLE tmpSearchResults_OwtlwUnd (itemID INT)
  824.  
  825. zotero(5)(+0000000): INSERT INTO tmpSearchResults_OwtlwUnd SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
  826.  
  827. zotero(5)(+0000001): INSERT INTO tmpSearchResults_OwtlwUnd SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
  828.  
  829. zotero(5)(+0000000): CREATE INDEX tmpSearchResults_OwtlwUnd_itemID ON tmpSearchResults_OwtlwUnd(itemID)
  830.  
  831. zotero(5)(+0000000): Committing transaction
  832.  
  833. zotero(3)(+0000001): Resetting Notifier event queue
  834.  
  835. zotero(5)(+0000000): SELECT DISTINCT tagID, name, type FROM itemTags NATURAL JOIN tags WHERE itemID IN (SELECT itemID FROM tmpSearchResults_OwtlwUnd)
  836.  
  837. zotero(3)(+0000000): Refreshing tags selector
  838.  
  839. zotero(5)(+0000004): SELECT linkMode FROM itemAttachments WHERE itemID=?
  840.  
  841. zotero(5)(+0000000): Binding parameter 1 of type int: 43
  842.  
  843. zotero(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?
  844.  
  845. zotero(5)(+0000000): Binding parameter 1 of type int: 43
  846.  
  847. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  848.  
  849. zotero(5)(+0000000): Binding parameter 1 of type int: 43
  850.  
  851. zotero(5)(+0000001): SELECT linkMode FROM itemAttachments WHERE itemID=?
  852.  
  853. zotero(5)(+0000000): Binding parameter 1 of type int: 42
  854.  
  855. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  856.  
  857. zotero(5)(+0000000): Binding parameter 1 of type int: 42
  858.  
  859. zotero(5)(+0000002): SELECT linkMode FROM itemAttachments WHERE itemID=?
  860.  
  861. zotero(5)(+0000000): Binding parameter 1 of type int: 71
  862.  
  863. zotero(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?
  864.  
  865. zotero(5)(+0000000): Binding parameter 1 of type int: 71
  866.  
  867. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  868.  
  869. zotero(5)(+0000001): Binding parameter 1 of type int: 71
  870.  
  871. zotero(5)(+0000000): SELECT linkMode FROM itemAttachments WHERE itemID=?
  872.  
  873. zotero(5)(+0000000): Binding parameter 1 of type int: 53
  874.  
  875. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  876.  
  877. zotero(5)(+0000000): Binding parameter 1 of type int: 53
  878.  
  879. zotero(3)(+0066630): Checking for unprocessed full-text content
  880.  
  881. zotero(5)(+0000000): SELECT itemID FROM fulltextItems WHERE synced=2
  882.  
  883. zotero(3)(+0000001): No unprocessed full-text content found
  884.  
  885. zotero(3)(+0276951): Backing up database 'zotero'
  886.  
  887. zotero(5)(+0000000): PRAGMA locking_mode=NORMAL
  888.  
  889. zotero(3)(+0000000): Stopping dummy statement for 'zotero'
  890.  
  891. zotero(5)(+0000099): PRAGMA locking_mode=EXCLUSIVE
  892.  
  893. zotero(3)(+0000000): Opening database 'zotero' for dummy statement
  894.  
  895. zotero(3)(+0000000): Initializing dummy statement for 'zotero'
  896.  
  897. zotero(3)(+0000007): Moving zotero.sqlite.bak to zotero.sqlite.1.bak
  898.  
  899. zotero(3)(+0000001): Backed up to zotero.sqlite.bak
  900.  
  901. zotero(3)(+0227021): Viewing item in pane 0
  902.  
  903. zotero(3)(+0000000): Refreshing item box
  904.  
  905. zotero(5)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined
  906.  
  907. zotero(5)(+0000013): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?
  908.  
  909. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  910.  
  911. zotero(3)(+0000003): DATE: could not apply algorithms
  912.  
  913. zotero(3)(+0000001): DATE: got year (2013, [{"part":"Aug 21, ","before":true},{"part":""}])
  914.  
  915. zotero(3)(+0000000): DATE: got month (7, [{"part":"","before":"m"},{"part":"21, ","after":"m"},{"part":""}])
  916.  
  917. zotero(3)(+0000000): DATE: got day (21, [{"part":"","before":"m"},{"part":", "},{"part":""}])
  918.  
  919. zotero(5)(+0000007): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name
  920.  
  921. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  922.  
  923. zotero(5)(+0000001): SELECT creatorTypeID AS id, creatorType AS name FROM creatorTypes
  924.  
  925. zotero(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex
  926.  
  927. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  928.  
  929. zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
  930.  
  931. zotero(5)(+0000000): Binding parameter 1 of type int: 73
  932.  
  933. zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
  934.  
  935. zotero(5)(+0000000): Binding parameter 1 of type int: 86
  936.  
  937. zotero(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?
  938.  
  939. zotero(5)(+0000000): Binding parameter 1 of type int: 87
  940.  
  941. zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
  942.  
  943. zotero(5)(+0000000): Binding parameter 1 of type int: 88
  944.  
  945. zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
  946.  
  947. zotero(5)(+0000000): Binding parameter 1 of type int: 89
  948.  
  949. zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
  950.  
  951. zotero(5)(+0000000): Binding parameter 1 of type int: 76
  952.  
  953. zotero(3)(+0000000): Loading data for creator 73 in Zotero.Creator.load()
  954.  
  955. zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?
  956.  
  957. zotero(5)(+0000000): Binding parameter 1 of type int: 73
  958.  
  959. zotero(3)(+0000013): Loading data for creator 86 in Zotero.Creator.load()
  960.  
  961. zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?
  962.  
  963. zotero(5)(+0000000): Binding parameter 1 of type int: 86
  964.  
  965. zotero(3)(+0000008): Loading data for creator 87 in Zotero.Creator.load()
  966.  
  967. zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?
  968.  
  969. zotero(5)(+0000000): Binding parameter 1 of type int: 87
  970.  
  971. zotero(3)(+0000004): Loading data for creator 88 in Zotero.Creator.load()
  972.  
  973. zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?
  974.  
  975. zotero(5)(+0000001): Binding parameter 1 of type int: 88
  976.  
  977. zotero(3)(+0000005): Loading data for creator 89 in Zotero.Creator.load()
  978.  
  979. zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?
  980.  
  981. zotero(5)(+0000000): Binding parameter 1 of type int: 89
  982.  
  983. zotero(3)(+0000008): Loading data for creator 76 in Zotero.Creator.load()
  984.  
  985. zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?
  986.  
  987. zotero(5)(+0000000): Binding parameter 1 of type int: 76
  988.  
  989. zotero(5)(+0000467): 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 sourceItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY mimeType='application/pdf' DESC, value=? DESC, dateAdded ASC
  990.  
  991. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  992.  
  993. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  994.  
  995. zotero(5)(+0000000): Binding parameter 3 of type string: ""
  996.  
  997. zotero(5)(+0000001): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?
  998.  
  999. zotero(5)(+0000000): Binding parameter 1 of type int: 71
  1000.  
  1001. zotero(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?
  1002.  
  1003. zotero(5)(+0000000): Binding parameter 1 of type int: 53
  1004.  
  1005. zotero(5)(+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 sourceItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY mimeType='application/pdf' DESC, value=? DESC, dateAdded ASC
  1006.  
  1007. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  1008.  
  1009. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  1010.  
  1011. zotero(5)(+0000000): Binding parameter 3 of type string: ""
  1012.  
  1013. zotero(5)(+0000001): 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 sourceItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY mimeType='application/pdf' DESC, value=? DESC, dateAdded ASC
  1014.  
  1015. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  1016.  
  1017. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  1018.  
  1019. zotero(5)(+0000000): Binding parameter 3 of type string: ""
  1020.  
  1021. zotero(5)(+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 sourceItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY mimeType='application/pdf' DESC, value=? DESC, dateAdded ASC
  1022.  
  1023. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  1024.  
  1025. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  1026.  
  1027. zotero(5)(+0000000): Binding parameter 3 of type string: ""
  1028.  
  1029. zotero(5)(+0000000): SELECT path FROM itemAttachments WHERE itemID=?
  1030.  
  1031. zotero(5)(+0000000): Binding parameter 1 of type int: 71
  1032.  
  1033. zotero(3)(+0000001): MIME type application/pdf can be handled by plugins
  1034.  
  1035. zotero(5)(+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 sourceItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY mimeType='application/pdf' DESC, value=? DESC, dateAdded ASC
  1036.  
  1037. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  1038.  
  1039. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  1040.  
  1041. zotero(5)(+0000000): Binding parameter 3 of type string: ""
  1042.  
  1043. zotero(5)(+0001999): SELECT leafName, translatorJSON, code, lastModifiedTime FROM translatorCache
  1044.  
  1045. zotero(3)(+0000064): Cached 468 translators in 64 ms
  1046.  
  1047. zotero(3)(+0000000): Translate: All translator detect calls and RPC calls complete
  1048.  
  1049. zotero(3)(+0000038): Loading BBT
  1050.  
  1051. zotero(4)(+0011203): Translate: Binding sandbox to http://www.example.com/
  1052.  
  1053. zotero(4)(+0000003): Translate: Parsing code for Better BibTeX
  1054.  
  1055. zotero(3)(+0000031): Translate: Beginning translation with Better BibTeX
  1056.  
  1057. zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
  1058.  
  1059. zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
  1060.  
  1061. zotero(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
  1062.  
  1063. zotero(5)(+0000000): Binding parameter 1 of type int: 71
  1064.  
  1065. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  1066.  
  1067. zotero(5)(+0000000): Binding parameter 1 of type int: 71
  1068.  
  1069. zotero(5)(+0000001): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
  1070.  
  1071. zotero(5)(+0000000): Binding parameter 1 of type int: 71
  1072.  
  1073. zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
  1074.  
  1075. zotero(5)(+0000000): Binding parameter 1 of type int: 71
  1076.  
  1077. zotero(3)(+0000000): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
  1078.  
  1079. zotero(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
  1080.  
  1081. zotero(5)(+0000000): Binding parameter 1 of type int: 53
  1082.  
  1083. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  1084.  
  1085. zotero(5)(+0000000): Binding parameter 1 of type int: 53
  1086.  
  1087. zotero(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
  1088.  
  1089. zotero(5)(+0000000): Binding parameter 1 of type int: 53
  1090.  
  1091. zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
  1092.  
  1093. zotero(5)(+0000000): Binding parameter 1 of type int: 53
  1094.  
  1095. zotero(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  1096.  
  1097. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  1098.  
  1099. zotero(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
  1100.  
  1101. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  1102.  
  1103. zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
  1104.  
  1105. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  1106.  
  1107. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1108.  
  1109. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1110.  
  1111. zotero(5)(+0000000): Binding parameter 2 of type int: 90
  1112.  
  1113. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1114.  
  1115. zotero(5)(+0000001): Binding parameter 1 of type int: 4
  1116.  
  1117. zotero(5)(+0000000): Binding parameter 2 of type int: 5
  1118.  
  1119. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1120.  
  1121. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1122.  
  1123. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  1124.  
  1125. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1126.  
  1127. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1128.  
  1129. zotero(5)(+0000000): Binding parameter 2 of type int: 28
  1130.  
  1131. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1132.  
  1133. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1134.  
  1135. zotero(5)(+0000000): Binding parameter 2 of type int: 29
  1136.  
  1137. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1138.  
  1139. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1140.  
  1141. zotero(5)(+0000000): Binding parameter 2 of type int: 25
  1142.  
  1143. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1144.  
  1145. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1146.  
  1147. zotero(5)(+0000000): Binding parameter 2 of type int: 87
  1148.  
  1149. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1150.  
  1151. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1152.  
  1153. zotero(5)(+0000000): Binding parameter 2 of type int: 26
  1154.  
  1155. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1156.  
  1157. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1158.  
  1159. zotero(5)(+0000000): Binding parameter 2 of type int: 13
  1160.  
  1161. zotero(5)(+0000001): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1162.  
  1163. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1164.  
  1165. zotero(5)(+0000000): Binding parameter 2 of type int: 116
  1166.  
  1167. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1168.  
  1169. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1170.  
  1171. zotero(5)(+0000000): Binding parameter 2 of type int: 1
  1172.  
  1173. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1174.  
  1175. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1176.  
  1177. zotero(5)(+0000000): Binding parameter 2 of type int: 27
  1178.  
  1179. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1180.  
  1181. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1182.  
  1183. zotero(5)(+0000000): Binding parameter 2 of type int: 123
  1184.  
  1185. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1186.  
  1187. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1188.  
  1189. zotero(5)(+0000000): Binding parameter 2 of type int: 19
  1190.  
  1191. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1192.  
  1193. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1194.  
  1195. zotero(5)(+0000000): Binding parameter 2 of type int: 62
  1196.  
  1197. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1198.  
  1199. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1200.  
  1201. zotero(5)(+0000000): Binding parameter 2 of type int: 18
  1202.  
  1203. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1204.  
  1205. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1206.  
  1207. zotero(5)(+0000000): Binding parameter 2 of type int: 2
  1208.  
  1209. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1210.  
  1211. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1212.  
  1213. zotero(5)(+0000000): Binding parameter 2 of type int: 22
  1214.  
  1215. zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
  1216.  
  1217. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  1218.  
  1219. zotero(5)(+0000000): Binding parameter 1 of type int: 71
  1220.  
  1221. zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
  1222.  
  1223. zotero(5)(+0000000): Binding parameter 1 of type int: 71
  1224.  
  1225. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1226.  
  1227. zotero(5)(+0000000): Binding parameter 1 of type int: 14
  1228.  
  1229. zotero(5)(+0000000): Binding parameter 2 of type int: 27
  1230.  
  1231. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1232.  
  1233. zotero(5)(+0000000): Binding parameter 1 of type int: 14
  1234.  
  1235. zotero(5)(+0000000): Binding parameter 2 of type int: 1
  1236.  
  1237. zotero(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
  1238.  
  1239. zotero(5)(+0000000): Binding parameter 1 of type int: 71
  1240.  
  1241. zotero(5)(+0000000): SELECT charsetID AS id, charset AS name FROM charsets
  1242.  
  1243. zotero(1)(+0000003): Invalid character set null
  1244.  
  1245. zotero(3)(+0000000): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
  1246.  
  1247. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  1248.  
  1249. zotero(5)(+0000000): Binding parameter 1 of type int: 53
  1250.  
  1251. zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
  1252.  
  1253. zotero(5)(+0000000): Binding parameter 1 of type int: 53
  1254.  
  1255. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1256.  
  1257. zotero(5)(+0000001): Binding parameter 1 of type int: 14
  1258.  
  1259. zotero(5)(+0000000): Binding parameter 2 of type int: 27
  1260.  
  1261. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1262.  
  1263. zotero(5)(+0000000): Binding parameter 1 of type int: 14
  1264.  
  1265. zotero(5)(+0000000): Binding parameter 2 of type int: 1
  1266.  
  1267. zotero(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?
  1268.  
  1269. zotero(5)(+0000000): Binding parameter 1 of type int: 53
  1270.  
  1271. zotero(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
  1272.  
  1273. zotero(5)(+0000000): Binding parameter 1 of type int: 53
  1274.  
  1275. zotero(1)(+0000000): Invalid character set null
  1276.  
  1277. zotero(5)(+0000000): Translate: Running handler 0 for itemDone
  1278.  
  1279. zotero(5)(+0000001): Spinning event loop (1)
  1280.  
  1281. zotero(2)(+0000092): Translate: Translation using Better BibTeX failed:
  1282. string => TypeError: Zotero.BetterBibTeX is undefined
  1283. stack => Translator.nextItem@/home/jonas/.zotero/zotero/wkoovh9d.default/zotero/translators/Better BibTeX.js:989
  1284. doExport@/home/jonas/.zotero/zotero/wkoovh9d.default/zotero/translators/Better BibTeX.js:8035
  1285.  
  1286. url => /tmp/Exported Items.bib
  1287. downloadAssociatedFiles => true
  1288. automaticSnapshots => true
  1289.  
  1290. zotero(5)(+0000000): Translate: Running handler 0 for done
  1291.  
  1292. zotero(5)(+0002694): SELECT collectionID FROM collections WHERE collectionID IN (SELECT collectionID FROM collectionItems WHERE itemID=?)
  1293.  
  1294. zotero(5)(+0000000): Binding parameter 1 of type int: 44
  1295.  
  1296. zotero(3)(+0238888): Viewing item in pane 0
  1297.  
  1298. zotero(3)(+0000000): Refreshing item box
  1299.  
  1300. zotero(5)(+0000010): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?
  1301.  
  1302. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  1303.  
  1304. zotero(3)(+0000004): DATE: retrieved with algorithms: {"order":"ymd","year":2007,"month":10,"day":1}
  1305.  
  1306. zotero(5)(+0000010): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex
  1307.  
  1308. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  1309.  
  1310. zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
  1311.  
  1312. zotero(5)(+0000000): Binding parameter 1 of type int: 74
  1313.  
  1314. zotero(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?
  1315.  
  1316. zotero(5)(+0000000): Binding parameter 1 of type int: 75
  1317.  
  1318. zotero(3)(+0000000): Loading data for creator 74 in Zotero.Creator.load()
  1319.  
  1320. zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?
  1321.  
  1322. zotero(5)(+0000000): Binding parameter 1 of type int: 74
  1323.  
  1324. zotero(3)(+0000008): Loading data for creator 75 in Zotero.Creator.load()
  1325.  
  1326. zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?
  1327.  
  1328. zotero(5)(+0000000): Binding parameter 1 of type int: 75
  1329.  
  1330. zotero(5)(+0000349): 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 sourceItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY mimeType='application/pdf' DESC, value=? DESC, dateAdded ASC
  1331.  
  1332. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  1333.  
  1334. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  1335.  
  1336. zotero(5)(+0000000): Binding parameter 3 of type string: "http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2025644/"
  1337.  
  1338. zotero(5)(+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 sourceItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY mimeType='application/pdf' DESC, value=? DESC, dateAdded ASC
  1339.  
  1340. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  1341.  
  1342. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  1343.  
  1344. zotero(5)(+0000000): Binding parameter 3 of type string: "http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2025644/"
  1345.  
  1346. zotero(5)(+0000001): 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 sourceItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY mimeType='application/pdf' DESC, value=? DESC, dateAdded ASC
  1347.  
  1348. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  1349.  
  1350. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  1351.  
  1352. zotero(5)(+0000001): Binding parameter 3 of type string: "http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2025644/"
  1353.  
  1354. zotero(5)(+0000001): 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 sourceItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY mimeType='application/pdf' DESC, value=? DESC, dateAdded ASC
  1355.  
  1356. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  1357.  
  1358. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  1359.  
  1360. zotero(5)(+0000000): Binding parameter 3 of type string: "http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2025644/"
  1361.  
  1362. zotero(5)(+0000001): SELECT path FROM itemAttachments WHERE itemID=?
  1363.  
  1364. zotero(5)(+0000000): Binding parameter 1 of type int: 43
  1365.  
  1366. zotero(3)(+0000002): MIME type application/pdf can be handled by plugins
  1367.  
  1368. zotero(5)(+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 sourceItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY mimeType='application/pdf' DESC, value=? DESC, dateAdded ASC
  1369.  
  1370. zotero(5)(+0000001): Binding parameter 1 of type int: 41
  1371.  
  1372. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  1373.  
  1374. zotero(5)(+0000000): Binding parameter 3 of type string: "http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2025644/"
  1375.  
  1376. zotero(3)(+0001918): Translate: All translator detect calls and RPC calls complete
  1377.  
  1378. zotero(3)(+0000020): Loading BBT
  1379.  
  1380. zotero(4)(+0008035): Translate: Binding sandbox to http://www.example.com/
  1381.  
  1382. zotero(4)(+0000004): Translate: Parsing code for Better BibTeX
  1383.  
  1384. zotero(3)(+0000029): Translate: Beginning translation with Better BibTeX
  1385.  
  1386. zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
  1387.  
  1388. zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
  1389.  
  1390. zotero(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?
  1391.  
  1392. zotero(5)(+0000001): Binding parameter 1 of type int: 43
  1393.  
  1394. zotero(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
  1395.  
  1396. zotero(5)(+0000000): Binding parameter 1 of type int: 43
  1397.  
  1398. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  1399.  
  1400. zotero(5)(+0000000): Binding parameter 1 of type int: 43
  1401.  
  1402. zotero(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
  1403.  
  1404. zotero(5)(+0000001): Binding parameter 1 of type int: 43
  1405.  
  1406. zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
  1407.  
  1408. zotero(5)(+0000000): Binding parameter 1 of type int: 43
  1409.  
  1410. zotero(3)(+0000000): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
  1411.  
  1412. zotero(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?
  1413.  
  1414. zotero(5)(+0000000): Binding parameter 1 of type int: 42
  1415.  
  1416. zotero(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
  1417.  
  1418. zotero(5)(+0000000): Binding parameter 1 of type int: 42
  1419.  
  1420. zotero(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  1421.  
  1422. zotero(5)(+0000000): Binding parameter 1 of type int: 42
  1423.  
  1424. zotero(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
  1425.  
  1426. zotero(5)(+0000000): Binding parameter 1 of type int: 42
  1427.  
  1428. zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
  1429.  
  1430. zotero(5)(+0000000): Binding parameter 1 of type int: 42
  1431.  
  1432. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  1433.  
  1434. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  1435.  
  1436. zotero(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
  1437.  
  1438. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  1439.  
  1440. zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
  1441.  
  1442. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  1443.  
  1444. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1445.  
  1446. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1447.  
  1448. zotero(5)(+0000000): Binding parameter 2 of type int: 90
  1449.  
  1450. zotero(5)(+0000001): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1451.  
  1452. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1453.  
  1454. zotero(5)(+0000000): Binding parameter 2 of type int: 5
  1455.  
  1456. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1457.  
  1458. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1459.  
  1460. zotero(5)(+0000000): Binding parameter 2 of type int: 3
  1461.  
  1462. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1463.  
  1464. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1465.  
  1466. zotero(5)(+0000000): Binding parameter 2 of type int: 28
  1467.  
  1468. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1469.  
  1470. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1471.  
  1472. zotero(5)(+0000000): Binding parameter 2 of type int: 29
  1473.  
  1474. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1475.  
  1476. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1477.  
  1478. zotero(5)(+0000000): Binding parameter 2 of type int: 25
  1479.  
  1480. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1481.  
  1482. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1483.  
  1484. zotero(5)(+0000000): Binding parameter 2 of type int: 87
  1485.  
  1486. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1487.  
  1488. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1489.  
  1490. zotero(5)(+0000000): Binding parameter 2 of type int: 26
  1491.  
  1492. zotero(5)(+0000001): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1493.  
  1494. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1495.  
  1496. zotero(5)(+0000000): Binding parameter 2 of type int: 13
  1497.  
  1498. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1499.  
  1500. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1501.  
  1502. zotero(5)(+0000000): Binding parameter 2 of type int: 116
  1503.  
  1504. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1505.  
  1506. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1507.  
  1508. zotero(5)(+0000000): Binding parameter 2 of type int: 1
  1509.  
  1510. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1511.  
  1512. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1513.  
  1514. zotero(5)(+0000000): Binding parameter 2 of type int: 27
  1515.  
  1516. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1517.  
  1518. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1519.  
  1520. zotero(5)(+0000000): Binding parameter 2 of type int: 123
  1521.  
  1522. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1523.  
  1524. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1525.  
  1526. zotero(5)(+0000000): Binding parameter 2 of type int: 19
  1527.  
  1528. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1529.  
  1530. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1531.  
  1532. zotero(5)(+0000000): Binding parameter 2 of type int: 62
  1533.  
  1534. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1535.  
  1536. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1537.  
  1538. zotero(5)(+0000000): Binding parameter 2 of type int: 18
  1539.  
  1540. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1541.  
  1542. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1543.  
  1544. zotero(5)(+0000000): Binding parameter 2 of type int: 2
  1545.  
  1546. zotero(5)(+0000001): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1547.  
  1548. zotero(5)(+0000000): Binding parameter 1 of type int: 4
  1549.  
  1550. zotero(5)(+0000000): Binding parameter 2 of type int: 22
  1551.  
  1552. zotero(3)(+0000000): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
  1553.  
  1554. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  1555.  
  1556. zotero(5)(+0000000): Binding parameter 1 of type int: 43
  1557.  
  1558. zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
  1559.  
  1560. zotero(5)(+0000000): Binding parameter 1 of type int: 43
  1561.  
  1562. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1563.  
  1564. zotero(5)(+0000000): Binding parameter 1 of type int: 14
  1565.  
  1566. zotero(5)(+0000000): Binding parameter 2 of type int: 27
  1567.  
  1568. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1569.  
  1570. zotero(5)(+0000000): Binding parameter 1 of type int: 14
  1571.  
  1572. zotero(5)(+0000000): Binding parameter 2 of type int: 1
  1573.  
  1574. zotero(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
  1575.  
  1576. zotero(5)(+0000000): Binding parameter 1 of type int: 43
  1577.  
  1578. zotero(1)(+0000000): Invalid character set null
  1579.  
  1580. zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
  1581.  
  1582. zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
  1583.  
  1584. zotero(5)(+0000000): Binding parameter 1 of type int: 42
  1585.  
  1586. zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
  1587.  
  1588. zotero(5)(+0000000): Binding parameter 1 of type int: 42
  1589.  
  1590. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1591.  
  1592. zotero(5)(+0000000): Binding parameter 1 of type int: 14
  1593.  
  1594. zotero(5)(+0000000): Binding parameter 2 of type int: 27
  1595.  
  1596. zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?
  1597.  
  1598. zotero(5)(+0000000): Binding parameter 1 of type int: 14
  1599.  
  1600. zotero(5)(+0000000): Binding parameter 2 of type int: 1
  1601.  
  1602. zotero(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?
  1603.  
  1604. zotero(5)(+0000000): Binding parameter 1 of type int: 42
  1605.  
  1606. zotero(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
  1607.  
  1608. zotero(5)(+0000000): Binding parameter 1 of type int: 42
  1609.  
  1610. zotero(1)(+0000000): Invalid character set null
  1611.  
  1612. zotero(5)(+0000000): Translate: Running handler 0 for itemDone
  1613.  
  1614. zotero(5)(+0000001): Spinning event loop (1)
  1615.  
  1616. zotero(2)(+0000111): Translate: Translation using Better BibTeX failed:
  1617. string => TypeError: Zotero.BetterBibTeX is undefined
  1618. stack => Translator.nextItem@/home/jonas/.zotero/zotero/wkoovh9d.default/zotero/translators/Better BibTeX.js:989
  1619. doExport@/home/jonas/.zotero/zotero/wkoovh9d.default/zotero/translators/Better BibTeX.js:8035
  1620.  
  1621. url => /tmp/Exported Items.bib
  1622. downloadAssociatedFiles => true
  1623. automaticSnapshots => true
  1624.  
  1625. zotero(5)(+0000000): Translate: Running handler 0 for done
  1626.  
  1627. zotero(3)(+0002756): Viewing item in pane 0
  1628.  
  1629. zotero(3)(+0000001): Refreshing item box
  1630.  
  1631. zotero(3)(+0000018): DATE: retrieved with algorithms: {"order":"ymd","year":2007,"month":10,"day":1}
  1632.  
  1633. zotero(5)(+0002496): SELECT collectionID FROM collections WHERE collectionID IN (SELECT collectionID FROM collectionItems WHERE itemID=?)
  1634.  
  1635. zotero(5)(+0000000): Binding parameter 1 of type int: 41
  1636.  

Replies to Zotero log rss

Title Name Language When
Оборудование бу AncicDic text 1 Year ago.
captcha