Zotero BBT start issue - log

zotero(3)(+0000000): Using data directory C:\Users\xxxxx\Zotero

zotero(3)(+0000009): Asynchronously opening database 'zotero'

zotero(3)(+0000000): C:\Users\xxxxx\Zotero\zotero.sqlite

zotero(4)(+0000005): PRAGMA main.locking_mode=EXCLUSIVE

zotero(4)(+0000001): PRAGMA page_size

zotero(4)(+0000001): PRAGMA cache_size=2000

zotero(4)(+0000000): PRAGMA foreign_keys=true

zotero(4)(+0000011): SELECT version FROM version WHERE schema='system'

zotero(4)(+0000002): SELECT version FROM version WHERE schema='userdata'

zotero(4)(+0000001): SELECT version FROM version WHERE schema='compatibility'

zotero(3)(+0000002): Proxy not required for https://zoteroproxycheck.s3.amazonaws.com/test

zotero(4)(+0000002): SELECT value FROM settings WHERE setting='db' AND key='integrityCheck'

zotero(3)(+0000002): HTTP GET resource://zotero/schema/global/schema.json

zotero(3)(+0000003): HTTP GET resource://zotero/schema/global/schema.json succeeded with 200

zotero(4)(+0000003): SELECT version FROM version WHERE schema='globalSchema'

zotero(3)(+0000001): Database is up to date with global schema version 15 -- skipping update

zotero(3)(+0000000): HTTP GET resource://zotero/schema/userdata.sql

zotero(3)(+0000002): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200

zotero(4)(+0000000): PRAGMA foreign_keys = false

zotero(4)(+0000001): Beginning DB transaction mFACRSfb

zotero(3)(+0000001): HTTP GET resource://zotero/schema/system.sql

zotero(3)(+0000002): HTTP GET resource://zotero/schema/system.sql succeeded with 200

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

zotero(4)(+0000001): PRAGMA foreign_keys

zotero(4)(+0000001): SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND tbl_name=? ['customItemTypes']

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

zotero(4)(+0000002): DELETE FROM fieldsCombined

zotero(4)(+0000008): DELETE FROM itemTypeFieldsCombined

zotero(4)(+0000001): DELETE FROM baseFieldMappingsCombined

zotero(4)(+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(4)(+0000002): 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(4)(+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(4)(+0000001): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings

zotero(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql

zotero(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200

zotero(4)(+0000000): SELECT 1 FROM itemDataValues WHERE value=0 LIMIT 1

zotero(3)(+0000000): HTTP GET resource://zotero/schema/userdata.sql

zotero(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200

zotero(4)(+0000000): SELECT version FROM version WHERE schema='triggers'

zotero(3)(+0000001): HTTP GET resource://zotero/schema/triggers.sql

zotero(3)(+0000001): HTTP GET resource://zotero/schema/triggers.sql succeeded with 200

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

zotero(4)(+0000000): PRAGMA foreign_keys

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

zotero(4)(+0000000): DELETE FROM fieldsCombined

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

zotero(4)(+0000002): DELETE FROM baseFieldMappingsCombined

zotero(4)(+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(4)(+0000006): 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(4)(+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(4)(+0000001): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings

zotero(4)(+0000008): Committed DB transaction mFACRSfb

zotero(4)(+0000002): PRAGMA foreign_keys = true

zotero(4)(+0000001): Beginning DB transaction reok3XG2

zotero(4)(+0000001): SELECT value FROM settings WHERE setting='client' AND key='lastVersion'

zotero(4)(+0000000): Committed DB transaction reok3XG2

zotero(4)(+0000001): SELECT key, value FROM settings WHERE setting='account'

zotero(4)(+0000000): SELECT userID, name FROM users

zotero(4)(+0000001): SELECT L.libraryID, L.type AS _libraryType, L.editable AS _libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS _libraryVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync AS _libraryLastSync, L.archived AS _libraryArchived, (SELECT COUNT(*)>0 FROM collections C WHERE C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)>0 FROM savedSearches S WHERE S.libraryID=L.libraryID) AS hasSearches FROM libraries L WHERE type NOT IN (?,?) ['feed', 'group']

zotero(4)(+0000001): SELECT L.libraryID, L.type AS _libraryType, L.editable AS _libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS _libraryVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync AS _libraryLastSync, L.archived AS _libraryArchived, (SELECT COUNT(*)>0 FROM collections C WHERE C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)>0 FROM savedSearches S WHERE S.libraryID=L.libraryID) AS hasSearches, F.name AS _feedName, F.url AS _feedUrl, F.lastUpdate AS _feedLastUpdate, F.lastCheck AS _feedLastCheck, F.lastCheckError AS _feedLastCheckError, F.cleanupUnreadAfter AS _feedCleanupUnreadAfter, F.cleanupReadAfter AS _feedCleanupReadAfter, F.refreshInterval AS _feedRefreshInterval, (SELECT COUNT(*) FROM items I JOIN feedItems FI USING (itemID) WHERE I.libraryID=F.libraryID AND FI.readTime IS NULL) AS _feedUnreadCount FROM feeds F JOIN libraries L USING (libraryID)

zotero(4)(+0000001): SELECT L.libraryID, L.type AS _libraryType, L.editable AS _libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS _libraryVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync AS _libraryLastSync, L.archived AS _libraryArchived, (SELECT COUNT(*)>0 FROM collections C WHERE C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)>0 FROM savedSearches S WHERE S.libraryID=L.libraryID) AS hasSearches, G.groupID, G.name AS _groupName, G.description AS _groupDescription, G.version AS _groupVersion FROM groups G JOIN libraries L USING (libraryID)

zotero(4)(+0000001): SELECT COALESCE(MAX(collectionID) + 1, 1) FROM collections

zotero(4)(+0000001): SELECT COALESCE(MAX(creatorID) + 1, 1) FROM creators

zotero(4)(+0000000): SELECT COALESCE(MAX(creatorTypeID) + 1, 1) FROM creatorTypes

zotero(4)(+0000000): SELECT COALESCE(MAX(customFieldID) + 1, 1) FROM customFields

zotero(4)(+0000001): SELECT COALESCE(MAX(customItemTypeID) + 1, 1) FROM customItemTypes

zotero(4)(+0000000): SELECT COALESCE(MAX(fieldID) + 1, 1) FROM fields

zotero(4)(+0000000): SELECT COALESCE(MAX(valueID) + 1, 1) FROM itemDataValues

zotero(4)(+0000001): SELECT COALESCE(MAX(itemTypeID) + 1, 1) FROM itemTypes

zotero(4)(+0000000): SELECT COALESCE(MAX(itemID) + 1, 1) FROM items

zotero(4)(+0000000): SELECT COALESCE(MAX(libraryID) + 1, 1) FROM libraries

zotero(4)(+0000001): SELECT COALESCE(MAX(proxyID) + 1, 1) FROM proxies

zotero(4)(+0000000): SELECT COALESCE(MAX(savedSearchID) + 1, 1) FROM savedSearches

zotero(4)(+0000000): SELECT COALESCE(MAX(tagID) + 1, 1) FROM tags

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

zotero(4)(+0000002): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE typeName IN ('webpage', 'attachment', 'note', 'annotation')

zotero(4)(+0000001): SELECT customItemTypeID AS id, label, icon FROM customItemTypes

zotero(4)(+0000001): SELECT * FROM fieldFormats

zotero(4)(+0000000): SELECT * FROM fieldsCombined

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

zotero(4)(+0000008): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined

zotero(4)(+0000005): 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(4)(+0000019): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined

zotero(4)(+0000048): SELECT itemTypeID, baseFieldID, fieldID, fieldName FROM baseFieldMappingsCombined JOIN fieldsCombined USING (fieldID)

zotero(4)(+0000002): SELECT DISTINCT fieldID FROM baseFieldMappingsCombined

zotero(4)(+0000001): SELECT itemTypeID, fieldID FROM itemTypeFieldsCombined ORDER BY orderIndex

zotero(4)(+0000007): SELECT creatorTypeID AS id, creatorType AS name FROM creatorTypes

zotero(4)(+0000001): SELECT itemTypeID, creatorTypeID AS id, creatorType AS name, primaryField FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes

zotero(4)(+0000011): SELECT itemTypeID, creatorTypeID FROM itemTypeCreatorTypes WHERE primaryField=1

zotero(4)(+0000001): SELECT fileTypeID AS id, fileType AS name FROM fileTypes

zotero(4)(+0000002): SELECT charsetID AS id, charset AS name FROM charsets

zotero(4)(+0000001): SELECT predicateID AS id, predicate AS name FROM relationPredicates

zotero(3)(+0000001): Getting contents of C:\Users\xxxxx\AppData\Roaming\Zotero\Zotero\Profiles\isol9kpt.default\session.json

zotero(3)(+0000001): Running unlock callbacks

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

zotero(4)(+0000000): ATTACH ':memory:' AS 'indexing'

zotero(4)(+0000000): CREATE TABLE indexing.fulltextWords (word NOT NULL)

zotero(4)(+0000002): SELECT version FROM version WHERE schema='lastsync'

zotero(4)(+0000001): SELECT name, syncObjectTypeID AS id FROM syncObjectTypes

zotero(3)(+0000002): Registering auto-sync idle observer

zotero(3)(+0000001): Registering URIContentListener

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

zotero(4)(+0000003): SELECT ROWID AS id, libraryID, key FROM collections

zotero(4)(+0000001): SELECT ROWID AS id, libraryID, key FROM items

zotero(3)(+0000001): Getting contents of C:\Users\xxxxx\Zotero\locate\engines.json

zotero(4)(+0000016): SELECT ROWID AS id, libraryID, key FROM savedSearches

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

zotero(1)(+0000002): Unknown item type 'nsfReviewer'

zotero(1)(+0000000): Unknown item type 'nsfReviewer'

zotero(1)(+0000001): Localized string not available for searchConditions.dateAdded

zotero(1)(+0000000): Localized string not available for searchConditions.title

zotero(1)(+0000000): Localized string not available for searchConditions.abstractNote

zotero(1)(+0000001): Localized string not available for searchConditions.artworkSize

zotero(1)(+0000000): Localized string not available for searchConditions.language

zotero(1)(+0000000): Localized string not available for searchConditions.shortTitle

zotero(1)(+0000000): Localized string not available for searchConditions.archive

zotero(1)(+0000000): Localized string not available for searchConditions.archiveLocation

zotero(1)(+0000000): Localized string not available for searchConditions.libraryCatalog

zotero(1)(+0000000): Localized string not available for searchConditions.callNumber

zotero(1)(+0000000): Localized string not available for searchConditions.url

zotero(1)(+0000000): Localized string not available for searchConditions.rights

zotero(1)(+0000000): Localized string not available for searchConditions.extra

zotero(1)(+0000000): Localized string not available for searchConditions.seriesTitle

zotero(1)(+0000000): Localized string not available for searchConditions.volume

zotero(1)(+0000000): Localized string not available for searchConditions.numberOfVolumes

zotero(1)(+0000000): Localized string not available for searchConditions.place

zotero(1)(+0000000): Localized string not available for searchConditions.publisher

zotero(1)(+0000000): Localized string not available for searchConditions.runningTime

zotero(1)(+0000000): Localized string not available for searchConditions.ISBN

zotero(1)(+0000001): Localized string not available for searchConditions.number

zotero(1)(+0000000): Localized string not available for searchConditions.code

zotero(1)(+0000000): Localized string not available for searchConditions.legislativeBody

zotero(1)(+0000000): Localized string not available for searchConditions.session

zotero(1)(+0000000): Localized string not available for searchConditions.history

zotero(1)(+0000000): Localized string not available for searchConditions.publicationTitle

zotero(1)(+0000000): Localized string not available for searchConditions.series

zotero(1)(+0000000): Localized string not available for searchConditions.edition

zotero(1)(+0000000): Localized string not available for searchConditions.numPages

zotero(1)(+0000000): Localized string not available for searchConditions.court

zotero(1)(+0000000): Localized string not available for searchConditions.reporter

zotero(1)(+0000000): Localized string not available for searchConditions.versionNumber

zotero(1)(+0000000): Localized string not available for searchConditions.system

zotero(1)(+0000000): Localized string not available for searchConditions.conferenceName

zotero(1)(+0000000): Localized string not available for searchConditions.DOI

zotero(1)(+0000000): Localized string not available for searchConditions.committee

zotero(1)(+0000000): Localized string not available for searchConditions.seriesText

zotero(1)(+0000000): Localized string not available for searchConditions.journalAbbreviation

zotero(1)(+0000000): Localized string not available for searchConditions.ISSN

zotero(1)(+0000001): Localized string not available for searchConditions.scale

zotero(1)(+0000000): Localized string not available for searchConditions.country

zotero(1)(+0000000): Localized string not available for searchConditions.assignee

zotero(1)(+0000000): Localized string not available for searchConditions.issuingAuthority

zotero(1)(+0000000): Localized string not available for searchConditions.filingDate

zotero(1)(+0000000): Localized string not available for searchConditions.applicationNumber

zotero(1)(+0000000): Localized string not available for searchConditions.priorityNumbers

zotero(1)(+0000000): Localized string not available for searchConditions.references

zotero(1)(+0000000): Localized string not available for searchConditions.legalStatus

zotero(1)(+0000000): Localized string not available for searchConditions.meetingName

zotero(1)(+0000000): Localized string not available for searchConditions.codeNumber

zotero(1)(+0000000): Localized string not available for searchConditions.archiveID

zotero(1)(+0000000): Localized string not available for searchConditions.citationKey

zotero(1)(+0000000): Localized string not available for searchConditions.accessDate

zotero(1)(+0000000): Localized string not available for searchConditions.date

zotero(1)(+0000000): Localized string not available for searchConditions.pages

zotero(1)(+0000000): Localized string not available for searchConditions.section

zotero(1)(+0000000): Localized string not available for searchConditions.seriesNumber

zotero(1)(+0000000): Localized string not available for searchConditions.issue

zotero(4)(+0000003): SELECT tagID, name FROM tags

zotero(4)(+0000002): SELECT * FROM creators

zotero(3)(+0000010): Loading collection relations

zotero(4)(+0000000): SELECT * FROM collectionRelations JOIN relationPredicates USING (predicateID)

zotero(3)(+0000001): Loaded collection relations in 1 ms

zotero(3)(+0000000): Loading item relations

zotero(4)(+0000000): SELECT * FROM itemRelations JOIN relationPredicates USING (predicateID)

zotero(3)(+0000000): Loaded item relations in 0 ms

zotero(4)(+0000000): SELECT itemID AS id, fieldID, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID IN (?, ?) [58, 16]

zotero(3)(+0000018): Getting contents of C:\Users\xxxxx\AppData\Roaming\Zotero\Zotero\Profiles\isol9kpt.default\retractions.json

zotero(4)(+0000043): SELECT libraryID, itemID, DI.itemID IS NOT NULL AS deleted, RI.flag FROM items JOIN retractedItems RI USING (itemID) LEFT JOIN deletedItems DI USING (itemID)

zotero(4)(+0000002): SELECT COUNT(*) FROM settings WHERE setting='globalSchema' AND key='migrateExtra'

zotero(3)(+0000001): Loading synced settings for library 1

zotero(4)(+0000001): SELECT setting, value, synced, version FROM syncedSettings WHERE libraryID=? [1]

zotero(3)(+0000001): Loading all collections in Meine Bibliothek

zotero(3)(+0000000): Loading primaryData for collections in Meine Bibliothek

zotero(4)(+0000001): SELECT O.collectionID, O.collectionName AS name, O.libraryID, O.key, O.version, O.synced, DC.collectionID IS NOT NULL AS deleted, O.parentCollectionID AS parentID, CP.key AS parentKey, (SELECT COUNT(*) FROM collections WHERE parentCollectionID=O.collectionID) != 0 AS hasChildCollections, (SELECT COUNT(*) FROM collectionItems WHERE collectionID=O.collectionID) != 0 AS hasChildItems FROM collections O LEFT JOIN deletedCollections DC ON (O.collectionID=DC.collectionID)LEFT JOIN collections CP ON (O.parentCollectionID=CP.collectionID)  WHERE 1 AND O.libraryID=? [1]

zotero(3)(+0000002): Loaded primaryData in Meine Bibliothek in 3 ms

zotero(3)(+0000000): Loading childCollections for collections in Meine Bibliothek

zotero(4)(+0000000): SELECT C1.collectionID, C2.collectionID AS childCollectionID FROM collections C1 LEFT JOIN collections C2 ON (C1.collectionID=C2.parentCollectionID) WHERE C1.libraryID=? [1]

zotero(3)(+0000001): Loaded childCollections in Meine Bibliothek in 1 ms

zotero(3)(+0000000): Loading childItems for collections in Meine Bibliothek

zotero(4)(+0000000): SELECT collectionID, itemID FROM collections LEFT JOIN collectionItems USING (collectionID) WHERE libraryID=? [1]

zotero(3)(+0000003): Loaded childItems in Meine Bibliothek in 3 ms

zotero(3)(+0000000): Loading relations for collections in Meine Bibliothek

zotero(4)(+0000001): SELECT collectionID, predicate, object FROM collections LEFT JOIN collectionRelations USING (collectionID) LEFT JOIN relationPredicates USING (predicateID) WHERE libraryID=? [1]

zotero(3)(+0000000): Loaded relations in Meine Bibliothek in 1 ms

zotero(3)(+0000001): Loaded collections in Meine Bibliothek in 9 ms

zotero(3)(+0000000): Loading all searches in Meine Bibliothek

zotero(3)(+0000000): Loading primaryData for searches in Meine Bibliothek

zotero(4)(+0000001): SELECT O.savedSearchID, O.savedSearchName AS name, O.libraryID, O.key, O.version, O.synced, DS.savedSearchID IS NOT NULL AS deleted FROM savedSearches O LEFT JOIN deletedSearches DS ON (O.savedSearchID=DS.savedSearchID) WHERE 1 AND O.libraryID=? [1]

zotero(3)(+0000000): Loaded primaryData in Meine Bibliothek in 1 ms

zotero(3)(+0000000): Loading conditions for searches in Meine Bibliothek

zotero(4)(+0000001): SELECT savedSearchID, searchConditionID, condition, operator, value, required FROM savedSearches LEFT JOIN savedSearchConditions USING (savedSearchID) WHERE libraryID=?ORDER BY savedSearchID, searchConditionID [1]

zotero(3)(+0000000): Loaded conditions in Meine Bibliothek in 1 ms

zotero(3)(+0000000): Loaded searches in Meine Bibliothek in 2 ms

zotero(3)(+0000001): Initializing Quick Copy

zotero(3)(+0000001): Running initialization callbacks

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

zotero(3)(+0000134): monkey-patch: 6.0.4: BBT enabled

zotero(3)(+0001013): Initializing Zotero pane

zotero(3)(+0000033): Initializing React CollectionTree

zotero(3)(+0000018): Refreshing collections pane

zotero(4)(+0000001): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [1]

zotero(3)(+0000016): Rendering tag selector

zotero(3)(+0000002): Rendering tag list

zotero(3)(+0000017): React CollectionTree initialized

zotero(3)(+0000000): Initializing React ItemTree main

zotero(3)(+0000005): itemTree.render(). Displaying Item Pane Message

zotero(3)(+0000003): React ItemTree main initialized

zotero(3)(+0000001): User interface ready in 2839 ms

zotero(3)(+0000017): Connecting to streaming server at wss://stream.zotero.org/

zotero(3)(+0000003): itemTree.render(). Displaying Item Pane Message

zotero(4)(+0000006): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, createdByUserID, lastModifiedByUserID, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, PI.itemID IS NOT NULL AS inPublications, (CASE O.itemTypeID WHEN 2 THEN IAP.itemID WHEN 26 THEN INoP.itemID WHEN 37 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key WHEN 37 THEN IAnP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID)LEFT JOIN groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID IN (280)

zotero(3)(+0000005): Notifier.trigger('add', 'tab', [tab-t5mjtbPy], {"tab-t5mjtbPy":{"itemID":280}}) called [observers: 4]

zotero(3)(+0000010): Loading all items in Meine Bibliothek

zotero(3)(+0000001): Loading primaryData for items in Meine Bibliothek

zotero(4)(+0000000): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, createdByUserID, lastModifiedByUserID, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName  FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, PI.itemID IS NOT NULL AS inPublications, (CASE O.itemTypeID WHEN 2 THEN IAP.itemID WHEN 26 THEN INoP.itemID WHEN 37 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key WHEN 37 THEN IAnP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID)LEFT JOIN groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? [1]

zotero(3)(+0000006): LibreOfficePlugin: Communication server listening on 127.0.0.1:23116

zotero(3)(+0000001): LibreOfficePlugin: Registering shutdown listener

zotero(3)(+0000003): PluginInstaller: fetching addon info

zotero(3)(+0000001): PluginInstaller: addon info fetched

zotero(3)(+0000000): BBT startup 1

zotero(3)(+0000001): {better-bibtex} +null Loading Better BibTeX: starting...