Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- zotero(3)(+0000000): Using data directory C:\Users\xxxxx\Zotero
- zotero(3)(+0000008): Asynchronously opening database 'zotero'
- zotero(3)(+0000001): C:\Users\xxxxx\Zotero\zotero.sqlite
- zotero(4)(+0000005): PRAGMA main.locking_mode=EXCLUSIVE
- zotero(4)(+0000001): PRAGMA page_size
- zotero(4)(+0000000): PRAGMA cache_size=2000
- zotero(4)(+0000000): PRAGMA foreign_keys=true
- zotero(4)(+0000021): SELECT version FROM version WHERE schema='system'
- zotero(3)(+0000002): Proxy not required for https://zoteroproxycheck.s3.amazonaws.com/test
- zotero(4)(+0000001): SELECT version FROM version WHERE schema='userdata'
- zotero(4)(+0000001): SELECT version FROM version WHERE schema='compatibility'
- zotero(4)(+0000003): SELECT value FROM settings WHERE setting='db' AND key='integrityCheck'
- zotero(3)(+0000002): HTTP GET resource://zotero/schema/global/schema.json
- zotero(3)(+0000020): HTTP GET resource://zotero/schema/global/schema.json succeeded with 200
- zotero(4)(+0000003): SELECT version FROM version WHERE schema='globalSchema'
- zotero(3)(+0000002): Database is up to date with global schema version 15 -- skipping update
- zotero(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql
- zotero(3)(+0000000): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200
- zotero(4)(+0000001): PRAGMA foreign_keys = false
- zotero(4)(+0000000): Beginning DB transaction MGvm5c15
- zotero(3)(+0000002): HTTP GET resource://zotero/schema/system.sql
- zotero(3)(+0000001): HTTP GET resource://zotero/schema/system.sql succeeded with 200
- zotero(3)(+0000001): Updating custom tables
- zotero(4)(+0000000): PRAGMA foreign_keys
- zotero(4)(+0000001): SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND tbl_name=? ['customItemTypes']
- zotero(4)(+0000001): DELETE FROM itemTypesCombined
- zotero(4)(+0000005): DELETE FROM fieldsCombined
- zotero(4)(+0000001): DELETE FROM itemTypeFieldsCombined
- zotero(4)(+0000000): DELETE FROM baseFieldMappingsCombined
- zotero(4)(+0000001): 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)(+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(4)(+0000000): 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)(+0000002): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings
- 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 1 FROM itemDataValues WHERE value=0 LIMIT 1
- zotero(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql
- zotero(3)(+0000000): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200
- zotero(4)(+0000001): SELECT version FROM version WHERE schema='triggers'
- zotero(3)(+0000000): HTTP GET resource://zotero/schema/triggers.sql
- zotero(3)(+0000002): HTTP GET resource://zotero/schema/triggers.sql succeeded with 200
- zotero(3)(+0000000): Updating custom tables
- zotero(4)(+0000000): PRAGMA foreign_keys
- zotero(4)(+0000000): DELETE FROM itemTypesCombined
- zotero(4)(+0000001): DELETE FROM fieldsCombined
- zotero(4)(+0000000): DELETE FROM itemTypeFieldsCombined
- zotero(4)(+0000000): 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)(+0000001): 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)(+0000000): 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 MGvm5c15
- zotero(4)(+0000002): PRAGMA foreign_keys = true
- zotero(4)(+0000001): Beginning DB transaction qG0kGM81
- zotero(4)(+0000001): SELECT value FROM settings WHERE setting='client' AND key='lastVersion'
- zotero(4)(+0000001): Committed DB transaction qG0kGM81
- zotero(4)(+0000000): SELECT key, value FROM settings WHERE setting='account'
- zotero(4)(+0000001): 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)(+0000000): 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)(+0000002): SELECT COALESCE(MAX(collectionID) + 1, 1) FROM collections
- zotero(4)(+0000000): SELECT COALESCE(MAX(creatorID) + 1, 1) FROM creators
- zotero(4)(+0000001): SELECT COALESCE(MAX(creatorTypeID) + 1, 1) FROM creatorTypes
- zotero(4)(+0000007): SELECT COALESCE(MAX(customFieldID) + 1, 1) FROM customFields
- zotero(4)(+0000000): SELECT COALESCE(MAX(customItemTypeID) + 1, 1) FROM customItemTypes
- zotero(4)(+0000002): SELECT COALESCE(MAX(fieldID) + 1, 1) FROM fields
- zotero(4)(+0000001): SELECT COALESCE(MAX(valueID) + 1, 1) FROM itemDataValues
- zotero(4)(+0000000): SELECT COALESCE(MAX(itemTypeID) + 1, 1) FROM itemTypes
- zotero(4)(+0000000): SELECT COALESCE(MAX(itemID) + 1, 1) FROM items
- zotero(4)(+0000001): SELECT COALESCE(MAX(libraryID) + 1, 1) FROM libraries
- zotero(4)(+0000000): SELECT COALESCE(MAX(proxyID) + 1, 1) FROM proxies
- zotero(4)(+0000001): 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)(+0000001): 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)(+0000000): SELECT * FROM fieldFormats
- zotero(4)(+0000001): SELECT * FROM fieldsCombined
- zotero(4)(+0000001): SELECT fieldID, itemTypeID FROM itemTypeFieldsCombined
- zotero(4)(+0000007): 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)(+0000018): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined
- zotero(4)(+0000053): 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)(+0000006): 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)(+0000001): 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\u64bulog.default\session.json
- zotero(3)(+0000001): Running unlock callbacks
- zotero(3)(+0000000): HTTP server listening on 127.0.0.1:23119
- zotero(4)(+0000001): ATTACH ':memory:' AS 'indexing'
- zotero(4)(+0000000): CREATE TABLE indexing.fulltextWords (word NOT NULL)
- zotero(4)(+0000001): 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)(+0000000): Registering URIContentListener
- zotero(4)(+0000001): SELECT * FROM proxies
- zotero(4)(+0000002): 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)(+0000018): 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)(+0000000): 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)(+0000001): 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)(+0000000): 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)(+0000001): 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)(+0000000): 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)(+0000001): 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)(+0000002): SELECT tagID, name FROM tags
- zotero(4)(+0000003): 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\u64bulog.default\retractions.json
- zotero(4)(+0000050): 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)(+0000001): SELECT COUNT(*) FROM settings WHERE setting='globalSchema' AND key='migrateExtra'
- zotero(3)(+0000002): Loading synced settings for library 1
- zotero(4)(+0000000): SELECT setting, value, synced, version FROM syncedSettings WHERE libraryID=? [1]
- zotero(3)(+0000001): Loading all collections in Meine Bibliothek
- zotero(3)(+0000001): 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)(+0000001): Loaded primaryData in Meine Bibliothek in 2 ms
- zotero(3)(+0000001): 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)(+0000000): SELECT collectionID, predicate, object FROM collections LEFT JOIN collectionRelations USING (collectionID) LEFT JOIN relationPredicates USING (predicateID) WHERE libraryID=? [1]
- zotero(3)(+0000001): Loaded relations in Meine Bibliothek in 1 ms
- zotero(3)(+0000000): Loaded collections in Meine Bibliothek in 9 ms
- zotero(3)(+0000000): Loading all searches in Meine Bibliothek
- zotero(3)(+0000001): Loading primaryData for searches in Meine Bibliothek
- zotero(4)(+0000000): 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 0 ms
- zotero(3)(+0000001): Loading conditions for searches in Meine Bibliothek
- zotero(4)(+0000000): SELECT savedSearchID, searchConditionID, condition, operator, value, required FROM savedSearches LEFT JOIN savedSearchConditions USING (savedSearchID) WHERE libraryID=?ORDER BY savedSearchID, searchConditionID [1]
- zotero(3)(+0000001): Loaded conditions in Meine Bibliothek in 1 ms
- zotero(3)(+0000000): Loaded searches in Meine Bibliothek in 3 ms
- zotero(3)(+0000001): Initializing Quick Copy
- zotero(3)(+0000000): Running initialization callbacks
- zotero(3)(+0000000): Triggering "zotero-loaded" event
- zotero(3)([31;40m+0000260[0m): monkey-patch: 6.0.6: BBT enabled
- zotero(3)(+0000134): {better-bibtex} +null idle?: queue paused: startup
- zotero(3)(+0000000): {better-bibtex} +1 scheduler: pausing
- zotero(3)([31;40m+0001317[0m): {better-bibtex} +1317 monkey-patching parseLibraryKeyHash
- zotero(3)(+0000000): {better-bibtex} +0 monkey-patching parseLibraryKey
- zotero(3)([31;40m+0000440[0m): Initializing Zotero pane
- zotero(3)(+0000053): Initializing React CollectionTree
- zotero(3)(+0000012): Refreshing collections pane
- zotero(4)(+0000001): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [1]
- zotero(3)(+0000012): Rendering tag selector
- zotero(3)(+0000002): Rendering tag list
- zotero(3)(+0000012): React CollectionTree initialized
- zotero(3)(+0000000): Initializing React ItemTree main
- zotero(3)(+0000005): itemTree.render(). Displaying Item Pane Message
- zotero(3)(+0000002): React ItemTree main initialized
- zotero(3)(+0000000): User interface ready in 3816 ms
- zotero(3)(+0000017): Connecting to streaming server at wss://stream.zotero.org/
- zotero(3)(+0000003): itemTree.render(). Displaying Item Pane Message
- zotero(3)(+0000013): Notifier.trigger('add', 'tab', [tab-BiABgAsO], {"tab-BiABgAsO":{"itemID":921}}) called [observers: 4]
- zotero(3)(+0000012): Notifier.trigger('add', 'tab', [tab-E4u68wQ1], {"tab-E4u68wQ1":{"itemID":921}}) called [observers: 4]
- zotero(3)(+0000005): Notifier.trigger('add', 'tab', [tab-K3Y7db0s], {"tab-K3Y7db0s":{"itemID":966}}) called [observers: 4]
- zotero(3)(+0000009): Notifier.trigger('add', 'tab', [tab-HqBQn67J], {"tab-HqBQn67J":{"itemID":968}}) called [observers: 4]
- zotero(3)(+0000003): Loading all items in Meine Bibliothek
- zotero(3)(+0000000): Loading primaryData for items in Meine Bibliothek
- zotero(4)(+0000001): 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)(+0000018): LibreOfficePlugin: Communication server listening on 127.0.0.1:23116
- zotero(3)(+0000000): LibreOfficePlugin: Registering shutdown listener
- zotero(3)(+0000011): PluginInstaller: fetching addon info
- zotero(3)(+0000002): PluginInstaller: addon info fetched
- zotero(3)(+0000000): BBT startup 1
- zotero(3)(+0000000): {better-bibtex} +633 Loading Better BibTeX: starting...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement