From Pay Day Loan , 6 Months ago, written in BNF (Backus-Naur form).
This paste is a reply to Zotero log from jonascj - go back
Viewing differences between Zotero log and gqtbidaa
zotero(3)(+0000000): Using data directory /home/jonas/.zotero/zotero/wkoovh9d.default/zotero

zotero(3)(+0000000): IPC: Initializing pipe at /home/jonas/.zotero/zotero/wkoovh9d.default/zotero/pipes/1432998024292

zotero(3)(+0000001): Loading in full mode

zotero(3)(+0000000): Opening database 'zotero'

zotero(5)(+0000006): PRAGMA locking_mode=EXCLUSIVE

zotero(3)(+0000001): IPC: Trying to broadcast "releaseLock /home/jonas/.zotero/zotero/wkoovh9d.default/zotero/zotero.sqlite" to instance 1432997996271

zotero(3)(+0000100): IPC: Removing defunct pipe 1432997996271

zotero(5)(+0000000): SELECT version FROM version WHERE schema='system'

zotero(5)(+0000000): SELECT version FROM version WHERE schema='userdata'

zotero(3)(+0000002): IPC: Received "test"

zotero(5)(+0000005): SELECT version FROM version WHERE schema='userdata2'

zotero(3)(+0000002): Proxy not required for http://zotero.org.s3.amazonaws.com/proxy-auth

zotero(5)(+0000003): Beginning DB transaction

zotero(3)(+0000000): Beginning Notifier event queue

zotero(3)(+0000001): Updating custom tables

zotero(5)(+0000000): DELETE FROM itemTypesCombined

zotero(5)(+0000001): DELETE FROM fieldsCombined

zotero(5)(+0000000): DELETE FROM itemTypeFieldsCombined

zotero(5)(+0000000): DELETE FROM baseFieldMappingsCombined

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

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

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

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

zotero(5)(+0000001): SELECT version FROM version WHERE schema='triggers'

zotero(5)(+0000003): Committing transaction

zotero(3)(+0000154): Resetting Notifier event queue

zotero(5)(+0000001): ATTACH ':memory:' AS 'indexing'

zotero(5)(+0000001): CREATE TABLE indexing.fulltextWords (word NOT NULL)

zotero(3)(+0000001): pdftotext-Linux-x86_64 not found -- PDF indexing disabled

zotero(5)(+0000000): SELECT * FROM fulltextItems LIMIT 1

zotero(3)(+0000000): Initializing full-text content ingester idle observer

zotero(3)(+0000001): Opening database 'zotero' for dummy statement

zotero(3)(+0000001): Initializing dummy statement for 'zotero'

zotero(3)(+0000000): Updating custom tables

zotero(5)(+0000000): DELETE FROM itemTypesCombined

zotero(5)(+0000103): DELETE FROM fieldsCombined

zotero(5)(+0000099): DELETE FROM itemTypeFieldsCombined

zotero(5)(+0000100): DELETE FROM baseFieldMappingsCombined

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

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

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

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

zotero(3)(+0000116): HTTP GET resource://zotero/schema/renamed-styles.json

zotero(3)(+0000002): HTTP server listening on 127.0.0.1:23119

zotero(4)(+0000001): Registering observer for [setting] in notifier with hash H0'

zotero(5)(+0000000): Beginning DB transaction

zotero(3)(+0000000): Beginning Notifier event queue

zotero(5)(+0000000): SELECT version FROM version WHERE schema='syncdeletelog'

zotero(5)(+0000000): Committing transaction

zotero(3)(+0000000): Resetting Notifier event queue

zotero(4)(+0000001): Registering observer for all types in notifier with hash WO'

zotero(4)(+0000000): Registering observer for all types in notifier with hash 3y'

zotero(3)(+0000000): Initializing sync idle observer

zotero(3)(+0000001): Registering URIContentListener

zotero(5)(+0000000): SELECT * FROM proxies

zotero(3)(+0000003): Triggering "zotero-loaded" event

zotero(3)(+0000000): Initialized in 1195 ms

zotero(3)(+0000014): Loading BBT

zotero(3)(+0000102): Setting mode to note

zotero(3)(+0000000): Setting mode to note

zotero(3)(+0000000): Setting mode to note

zotero(3)(+0000000): Setting mode to note

zotero(4)(+0000001): Registering observer for [item-tag,setting] in notifier with hash CS'

zotero(4)(+0000056): Registering observer for [collection,search,share,group,trash,bucket] in notifier with hash 3l'

zotero(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID IS NULL AND libraryID IS NULL

zotero(3)(+0000001): Reloading all collections

zotero(5)(+0000000): SELECT ROWID FROM collections

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

zotero(5)(+0000001): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

zotero(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =3

zotero(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

zotero(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =4

zotero(5)(+0000000): No child collections of collection 4

zotero(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

zotero(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =1

zotero(5)(+0000000): No child collections of collection 1

zotero(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

zotero(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =6

zotero(5)(+0000000): No child collections of collection 6

zotero(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

zotero(5)(+0000000): SELECT fieldName FROM fieldsCombined WHERE fieldName NOT IN ('accessDate', 'date', 'pages', 'section','seriesNumber','issue')

zotero(5)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined

zotero(1)(+0000001): Invalid item type nsfReviewer

zotero(1)(+0000000): Invalid item type nsfReviewer

zotero(5)(+0000000): SELECT DISTINCT fieldID FROM baseFieldMappingsCombined

zotero(5)(+0000000): SELECT * FROM fieldFormats

zotero(5)(+0000001): SELECT * FROM fieldsCombined

zotero(5)(+0000001): SELECT fieldID, itemTypeID FROM itemTypeFieldsCombined

zotero(5)(+0000005): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined

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)

zotero(5)(+0000040): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined

zotero(5)(+0000006): SELECT baseFieldID, fieldID, fieldName FROM baseFieldMappingsCombined JOIN fieldsCombined USING (fieldID)

zotero(5)(+0000003): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE libraryID IS NULL

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)

zotero(5)(+0000001): SELECT fieldID FROM itemTypeFieldsCombined WHERE itemTypeID=4 ORDER BY orderIndex

zotero(5)(+0000001): SELECT * FROM items LIMIT 1

zotero(5)(+0000000): SELECT groupID FROM groups ORDER BY name COLLATE locale

zotero(4)(+0000001): Registering observer for [item,collection-item,item-tag,share-items,bucket] in notifier with hash k7'

zotero(3)(+0000001): Refreshing items list

zotero(5)(+0000004): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE display IN (1,2)

zotero(5)(+0000008): SELECT subject FROM relations WHERE predicate != ? UNION SELECT object FROM relations WHERE predicate != ?

zotero(5)(+0000001): Binding parameter 1 of type string: "dc:isReplacedBy"

zotero(5)(+0000000): Binding parameter 2 of type string: "dc:isReplacedBy"

zotero(3)(+0000000): Purged data tables in 1 ms

zotero(3)(+0000063): ZoteroOpenOfficeIntegration: Communication server listening on 127.0.0.1:23116

zotero(3)(+0000000): ZoteroOpenOfficeIntegration: Registering shutdown listener

zotero(5)(+0000041): Beginning DB transaction

zotero(3)(+0000000): Beginning Notifier event queue

zotero(3)(+0000000): Caching fields [title,date,firstCreator,extra]

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

zotero(5)(+0000017): SELECT fieldID FROM itemTypeFieldsCombined WHERE itemTypeID=14 ORDER BY orderIndex

zotero(5)(+0000003): SELECT fieldID FROM itemTypeFieldsCombined WHERE itemTypeID=1 ORDER BY orderIndex

zotero(5)(+0000001): SELECT fieldID FROM itemTypeFieldsCombined WHERE itemTypeID=2 ORDER BY orderIndex

zotero(5)(+0000002): SELECT itemID FROM items

zotero(5)(+0000001): SELECT itemID, fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE fieldID IN (110,111,112,113,14,96,52,100,22)

zotero(5)(+0000005): SELECT itemID, title FROM itemNotes WHERE itemID NOT IN (SELECT itemID FROM itemAttachments)

zotero(5)(+0000002): Transaction in progress -- increasing level to 1

zotero(5)(+0000000): SELECT ROWID FROM collections WHERE libraryID IS NULL AND key=?

zotero(5)(+0000000): Binding parameter 1 of type string: "7TBRQSXC"

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 (?)))

zotero(5)(+0000000): Binding parameter 1 of type int: 6

zotero(5)(+0000001): CREATE INDEX tmpSearchResults_pX3UvKUz_itemID ON tmpSearchResults_pX3UvKUz(itemID)

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)))

zotero(5)(+0000001): DROP TABLE tmpSearchResults_pX3UvKUz

zotero(5)(+0000000): Decreasing transaction level to 0

zotero(5)(+0000000): Committing transaction

zotero(3)(+0000000): Resetting Notifier event queue

zotero(3)(+0000010): Updating tag selector with current tags

zotero(5)(+0000000): Beginning DB transaction

zotero(3)(+0000000): Beginning Notifier event queue

zotero(5)(+0000000): CREATE TEMPORARY TABLE tmpSearchResults_1ZmHZNtl (itemID INT)

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 ?

zotero(5)(+0000000): INSERT INTO tmpSearchResults_1ZmHZNtl SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?

zotero(5)(+0000000): CREATE INDEX tmpSearchResults_1ZmHZNtl_itemID ON tmpSearchResults_1ZmHZNtl(itemID)

zotero(5)(+0000000): Committing transaction

zotero(3)(+0000001): Resetting Notifier event queue

zotero(5)(+0000000): SELECT DISTINCT tagID, name, type FROM itemTags NATURAL JOIN tags WHERE itemID IN (SELECT itemID FROM tmpSearchResults_1ZmHZNtl)

zotero(4)(+0000000): Registering observer for [collection-item,item-tag,tag,setting] in notifier with hash Jt'

zotero(3)(+0000000): Refreshing tags selector

zotero(3)(+0000000): Set tree in 163 ms

zotero(5)(+0000001): SELECT value FROM syncedSettings WHERE setting=? AND libraryID=?

zotero(5)(+0000000): Binding parameter 1 of type string: "tagColors"

zotero(5)(+0000000): Binding parameter 2 of type int: 0

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE libraryID IS NULL AND type IN (0,1)

zotero(3)(+0000001): Reloading all tags

zotero(5)(+0000000): SELECT ROWID FROM tags

zotero(5)(+0000000): SELECT * FROM tags WHERE 1

zotero(5)(+0000028): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 41

zotero(5)(+0000003): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(3)(+0000540): No general proxy or PAC file found -- assuming direct connection

zotero(3)(+0000279): Getting Zotero sync password

zotero(5)(+0000020): SELECT subject FROM relations WHERE predicate != ? UNION SELECT object FROM relations WHERE predicate != ?

zotero(5)(+0000000): Binding parameter 1 of type string: "dc:isReplacedBy"

zotero(5)(+0000000): Binding parameter 2 of type string: "dc:isReplacedBy"

zotero(3)(+0000001): ===>false<===(boolean)

zotero(3)(+0000000): Notifier.trigger('redraw', 'collection', []) called [observers: 8]

zotero(4)(+0000000): Calling notify('redraw') on observer with hash '0y'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'H0'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'WO'

zotero(5)(+0000000): UPDATE syncObjectTypes SET name='relation' WHERE syncObjectTypeID=6 AND name='relations'

zotero(5)(+0000000): SELECT * FROM syncObjectTypes

zotero(5)(+0000000): Beginning DB transaction

zotero(3)(+0000000): Beginning Notifier event queue

zotero(5)(+0000000): Committing transaction

zotero(3)(+0000000): Resetting Notifier event queue

zotero(4)(+0000000): Calling notify('redraw') on observer with hash '3y'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'CS'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash '3l'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'k7'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'Jt'

zotero(3)(+0000000): Session ID not available -- logging in

zotero(5)(+0000000): SELECT version FROM version WHERE schema='userdata'

zotero(3)(+0000000): HTTP POST version=9&username=jonascj&password=******** to https://sync.zotero.org/login

zotero(3)(+0000520): ===>false<===(boolean)

zotero(3)(+0000000): Notifier.trigger('redraw', 'collection', []) called [observers: 8]

zotero(4)(+0000001): Calling notify('redraw') on observer with hash '0y'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'H0'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'WO'

zotero(5)(+0000000): Beginning DB transaction

zotero(3)(+0000000): Beginning Notifier event queue

zotero(5)(+0000000): Committing transaction

zotero(3)(+0000000): Resetting Notifier event queue

zotero(4)(+0000000): Calling notify('redraw') on observer with hash '3y'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'CS'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash '3l'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'k7'

zotero(4)(+0000000): Calling notify('redraw') on observer with hash 'Jt'

zotero(3)(+0000000): Beginning server sync

zotero(5)(+0000000): SELECT version FROM version WHERE schema='lastremotesync'

zotero(5)(+0000000): SELECT version FROM version WHERE schema='lastlocalsync'

zotero(5)(+0000000): SELECT value FROM settings WHERE setting='fulltext' AND key='downloadAll'

zotero(5)(+0000000): SELECT itemID FROM fulltextItems WHERE synced=3

zotero(3)(+0000001): HTTP POST version=9&sessionid=********&lastsync=1432998000&ft=1 to https://sync.zotero.org/updated

zotero(3)(+0000294): <?xml version="1.0"?>
<response version="9" timestamp="1432998028" userID="2204430" defaultLibraryID="1983720" updateKey="e3b1870a1e5672ccef5829539464ac37" earliest="1398841199"><updated/></response>


zotero(5)(+0000000): Beginning DB transaction

zotero(3)(+0000000): Beginning Notifier event queue

zotero(5)(+0000001): SELECT value FROM settings WHERE setting='account' AND key='username'

zotero(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND key='userID'

zotero(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND key='libraryID'

zotero(5)(+0000001): Committing transaction

zotero(3)(+0000000): Resetting Notifier event queue

zotero(5)(+0000000): Beginning DB transaction

zotero(3)(+0000000): Beginning Notifier event queue

zotero(3)(+0000001): Getting updated local creators

zotero(5)(+0000000): SELECT ROWID FROM creators WHERE dateModified<?

zotero(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"

zotero(5)(+0000001): SELECT ROWID FROM creators WHERE clientDateModified>?

zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"

zotero(3)(+0000000): Getting updated local items

zotero(5)(+0000001): SELECT ROWID FROM items WHERE dateModified<?

zotero(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"

zotero(5)(+0000000): SELECT ROWID FROM items WHERE clientDateModified>?

zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"

zotero(3)(+0000000): Getting updated local collections

zotero(5)(+0000000): SELECT ROWID FROM collections WHERE dateModified<?

zotero(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"

zotero(5)(+0000000): SELECT ROWID FROM collections WHERE clientDateModified>?

zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"

zotero(3)(+0000000): Getting updated local searches

zotero(5)(+0000000): SELECT ROWID FROM savedSearches WHERE dateModified<?

zotero(5)(+0000001): Binding parameter 1 of type string: "0000-00-00 00:00:00"

zotero(5)(+0000000): SELECT ROWID FROM savedSearches WHERE clientDateModified>?

zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"

zotero(3)(+0000000): Getting updated local tags

zotero(5)(+0000000): SELECT ROWID FROM tags WHERE dateModified<?

zotero(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"

zotero(5)(+0000000): SELECT ROWID FROM tags WHERE clientDateModified>?

zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"

zotero(3)(+0000000): Getting updated local relations

zotero(5)(+0000000): SELECT ROWID FROM relations WHERE clientDateModified<?

zotero(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"

zotero(5)(+0000000): SELECT ROWID FROM relations WHERE clientDateModified>?

zotero(5)(+0000000): Binding parameter 1 of type string: "2015-05-30 14:59:59"

zotero(5)(+0000000): SELECT version FROM version WHERE schema='syncdeletelog'

zotero(5)(+0000000): SELECT syncObjectTypeID, libraryID, key FROM syncDeleteLog WHERE timestamp>? ORDER BY timestamp

zotero(5)(+0000001): Binding parameter 1 of type int: 1432997999

zotero(3)(+0000000): No changes received from server

zotero(3)(+0000000): Processing locally changed creators

zotero(3)(+0000000): Processing locally changed items

zotero(3)(+0000000): Processing locally changed collections

zotero(3)(+0000000): Processing locally changed searches

zotero(3)(+0000000): Processing locally changed tags

zotero(3)(+0000000): Processing locally changed relations

zotero(3)(+0000000): Processing locally changed fulltexts

zotero(5)(+0000000): SELECT libraryID, setting, value FROM syncedSettings WHERE synced=0

zotero(5)(+0000001): SELECT itemID, indexedChars, totalChars, indexedPages, totalPages FROM fulltextItems JOIN items USING (itemID) WHERE synced=0 ORDER BY clientDateModified DESC

zotero(3)(+0000000): Processing locally deleted creators

zotero(3)(+0000000): Processing locally deleted items

zotero(3)(+0000000): Processing locally deleted collections

zotero(3)(+0000000): Processing locally deleted searches

zotero(3)(+0000000): Processing locally deleted tags

zotero(3)(+0000000): Processing locally deleted relations

zotero(3)(+0000000): Processing locally deleted settings

zotero(3)(+0000000): Processing locally deleted fulltexts

zotero(3)(+0000000): Nothing to upload to server

zotero(5)(+0000000): REPLACE INTO version VALUES ('lastremotesync', ?)

zotero(5)(+0000000): Binding parameter 1 of type string: "1432998028"

zotero(5)(+0000000): REPLACE INTO version VALUES ('lastlocalsync', ?)

zotero(5)(+0000000): Binding parameter 1 of type int: 1432998027

zotero(5)(+0000000): Committing transaction

zotero(3)(+0000133): Resetting Notifier event queue

zotero(3)(+0000000): Starting file sync

zotero(5)(+0000003): SELECT groupID FROM groups ORDER BY name COLLATE locale

zotero(3)(+0000000): HTTP GET https://jonascj:********@api.zotero.org/?auth=1

zotero(3)(+0001293): Credentials are cached

zotero(3)(+0000001): ZFS credentials are already cached

zotero(3)(+0000001): HTTP GET https://jonascj:********@api.zotero.org/users/2204430/laststoragesync

zotero(3)(+0000133): HTTP GET https://jonascj:********@api.zotero.org/users/2204430/laststoragesync succeeded with 200

zotero(3)(+0000001): 1432900157

zotero(3)(+0000001): Last successful ZFS sync for library 0 was Fri May 29 2015 13:49:17 GMT+0200 (CEST)

zotero(3)(+0000001): Checking for locally changed attachment files in library 0

zotero(5)(+0000000): Beginning DB transaction

zotero(3)(+0000000): Beginning Notifier event queue

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

zotero(5)(+0000001): Binding parameter 1 of type int: 0

zotero(5)(+0000000): Binding parameter 2 of type int: 1

zotero(5)(+0000000): Binding parameter 3 of type int: 0

zotero(5)(+0000000): Binding parameter 4 of type int: 2

zotero(5)(+0000003): Committing transaction

zotero(3)(+0000000): Resetting Notifier event queue

zotero(3)(+0000000): Checking attachment file for item 0/INS4IWWK

zotero(3)(+0000004): Checking attachment file for item 0/N45BPH8D

zotero(3)(+0000006): Checking attachment file for item 0/F2Q59VCR

zotero(3)(+0000002): Checking attachment file for item 0/3868F68T

zotero(3)(+0000001): Checking attachment file for item 0/NJANSRPG

zotero(3)(+0000002): Checking attachment file for item 0/RXQAIPXB

zotero(3)(+0000001): Checking attachment file for item 0/7IU7AM5N

zotero(3)(+0000003): Checking attachment file for item 0/44ATPDTB

zotero(3)(+0000004): Checking attachment file for item 0/65AS5HEM

zotero(3)(+0000003): Checking attachment file for item 0/42W2IAP3

zotero(3)(+0000002): Checking attachment file for item 0/FCMK3CFZ

zotero(3)(+0000002): Checking attachment file for item 0/5H2NS9BK

zotero(3)(+0000001): Checking attachment file for item 0/T2CEIRG6

zotero(3)(+0000002): Checking attachment file for item 0/MJVP5BNP

zotero(3)(+0000001): Checking attachment file for item 0/B9ZKMCJZ

zotero(3)(+0000002): Checking attachment file for item 0/X3QTREE2

zotero(3)(+0000001): Checking attachment file for item 0/KCBN9RDR

zotero(3)(+0000004): Checking attachment file for item 0/TDVZHR9I

zotero(3)(+0000002): Checking attachment file for item 0/98C6FSAD

zotero(3)(+0000001): Checking attachment file for item 0/IPHCXGVR

zotero(3)(+0000001): Checking attachment file for item 0/78JXJB5K

zotero(3)(+0000002): Checking attachment file for item 0/RIXDHQJ7

zotero(3)(+0000002): Checking attachment file for item 0/2FZ5VU77

zotero(3)(+0000001): Checking attachment file for item 0/MTA9X7S6

zotero(3)(+0000001): Checking attachment file for item 0/RQSN3Q6H

zotero(3)(+0000002): Checking attachment file for item 0/SBS8T9B7

zotero(3)(+0000002): Checking attachment file for item 0/F39WRSK3

zotero(3)(+0000002): Checking attachment file for item 0/HTXJA8IA

zotero(3)(+0000001): Checking attachment file for item 0/5E4UM9ZR

zotero(3)(+0000002): Checking attachment file for item 0/QDJBXZEQ

zotero(3)(+0000001): Checking attachment file for item 0/M7236N7J

zotero(3)(+0000001): Checking attachment file for item 0/K68P68UV

zotero(3)(+0000002): Checking attachment file for item 0/6SXKPVNG

zotero(3)(+0000002): Checking attachment file for item 0/CU3ZCBHV

zotero(3)(+0000001): Checking attachment file for item 0/R2KZPFM5

zotero(3)(+0000002): Checking attachment file for item 0/GNH4PTG3

zotero(3)(+0000001): Checking attachment file for item 0/TE85FVCM

zotero(3)(+0000002): Checking attachment file for item 0/PCEM6K7E

zotero(3)(+0000001): Checking attachment file for item 0/7EB789QI

zotero(3)(+0000002): Checking attachment file for item 0/KWAZE72S

zotero(3)(+0000001): Checking attachment file for item 0/NB736JPW

zotero(3)(+0000002): Checking attachment file for item 0/MF5JGZ76

zotero(3)(+0000001): Checking attachment file for item 0/3BPHBKZM

zotero(3)(+0000002): Checking attachment file for item 0/JUQ7G4W8

zotero(3)(+0000002): Checking attachment file for item 0/CQTD2VXV

zotero(3)(+0000001): Checking attachment file for item 0/6BXE6XUK

zotero(3)(+0000002): Checking attachment file for item 0/I5ZPJFWI

zotero(3)(+0000001): Checking attachment file for item 0/BDDIA29J

zotero(3)(+0000004): Checking attachment file for item 0/AEHFFWUS

zotero(3)(+0000001): Checking attachment file for item 0/WFDM9UV7

zotero(3)(+0000002): Checking attachment file for item 0/KFN23SB8

zotero(3)(+0000001): Checking attachment file for item 0/H2W9T3SZ

zotero(3)(+0000001): Checking attachment file for item 0/BQBWBJZW

zotero(3)(+0000002): Checking attachment file for item 0/4WE7UZSV

zotero(3)(+0000001): Checking attachment file for item 0/6DJNQRGX

zotero(3)(+0000002): Checking attachment file for item 0/C2HWZDGW

zotero(3)(+0000001): Checking attachment file for item 0/67UJBTZP

zotero(3)(+0000002): Checking attachment file for item 0/86GQ25G3

zotero(3)(+0000001): Checking attachment file for item 0/WA92RRIK

zotero(3)(+0000002): Checking attachment file for item 0/HXTSPD3T

zotero(3)(+0000001): Checking attachment file for item 0/RN4USVKR

zotero(3)(+0000002): Checking attachment file for item 0/ZVXWC4JF

zotero(3)(+0000002): Checking attachment file for item 0/MF4WPJ77

zotero(3)(+0000001): Checking attachment file for item 0/EI4V54GM

zotero(3)(+0000002): Checking attachment file for item 0/87EN3HFH

zotero(3)(+0000001): No synced files have changed locally

zotero(3)(+0000000): Checked 65 files in library 0 in 116ms

zotero(5)(+0000000): SELECT COUNT(*) FROM items JOIN itemAttachments USING (itemID) WHERE libraryID IS NULL AND syncState=?

zotero(5)(+0000001): Binding parameter 1 of type int: 4

zotero(5)(+0000000): SELECT version FROM version WHERE schema=?

zotero(5)(+0000000): Binding parameter 1 of type string: "storage_zfs_0"

zotero(5)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE libraryID IS NULL AND syncState IN (?,?) AND path!=''

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 1

zotero(5)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE syncState IN (?,?) AND linkMode IN (?,?) AND libraryID IS NULL

zotero(5)(+0000000): Binding parameter 1 of type int: 0

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): Binding parameter 3 of type int: 0

zotero(5)(+0000000): Binding parameter 4 of type int: 1

zotero(3)(+0000000): Starting file sync queues for library 0

zotero(3)(+0000000): No files to sync for library 0

zotero(3)(+0000001): All storage queues are finished for library 0

zotero(3)(+0000000): Queue manager is finished

zotero(3)(+0000000): No local changes made during file sync

zotero(3)(+0000000): ZFS credentials are already cached

zotero(3)(+0000000): File sync is finished

zotero(5)(+0000357): SELECT version FROM version WHERE schema='delete'

zotero(5)(+0000001): SELECT version FROM version WHERE schema=?

zotero(5)(+0000000): Binding parameter 1 of type string: "translators"

zotero(3)(+0000000): Installed translators are up-to-date with translators.zip

zotero(5)(+0000002): SELECT version FROM version WHERE schema='delete'

zotero(5)(+0000000): SELECT version FROM version WHERE schema=?

zotero(5)(+0000000): Binding parameter 1 of type string: "styles"

zotero(3)(+0000000): Installed styles are up-to-date with styles.zip

zotero(5)(+0000001): SELECT version FROM version WHERE schema='lastcheck'

zotero(4)(+0000000): Not enough time since last update -- not checking repository

zotero(3)(+0000000): Setting repository check interval to 85790 seconds

zotero(5)(+0000818): DROP TABLE tmpSearchResults_1ZmHZNtl

zotero(3)(+0000001): Refreshing items list

zotero(5)(+0000001): Beginning DB transaction

zotero(3)(+0000000): Beginning Notifier event queue

zotero(3)(+0000000): Caching fields [title,date,firstCreator,extra]

zotero(5)(+0000004): Transaction in progress -- increasing level to 1

zotero(5)(+0000001): SELECT ROWID FROM collections WHERE libraryID IS NULL AND key=?

zotero(5)(+0000000): Binding parameter 1 of type string: "7TBRQSXC"

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 (?)))

zotero(5)(+0000001): Binding parameter 1 of type int: 6

zotero(5)(+0000001): CREATE INDEX tmpSearchResults_iIHICSWx_itemID ON tmpSearchResults_iIHICSWx(itemID)

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)))

zotero(5)(+0000000): Binding parameter 1 of type string: "%-%"

zotero(5)(+0000000): Binding parameter 2 of type string: "%-%"

zotero(5)(+0000000): Binding parameter 3 of type string: "%-%"

zotero(5)(+0000000): Binding parameter 4 of type string: "%-%"

zotero(5)(+0000004): DROP TABLE tmpSearchResults_iIHICSWx

zotero(5)(+0000000): Decreasing transaction level to 0

zotero(5)(+0000000): Committing transaction

zotero(3)(+0000000): Resetting Notifier event queue

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)

zotero(5)(+0000000): Binding parameter 1 of type int: 41

zotero(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

zotero(5)(+0000000): Binding parameter 1 of type int: 41

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)

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(3)(+0000002): Updating tag selector with current tags

zotero(5)(+0000000): Beginning DB transaction

zotero(3)(+0000000): Beginning Notifier event queue

zotero(5)(+0000000): CREATE TEMPORARY TABLE tmpSearchResults_OwtlwUnd (itemID INT)

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 ?

zotero(5)(+0000001): INSERT INTO tmpSearchResults_OwtlwUnd SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?

zotero(5)(+0000000): CREATE INDEX tmpSearchResults_OwtlwUnd_itemID ON tmpSearchResults_OwtlwUnd(itemID)

zotero(5)(+0000000): Committing transaction

zotero(3)(+0000001): Resetting Notifier event queue

zotero(5)(+0000000): SELECT DISTINCT tagID, name, type FROM itemTags NATURAL JOIN tags WHERE itemID IN (SELECT itemID FROM tmpSearchResults_OwtlwUnd)

zotero(3)(+0000000): Refreshing tags selector

zotero(5)(+0000004): SELECT linkMode FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 43

zotero(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 43

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 43

zotero(5)(+0000001): SELECT linkMode FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 42

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 42

zotero(5)(+0000002): SELECT linkMode FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 71

zotero(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 71

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000001): Binding parameter 1 of type int: 71

zotero(5)(+0000000): SELECT linkMode FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 53

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 53

zotero(3)(+0066630): Checking for unprocessed full-text content

zotero(5)(+0000000): SELECT itemID FROM fulltextItems WHERE synced=2

zotero(3)(+0000001): No unprocessed full-text content found

zotero(3)(+0276951): Backing up database 'zotero'

zotero(5)(+0000000): PRAGMA locking_mode=NORMAL

zotero(3)(+0000000): Stopping dummy statement for 'zotero'

zotero(5)(+0000099): PRAGMA locking_mode=EXCLUSIVE

zotero(3)(+0000000): Opening database 'zotero' for dummy statement

zotero(3)(+0000000): Initializing dummy statement for 'zotero'

zotero(3)(+0000007): Moving zotero.sqlite.bak to zotero.sqlite.1.bak

zotero(3)(+0000001): Backed up to zotero.sqlite.bak

zotero(3)(+0227021): Viewing item in pane 0

zotero(3)(+0000000): Refreshing item box

zotero(5)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined

zotero(5)(+0000013): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(3)(+0000003): DATE: could not apply algorithms

zotero(3)(+0000001): DATE: got year (2013, [{"part":"Aug 21, ","before":true},{"part":""}])

zotero(3)(+0000000): DATE: got month (7, [{"part":"","before":"m"},{"part":"21, ","after":"m"},{"part":""}])

zotero(3)(+0000000): DATE: got day (21, [{"part":"","before":"m"},{"part":", "},{"part":""}])

zotero(5)(+0000007): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000001): SELECT creatorTypeID AS id, creatorType AS name FROM creatorTypes

zotero(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 73

zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 86

zotero(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 87

zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 88

zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 89

zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 76

zotero(3)(+0000000): Loading data for creator 73 in Zotero.Creator.load()

zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 73

zotero(3)(+0000013): Loading data for creator 86 in Zotero.Creator.load()

zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 86

zotero(3)(+0000008): Loading data for creator 87 in Zotero.Creator.load()

zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 87

zotero(3)(+0000004): Loading data for creator 88 in Zotero.Creator.load()

zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

zotero(5)(+0000001): Binding parameter 1 of type int: 88

zotero(3)(+0000005): Loading data for creator 89 in Zotero.Creator.load()

zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 89

zotero(3)(+0000008): Loading data for creator 76 in Zotero.Creator.load()

zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 76

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

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): Binding parameter 3 of type string: ""

zotero(5)(+0000001): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 71

zotero(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 53

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

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): Binding parameter 3 of type string: ""

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

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): Binding parameter 3 of type string: ""

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

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): Binding parameter 3 of type string: ""

zotero(5)(+0000000): SELECT path FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 71

zotero(3)(+0000001): MIME type application/pdf can be handled by plugins

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

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): Binding parameter 3 of type string: ""

zotero(5)(+0001999): SELECT leafName, translatorJSON, code, lastModifiedTime FROM translatorCache

zotero(3)(+0000064): Cached 468 translators in 64 ms

zotero(3)(+0000000): Translate: All translator detect calls and RPC calls complete

zotero(3)(+0000038): Loading BBT

zotero(4)(+0011203): Translate: Binding sandbox to http://www.example.com/

zotero(4)(+0000003): Translate: Parsing code for Better BibTeX

zotero(3)(+0000031): Translate: Beginning translation with Better BibTeX

zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()

zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()

zotero(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 71

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 71

zotero(5)(+0000001): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 71

zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 71

zotero(3)(+0000000): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()

zotero(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 53

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 53

zotero(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 53

zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 53

zotero(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 90

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000001): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 5

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 28

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 29

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 25

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 87

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 26

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 13

zotero(5)(+0000001): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 116

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 1

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 27

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 123

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 19

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 62

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 18

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 2

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 22

zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 71

zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 71

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 14

zotero(5)(+0000000): Binding parameter 2 of type int: 27

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 14

zotero(5)(+0000000): Binding parameter 2 of type int: 1

zotero(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 71

zotero(5)(+0000000): SELECT charsetID AS id, charset AS name FROM charsets

zotero(1)(+0000003): Invalid character set null

zotero(3)(+0000000): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 53

zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 53

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000001): Binding parameter 1 of type int: 14

zotero(5)(+0000000): Binding parameter 2 of type int: 27

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 14

zotero(5)(+0000000): Binding parameter 2 of type int: 1

zotero(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 53

zotero(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 53

zotero(1)(+0000000): Invalid character set null

zotero(5)(+0000000): Translate: Running handler 0 for itemDone

zotero(5)(+0000001): Spinning event loop (1)

zotero(2)(+0000092): Translate: Translation using Better BibTeX failed:
string => TypeError: Zotero.BetterBibTeX is undefined
stack => Translator.nextItem@/home/jonas/.zotero/zotero/wkoovh9d.default/zotero/translators/Better BibTeX.js:989
doExport@/home/jonas/.zotero/zotero/wkoovh9d.default/zotero/translators/Better BibTeX.js:8035

url => /tmp/Exported Items.bib
downloadAssociatedFiles => true
automaticSnapshots => true

zotero(5)(+0000000): Translate: Running handler 0 for done

zotero(5)(+0002694): SELECT collectionID FROM collections WHERE collectionID IN (SELECT collectionID FROM collectionItems WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 44

zotero(3)(+0238888): Viewing item in pane 0

zotero(3)(+0000000): Refreshing item box

zotero(5)(+0000010): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 41

zotero(3)(+0000004): DATE: retrieved with algorithms: {"order":"ymd","year":2007,"month":10,"day":1}

zotero(5)(+0000010): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

zotero(5)(+0000000): Binding parameter 1 of type int: 41

zotero(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 74

zotero(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 75

zotero(3)(+0000000): Loading data for creator 74 in Zotero.Creator.load()

zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 74

zotero(3)(+0000008): Loading data for creator 75 in Zotero.Creator.load()

zotero(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 75

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

zotero(5)(+0000000): Binding parameter 1 of type int: 41

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): Binding parameter 3 of type string: "http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2025644/"

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

zotero(5)(+0000000): Binding parameter 1 of type int: 41

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): Binding parameter 3 of type string: "http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2025644/"

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

zotero(5)(+0000000): Binding parameter 1 of type int: 41

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000001): Binding parameter 3 of type string: "http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2025644/"

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

zotero(5)(+0000000): Binding parameter 1 of type int: 41

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): Binding parameter 3 of type string: "http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2025644/"

zotero(5)(+0000001): SELECT path FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 43

zotero(3)(+0000002): MIME type application/pdf can be handled by plugins

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

zotero(5)(+0000001): Binding parameter 1 of type int: 41

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): Binding parameter 3 of type string: "http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2025644/"

zotero(3)(+0001918): Translate: All translator detect calls and RPC calls complete

zotero(3)(+0000020): Loading BBT

zotero(4)(+0008035): Translate: Binding sandbox to http://www.example.com/

zotero(4)(+0000004): Translate: Parsing code for Better BibTeX

zotero(3)(+0000029): Translate: Beginning translation with Better BibTeX

zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()

zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()

zotero(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?

zotero(5)(+0000001): Binding parameter 1 of type int: 43

zotero(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 43

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 43

zotero(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?

zotero(5)(+0000001): Binding parameter 1 of type int: 43

zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 43

zotero(3)(+0000000): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()

zotero(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 42

zotero(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 42

zotero(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 42

zotero(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 42

zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 42

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 41

zotero(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 41

zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 41

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 90

zotero(5)(+0000001): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 5

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 3

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 28

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 29

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 25

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 87

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 26

zotero(5)(+0000001): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 13

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 116

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 1

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 27

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 123

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 19

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 62

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 18

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 2

zotero(5)(+0000001): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 4

zotero(5)(+0000000): Binding parameter 2 of type int: 22

zotero(3)(+0000000): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 43

zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 43

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 14

zotero(5)(+0000000): Binding parameter 2 of type int: 27

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 14

zotero(5)(+0000000): Binding parameter 2 of type int: 1

zotero(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 43

zotero(1)(+0000000): Invalid character set null

zotero(3)(+0000001): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()

zotero(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 42

zotero(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 42

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 14

zotero(5)(+0000000): Binding parameter 2 of type int: 27

zotero(5)(+0000000): SELECT baseFieldID FROM baseFieldMappingsCombined WHERE itemTypeID=? AND fieldID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 14

zotero(5)(+0000000): Binding parameter 2 of type int: 1

zotero(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 42

zotero(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?

zotero(5)(+0000000): Binding parameter 1 of type int: 42

zotero(1)(+0000000): Invalid character set null

zotero(5)(+0000000): Translate: Running handler 0 for itemDone

zotero(5)(+0000001): Spinning event loop (1)

zotero(2)(+0000111): Translate: Translation using Better BibTeX failed:
string => TypeError: Zotero.BetterBibTeX is undefined
stack => Translator.nextItem@/home/jonas/.zotero/zotero/wkoovh9d.default/zotero/translators/Better BibTeX.js:989
doExport@/home/jonas/.zotero/zotero/wkoovh9d.default/zotero/translators/Better BibTeX.js:8035

url => /tmp/Exported Items.bib
downloadAssociatedFiles => true
automaticSnapshots => true

zotero(5)(+0000000): Translate: Running handler 0 for done

zotero(3)(+0002756): Viewing item in pane 0

zotero(3)(+0000001): Refreshing item box

zotero(3)(+0000018): DATE: retrieved with algorithms: {"order":"ymd","year":2007,"month":10,"day":1}

zotero(5)(+0002496): SELECT collectionID FROM collections WHERE collectionID IN (SELECT collectionID FROM collectionItems WHERE itemID=?)

zotero(5)(+0000000): Binding parameter 1 of type int: 41
adpm
captcha