Skip to content

Instantly share code, notes, and snippets.

@schmittlauch

schmittlauch/gist:ac7451d0b246ce04d572908040635a3a Secret

Created May 6, 2019 18:32
Show Gist options
  • Save schmittlauch/ac7451d0b246ce04d572908040635a3a to your computer and use it in GitHub Desktop.
Save schmittlauch/ac7451d0b246ce04d572908040635a3a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
(3)(+0000000): Using data directory /home/spiollinux/Zotero
(3)(+0000086): IPC: Initializing pipe at /home/spiollinux/Zotero/pipes/1557167067364
(3)(+0000004): Asynchronously opening database 'zotero'
(3)(+0000000): /home/spiollinux/Zotero/zotero.sqlite
(4)(+0000014): PRAGMA main.locking_mode=EXCLUSIVE
(4)(+0000002): PRAGMA page_size
(4)(+0000002): PRAGMA cache_size=250
(4)(+0000002): PRAGMA foreign_keys=true
(4)(+0000016): SELECT version FROM version WHERE schema='system'
(3)(+0000006): Proxy not required for https://zoteroproxycheck.s3.amazonaws.com/test
(4)(+0000006): SELECT version FROM version WHERE schema='userdata'
(4)(+0000002): SELECT version FROM version WHERE schema='compatibility'
(4)(+0000006): SELECT value FROM settings WHERE setting='db' AND key='integrityCheck'
(3)(+0000002): HTTP GET resource://zotero/schema/userdata.sql
(3)(+0000002): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200
(4)(+0000002): PRAGMA foreign_keys = false
(4)(+0000002): Beginning DB transaction 1l7bes9l
(3)(+0000010): HTTP GET resource://zotero/schema/system.sql
(3)(+0000004): HTTP GET resource://zotero/schema/system.sql succeeded with 200
(3)(+0000002): Updating custom tables
(4)(+0000002): DELETE FROM itemTypesCombined
(4)(+0000004): SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND tbl_name=? ['customItemTypes']
(4)(+0000006): DELETE FROM fieldsCombined WHERE fieldID NOT IN (SELECT fieldID FROM itemData)
(4)(+0000004): DELETE FROM itemTypeFieldsCombined
(4)(+0000004): DELETE FROM baseFieldMappingsCombined
(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
(4)(+0000002): INSERT OR IGNORE 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
(4)(+0000002): 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
(4)(+0000004): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings
(3)(+0000002): HTTP GET resource://zotero/schema/userdata.sql
(3)(+0000002): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200
(4)(+0000002): SELECT version FROM version WHERE schema='triggers'
(3)(+0000000): HTTP GET resource://zotero/schema/triggers.sql
(3)(+0000004): HTTP GET resource://zotero/schema/triggers.sql succeeded with 200
(3)(+0000002): Updating custom tables
(4)(+0000000): DELETE FROM itemTypesCombined
(4)(+0000002): DELETE FROM fieldsCombined WHERE fieldID NOT IN (SELECT fieldID FROM itemData)
(4)(+0000002): DELETE FROM itemTypeFieldsCombined
(4)(+0000000): DELETE FROM baseFieldMappingsCombined
(4)(+0000002): 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
(4)(+0000002): INSERT OR IGNORE 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
(4)(+0000002): 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
(4)(+0000002): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings
(4)(+0000084): Committed DB transaction 1l7bes9l
(4)(+0000002): PRAGMA foreign_keys = true
(4)(+0000004): Beginning DB transaction SfX3z9UW
(4)(+0000002): SELECT value FROM settings WHERE setting='client' AND key='lastVersion'
(4)(+0000004): Committed DB transaction SfX3z9UW
(4)(+0000002): SELECT key, value FROM settings WHERE setting='account'
(4)(+0000004): 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']
(4)(+0000002): 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)
(4)(+0000002): 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)
(4)(+0000004): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined
(4)(+0000004): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE (display=2 AND itemTypeID!=5) LIMIT 5
(4)(+0000042): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE display IN (1,2)
(3)(+0000002): zotero-better-bibtex: loading content/BetterBibTeX.ts
(3)(+0000000): zotero-better-bibtex: loading content/better-bibtex.ts
(3)(+0000000): zotero-better-bibtex: loading content/prefs.ts
(3)(+0000000): zotero-better-bibtex: loading content/debug.ts
(3)(+0000000): zotero-better-bibtex: loading content/logger.ts
(3)(+0000000): zotero-better-bibtex: loaded content/logger.ts
(3)(+0000000): zotero-better-bibtex: loaded content/debug.ts
(3)(+0000000): zotero-better-bibtex: loading content/events.ts
(3)(+0000002): zotero-better-bibtex: loading content/monkey-patch.ts
(3)(+0000000): zotero-better-bibtex: loaded content/monkey-patch.ts
(3)(+0000002): {better-bibtex +null} events: handler registered for preference-changed
(3)(+0000000): {better-bibtex +0} events: handler registered for items-changed
(3)(+0000000): {better-bibtex +0} events: handler registered for items-removed
(3)(+0000000): {better-bibtex +0} events: handler registered for libraries-changed
(3)(+0000000): {better-bibtex +0} events: handler registered for collections-changed
(3)(+0000000): {better-bibtex +0} events: handler registered for collections-removed
(3)(+0000000): {better-bibtex +0} events: handler registered for libraries-removed
(3)(+0000002): {better-bibtex +2} events: handler registered for loaded
(3)(+0000000): zotero-better-bibtex: loaded content/events.ts
(3)(+0000000): zotero-better-bibtex: loading content/zotero-config.ts
(3)(+0000000): {better-bibtex +0} zotero config loaded: {"GUID":"zotero@chnm.gmu.edu","ID":"zotero","CLIENT_NAME":"Zotero","DOMAIN_NAME":"zotero.org","REPOSITORY_URL":"https://repo.zotero.org/repo/","REPOSITORY_CHECK_INTERVAL":86400,"REPOSITORY_RETRY_INTERVAL":3600,"BASE_URI":"http://zotero.org/","WWW_BASE_URL":"https://www.zotero.org/","PROXY_AUTH_URL":"https://zoteroproxycheck.s3.amazonaws.com/test","API_URL":"https://api.zotero.org/","STREAMING_URL":"wss://stream.zotero.org/","SERVICES_URL":"https://services.zotero.org/","API_VERSION":3,"CONNECTOR_MIN_VERSION":"5.0.39","PREF_BRANCH":"extensions.zotero.","BOOKMARKLET_ORIGIN":"https://www.zotero.org","BOOKMARKLET_URL":"https://www.zotero.org/bookmarklet/","START_URL":"https://www.zotero.org/start","QUICK_START_URL":"https://www.zotero.org/support/quick_start_guide","PDF_TOOLS_URL":"https://www.zotero.org/download/xpdf/","SUPPORT_URL":"https://www.zotero.org/support/","TROUBLESHOOTING_URL":"https://www.zotero.org/support/getting_help","FEEDBACK_URL":"https://forums.zotero.org/","CONNECTORS_URL":"https://www.zotero.org/download/connectors","Zotero":{"version":"5.0.66","platform":"Linux x86_64","oscpu":"Linux x86_64","locale":"de","appName":"Zotero","appVersion":"5.0.66","isZotero":true,"isJurisM":false}}
(3)(+0000000): zotero-better-bibtex: loaded content/zotero-config.ts
(3)(+0000000): zotero-better-bibtex: loaded content/prefs.ts
(3)(+0000000): zotero-better-bibtex: loading content/pull-export.ts
(3)(+0000002): zotero-better-bibtex: loading content/translators.ts
(3)(+0000000): zotero-better-bibtex: loading content/db/cache.ts
(3)(+0000000): zotero-better-bibtex: loading content/db/loki.ts
(3)(+0000128): zotero-better-bibtex: loaded content/db/loki.ts
(3)(+0000000): zotero-better-bibtex: loading content/db/store.ts
(3)(+0000000): zotero-better-bibtex: loaded content/db/store.ts
(3)(+0000002): {better-bibtex +132} events: handler registered for preference-changed
(3)(+0000000): zotero-better-bibtex: loaded content/db/cache.ts
(3)(+0000000): zotero-better-bibtex: loading content/db/main.ts
(3)(+0000000): zotero-better-bibtex: loading content/get-items-async.ts
(3)(+0000000): zotero-better-bibtex: loaded content/get-items-async.ts
(3)(+0000000): zotero-better-bibtex: loaded content/db/main.ts
(3)(+0000000): zotero-better-bibtex: loading content/timeout.ts
(3)(+0000000): zotero-better-bibtex: loaded content/timeout.ts
(3)(+0000000): zotero-better-bibtex: loaded content/translators.ts
(3)(+0000000): zotero-better-bibtex: loaded content/pull-export.ts
(3)(+0000000): zotero-better-bibtex: loading content/json-rpc.ts
(3)(+0000000): zotero-better-bibtex: loading content/key-manager.ts
(3)(+0000000): zotero-better-bibtex: loading content/key-manager/kuroshiro.ts
(3)(+0000006): zotero-better-bibtex: loaded content/key-manager/kuroshiro.ts
(3)(+0000000): zotero-better-bibtex: loading content/flash.ts
(3)(+0000000): zotero-better-bibtex: loaded content/flash.ts
(3)(+0000000): zotero-better-bibtex: loading content/arXiv.ts
(3)(+0000000): zotero-better-bibtex: loaded content/arXiv.ts
(3)(+0000000): zotero-better-bibtex: loading content/var-extract.ts
(3)(+0000002): zotero-better-bibtex: loading content/key-manager/get-set.ts
(3)(+0000000): zotero-better-bibtex: loaded content/key-manager/get-set.ts
(3)(+0000000): zotero-better-bibtex: loaded content/var-extract.ts
(3)(+0000000): zotero-better-bibtex: loading content/db/zotero.ts
(3)(+0000000): zotero-better-bibtex: loaded content/db/zotero.ts
(3)(+0000000): zotero-better-bibtex: loading content/key-manager/formatter.ts
(3)(+0000082): zotero-better-bibtex: loading content/journal-abbrev.ts
(3)(+0000000): zotero-better-bibtex: loaded content/journal-abbrev.ts
(3)(+0000002): zotero-better-bibtex: loading content/dateparser.ts
(3)(+0000014): zotero-better-bibtex: loaded content/dateparser.ts
(3)(+0000008): zotero-better-bibtex: loaded content/key-manager/formatter.ts
(3)(+0000000): zotero-better-bibtex: loading content/auto-export.ts
(3)(+0000000): zotero-better-bibtex: loading content/path-search.ts
(3)(+0000000): zotero-better-bibtex: loaded content/path-search.ts
(3)(+0000000): {better-bibtex +114} events: handler registered for preference-changed
(3)(+0000002): {better-bibtex +2} events: handler registered for libraries-changed
(3)(+0000000): {better-bibtex +0} events: handler registered for libraries-removed
(3)(+0000000): {better-bibtex +0} events: handler registered for collections-changed
(3)(+0000000): {better-bibtex +0} events: handler registered for collections-removed
(3)(+0000000): zotero-better-bibtex: loaded content/auto-export.ts
(3)(+0000000): zotero-better-bibtex: loaded content/key-manager.ts
(3)(+0000000): zotero-better-bibtex: loaded content/json-rpc.ts
(3)(+0000000): zotero-better-bibtex: loading content/aux-scanner.ts
(3)(+0000000): zotero-better-bibtex: loaded content/aux-scanner.ts
(3)(+0000000): {better-bibtex +0} Loading Better BibTeX
(3)(+0000000): zotero-better-bibtex: loading content/serializer.ts
(3)(+0000000): zotero-better-bibtex: loaded content/serializer.ts
(3)(+0000000): zotero-better-bibtex: loading content/tex-studio.ts
(3)(+0000000): zotero-better-bibtex: loaded content/tex-studio.ts
(3)(+0000000): zotero-better-bibtex: loading content/cayw.ts
(3)(+0000000): zotero-better-bibtex: loading content/cayw/formatter.ts
(3)(+0000000): zotero-better-bibtex: loaded content/cayw/formatter.ts
(3)(+0000002): zotero-better-bibtex: loading content/escape.ts
(3)(+0000000): zotero-better-bibtex: loaded content/escape.ts
(3)(+0000000): zotero-better-bibtex: loaded content/cayw.ts
(3)(+0000000): zotero-better-bibtex: loading content/qr-check.ts
(3)(+0000000): zotero-better-bibtex: loaded content/qr-check.ts
(3)(+0000000): zotero-better-bibtex: loading content/title-case.ts
(3)(+0000000): zotero-better-bibtex: loaded content/title-case.ts
(3)(+0000000): zotero-better-bibtex: loading content/markupparser.ts
(3)(+0000004): zotero-better-bibtex: loaded content/markupparser.ts
(3)(+0000000): {better-bibtex +6} Loading Better BibTeX: setup done
(3)(+0000000): zotero-better-bibtex: loaded content/better-bibtex.ts
(3)(+0000000): zotero-better-bibtex: loaded content/BetterBibTeX.ts
(4)(+0000004): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE display=0
(4)(+0000006): SELECT customItemTypeID AS id, label, icon FROM customItemTypes
(4)(+0000002): SELECT * FROM fieldFormats
(3)(+0000002): zotero-better-bibtex: loading content/ZoteroPane.ts
(3)(+0000000): zotero-better-bibtex: loaded content/ZoteroPane.ts
(4)(+0000000): SELECT * FROM fieldsCombined
(3)(+0000002): zotero-better-bibtex: loading content/KeyManager.ts
(3)(+0000000): zotero-better-bibtex: loaded content/KeyManager.ts
(4)(+0000002): SELECT fieldID, itemTypeID FROM itemTypeFieldsCombined
(4)(+0000016): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined
(3)(+0000000): zotero-better-bibtex: loading content/TestSupport.ts
(3)(+0000000): zotero-better-bibtex: loaded content/TestSupport.ts
(4)(+0000008): 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)
(3)(+0000008): zotero-better-bibtex: loading content/ItemPane.ts
(3)(+0000000): zotero-better-bibtex: loaded content/ItemPane.ts
(3)(+0000148): Setting mode to note
(3)(+0000008): Setting mode to note
(3)(+0000008): Setting mode to note
(3)(+0000008): Setting mode to note
(4)(+0000046): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined
(4)(+0000102): SELECT itemTypeID, baseFieldID, fieldID, fieldName FROM baseFieldMappingsCombined JOIN fieldsCombined USING (fieldID)
(4)(+0000008): SELECT DISTINCT fieldID FROM baseFieldMappingsCombined
(4)(+0000002): SELECT itemTypeID, fieldID FROM itemTypeFieldsCombined ORDER BY orderIndex
(3)(+0000006): LibreOfficePlugin: Communication server listening on 127.0.0.1:23116
(3)(+0000000): LibreOfficePlugin: Registering shutdown listener
(3)(+0000002): {better-bibtex +388} Loading Better BibTeX: starting...
(3)(+0000000): {better-bibtex +0} pathSearch: looking for texstudio in {"path":["/run/wrappers/bin","/usr/bin","/usr/sbin"],"pathext":[""],"sep":"/"}
(3)(+0000000): {better-bibtex +0} pathSearch: texstudio not found in ["/run/wrappers/bin","/usr/bin","/usr/sbin"]
(4)(+0000002): Unregistering notifier observer in notifier with id 'itembox_A7'
(3)(+0000010): {better-bibtex +12} TeXstudio: not found
(3)(+0000002): {better-bibtex +2} Startup progress: waiting for Zotero locks...
(4)(+0000008): SELECT creatorTypeID AS id, creatorType AS name FROM creatorTypes
(4)(+0000044): SELECT itemTypeID, creatorTypeID AS id, creatorType AS name, primaryField FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes
(4)(+0000028): SELECT itemTypeID, creatorTypeID FROM itemTypeCreatorTypes WHERE primaryField=1
(4)(+0000004): SELECT fileTypeID AS id, fileType AS name FROM fileTypes
(4)(+0000004): SELECT charsetID AS id, charset AS name FROM charsets
(4)(+0000004): SELECT predicateID AS id, predicate AS name FROM relationPredicates
(3)(+0000000): Running unlock callbacks
(3)(+0000000): HTTP server listening on 127.0.0.1:23119
(4)(+0000002): ATTACH ':memory:' AS 'indexing'
(4)(+0000000): CREATE TABLE indexing.fulltextWords (word NOT NULL)
(4)(+0000002): SELECT version FROM version WHERE schema='lastsync'
(4)(+0000002): SELECT version FROM version WHERE schema='lastlocalsync'
(4)(+0000002): SELECT name, syncObjectTypeID AS id FROM syncObjectTypes
(3)(+0000002): Registering auto-sync idle observer
(3)(+0000002): Registering URIContentListener
(4)(+0000000): SELECT * FROM proxies
(4)(+0000008): SELECT COALESCE(MAX(collectionID) + 1, 1) FROM collections
(4)(+0000002): SELECT COALESCE(MAX(creatorID) + 1, 1) FROM creators
(3)(+0000000): Getting contents of /home/spiollinux/Zotero/locate/engines.json
(4)(+0000002): SELECT COALESCE(MAX(customFieldID) + 1, 1) FROM customFields
(4)(+0000002): SELECT COALESCE(MAX(customItemTypeID) + 1, 1) FROM customItemTypes
(4)(+0000002): SELECT COALESCE(MAX(valueID) + 1, 1) FROM itemDataValues
(4)(+0000002): SELECT COALESCE(MAX(itemID) + 1, 1) FROM items
(4)(+0000000): SELECT COALESCE(MAX(libraryID) + 1, 1) FROM libraries
(4)(+0000002): SELECT COALESCE(MAX(proxyID) + 1, 1) FROM proxies
(4)(+0000000): SELECT COALESCE(MAX(savedSearchID) + 1, 1) FROM savedSearches
(4)(+0000002): SELECT COALESCE(MAX(tagID) + 1, 1) FROM tags
(4)(+0000000): SELECT ROWID AS id, libraryID, key FROM collections
(4)(+0000002): SELECT ROWID AS id, libraryID, key FROM items
(4)(+0000018): SELECT ROWID AS id, libraryID, key FROM savedSearches
(4)(+0000004): SELECT fieldName FROM fieldsCombined WHERE fieldName NOT IN ('accessDate', 'date', 'pages', 'section','seriesNumber','issue')
(1)(+0000002): Unknown item type 'nsfReviewer'
(1)(+0000000): Unknown item type 'nsfReviewer'
(4)(+0000014): SELECT tagID, name FROM tags
(4)(+0000006): SELECT * FROM creators
(3)(+0000012): Loading collection relations
(4)(+0000000): SELECT * FROM collectionRelations JOIN relationPredicates USING (predicateID)
(3)(+0000002): Loaded collection relations in 2 ms
(3)(+0000000): Loading item relations
(4)(+0000000): SELECT * FROM itemRelations JOIN relationPredicates USING (predicateID)
(3)(+0000000): Loaded item relations in 0 ms
(3)(+0000002): Loading synced settings for library 1
(4)(+0000000): SELECT setting, value, synced, version FROM syncedSettings WHERE libraryID=? [1]
(3)(+0000002): Loading all collections in Meine Bibliothek
(3)(+0000002): Loading primaryData for collections in Meine Bibliothek
(4)(+0000000): SELECT O.collectionID, O.collectionName AS name, O.libraryID, O.key, O.version, O.synced, 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 collections CP ON (O.parentCollectionID=CP.collectionID) WHERE 1 AND O.libraryID=? [1]
(3)(+0000002): Loaded primaryData in Meine Bibliothek in 2 ms
(3)(+0000000): Loading childCollections for collections in Meine Bibliothek
(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]
(3)(+0000002): Loaded childCollections in Meine Bibliothek in 2 ms
(3)(+0000000): Loading childItems for collections in Meine Bibliothek
(4)(+0000002): SELECT collectionID, itemID FROM collections LEFT JOIN collectionItems USING (collectionID) WHERE libraryID=? [1]
(3)(+0000002): Loaded childItems in Meine Bibliothek in 4 ms
(3)(+0000000): Loading relations for collections in Meine Bibliothek
(4)(+0000000): SELECT collectionID, predicate, object FROM collections LEFT JOIN collectionRelations USING (collectionID) LEFT JOIN relationPredicates USING (predicateID) WHERE libraryID=? [1]
(3)(+0000002): Loaded relations in Meine Bibliothek in 2 ms
(3)(+0000000): Loaded collections in Meine Bibliothek in 12 ms
(3)(+0000002): Loading all searches in Meine Bibliothek
(3)(+0000000): Loading primaryData for searches in Meine Bibliothek
(4)(+0000002): SELECT O.savedSearchID, O.savedSearchName AS name, O.libraryID, O.key, O.version, O.synced FROM savedSearches O WHERE 1 AND O.libraryID=? [1]
(3)(+0000000): Loaded primaryData in Meine Bibliothek in 2 ms
(3)(+0000002): Loading conditions for searches in Meine Bibliothek
(4)(+0000000): SELECT savedSearchID, searchConditionID, condition, operator, value, required FROM savedSearches LEFT JOIN savedSearchConditions USING (savedSearchID) WHERE libraryID=?ORDER BY savedSearchID, searchConditionID [1]
(3)(+0000002): Loaded conditions in Meine Bibliothek in 2 ms
(3)(+0000000): Loaded searches in Meine Bibliothek in 6 ms
(3)(+0000000): Initializing Quick Copy
(3)(+0000002): Running initialization callbacks
(3)(+0000000): Triggering "zotero-loaded" event
(3)(+0000000): Initializing Zotero pane
(3)(+0000010): Creating collections view with id t8zSjESb
(3)(+0000002): Refreshing collections pane
(4)(+0000002): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [1]
(3)(+0000054): Rendering tag selector
(3)(+0000004): Rendering tag list
(4)(+0000040): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE libraryID=? [1]
(3)(+0000006): Creating items view with id Qhlnx0w0
(3)(+0000000): Waiting for items to load for library 1
(3)(+0000000): Loading all items in Meine Bibliothek
(3)(+0000002): Loading primaryData for items in Meine Bibliothek
(4)(+0000000): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, 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 IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (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 IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID IN (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 14 THEN IAP.itemID WHEN 1 THEN INoP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 14 THEN IAP.key WHEN 1 THEN INoP.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, 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 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 feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? [1]
(3)(+0000078): Loaded primaryData in Meine Bibliothek in 78 ms
(3)(+0000000): Loading creators for items in Meine Bibliothek
(4)(+0000002): SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT JOIN itemCreators USING (itemID) WHERE libraryID=? ORDER BY itemID, orderIndex [1]
(3)(+0000024): Loaded creators in Meine Bibliothek in 26 ms
(3)(+0000000): Loading itemData for items in Meine Bibliothek
(4)(+0000000): SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID) JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=? [1, 1]
(3)(+0000008): Rendering tag selector
(3)(+0000002): Rendering tag list
(3)(+0000008): Tag selector updated
(4)(+0000070): SELECT itemID FROM items WHERE libraryID=? [1]
(4)(+0000036): SELECT itemID, title FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments) [1]
(3)(+0000024): Loaded itemData in Meine Bibliothek in 148 ms
(3)(+0000000): Loading note for items in Meine Bibliothek
(4)(+0000002): SELECT itemID, note FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? [1]
(4)(+0000004): SELECT itemID FROM items WHERE libraryID=? AND itemTypeID IN (?, ?) AND itemID NOT IN (SELECT itemID FROM itemNotes) [1, 1, 14]
(3)(+0000002): Loaded note in Meine Bibliothek in 8 ms
(3)(+0000000): Loading childItems for items in Meine Bibliothek
(4)(+0000000): SELECT parentItemID, A.itemID, value AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAttachments A JOIN items I ON (A.parentItemID=I.itemID) LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [1]
(4)(+0000004): SELECT parentItemID, N.itemID, title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemNotes N JOIN items I ON (N.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [1]
(4)(+0000004): SELECT itemID FROM items I WHERE libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments UNION SELECT itemID FROM itemNotes) [1]
(3)(+0000004): Loaded childItems in Meine Bibliothek in 12 ms
(3)(+0000000): Loading tags for items in Meine Bibliothek
(4)(+0000000): SELECT itemID, name, type FROM items LEFT JOIN itemTags USING (itemID) LEFT JOIN tags USING (tagID) WHERE libraryID=? [1]
(3)(+0000014): Loaded tags in Meine Bibliothek in 14 ms
(3)(+0000000): Loading collections for items in Meine Bibliothek
(4)(+0000002): SELECT itemID, collectionID FROM items LEFT JOIN collectionItems USING (itemID) WHERE libraryID=? [1]
(3)(+0000004): Loaded collections in Meine Bibliothek in 6 ms
(3)(+0000000): Loading relations for items in Meine Bibliothek
(4)(+0000002): SELECT itemID, predicate, object FROM items LEFT JOIN itemRelations USING (itemID) LEFT JOIN relationPredicates USING (predicateID) WHERE libraryID=? [1]
(3)(+0000004): Loaded relations in Meine Bibliothek in 6 ms
(3)(+0000000): Loaded items in Meine Bibliothek in 300 ms
(3)(+0000002): Setting tree for C6 items view Qhlnx0w0
(3)(+0000002): Refreshing items list for Qhlnx0w0
(4)(+0000008): CREATE TEMPORARY TABLE tmpSearchResults_RPreBrdu AS SELECT itemID FROM items WHERE (itemID NOT IN (SELECT itemID FROM deletedItems) AND itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems))) AND (itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL)) AND itemID IN (SELECT itemID FROM items WHERE (libraryID=?)) AND itemID IN (SELECT itemID FROM collectionItems WHERE (collectionID IN (6))) [1]
(4)(+0000002): CREATE INDEX tmpSearchResults_RPreBrdu_itemID ON tmpSearchResults_RPreBrdu(itemID)
(4)(+0000002): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT itemID FROM items WHERE (itemID NOT IN (SELECT itemID FROM deletedItems) AND itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems))) AND itemID IN (SELECT itemID FROM items WHERE (libraryID=?))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_RPreBrdu) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_RPreBrdu)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_RPreBrdu))) [1]
(4)(+0000004): DROP TABLE IF EXISTS tmpSearchResults_RPreBrdu
(3)(+0000006): Sorting items list by title, firstCreator, date, dateAdded ascending for 61 items
(3)(+0000004): Sorted 61 items in 4 ms
(3)(+0000000): Refreshed open parents in 0 ms
(3)(+0000004): Rendering tag selector
(3)(+0000002): Rendering tag list
(3)(+0000006): Tag selector updated
(3)(+0000000): Updating tag selector from current view
(3)(+0000000): Creating tmpSearchResults_aYu9JxAi with 145 items
(3)(+0000006): Set tree for items view Qhlnx0w0 in 46 ms
(3)(+0000000): User interface ready in 2174 ms
(3)(+0000014): Connecting to streaming server at wss://stream.zotero.org/
(3)(+0000002): {better-bibtex +694} Startup progress: Warten auf Zotero-Datenbank...
(3)(+0000004): {better-bibtex +4} Startup progress: progress window up
(4)(+0000008): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [378, 3, 'https://blog.twitter.com/official/en_us/a/2011/numbers.html']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [388, 3, '']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [409, 3, 'http://portal.acm.org/citation.cfm?doid=1883612.1883615']
(4)(+0000006): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [423, 3, '']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [334, 3, 'http://waterken.sourceforge.net/aclsdont/current.pdf']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [324, 3, 'https://www.w3.org/TR/activitystreams-vocabulary/']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [284, 3, 'https://schub.io/blog/2018/02/01/activitypub-one-protocol-to-rule-them-all.html']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [411, 3, 'https://www.w3.org/TR/2018/REC-activitypub-20180123/']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [281, 3, 'https://blog.soykaf.com/post/activity-pub-in-pleroma/']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [310, 3, 'https://activitypub.rocks/implementation-report/']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [315, 3, 'https://github.com/WebOfTrustInfo/rebooting-the-web-of-trust-fall2017/raw/master/final-documents/activitypub-decentralized-distributed.pdf']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [398, 3, 'https://blog.dereferenced.org/activitypub-the-worse-is-better-approach-to-federated-social-networking']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [429, 3, '']
(4)(+0000008): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [336, 3, 'https://github.com/WebOfTrustInfo/rebooting-the-web-of-trust/raw/master/final-documents/dpki.pdf']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [338, 3, 'https://raw.githubusercontent.com/jaywink/social-relay/master/docs/relays.md']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [474, 3, 'https://0b101010.codes/research-things/open-data/tree/master/diaspora/tag-usage']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [460, 3, 'http://nrs.harvard.edu/urn-3:HUL.InstRepos:2962660']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [443, 3, 'http://ieeexplore.ieee.org/document/1401878/']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [472, 3, 'https://doi.org/10.5281/zenodo.1146014']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [403, 3, 'https://gnusocial.net/doc/groups']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [401, 3, 'https://www.w3.org/community/ostatus/wiki/Groups']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [439, 3, 'https://www.iana.org/assignments/ipv6-unicast-address-assignments/ipv6-unicast-address-assignments.xhtml']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [433, 3, 'http://link.springer.com/10.1007/3-540-45748-8_5']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [417, 3, 'http://www.rfc-editor.org/rfc/rfc2119.txt']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [449, 3, 'http://link.springer.com/10.1007/11422778_3']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [373, 3, '']
(4)(+0000004): CREATE UNIQUE INDEX tmpSearchResults_aYu9JxAi_itemID ON tmpSearchResults_aYu9JxAi(itemID)
(4)(+0000048): SELECT DISTINCT tagID || ':' || type FROM itemTags JOIN tags USING (tagID) WHERE 1 AND itemID IN (SELECT itemID FROM tmpSearchResults_aYu9JxAi) ORDER BY name COLLATE NOCASE
(3)(+0000004): {better-bibtex +146} Zotero ready, let's roll!
(3)(+0000000): {better-bibtex +0} Startup progress: Warten auf Zotero-Datenbank took 0.844 s
(3)(+0000000): {better-bibtex +0} Startup progress: Lade Zitierschlüssel...
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [460, 3, 'http://nrs.harvard.edu/urn-3:HUL.InstRepos:2962660']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [443, 3, 'http://ieeexplore.ieee.org/document/1401878/']
(3)(+0000012): Sorted tags in 2 ms
(3)(+0000002): Rendering tag selector
(3)(+0000018): Rendering tag list
(3)(+0000052): Tag selector updated
(4)(+0000042): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [378, 3, 'https://blog.twitter.com/official/en_us/a/2011/numbers.html']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [388, 3, '']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [409, 3, 'http://portal.acm.org/citation.cfm?doid=1883612.1883615']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [423, 3, '']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [334, 3, 'http://waterken.sourceforge.net/aclsdont/current.pdf']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [324, 3, 'https://www.w3.org/TR/activitystreams-vocabulary/']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [284, 3, 'https://schub.io/blog/2018/02/01/activitypub-one-protocol-to-rule-them-all.html']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [411, 3, 'https://www.w3.org/TR/2018/REC-activitypub-20180123/']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [281, 3, 'https://blog.soykaf.com/post/activity-pub-in-pleroma/']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [310, 3, 'https://activitypub.rocks/implementation-report/']
(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [315, 3, 'https://github.com/WebOfTrustInfo/rebooting-the-web-of-trust-fall2017/raw/master/final-documents/activitypub-decentralized-distributed.pdf']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [398, 3, 'https://blog.dereferenced.org/activitypub-the-worse-is-better-approach-to-federated-social-networking']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [429, 3, '']
(4)(+0000006): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [336, 3, 'https://github.com/WebOfTrustInfo/rebooting-the-web-of-trust/raw/master/final-documents/dpki.pdf']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [338, 3, 'https://raw.githubusercontent.com/jaywink/social-relay/master/docs/relays.md']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [460, 3, 'http://nrs.harvard.edu/urn-3:HUL.InstRepos:2962660']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [443, 3, 'http://ieeexplore.ieee.org/document/1401878/']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [403, 3, 'https://gnusocial.net/doc/groups']
(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [401, 3, 'https://www.w3.org/community/ostatus/wiki/Groups']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [439, 3, 'https://www.iana.org/assignments/ipv6-unicast-address-assignments/ipv6-unicast-address-assignments.xhtml']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [433, 3, 'http://link.springer.com/10.1007/3-540-45748-8_5']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [417, 3, 'http://www.rfc-editor.org/rfc/rfc2119.txt']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [449, 3, 'http://link.springer.com/10.1007/11422778_3']
(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [373, 3, '']
(4)(+0000020): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [336, 3, 'https://github.com/WebOfTrustInfo/rebooting-the-web-of-trust/raw/master/final-documents/dpki.pdf']
(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [338, 3, 'https://raw.githubusercontent.com/jaywink/social-relay/master/docs/relays.md']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [460, 3, 'http://nrs.harvard.edu/urn-3:HUL.InstRepos:2962660']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [443, 3, 'http://ieeexplore.ieee.org/document/1401878/']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [403, 3, 'https://gnusocial.net/doc/groups']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [401, 3, 'https://www.w3.org/community/ostatus/wiki/Groups']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [439, 3, 'https://www.iana.org/assignments/ipv6-unicast-address-assignments/ipv6-unicast-address-assignments.xhtml']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [433, 3, 'http://link.springer.com/10.1007/3-540-45748-8_5']
(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [417, 3, 'http://www.rfc-editor.org/rfc/rfc2119.txt']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [449, 3, 'http://link.springer.com/10.1007/11422778_3']
(3)(+0000004): PluginInstaller: fetching addon info
(4)(+0000074): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [429, 3, '']
(3)(+0000024): {better-bibtex +316} FileStore.migrate: {"path":"/home/spiollinux/Zotero/cache.sqlite","exists":false}
(3)(+0000002): {better-bibtex +2} FileStore.migrate: {"path":"/home/spiollinux/Zotero/better-bibtex.sqlite","exists":true}
(3)(+0000000): [better-bibtex] Asynchronously opening database 'better-bibtex'
(3)(+0000000): /home/spiollinux/Zotero/better-bibtex.sqlite
(3)(+0000028): PluginInstaller: addon info fetched
(4)(+0000052): PRAGMA main.locking_mode=EXCLUSIVE
(4)(+0000004): PRAGMA page_size
(4)(+0000000): PRAGMA cache_size=250
(4)(+0000006): PRAGMA foreign_keys=true
(4)(+0000004): SELECT name, data FROM "better-bibtex" ORDER BY name ASC
(3)(+0000006): {better-bibtex +100} installing schema for citekey {"type":"object","properties":{"itemID":{"type":"integer"},"itemKey":{"type":"string"},"libraryID":{"type":"integer"},"citekey":{"type":"string","minLength":1},"pinned":{"type":"boolean","default":false},"meta":{"type":"object"},"$loki":{"type":"integer"}},"required":["itemID","libraryID","citekey","pinned"],"additionalProperties":false}
(3)(+0000010): {better-bibtex +10} Keymanager: userLibraryID = 1
(3)(+0000018): {better-bibtex +18} installing schema for autoexport {"type":"object","properties":{"type":{"enum":["collection","library"]},"id":{"type":"integer"},"path":{"type":"string","minLength":1},"status":{"enum":["scheduled","running","done","error"]},"translatorID":{"type":"string","minLength":1},"exportNotes":{"type":"boolean","default":false},"useJournalAbbreviation":{"type":"boolean","default":false},"DOIandURL":{"enum":["both","doi","url"]},"asciiBibLaTeX":{"type":"boolean"},"asciiBibTeX":{"type":"boolean"},"biblatexExtendedNameFormat":{"type":"boolean"},"bibtexParticleNoOp":{"type":"boolean"},"bibtexURL":{"enum":["off","note","url"]},"error":{"type":"string","default":""},"meta":{"type":"object"},"$loki":{"type":"integer"}},"required":["type","id","path","status","translatorID","exportNotes","useJournalAbbreviation","DOIandURL","asciiBibLaTeX","asciiBibTeX","biblatexExtendedNameFormat","bibtexParticleNoOp","bibtexURL"],"additionalProperties":false}
(3)(+0000040): {better-bibtex +40} installing schema for itemToExportFormat {"type":"object","properties":{"itemID":{"type":"integer"},"legacy":{"type":"boolean"},"skipChildItems":{"type":"boolean"},"item":{"type":"object"},"meta":{"type":"object"},"$loki":{"type":"integer"}},"required":["itemID","legacy","skipChildItems","item"],"additionalProperties":false}
(3)(+0000008): CACHE: retaining cache itemToExportFormat because stored Zotero is 5.0.66 (current: 5.0.66)
(4)(+0000000): SELECT itemID, strftime("%s", dateModified) * 1000 AS modified FROM items WHERE itemID NOT IN (select itemID from deletedItems)
(3)(+0000040): {better-bibtex +48} installing schema for Better BibLaTeX {"type":"object","properties":{"itemID":{"type":"integer"},"reference":{"type":"string"},"exportNotes":{"type":"boolean"},"useJournalAbbreviation":{"type":"boolean"},"DOIandURL":{"enum":["both","doi","url"]},"asciiBibLaTeX":{"type":"boolean"},"asciiBibTeX":{"type":"boolean"},"biblatexExtendedNameFormat":{"type":"boolean"},"bibtexParticleNoOp":{"type":"boolean"},"bibtexURL":{"enum":["off","note","url"]},"metadata":{"type":"object"},"meta":{"type":"object"},"$loki":{"type":"integer"}},"required":["itemID","exportNotes","useJournalAbbreviation","DOIandURL","asciiBibLaTeX","asciiBibTeX","biblatexExtendedNameFormat","bibtexParticleNoOp","bibtexURL","reference"],"additionalProperties":false}
(3)(+0000006): CACHE: retaining cache Better BibLaTeX because stored BetterBibTeX is 5.1.76.3938 (current: 5.1.76.3938)
(3)(+0000000): {better-bibtex +6} installing schema for Better BibTeX {"type":"object","properties":{"itemID":{"type":"integer"},"reference":{"type":"string"},"exportNotes":{"type":"boolean"},"useJournalAbbreviation":{"type":"boolean"},"DOIandURL":{"enum":["both","doi","url"]},"asciiBibLaTeX":{"type":"boolean"},"asciiBibTeX":{"type":"boolean"},"biblatexExtendedNameFormat":{"type":"boolean"},"bibtexParticleNoOp":{"type":"boolean"},"bibtexURL":{"enum":["off","note","url"]},"metadata":{"type":"object"},"meta":{"type":"object"},"$loki":{"type":"integer"}},"required":["itemID","exportNotes","useJournalAbbreviation","DOIandURL","asciiBibLaTeX","asciiBibTeX","biblatexExtendedNameFormat","bibtexParticleNoOp","bibtexURL","reference"],"additionalProperties":false}
(3)(+0000002): CACHE: retaining cache Better BibTeX because stored BetterBibTeX is 5.1.76.3938 (current: 5.1.76.3938)
(3)(+0000000): {better-bibtex +2} installing schema for Better BibTeX Citation Key Quick Copy {"type":"object","properties":{"itemID":{"type":"integer"},"reference":{"type":"string"},"exportNotes":{"type":"boolean"},"useJournalAbbreviation":{"type":"boolean"},"DOIandURL":{"enum":["both","doi","url"]},"asciiBibLaTeX":{"type":"boolean"},"asciiBibTeX":{"type":"boolean"},"biblatexExtendedNameFormat":{"type":"boolean"},"bibtexParticleNoOp":{"type":"boolean"},"bibtexURL":{"enum":["off","note","url"]},"metadata":{"type":"object"},"meta":{"type":"object"},"$loki":{"type":"integer"}},"required":["itemID","exportNotes","useJournalAbbreviation","DOIandURL","asciiBibLaTeX","asciiBibTeX","biblatexExtendedNameFormat","bibtexParticleNoOp","bibtexURL","reference"],"additionalProperties":false}
(3)(+0000000): CACHE: retaining cache Better BibTeX Citation Key Quick Copy because stored BetterBibTeX is 5.1.76.3938 (current: 5.1.76.3938)
(3)(+0000000): {better-bibtex +0} installing schema for Better CSL JSON {"type":"object","properties":{"itemID":{"type":"integer"},"reference":{"type":"string"},"exportNotes":{"type":"boolean"},"useJournalAbbreviation":{"type":"boolean"},"DOIandURL":{"enum":["both","doi","url"]},"asciiBibLaTeX":{"type":"boolean"},"asciiBibTeX":{"type":"boolean"},"biblatexExtendedNameFormat":{"type":"boolean"},"bibtexParticleNoOp":{"type":"boolean"},"bibtexURL":{"enum":["off","note","url"]},"metadata":{"type":"object"},"meta":{"type":"object"},"$loki":{"type":"integer"}},"required":["itemID","exportNotes","useJournalAbbreviation","DOIandURL","asciiBibLaTeX","asciiBibTeX","biblatexExtendedNameFormat","bibtexParticleNoOp","bibtexURL","reference"],"additionalProperties":false}
(3)(+0000000): CACHE: retaining cache Better CSL JSON because stored BetterBibTeX is 5.1.76.3938 (current: 5.1.76.3938)
(3)(+0000000): {better-bibtex +0} installing schema for Better CSL YAML {"type":"object","properties":{"itemID":{"type":"integer"},"reference":{"type":"string"},"exportNotes":{"type":"boolean"},"useJournalAbbreviation":{"type":"boolean"},"DOIandURL":{"enum":["both","doi","url"]},"asciiBibLaTeX":{"type":"boolean"},"asciiBibTeX":{"type":"boolean"},"biblatexExtendedNameFormat":{"type":"boolean"},"bibtexParticleNoOp":{"type":"boolean"},"bibtexURL":{"enum":["off","note","url"]},"metadata":{"type":"object"},"meta":{"type":"object"},"$loki":{"type":"integer"}},"required":["itemID","exportNotes","useJournalAbbreviation","DOIandURL","asciiBibLaTeX","asciiBibTeX","biblatexExtendedNameFormat","bibtexParticleNoOp","bibtexURL","reference"],"additionalProperties":false}
(3)(+0000000): CACHE: retaining cache Better CSL YAML because stored BetterBibTeX is 5.1.76.3938 (current: 5.1.76.3938)
(3)(+0000000): {better-bibtex +0} installing schema for BetterBibTeX JSON {"type":"object","properties":{"itemID":{"type":"integer"},"reference":{"type":"string"},"exportNotes":{"type":"boolean"},"useJournalAbbreviation":{"type":"boolean"},"DOIandURL":{"enum":["both","doi","url"]},"asciiBibLaTeX":{"type":"boolean"},"asciiBibTeX":{"type":"boolean"},"biblatexExtendedNameFormat":{"type":"boolean"},"bibtexParticleNoOp":{"type":"boolean"},"bibtexURL":{"enum":["off","note","url"]},"metadata":{"type":"object"},"meta":{"type":"object"},"$loki":{"type":"integer"}},"required":["itemID","exportNotes","useJournalAbbreviation","DOIandURL","asciiBibLaTeX","asciiBibTeX","biblatexExtendedNameFormat","bibtexParticleNoOp","bibtexURL","reference"],"additionalProperties":false}
(3)(+0000002): CACHE: retaining cache BetterBibTeX JSON because stored BetterBibTeX is 5.1.76.3938 (current: 5.1.76.3938)
(3)(+0000000): {better-bibtex +2} installing schema for Citation graph {"type":"object","properties":{"itemID":{"type":"integer"},"reference":{"type":"string"},"exportNotes":{"type":"boolean"},"useJournalAbbreviation":{"type":"boolean"},"DOIandURL":{"enum":["both","doi","url"]},"asciiBibLaTeX":{"type":"boolean"},"asciiBibTeX":{"type":"boolean"},"biblatexExtendedNameFormat":{"type":"boolean"},"bibtexParticleNoOp":{"type":"boolean"},"bibtexURL":{"enum":["off","note","url"]},"metadata":{"type":"object"},"meta":{"type":"object"},"$loki":{"type":"integer"}},"required":["itemID","exportNotes","useJournalAbbreviation","DOIandURL","asciiBibLaTeX","asciiBibTeX","biblatexExtendedNameFormat","bibtexParticleNoOp","bibtexURL","reference"],"additionalProperties":false}
(3)(+0000000): CACHE: retaining cache Citation graph because stored BetterBibTeX is 5.1.76.3938 (current: 5.1.76.3938)
(3)(+0000000): {better-bibtex +0} installing schema for Collected notes {"type":"object","properties":{"itemID":{"type":"integer"},"reference":{"type":"string"},"exportNotes":{"type":"boolean"},"useJournalAbbreviation":{"type":"boolean"},"DOIandURL":{"enum":["both","doi","url"]},"asciiBibLaTeX":{"type":"boolean"},"asciiBibTeX":{"type":"boolean"},"biblatexExtendedNameFormat":{"type":"boolean"},"bibtexParticleNoOp":{"type":"boolean"},"bibtexURL":{"enum":["off","note","url"]},"metadata":{"type":"object"},"meta":{"type":"object"},"$loki":{"type":"integer"}},"required":["itemID","exportNotes","useJournalAbbreviation","DOIandURL","asciiBibLaTeX","asciiBibTeX","biblatexExtendedNameFormat","bibtexParticleNoOp","bibtexURL","reference"],"additionalProperties":false}
(3)(+0000000): CACHE: retaining cache Collected notes because stored BetterBibTeX is 5.1.76.3938 (current: 5.1.76.3938)
(3)(+0000000): {better-bibtex +0} Startup progress: Lade Zitierschlüssel took 0.544 s
(3)(+0000000): {better-bibtex +0} Startup progress: Beginne automatischen Export...
(3)(+0000002): {better-bibtex +2} pathSearch: looking for git in {"path":["/run/wrappers/bin","/usr/bin","/usr/sbin"],"pathext":[""],"sep":"/"}
(3)(+0000000): {better-bibtex +0} pathSearch: git not found in ["/run/wrappers/bin","/usr/bin","/usr/sbin"]
(3)(+0000000): {better-bibtex +0} git.init: git not found
(3)(+0000002): {better-bibtex +2} Startup progress: Beginne automatischen Export took 0.004 s
(3)(+0000000): {better-bibtex +0} Startup progress: Starte Schlüsselverwaltung...
(3)(+0000000): {better-bibtex +0} KeyManager.init...
(3)(+0000000): {better-bibtex +0} initializing kuroshiro
(3)(+0000000): {better-bibtex +0} kuroshiro: initializing...
(3)(+0000000): {better-bibtex +0} kuroshiro: disabled
(3)(+0000000): {better-bibtex +0} kuroshiro initialized
(3)(+0000000): {better-bibtex +0} KeyManager.init: {"keys":189}
(4)(+0000000): select fieldID, fieldName from fields where fieldName in ('extra')
(4)(+0000004): select itemTypeID, typeName from itemTypes where typeName in ('note', 'attachment')
(4)(+0000000): select typeName from itemTypes
(3)(+0000004): {better-bibtex +8} Formatter.itemTypes = ["note","book","booksection","journalarticle","magazinearticle","newspaperarticle","thesis","letter","manuscript","interview","film","artwork","webpage","attachment","report","bill","case","hearing","patent","statute","email","map","blogpost","instantmessage","forumpost","audiorecording","presentation","videorecording","tvbroadcast","radiobroadcast","podcast","computerprogram","conferencepaper","document","encyclopediaarticle","dictionaryentry"]
(3)(+0000000): {better-bibtex +0} PatternFormatter.update: init
(3)(+0000000): {better-bibtex +0} PatternFormatter.update: trying citekeyFormat [auth:lower][shorttitle3_3][year]...
(3)(+0000002): {better-bibtex +2} PatternFormatter.update: citekeyFormat= [auth:lower][shorttitle3_3][year] function anonymous() { var loop, citekey, postfix, chunk; for (loop = true; loop; loop=false) { citekey = ''; postfix = 'a'; chunk = this.$auth(false, false, ""); chunk = this.clean(chunk); chunk = this._lower(chunk); citekey += chunk; chunk = this.$shorttitle(3, 3); citekey += chunk; chunk = this.$year(); citekey += chunk; citekey = citekey.replace(/[\s{},]/g, ''); if (citekey) return {citekey: citekey, postfix: postfix}; } return {citekey: ''}; }
(3)(+0000000): {better-bibtex +0} KeyManager.rescan: {"keys":189}
(4)(+0000002): SELECT item.itemID, item.libraryID, item.key, extra.value as extra, item.itemTypeID FROM items item LEFT JOIN itemData field ON field.itemID = item.itemID AND field.fieldID = 22 LEFT JOIN itemDataValues extra ON extra.valueID = field.valueID WHERE item.itemID NOT IN (select itemID from deletedItems) AND item.itemTypeID NOT IN (14, 1)
(3)(+0000034): {better-bibtex +36} KeyManager.bench: cleanup 36
(3)(+0000004): {better-bibtex +4} KeyManager.bench: regenerate 4
(3)(+0000000): {better-bibtex +0} KeyManager.rescan: done updating citation keys
(3)(+0000000): {better-bibtex +0} KeyManager.init: done
(3)(+0000000): {better-bibtex +0} events: handler registered for preference-changed
(3)(+0000000): {better-bibtex +0} Startup progress: Starte Schlüsselverwaltung took 0.05 s
(3)(+0000000): {better-bibtex +0} Startup progress: Warten auf Zotero-Übersetzer...
(4)(+0000074): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [328, 3, 'https://github.com/w3c/activitypub/issues/203']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [322, 3, 'https://w3c-dvcg.github.io/ld-signatures/']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [331, 3, 'https://litepub.social/litepub/overview.html']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [446, 3, 'http://ieeexplore.ieee.org/document/1354648/']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [422, 3, 'http://link.springer.com/10.1007/978-3-540-45172-3_6']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [326, 3, 'https://source.joinmastodon.org/mastodon/pub-relay']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [384, 3, '']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [297, 3, 'http://blog.notdot.net/2008/6/Nearly-all-DHT-implementations-vulnerable-to-merge-bug']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [437, 3, 'http://nodeinfo.diaspora.software/']
(4)(+0000006): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [355, 3, '']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [357, 3, '']
(4)(+0000002): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [406, 3, 'https://git.pleroma.social/pleroma/relay']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [306, 3, 'https://discourse.diasporafoundation.org/t/public-post-federation/264/111']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [308, 3, 'https://wiki.diasporafoundation.org/Relay_servers_for_public_posts']
(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=1) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (?) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [317, 3, 'https://www.weboftrust.info/papers.html']
(3)(+0000214): WebSocket connection opened
(3)(+0000000): WebSocket message: {"event":"connected","retry":10000}
(3)(+0000004): WebSocket message send: {"action":"createSubscriptions","subscriptions":[{"topics":["styles","translators"]}]}
(3)(+0000202): WebSocket message: {"event":"subscriptionsCreated","subscriptions":[{"topics":["styles","translators"]}],"errors":[]}
(3)(+0000622): No general proxy or PAC file found -- assuming direct connection
(4)(+0000002): Sync not enabled -- skipping auto-sync
(3)(+0001000): Updating bundled files
(3)(+0000002): Initializing translators
(4)(+0000000): SELECT rowid, fileName, metadataJSON, lastModifiedTime FROM translatorCache
(4)(+0000862): Beginning DB transaction JztnVyC3
(4)(+0000004): SELECT name FROM "better-bibtex"
(4)(+0000004): REPLACE INTO "better-bibtex" (name, data) VALUES (?, ?) ['better-bibtex.citekey', '{"name":"citekey","data":[{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1332017","pinned":false,"itemID":5,"libraryID":1,"itemKey":"I9VII6TY","meta":{"revision":94,"created":1527972533584,"version":0,"updated":1557167070290},"$loki":2},{"citekey":"3GPPTS23","pinned":false,"itemID":6,"libraryID":1,"itemKey":"EA2F6Y7Z","meta":{"revision":94,"created":1527972533586,"version":0,"updated":1557167070290},"$loki":3},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1022012","pinned":false,"itemID":9,"libraryID":1,"itemKey":"8GTC4SMN","meta":{"revision":94,"created":1527972533588,"version":0,"updated":1557167070290},"$loki":4},{"citekey":"SearchBrowseStandards","pinned":false,"itemID":10,"libraryID":1,"itemKey":"CEPBESUD","meta":{"revision":94,"created":1527972533588,"version":0,"updated":1557167070290},"$loki":5},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSI3026652010","pinned":false,"itemID":13,"libraryID":1,"itemKey":"AIIJQNHZ","meta":{"revision":94,"created":1527972533588,"version":0,"updated":1557167070290},"$loki":6},{"citekey":"StudyArchitectureEnhancements","pinned":false,"itemID":15,"libraryID":1,"itemKey":"U2CU2DMQ","meta":{"revision":94,"created":1527972533588,"version":0,"updated":1557167070290},"$loki":7},{"citekey":"StudySecurityAspects","pinned":false,"itemID":17,"libraryID":1,"itemKey":"LNDMAJ65","meta":{"revision":94,"created":1527972533590,"version":0,"updated":1557167070290},"$loki":8},{"citekey":"angermeierPALPrivacyAugmented2013","pinned":false,"itemID":19,"libraryID":1,"itemKey":"9I7K9M8V","meta":{"revision":94,"created":1527972533590,"version":0,"updated":1557167070290},"$loki":9},{"citekey":"schaubVtokensConditionalPseudonymity2010","pinned":false,"itemID":22,"libraryID":1,"itemKey":"XEGKRCL6","meta":{"revision":94,"created":1527972533592,"version":0,"updated":1557167070290},"$loki":10},{"citekey":"forsterPUCAPseudonymScheme2015","pinned":false,"itemID":25,"libraryID":1,"itemKey":"RE5NMC9P","meta":{"revision":94,"created":1527972533600,"version":0,"updated":1557167070290},"$loki":11},{"citekey":"forsterPUCAPseudonymScheme2016","pinned":false,"itemID":28,"libraryID":1,"itemKey":"CZSV76BV","meta":{"revision":94,"created":1527972533600,"version":0,"updated":1557167070290},"$loki":12},{"citekey":"AnalysisPrivacyThreat2017","pinned":false,"itemID":29,"libraryID":1,"itemKey":"3DGJGMI7","meta":{"revision":94,"created":1527972533602,"version":0,"updated":1557167070290},"$loki":13},{"citekey":"baldiniAnalysisPrivacyThreat2017","pinned":false,"itemID":31,"libraryID":1,"itemKey":"GPNS5CNK","meta":{"revision":94,"created":1527972533602,"version":0,"updated":1557167070290},"$loki":14},{"citekey":"quSecurityPrivacyReview2015","pinned":false,"itemID":34,"libraryID":1,"itemKey":"QPQMNBXJ","meta":{"revision":94,"created":1527972533602,"version":0,"updated":1557167070290},"$loki":15},{"citekey":"liuAnonymousGroupMessage","pinned":false,"itemID":38,"libraryID":1,"itemKey":"MG6Y3GWQ","meta":{"revision":94,"created":1527972533602,"version":0,"updated":1557167070290},"$loki":16},{"citekey":"sorensen5GVisionsUser2015","pinned":false,"itemID":39,"libraryID":1,"itemKey":"CA6A66AM","meta":{"revision":94,"created":1527972533602,"version":0,"updated":1557167070290},"$loki":17},{"citekey":"lentzSDDRLightWeightSecure","pinned":false,"itemID":43,"libraryID":1,"itemKey":"WSNY3M9K","meta":{"revision":94,"created":1527972533604,"version":0,"updated":1557167070290},"$loki":18},{"citekey":"nevenPrivacypreservingAttributebasedCredentials2017","pinned":false,"itemID":45,"libraryID":1,"itemKey":"9FTEXG8D","meta":{"revision":94,"created":1527972533604,"version":0,"updated":1557167070290},"$loki":19},{"citekey":"boualouacheSurveyPseudonymChanging2018","pinned":false,"itemID":49,"libraryID":1,"itemKey":"2DN6YKLS","meta":{"revision":94,"created":1527972533604,"version":0,"updated":1557167070290},"$loki":20},{"citekey":"petitPseudonymSchemesVehicular2015","pinned":false,"itemID":51,"libraryID":1,"itemKey":"XPQWJB5G","meta":{"revision":94,"created":1527972533604,"version":0,"updated":1557167070290},"$loki":21},{"citekey":"Vocabulary3GPPSpecifications","pinned":false,"itemID":55,"libraryID":1,"itemKey":"LB57MGTW","meta":{"revision":94,"created":1527972533604,"version":0,"updated":1557167070290},"$loki":22},{"citekey":"wernkeClassificationLocationPrivacy2014","pinned":false,"itemID":59,"libraryID":1,"itemKey":"675428LG","meta":{"revision":94,"created":1527972533604,"version":0,"updated":1557167070290},"$loki":23},{"citekey":"zengPseudonymousPKIUbiquitous2006","pinned":false,"itemID":63,"libraryID":1,"itemKey":"4VHGPZD4","meta":{"revision":94,"created":1527972533616,"version":0,"updated":1557167070290},"$loki":24},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITR1032018","pinned":false,"itemID":72,"libraryID":1,"itemKey":"9LJ4CXZV","meta":{"revision":94,"created":1527972533616,"version":0,"updated":1557167070290},"$loki":25},{"citekey":"hamidaSecurityCooperativeIntelligent2015","pinned":false,"itemID":78,"libraryID":1,"itemKey":"YCYSPS2P","meta":{"revision":94,"created":1527972533616,"version":0,"updated":1557167070290},"$loki":26},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1022010","pinned":false,"itemID":81,"libraryID":1,"itemKey":"PJ3AM7TH","meta":{"revision":94,"created":1527972533616,"version":0,"updated":1557167070290},"$loki":27},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1022012a","pinned":false,"itemID":83,"libraryID":1,"itemKey":"49QW9IS4","meta":{"revision":94,"created":1527972533616,"version":0,"updated":1557167070290},"$loki":28},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSI302636612014","pinned":false,"itemID":86,"libraryID":1,"itemKey":"7Y8ZHFLZ","meta":{"revision":94,"created":1527972533618,"version":0,"updated":1557167070290},"$loki":29},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSI302636412017","pinned":false,"itemID":89,"libraryID":1,"itemKey":"IM2SWQZJ","meta":{"revision":94,"created":1527972533618,"version":0,"updated":1557167070290},"$loki":30},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSI302636512017","pinned":false,"itemID":91,"libraryID":1,"itemKey":"F8T6B5QA","meta":{"revision":98,"created":1527972533618,"version":0,"updated":1557167070290},"$loki":31},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSI30263632014","pinned":false,"itemID":94,"libraryID":1,"itemKey":"UIBIW7MF","meta":{"revision":96,"created":1527972533618,"version":0,"updated":1557167070290},"$loki":32},{"citekey":"sandonisVehicleInternetCommunications2016","pinned":false,"itemID":98,"libraryID":1,"itemKey":"LL7VW3QK","meta":{"revision":94,"created":1527972533618,"version":0,"updated":1557167070290},"$loki":33},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1022011a","pinned":false,"itemID":104,"libraryID":1,"itemKey":"B786TJGZ","meta":{"revision":94,"created":1527972533618,"version":0,"updated":1557167070290},"$loki":34},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1022010b","pinned":false,"itemID":105,"libraryID":1,"itemKey":"8A3FA4EQ","meta":{"revision":94,"created":1527972533620,"version":0,"updated":1557167070290},"$loki":35},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSI30263622013","pinned":false,"itemID":106,"libraryID":1,"itemKey":"NMJFVU5F","meta":{"revision":96,"created":1527972533634,"version":0,"updated":1557167070290},"$loki":36},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSI30263612014","pinned":false,"itemID":107,"libraryID":1,"itemKey":"S8F59WHV","meta":{"revision":96,"created":1527972533640,"version":0,"updated":1557167070290},"$loki":37},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1022012b","pinned":false,"itemID":111,"libraryID":1,"itemKey":"FSS36939","meta":{"revision":94,"created":1527972533640,"version":0,"updated":1557167070290},"$loki":38},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1022012c","pinned":false,"itemID":112,"libraryID":1,"itemKey":"KBR9GSUJ","meta":{"revision":94,"created":1527972533642,"version":0,"updated":1557167070290},"$loki":39},{"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1032017","pinned":false,"itemID":113,"libraryID":1,"itemKey":"DBLASWZL","meta":{"revision":94,"created":1527972533642,"version":0,"updated":1557167070290},"$loki":40},{"citekey":"polalemanypratsPerformanceStudyIEEE2017","pinned":false,"itemID":115,"libraryID":1,"itemKey":"MA88SG9E","meta":{"revision":94,"created":1527972533642,"version":0,"updated":1557167070290},"$loki":41},{"citekey":"eucomissionc-itsplatformSecurityPolicyGovernance","pinned":false,"itemID":118,"libraryID":1,"itemKey":"Z4284R7I","meta":{"revision":94,"created":1527972533642,"version":0,"updated":1557167070288},"$loki":42},{"citekey":"stillerMobileSystemsIV2010","pinned":false,"itemID":122,"libraryID":1,"itemKey":"CD5A5UJ3","meta":{"revision":94,"created":1527972533642,"version":0,"updated":1557167070288},"$loki":43},{"citekey":"instituteetsiRecommendationGSM021992","pinned":false,"itemID":123,"libraryID":1,"itemKey":"HYTAL2FF","meta":{"revision":94,"created":1527972533644,"version":0,"updated":1557167070288},"$loki":44},{"citekey":"ITUTRecommendationDatabase","pinned":false,"itemID":124,"libraryID":1,"itemKey":"FZRP6HMP","meta":{"revision":94,"created":1527972533644,"version":0,"updated":1557167070288},"$loki":45},{"itemID":127,"libraryID":1,"itemKey":"TPZMFB6F","pinned":true,"citekey":"TN_libero_mab2","meta":{"revision":93,"created":1528019702854,"version":0,"updated":1557167070288},"$loki":46},{"itemID":128,"libraryID":1,"itemKey":"827JWE9S","pinned":true,"citekey":"RFC8200","meta":{"revision":93,"created":1528025210258,"version":0,"updated":1557167070288},"$loki":47},{"itemID":129,"libraryID":1,"itemKey":"USPVKMGG","pinned":true,"citekey":"RFC4291","meta":{"revision":93,"created":1528026098854,"version":0,"updated":1557167070288},"$loki":48},{"itemID":130,"libraryID":1,"itemKey":"3ZFKYKE4","pinned":false,"citekey":"baeckerRFCE014IPv6","meta":{"revision":97,"created":1528026894270,"version":0,"updated":1557167070288},"$loki":49},{"itemID":131,"libraryID":1,"itemKey":"4AM5Y27N","pinned":true,"citekey":"RFC4861","meta":{"revision":93,"created":1528064617290,"version":0,"updated":1557167070288},"$loki":50},{"itemID":142,"libraryID":1,"itemKey":"3JZAKN2F","pinned":false,"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1032016","meta":{"revision":93,"created":1528307437670,"version":0,"updated":1557167070288},"$loki":52},{"itemID":145,"libraryID":1,"itemKey":"8JLELUFW","pinned":true,"citekey":"RFC6437","meta":{"revision":89,"created":1528409876786,"version":0,"updated":1557167070288},"$loki":53},{"itemID":147,"libraryID":1,"itemKey":"SLHTK5EJ","pinned":true,"citekey":"RFC3963","meta":{"revision":88,"created":1528631505044,"version":0,"updated":1557167070288},"$loki":54},{"itemID":148,"libraryID":1,"itemKey":"PX78XXFK","pinned":false,"citekey":"armknechtCrosslayerPrivacyEnhancement2007","meta":{"revision":88,"created":1528664972640,"version":0,"updated":1557167070288},"$loki":55},{"itemID":151,"libraryID":1,"itemKey":"75BY5LZZ","pinned":false,"citekey":"calandrielloEfficientRobustPseudonymous2007","meta":{"revision":88,"created":1528665200840,"version":0,"updated":1557167070288},"$loki":56},{"itemID":154,"libraryID":1,"itemKey":"CGFHSSVB","pinned":false,"citekey":"perrigTESLABroadcastAuthentication","meta":{"revision":87,"created":1528728216998,"version":0,"updated":1557167070288},"$loki":57},{"itemID":156,"libraryID":1,"itemKey":"E6CZ2QLB","pinned":false,"citekey":"CommunicationTechnologiesVehicles2016","meta":{"revision":87,"created":1528741701874,"version":0,"updated":1557167070288},"$loki":58},{"itemID":158,"libraryID":1,"itemKey":"GP9RX5SP","pinned":false,"citekey":"zotero-158","meta":{"revision":86,"created":1528744699390,"version":0,"updated":1557167070288},"$loki":59},{"itemID":161,"libraryID":1,"itemKey":"KDW8VLWZ","pinned":false,"citekey":"verheulIssueFirstActivate","meta":{"revision":86,"created":1528744753862,"version":0,"updated":1557167070288},"$loki":60},{"itemID":163,"libraryID":1,"itemKey":"W4S3TDGF","pinned":false,"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1022014","meta":{"revision":89,"created":1528746390620,"version":0,"updated":1557167070288},"$loki":61},{"itemID":165,"libraryID":1,"itemKey":"99UVGDCP","pinned":false,"citekey":"dolevSecurityPublicKey1983","meta":{"revision":86,"created":1528755034618,"version":0,"updated":1557167070288},"$loki":62},{"itemID":167,"libraryID":1,"itemKey":"IZHU9UJH","pinned":false,"citekey":"dolevSecurityPublicKey1983a","meta":{"revision":86,"created":1528755873812,"version":0,"updated":1557167070288},"$loki":63},{"itemID":169,"libraryID":1,"itemKey":"JPHGZGWU","pinned":false,"citekey":"europeantelecommunicationsstandardsinstituteetsiETSITS1022014a","meta":{"revision":89,"created":1528768767896,"version":0,"updated":1557167070288},"$loki":64},{"itemID":171,"libraryID":1,"itemKey":"WUEQU7I2","pinned":false,"citekey":"europeancommission-directorategeneralformobilityandtransportEvolutionEURoad2018","meta":{"revision":84,"created":1530555210586,"version":0,"updated":1557167070288},"$loki":65},{"itemID":172,"libraryID":1,"itemKey":"U43B86PD","pinned":false,"citekey":"claestingvallVisionZeroEthical1999","meta":{"revision":84,"created":1530572560414,"version":0,"updated":1557167070288},"$loki":66},{"itemID":175,"libraryID":1,"itemKey":"ZFABGIYK","pinned":false,"citekey":"careeuroadaccidentsdatabaseEUFatalitiesTargets","meta":{"revision":82,"created":1531591103502,"version":0,"updated":1557167070288},"$loki":67},{"itemID":177,"libraryID":1,"itemKey":"QNG8DUWF","pinned":false,"citekey":"zotero-177","meta":{"revision":77,"created":1533120511320,"version":0,"updated":1557167070288},"$loki":68},{"itemID":179,"libraryID":1,"itemKey":"V4YHQRDM","pinned":false,"citekey":"hartigLateralThinkingTrustworthy2017","meta":{"revision":77,"created":1533120726050,"version":0,"updated":1557167070288},"$loki":69},{"itemID":181,"libraryID":1,"itemKey":"D4FML8C9","pinned":false,"citekey":"himanshurajalecwolmanandronaldaignerandjeremiahcoxandProceedings2005Workshop2005","meta":{"revision":84,"created":1533120783496,"version":0,"updated":1557167070288},"$loki":70},{"itemID":182,"libraryID":1,"itemKey":"J44MFAWI","pinned":true,"citekey":"197213","meta":{"revision":77,"created":1533121348662,"version":0,"updated":1557167070288},"$loki":71},{"itemID":184,"libraryID":1,"itemKey":"TVZGMQXA","pinned":false,"citekey":"linnObfuscationExecutableCode","meta":{"revision":77,"created":1533121463182,"version":0,"updated":1557167070288},"$loki":72},{"itemID":186,"libraryID":1,"itemKey":"YLSNE95M","pinned":false,"citekey":"hofmannInkTagSecureApplications","meta":{"revision":77,"created":1533121599318,"version":0,"updated":1557167070288},"$loki":73},{"itemID":188,"libraryID":1,"itemKey":"G36IT7E3","pinned":false,"citekey":"TrustyTEE","meta":{"revision":77,"created":1533132117232,"version":0,"updated":1557167070288},"$loki":74},{"itemID":191,"libraryID":1,"itemKey":"TC2D9DHH","pinned":false,"citekey":"AndroidDRMFramework","meta":{"revision":79,"created":1533132178444,"version":0,"updated":1557167070288},"$loki":75},{"itemID":193,"libraryID":1,"itemKey":"LE5H4H63","pinned":false,"citekey":"NetflixDefectiveDesign","meta":{"revision":77,"created":1533132308702,"version":0,"updated":1557167070288},"$loki":76},{"itemID":195,"libraryID":1,"itemKey":"33Q66Q7I","pinned":false,"citekey":"chuangDigitalRightManagement2010","meta":{"revision":77,"created":1533132587826,"version":0,"updated":1557167070288},"$loki":77},{"itemID":199,"libraryID":1,"itemKey":"2MAZE4NJ","pinned":false,"citekey":"chuangDigitalRightManagement2010a","meta":{"revision":77,"created":1533132715762,"version":0,"updated":1557167070288},"$loki":78},{"itemID":201,"libraryID":1,"itemKey":"5NVSJEP2","pinned":false,"citekey":"googleWidevineDRMArchitecture2017","meta":{"revision":79,"created":1533132908440,"version":0,"updated":1557167070288},"$loki":79},{"itemID":203,"libraryID":1,"itemKey":"F3H6E2WP","pinned":false,"citekey":"andyNetflixUseGoogle2017","meta":{"revision":79,"created":1533133074812,"version":0,"updated":1557167070288},"$loki":80},{"itemID":205,"libraryID":1,"itemKey":"JEAT3DY4","pinned":false,"citekey":"livshitsSecurityNativeDRM2015","meta":{"revision":77,"created":1533133462716,"version":0,"updated":1557167070286},"$loki":81},{"itemID":209,"libraryID":1,"itemKey":"RXFULEX6","pinned":false,"citekey":"andreasgalReconcilingMozillaMission2014","meta":{"revision":79,"created":1533134367898,"version":0,"updated":1557167070286},"$loki":82},{"itemID":214,"libraryID":1,"itemKey":"NJ3EUEDE","pinned":false,"citekey":"yuTBDRMTPMBasedSecure2009","meta":{"revision":76,"created":1533408809182,"version":0,"updated":1557167070286},"$loki":83},{"itemID":215,"libraryID":1,"itemKey":"ADVB7ZU8","pinned":false,"citekey":"costanIntelSGXExplained2016","meta":{"revision":76,"created":1533505503646,"version":0,"updated":1557167070286},"$loki":84},{"itemID":218,"libraryID":1,"itemKey":"XUTTGJAL","pinned":false,"citekey":"NetflixUseGoogle2017a","meta":{"revision":76,"created":1533565477150,"version":0,"updated":1557167070286},"$loki":85},{"itemID":224,"libraryID":1,"itemKey":"PCIATW7U","pinned":false,"citekey":"w3cEncryptedMediaExtensions2017","meta":{"revision":75,"created":1535972968464,"version":0,"updated":1557167070286},"$loki":86},{"itemID":228,"libraryID":1,"itemKey":"TIIQIMYS","pinned":false,"citekey":"WhatEMEHsivonen","meta":{"revision":72,"created":1536061370156,"version":0,"updated":1557167070286},"$loki":87},{"itemID":231,"libraryID":1,"itemKey":"PDW7VZ6D","pinned":false,"citekey":"daubsHTML5DIGITALRIGHTS2017","meta":{"revision":72,"created":1536071936418,"version":0,"updated":1557167070286},"$loki":88},{"itemID":233,"libraryID":1,"itemKey":"SA7ZXWL7","pinned":false,"citekey":"phamOpenSourceContent2015","meta":{"revision":72,"created":1536072143224,"version":0,"updated":1557167070286},"$loki":89},{"itemID":236,"libraryID":1,"itemKey":"QA2E97P5","pinned":false,"citekey":"corydoctorowComingWarGeneral2011","meta":{"revision":75,"created":1536143841692,"version":0,"updated":1557167070286},"$loki":90},{"itemID":238,"libraryID":1,"itemKey":"LLK25N3S","pinned":false,"citekey":"bruceschneierCryptoGramMay152001","meta":{"revision":74,"created":1536146978514,"version":0,"updated":1557167070286},"$loki":91},{"itemID":242,"libraryID":1,"itemKey":"YJ28UBST","pinned":false,"citekey":"worldinternationalcopyrightorganizationWIPOCopyrightTreaty1996","meta":{"revision":74,"created":1536154362290,"version":0,"updated":1557167070286},"$loki":92},{"itemID":244,"libraryID":1,"itemKey":"7K2TZTUA","pinned":false,"citekey":"movielabsinc.MovieLabsSpecificationEnhanced2018","meta":{"revision":75,"created":1536169425932,"version":0,"updated":1557167070286},"$loki":93},{"itemID":245,"libraryID":1,"itemKey":"QBCD4J7M","pinned":false,"citekey":"sonydeveloperworldUnlockBootloaderOpen","meta":{"revision":73,"created":1536170438558,"version":0,"updated":1557167070286},"$loki":94},{"itemID":248,"libraryID":1,"itemKey":"EZJXMZMK","pinned":false,"citekey":"unifiedefiforuminc.UEFISpecificationVersion2017","meta":{"revision":73,"created":1536181191894,"version":0,"updated":1557167070286},"$loki":95},{"itemID":250,"libraryID":1,"itemKey":"CVJ9HCX4","pinned":false,"citekey":"MicrosoftHardwareCertification2014","meta":{"revision":74,"created":1536187334312,"version":0,"updated":1557167070286},"$loki":96},{"itemID":251,"libraryID":1,"itemKey":"SFJ33IWV","pinned":false,"citekey":"moodyMicrosoftBlockingLinux","meta":{"revision":72,"created":1536187929560,"version":0,"updated":1557167070286},"$loki":97},{"itemID":253,"libraryID":1,"itemKey":"IM72FQDH","pinned":false,"citekey":"matthewgarrettAnnouncingShimReview","meta":{"revision":74,"created":1536189009268,"version":0,"updated":1557167070286},"$loki":98},{"itemID":256,"libraryID":1,"itemKey":"4JJQ7ZGC","pinned":false,"citekey":"armlimitedARMSecurityTechnology2005","meta":{"revision":74,"created":1536239305614,"version":0,"updated":1557167070286},"$loki":99},{"itemID":257,"libraryID":1,"itemKey":"8WB2PHMD","pinned":false,"citekey":"peinadom.ControlledChannelAttacksDeterministic2015","meta":{"revision":76,"created":1536324752558,"version":0,"updated":1557167070286},"$loki":100},{"itemID":262,"libraryID":1,"itemKey":"79PWI4YU","pinned":false,"citekey":"swamiyogeshIntelSGXRemote2017","meta":{"revision":71,"created":1537284437012,"version":0,"updated":1557167070284},"$loki":101},{"itemID":263,"libraryID":1,"itemKey":"NASIJSCV","pinned":false,"citekey":"corvindavenportNetflixConfirmsIt2017","meta":{"revision":69,"created":1537367905690,"version":0,"updated":1557167070284},"$loki":102},{"itemID":267,"libraryID":1,"itemKey":"4QAE3AFA","pinned":false,"citekey":"arthurPracticalGuideTPM2015","meta":{"revision":67,"created":1537490623336,"version":0,"updated":1557167070284},"$loki":103},{"itemID":269,"libraryID":1,"itemKey":"DEB4ZNJN","pinned":false,"citekey":"shenExploitingTrustzoneAndroid2015","meta":{"revision":68,"created":1537544138894,"version":0,"updated":1557167070284},"$loki":104},{"itemID":270,"libraryID":1,"itemKey":"KRTHALS5","pinned":true,"citekey":"DBLP:conf/reconfig/LombG11","meta":{"revision":67,"created":1537547130014,"version":0,"updated":1557167070284},"$loki":105},{"itemID":271,"libraryID":1,"itemKey":"T6BKX5NB","pinned":true,"citekey":"DBLP:conf/reconfig/2011","meta":{"revision":67,"created":1537547130226,"version":0,"updated":1557167070284},"$loki":106},{"itemID":272,"libraryID":1,"itemKey":"52KDXZ66","pinned":false,"citekey":"doctorowCloudComputingDRM","meta":{"revision":69,"created":1537556555158,"version":0,"updated":1557167070284},"$loki":107},{"itemID":274,"libraryID":1,"itemKey":"5TAM2CZ3","pinned":false,"citekey":"bergmayerItAlwaysDRM2018","meta":{"revision":68,"created":1537556823494,"version":0,"updated":1557167070284},"$loki":108},{"itemID":277,"libraryID":1,"itemKey":"BI7FYCLK","pinned":false,"citekey":"freesoftwarefoundationeuropeDRMStrangeBroken2012","meta":{"revision":70,"created":1537557303172,"version":0,"updated":1557167070284},"$loki":109},{"itemID":278,"libraryID":1,"itemKey":"RZAUVS3V","pinned":false,"citekey":"sterlingDeadMediaBeat2008","meta":{"revision":67,"created":1537565070978,"version":0,"updated":1557167070284},"$loki":110},{"itemID":281,"libraryID":1,"itemKey":"76EGV72Q","pinned":false,"citekey":"lainpleroma.soykaf.comActivityPubPleroma2018","meta":{"revision":63,"created":1541337330918,"version":0,"updated":1557167070284},"$loki":111},{"itemID":284,"libraryID":1,"itemKey":"VHNRSSDF","pinned":false,"citekey":"ActivityPubOneProtocol","meta":{"revision":63,"created":1541338758518,"version":0,"updated":1557167070284},"$loki":112},{"itemID":287,"libraryID":1,"itemKey":"I5XNZTCG","pinned":false,"citekey":"SocialCGActivityPubAuthentication","meta":{"revision":63,"created":1541338799670,"version":0,"updated":1557167070284},"$loki":113},{"itemID":289,"libraryID":1,"itemKey":"IP8IXZC8","pinned":false,"citekey":"SecurityVocabularyHttps","meta":{"revision":63,"created":1541339744210,"version":0,"updated":1557167070284},"$loki":114},{"itemID":291,"libraryID":1,"itemKey":"6SMEWX5C","pinned":true,"citekey":"I-D.cavage-http-signatures","meta":{"revision":63,"created":1541342473254,"version":0,"updated":1557167070284},"$loki":115},{"itemID":293,"libraryID":1,"itemKey":"WW8I573Z","pinned":false,"citekey":"TwisterP2PMicroblogging","meta":{"revision":63,"created":1541343022052,"version":0,"updated":1557167070284},"$loki":116},{"itemID":297,"libraryID":1,"itemKey":"5HILC6L8","pinned":false,"citekey":"NearlyAllDHT","meta":{"revision":63,"created":1541344316494,"version":0,"updated":1557167070284},"$loki":117},{"itemID":299,"libraryID":1,"itemKey":"QVIB6FFM","pinned":false,"citekey":"freitasTwisterP2PMicroblogging2013","meta":{"revision":63,"created":1541344487473,"version":0,"updated":1557167070284},"$loki":118},{"itemID":303,"libraryID":1,"itemKey":"UWGWQNSC","pinned":false,"citekey":"SocialrelayPublicPost","meta":{"revision":64,"created":1541345218101,"version":0,"updated":1557167070284},"$loki":119},{"itemID":306,"libraryID":1,"itemKey":"96F7ZIWD","pinned":false,"citekey":"PublicPostFederation2017","meta":{"revision":62,"created":1541366713805,"version":0,"updated":1557167070284},"$loki":120},{"itemID":308,"libraryID":1,"itemKey":"IXFGTNRG","pinned":false,"citekey":"RelayServersPublic","meta":{"revision":62,"created":1541367668075,"version":0,"updated":1557167070284},"$loki":121},{"itemID":310,"libraryID":1,"itemKey":"IR2DE37E","pinned":false,"citekey":"ActivityPubRocksHttps","meta":{"revision":62,"created":1541368148561,"version":0,"updated":1557167070284},"$loki":122},{"itemID":315,"libraryID":1,"itemKey":"KJFEFGGY","pinned":false,"citekey":"webberActivityPubDecentralizedDistributed","meta":{"revision":64,"created":1541368963522,"version":0,"updated":1557167070284},"$loki":124},{"itemID":317,"libraryID":1,"itemKey":"HNSYKUET","pinned":false,"citekey":"RWOTWhitePapers","meta":{"revision":62,"created":1541369365273,"version":0,"updated":1557167070284},"$loki":125},{"itemID":322,"libraryID":1,"itemKey":"6EIWSBUM","pinned":false,"citekey":"LinkedDataSignatures","meta":{"revision":62,"created":1541370475477,"version":0,"updated":1557167070284},"$loki":126},{"itemID":324,"libraryID":1,"itemKey":"HEWQPJKC","pinned":false,"citekey":"ActivityVocabularyHttps","meta":{"revision":62,"created":1541379603932,"version":0,"updated":1557167070284},"$loki":127},{"itemID":326,"libraryID":1,"itemKey":"MDIGE99R","pinned":false,"citekey":"MastodonPubrelay","meta":{"revision":62,"created":1541379817095,"version":0,"updated":1557167070284},"$loki":128},{"itemID":328,"libraryID":1,"itemKey":"BAC8YHY9","pinned":false,"citekey":"LinkedDataSignaturesa","meta":{"revision":62,"created":1541380770727,"version":0,"updated":1557167070284},"$loki":129},{"itemID":331,"libraryID":1,"itemKey":"T5CY5288","pinned":false,"citekey":"LitePubSpecificationDraft","meta":{"revision":62,"created":1541940365220,"version":0,"updated":1557167070284},"$loki":130},{"itemID":334,"libraryID":1,"itemKey":"222I79G9","pinned":false,"citekey":"closeACLsDon","meta":{"revision":64,"created":1541944153584,"version":0,"updated":1557167070284},"$loki":131},{"itemID":336,"libraryID":1,"itemKey":"EFI8GPWG","pinned":false,"citekey":"DecentralizedPublicKey","meta":{"revision":60,"created":1541945593334,"version":0,"updated":1557167070284},"$loki":132},{"itemID":338,"libraryID":1,"itemKey":"NSR97S5F","pinned":false,"citekey":"robinsonDiasporaSocialRelay","meta":{"revision":59,"created":1541958719692,"version":0,"updated":1557167070284},"$loki":133},{"itemID":341,"libraryID":1,"itemKey":"FX6X784A","pinned":false,"citekey":"rowstronSCRIBEDesignLargescale","meta":{"revision":58,"created":1541965007407,"version":0,"updated":1557167070282},"$loki":134},{"itemID":343,"libraryID":1,"itemKey":"N2WIDF9W","pinned":false,"citekey":"rowstronPastryScalableDecentralized","meta":{"revision":58,"created":1541965841206,"version":0,"updated":1557167070282},"$loki":135},{"itemID":345,"libraryID":1,"itemKey":"WXZAGC7C","pinned":true,"citekey":"SplitStream-SOSP","meta":{"revision":56,"created":1541966274331,"version":0,"updated":1557167070282},"$loki":136},{"itemID":346,"libraryID":1,"itemKey":"DX7I4IAW","pinned":true,"citekey":"Anycast-NGC","meta":{"revision":56,"created":1541966274688,"version":0,"updated":1557167070282},"$loki":137},{"itemID":347,"libraryID":1,"itemKey":"7KZCJISX","pinned":true,"citekey":"ScribeEvaluation-Infocom","meta":{"revision":56,"created":1541966274914,"version":0,"updated":1557167070282},"$loki":138},{"itemID":348,"libraryID":1,"itemKey":"94PZEAIQ","pinned":true,"citekey":"SplitStream-IPTPS","meta":{"revision":56,"created":1541966275320,"version":0,"updated":1557167070282},"$loki":139},{"itemID":349,"libraryID":1,"itemKey":"4EFYJ3DL","pinned":true,"citekey":"PastryReliability-IPTPS","meta":{"revision":56,"created":1541966275609,"version":0,"updated":1557167070282},"$loki":140},{"itemID":350,"libraryID":1,"itemKey":"Z2Q8USAV","pinned":true,"citekey":"PastrySecurity-OSDI","meta":{"revision":56,"created":1541966275810,"version":0,"updated":1557167070282},"$loki":141},{"itemID":351,"libraryID":1,"itemKey":"QEQEJLVC","pinned":true,"citekey":"Scribe-NGC","meta":{"revision":56,"created":1541966276023,"version":0,"updated":1557167070282},"$loki":142},{"itemID":352,"libraryID":1,"itemKey":"ET5S9UBS","pinned":true,"citekey":"Pastry-fudico","meta":{"revision":56,"created":1541966276334,"version":0,"updated":1557167070282},"$loki":143},{"itemID":353,"libraryID":1,"itemKey":"96P5MAG9","pinned":true,"citekey":"Scribe-JSAC","meta":{"revision":56,"created":1541966276549,"version":0,"updated":1557167070282},"$loki":144},{"itemID":354,"libraryID":1,"itemKey":"7ZA6BJEW","pinned":true,"citekey":"Rings-EW","meta":{"revision":56,"created":1541966276738,"version":0,"updated":1557167070282},"$loki":145},{"itemID":355,"libraryID":1,"itemKey":"MWWXV9WM","pinned":true,"citekey":"PAST-Hotos","meta":{"revision":56,"created":1541966276930,"version":0,"updated":1557167070282},"$loki":146},{"itemID":356,"libraryID":1,"itemKey":"5YK85AR3","pinned":true,"citekey":"PAST-SOSP","meta":{"revision":56,"created":1541966277320,"version":0,"updated":1557167070282},"$loki":147},{"itemID":357,"libraryID":1,"itemKey":"N5XM2L24","pinned":true,"citekey":"Pastry-Middleware","meta":{"revision":56,"created":1541966277975,"version":0,"updated":1557167070282},"$loki":148},{"itemID":358,"libraryID":1,"itemKey":"EUXFPCUJ","pinned":true,"citekey":"Squirrel-PODC","meta":{"revision":56,"created":1541966278405,"version":0,"updated":1557167070282},"$loki":149},{"itemID":362,"libraryID":1,"itemKey":"2G5VTGYV","pinned":false,"citekey":"SplitStreamHighBandwidthMulticast","meta":{"revision":57,"created":1541967701232,"version":0,"updated":1557167070282},"$loki":150},{"itemID":363,"libraryID":1,"itemKey":"NTU8JLHI","pinned":true,"citekey":"SplitStream-SOSP","meta":{"revision":56,"created":1541967770243,"version":0,"updated":1557167070282},"$loki":151},{"itemID":365,"libraryID":1,"itemKey":"JZQJ6KKQ","pinned":false,"citekey":"mozoTagIndexedDHT2006","meta":{"revision":56,"created":1541975974257,"version":0,"updated":1557167070282},"$loki":152},{"itemID":367,"libraryID":1,"itemKey":"6F4QJAZX","pinned":false,"citekey":"mozoTagIndexedDHT2006a","meta":{"revision":56,"created":1541976214155,"version":0,"updated":1557167070282},"$loki":153},{"itemID":372,"libraryID":1,"itemKey":"4WVPWVW8","pinned":false,"citekey":"LilliputStorageService","meta":{"revision":56,"created":1542042717606,"version":0,"updated":1557167070280},"$loki":154},{"itemID":373,"libraryID":1,"itemKey":"AGA72WIR","pinned":true,"citekey":"paul2017lilliput","meta":{"revision":55,"created":1542042824539,"version":0,"updated":1557167070280},"$loki":155},{"itemID":375,"libraryID":1,"itemKey":"QSNEMF2Q","pinned":true,"citekey":"wiki:xxx","meta":{"revision":52,"created":1542849046811,"version":0,"updated":1557167070280},"$loki":156},{"itemID":376,"libraryID":1,"itemKey":"9YMLXNFU","pinned":true,"citekey":"Dolstra:2004:NSP:1052676.1052686","meta":{"revision":52,"created":1542849547979,"version":0,"updated":1557167070280},"$loki":157},{"itemID":378,"libraryID":1,"itemKey":"LZF76BQI","pinned":true,"citekey":"twitterincNumbersTwitterStatistics2011","meta":{"revision":55,"created":1543051584578,"version":0,"updated":1557167070280},"$loki":158},{"itemID":380,"libraryID":1,"itemKey":"HSUNWPLS","pinned":false,"citekey":"TwitterUsageStatistics","meta":{"revision":50,"created":1543051591174,"version":0,"updated":1557167070280},"$loki":159},{"itemID":384,"libraryID":1,"itemKey":"EKCBHCMH","pinned":false,"citekey":"perfittMegaphoneFaultTolerant2010","meta":{"revision":49,"created":1543233180088,"version":0,"updated":1557167070280},"$loki":160},{"itemID":388,"libraryID":1,"itemKey":"K5MYXUTW","pinned":false,"citekey":"terpstraPeertoPeerApproachContentBased","meta":{"revision":49,"created":1543245354972,"version":0,"updated":1557167070280},"$loki":161},{"itemID":390,"libraryID":1,"itemKey":"7UTYGLXP","pinned":false,"citekey":"mozoScalableTagSearch2008","meta":{"revision":47,"created":1544457571140,"version":0,"updated":1557167070280},"$loki":162},{"itemID":396,"libraryID":1,"itemKey":"Y88BE28F","pinned":false,"citekey":"RWOT5BostonMassachusetts2018","meta":{"revision":44,"created":1545086644786,"version":0,"updated":1557167070280},"$loki":163},{"itemID":398,"libraryID":1,"itemKey":"SKIEMMJW","pinned":false,"citekey":"blog!ActivityPubWorseBetter2019","meta":{"revision":40,"created":1547413193830,"version":0,"updated":1557167070280},"$loki":164},{"itemID":401,"libraryID":1,"itemKey":"CPELY3IK","pinned":false,"citekey":"GroupsOStatusCommunity","meta":{"revision":36,"created":1550492369246,"version":0,"updated":1557167070280},"$loki":165},{"itemID":403,"libraryID":1,"itemKey":"RX2F7ICC","pinned":false,"citekey":"GroupsGnusocialNet","meta":{"revision":36,"created":1550492378254,"version":0,"updated":1557167070280},"$loki":166},{"itemID":406,"libraryID":1,"itemKey":"L29UJ7RC","pinned":false,"citekey":"PleromaRelay","meta":{"revision":36,"created":1550495616194,"version":0,"updated":1557167070280},"$loki":167},{"itemID":409,"libraryID":1,"itemKey":"UE9PJEHS","pinned":false,"citekey":"urdanetaSurveyDHTSecurity2011","meta":{"revision":36,"created":1550506582302,"version":0,"updated":1557167070280},"$loki":168},{"itemID":411,"libraryID":1,"itemKey":"I2QR4HDG","pinned":false,"citekey":"lemmerwebberActivityPubW3CRecommendation2018","meta":{"revision":38,"created":1551546679356,"version":0,"updated":1557167070280},"$loki":169},{"itemID":413,"libraryID":1,"itemKey":"JV4GXH7Y","pinned":false,"citekey":"twitterinc.Twitter2019","meta":{"revision":35,"created":1551548332990,"version":0,"updated":1557167070280},"$loki":170},{"itemID":415,"libraryID":1,"itemKey":"224GPULD","pinned":false,"citekey":"HttpsWwwIetf","meta":{"revision":32,"created":1551734495788,"version":0,"updated":1557167070280},"$loki":171},{"itemID":417,"libraryID":1,"itemKey":"V2TIM2NJ","pinned":true,"citekey":"RFC2119","meta":{"revision":32,"created":1551734559602,"version":0,"updated":1557167070280},"$loki":172},{"itemID":419,"libraryID":1,"itemKey":"LNWIRMAR","pinned":true,"citekey":"DBLP:conf/iptps/ByersCM03","meta":{"revision":31,"created":1552565777154,"version":0,"updated":1557167070280},"$loki":173},{"itemID":422,"libraryID":1,"itemKey":"NJ58AXHC","pinned":false,"citekey":"raoLoadBalancingStructured2003","meta":{"revision":31,"created":1552565984842,"version":0,"updated":1557167070280},"$loki":174},{"itemID":423,"libraryID":1,"itemKey":"PI38JNHE","pinned":false,"citekey":"riecheThermaldissipationbasedApproachBalancing2004","meta":{"revision":31,"created":1552571790466,"version":0,"updated":1557167070280},"$loki":175},{"itemID":427,"libraryID":1,"itemKey":"CJZ3W9V4","pinned":false,"citekey":"kargerSimpleEfficientLoad","meta":{"revision":31,"created":1552571893232,"version":0,"updated":1557167070280},"$loki":176},{"itemID":429,"libraryID":1,"itemKey":"NURL26AE","pinned":false,"citekey":"stoicaChordScalablePeertopeer2003","meta":{"revision":29,"created":1552920278626,"version":0,"updated":1557167070280},"$loki":177},{"itemID":433,"libraryID":1,"itemKey":"P6XGVMV4","pinned":false,"citekey":"maymounkovKademliaPeertoPeerInformation2002","meta":{"revision":29,"created":1552920789372,"version":0,"updated":1557167070280},"$loki":178},{"itemID":436,"libraryID":1,"itemKey":"6MIMFETI","pinned":false,"citekey":"stevensFirstCollisionFull2017","meta":{"revision":28,"created":1553183498292,"version":0,"updated":1557167070280},"$loki":179},{"itemID":437,"libraryID":1,"itemKey":"TGVLBIU3","pinned":false,"citekey":"NodeInfoSpecification","meta":{"revision":29,"created":1553256399540,"version":0,"updated":1557167070278},"$loki":180},{"itemID":439,"libraryID":1,"itemKey":"WRILWH53","pinned":false,"citekey":"IPv6GlobalUnicast","meta":{"revision":28,"created":1553266343088,"version":0,"updated":1557167070278},"$loki":181},{"itemID":443,"libraryID":1,"itemKey":"QJ9R7VFZ","pinned":false,"citekey":"zhuEfficientProximityawareLoad2005","meta":{"revision":28,"created":1553271276120,"version":0,"updated":1557167070278},"$loki":182},{"itemID":446,"libraryID":1,"itemKey":"8TRTYR5Z","pinned":false,"citekey":"godfreyLoadBalancingDynamic2004","meta":{"revision":28,"created":1553271430210,"version":0,"updated":1557167070278},"$loki":183},{"itemID":449,"libraryID":1,"itemKey":"SV42BFRC","pinned":false,"citekey":"yuLeopardLocalityAware2005","meta":{"revision":28,"created":1553273947932,"version":0,"updated":1557167070278},"$loki":184},{"itemID":451,"libraryID":1,"itemKey":"NKHT4LSW","pinned":false,"citekey":"prodromouTagsPubHome2017","meta":{"revision":27,"created":1553528337214,"version":0,"updated":1557167070278},"$loki":185},{"itemID":457,"libraryID":1,"itemKey":"MKKZ9W2D","pinned":false,"citekey":"dabekWideareaCooperativeStorage","meta":{"revision":23,"created":1554387731024,"version":0,"updated":1557167070278},"$loki":186},{"itemID":460,"libraryID":1,"itemKey":"7V3B7KYG","pinned":false,"citekey":"ledlieDistributedSecureLoad2005","meta":{"revision":23,"created":1554389353086,"version":0,"updated":1557167070278},"$loki":187},{"itemID":465,"libraryID":1,"itemKey":"DLK6P7NU","pinned":false,"citekey":"ResearchthingsOpenData","meta":{"revision":22,"created":1554594730192,"version":0,"updated":1557167070276},"$loki":188},{"itemID":467,"libraryID":1,"itemKey":"CE7YRU8G","pinned":false,"citekey":"DiasporaMasterResearchthings","meta":{"revision":22,"created":1554594796450,"version":0,"updated":1557167070276},"$loki":189},{"citekey":"tange_ole_2018_1146014","pinned":true,"itemID":472,"libraryID":1,"itemKey":"WHSGQKBT","meta":{"revision":19,"created":1555017170612,"version":0,"updated":1557167070276},"$loki":190},{"itemID":474,"libraryID":1,"itemKey":"A7KWGKHC","pinned":false,"citekey":"schubertDiasporaTagUsage","meta":{"revision":18,"created":1557150362584,"version":0,"updated":1557167070276},"$loki":191},{"itemID":475,"libraryID":1,"itemKey":"7AMBZDRJ","pinned":false,"citekey":"DiasporaProject","meta":{"revision":17,"created":1557151547468,"version":0,"updated":1557167070276},"$loki":192}],"idIndex":[2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192],"binaryIndices":{"itemID":{"name":"itemID","dirty":false,"values":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188]},"itemKey":{"name":"itemKey","dirty":true,"values":[19,76,75,12,50,48,27,49,97,101,23,105,77,106,22,54,99,91,28,46,34,3,51,98,60,18,8,24,82,5,33,107,16,42,4,55,94,11,68,39,102,56,2,93,78,30,37,44,72,57,13,43,1,29,96,61,69,79,62,38,58,103,21,74,32,89,7,40,15,100,81,35,84,86,26,53,88,92,66,14,10,80,108,36,87,95,52,0,104,73,85,45,70,6,64,31,47,67,59,17,63,9,20,83,25,90,71,41,65]},"libraryID":{"name":"libraryID","dirty":true,"values":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189]},"citekey":{"name":"citekey","dirty":false,"values":[68,1,109,119,123,11,72,133,55,169,103,102,128,185,188,153,162,161,167,112,177,43,150,122,125,126,124,93,114,73,82,176,142,143,144,139,136,137,163,117,168,51,46,48,50,45,159,121,118,184,141,140,138,134,3,111,110,116,135,132,147,146,145,5,6,44,71,113,155,20,84,79,77,7,52,96,100,47,12,105,160,18,88,53,64,74,75,63,127,99,87,81,182,85,104,59,60,40,62,35,34,30,28,29,27,4,23,25,33,32,2,26,36,37,58,61,49,38,0,9,10,106,115,179,76,24,66,67,70,42,172,108,183,165,16,69,14,78,95,174,94,90,158,148,149,17,151,97,156,54,19,86,39,181,13,170,171,129,131,130,31,8,187,101,91,15,107,175,41,173,98,186,157,166,154,92,164,57,83,120,21,152,89,180,80,22,178,56,65]},"pinned":{"name":"pinned","dirty":true,"values":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,48,50,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,105,106,107,108,45,46,47,49,51,52,69,103,104]}},"constraints":null,"uniqueNames":["itemID"],"transforms":{},"objType":"citekey","dirty":true,"cachedIndex":null,"cachedBinaryIndex":null,"cachedData":null,"adaptiveBinaryIndices":false,"transactional":false,"cloneObjects":true,"cloneMethod":"parse-stringify","asyncListeners":false,"disableMeta":false,"disableChangesApi":true,"disableDeltaChangesApi":true,"autoupdate":false,"serializableIndices":true,"ttl":null,"maxId":192,"DynamicViews":[],"events":{"insert":[],"update":[],"pre-insert":[],"pre-update":[],"close":[],"flushbuffer":[],"error":[],"delete":[null],"warning":[null]},"changes":[]}']
(4)(+0000000): REPLACE INTO "better-bibtex" (name, data) VALUES (?, ?) ['better-bibtex', '{"filename":"better-bibtex","collections":["better-bibtex.citekey","better-bibtex.autoexport"],"databaseVersion":1.5,"engineVersion":1.5,"autosave":false,"autosaveInterval":5000,"autosaveHandle":null,"throttledSaves":false,"options":{"env":"NA","serializationMethod":"normal","destructureDelimiter":"$<\n"},"persistenceAdapter":null,"throttledSavePending":false,"throttledCallbacks":[],"verbose":false,"events":{"init":[null],"loaded":[],"flushChanges":[],"close":[],"changes":[],"warning":[]},"ENV":"NA"}']
(4)(+0000064): Committed DB transaction JztnVyC3
(3)(+0000492): Cached 550 translators in 1426 ms
(3)(+0000006): HTTP GET resource://zotero/schema/repotime.txt
(3)(+0000002): HTTP GET resource://zotero/schema/repotime.txt succeeded with 200
(4)(+0000004): SELECT version FROM version WHERE schema='delete'
(3)(+0000004): Getting contents of input stream
(4)(+0000002): SELECT version FROM version WHERE schema=? ['translators']
(3)(+0000002): Installed translators are up-to-date with XPI
(3)(+0000000): Initializing styles
(3)(+0000004): Getting contents of /home/spiollinux/Zotero/styles/elsevier-harvard.csl
(3)(+0000004): Getting contents of /home/spiollinux/Zotero/styles/cell.csl
(3)(+0000004): Getting contents of /home/spiollinux/Zotero/styles/chicago-author-date.csl
(3)(+0000004): Getting contents of /home/spiollinux/Zotero/styles/apa.csl
(3)(+0000006): Getting contents of /home/spiollinux/Zotero/styles/modern-language-association.csl
(3)(+0000006): Getting contents of /home/spiollinux/Zotero/styles/chicago-fullnote-bibliography.csl
(3)(+0000010): Getting contents of /home/spiollinux/Zotero/styles/vancouver.csl
(3)(+0000004): Getting contents of /home/spiollinux/Zotero/styles/chicago-note-bibliography.csl
(3)(+0000008): Getting contents of /home/spiollinux/Zotero/styles/modern-humanities-research-association.csl
(3)(+0000004): Getting contents of /home/spiollinux/Zotero/styles/nature.csl
(3)(+0000008): Getting contents of /home/spiollinux/Zotero/styles/ieee.csl
(3)(+0000004): Getting contents of /home/spiollinux/Zotero/styles/american-anthropological-association.csl
(3)(+0000006): Cached 12 styles in 72 ms
(3)(+0000000): HTTP GET chrome://zotero/content/locale/csl/locales.json
(3)(+0000002): HTTP GET chrome://zotero/content/locale/csl/locales.json succeeded with 200
(3)(+0000002): HTTP GET resource://zotero/schema/renamed-styles.json
(3)(+0000002): HTTP GET resource://zotero/schema/renamed-styles.json succeeded with 200
(3)(+0000004): HTTP GET resource://zotero/schema/repotime.txt
(3)(+0000002): HTTP GET resource://zotero/schema/repotime.txt succeeded with 200
(4)(+0000004): SELECT version FROM version WHERE schema='delete'
(3)(+0000002): Getting contents of input stream
(4)(+0000002): SELECT version FROM version WHERE schema=? ['styles']
(3)(+0000002): Installed styles are up-to-date with XPI
(4)(+0000002): SELECT version FROM version WHERE schema='repository'
(3)(+0000000): Checking repository for updates
(3)(+0000004): HTTP POST "styles=%5B%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Felsevier-harvard%22%2C%22updated%22%3A1548169032%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Felsevier-harvard%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fcell%22%2C%22updated%22%3A1410033753%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fcell%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fchicago-author-date%22%2C%22updated%22%3A1546553342%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fchicago-author-date%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fapa%22%2C%22updated%22%3A1556383561%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fapa%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fmodern-language-association%22%2C%22updated%22%3A1555286253%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fmodern-language-association%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fchicago-fullnote-bibliography%22%2C%22updated%22%3…" (2290 chars) to https://repo.zotero.org/repo/updated?last=1557167053&version=5.0.66&m=3
(3)(+0001558): HTTP POST https://repo.zotero.org/repo/updated?last=1557167053&version=5.0.66&m=3 succeeded with 200
(3)(+0000008): Saving style 'http://www.zotero.org/styles/elsevier-harvard'
(3)(+0000008): Saving style 'http://www.zotero.org/styles/cell'
(3)(+0000010): Saving style 'http://www.zotero.org/styles/chicago-author-date'
(3)(+0000012): Saving style 'http://www.zotero.org/styles/apa'
(3)(+0000012): Saving style 'http://www.zotero.org/styles/modern-language-association'
(3)(+0000008): Saving style 'http://www.zotero.org/styles/chicago-fullnote-bibliography'
(3)(+0000056): Saving style 'http://www.zotero.org/styles/vancouver'
(3)(+0000020): Saving style 'http://www.zotero.org/styles/chicago-note-bibliography'
(3)(+0000006): Saving style 'http://www.zotero.org/styles/modern-humanities-research-association'
(3)(+0000012): Saving style 'http://www.zotero.org/styles/nature'
(3)(+0000014): Saving style 'http://www.zotero.org/styles/ieee'
(3)(+0000006): Saving style 'http://www.zotero.org/styles/american-anthropological-association'
(3)(+0000010): Initializing translators
(4)(+0000002): SELECT rowid, fileName, metadataJSON, lastModifiedTime FROM translatorCache
(3)(+0001236): Cached 550 translators in 1236 ms
(3)(+0000004): Initializing styles
(3)(+0000010): Getting contents of /home/spiollinux/Zotero/styles/elsevier-harvard.csl
(3)(+0000006): Getting contents of /home/spiollinux/Zotero/styles/cell.csl
(3)(+0000012): Getting contents of /home/spiollinux/Zotero/styles/chicago-author-date.csl
(3)(+0000006): Getting contents of /home/spiollinux/Zotero/styles/apa.csl
(3)(+0000016): Getting contents of /home/spiollinux/Zotero/styles/modern-language-association.csl
(3)(+0000006): Getting contents of /home/spiollinux/Zotero/styles/chicago-fullnote-bibliography.csl
(3)(+0000010): Getting contents of /home/spiollinux/Zotero/styles/vancouver.csl
(3)(+0000054): Getting contents of /home/spiollinux/Zotero/styles/chicago-note-bibliography.csl
(3)(+0000010): Getting contents of /home/spiollinux/Zotero/styles/modern-humanities-research-association.csl
(3)(+0000012): Getting contents of /home/spiollinux/Zotero/styles/nature.csl
(3)(+0000012): Getting contents of /home/spiollinux/Zotero/styles/ieee.csl
(3)(+0000006): Getting contents of /home/spiollinux/Zotero/styles/american-anthropological-association.csl
(3)(+0000014): Cached 12 styles in 172 ms
(3)(+0000002): HTTP GET chrome://zotero/content/locale/csl/locales.json
(3)(+0000006): HTTP GET chrome://zotero/content/locale/csl/locales.json succeeded with 200
(3)(+0000004): HTTP GET resource://zotero/schema/renamed-styles.json
(3)(+0000006): HTTP GET resource://zotero/schema/renamed-styles.json succeeded with 200
(4)(+0000004): Beginning DB transaction YEgV5V5f
(4)(+0000010): REPLACE INTO version (schema,version) VALUES (?,?) ['repository', 1557167074]
(4)(+0000048): REPLACE INTO version (schema,version) VALUES (?,?) ['lastcheck', 1557167076]
(4)(+0000024): Committed DB transaction YEgV5V5f
(3)(+0000006): Initializing DB backup idle observer
(4)(+0000006): Beginning DB transaction ERJoWuWB
(3)(+0000004): Initializing DB backup idle observer
(3)(+0000004): Preloading a515a220-6fef-45ea-9842-8025dfebcc8f for Quick Copy
(3)(+0000006): {better-bibtex +7004} Startup progress: Warten auf Zotero-Übersetzer took 7.004 s
(3)(+0000002): {better-bibtex +4} Startup progress: Starte Serialisierungs-Cache...
(3)(+0000004): {better-bibtex +4} events: handler registered for preference-changed
(3)(+0000002): {better-bibtex +2} JournalAbbrev.reset
(3)(+0000000): {better-bibtex +0} JournalAbbrev.reset: {"style":""}
(3)(+0000002): {better-bibtex +2} JournalAbbrev.init: done
(3)(+0000002): {better-bibtex +2} Startup progress: Starte Serialisierungs-Cache took 0.014 s
(3)(+0000000): {better-bibtex +0} Startup progress: Lade Zeitschriften-Abkürzer...
(3)(+0000002): {better-bibtex +2} Startup progress: Lade Zeitschriften-Abkürzer took 0.002 s
(3)(+0000002): {better-bibtex +2} Startup progress: Installiere kompilierte Export-Module...
(3)(+0000004): {better-bibtex +4} Translators.install: installed = true
(3)(+0000002): Getting contents of /home/spiollinux/Zotero/translators/Better BibTeX Citation Key Quick Copy.js
(3)(+0000036): {better-bibtex +38} Translators.install: Better CSL YAML not reinstalling 1080bb4b6ed72fa636332d93164937d3-c60cf06859f43bc0d3ef8da6e128f363
(3)(+0000002): {better-bibtex +2} Translators.install: installed = true
(4)(+0000004): SELECT key AS domainPath, value AS format FROM settings WHERE setting='quickCopySite'
(4)(+0000016): Committed DB transaction ERJoWuWB
(4)(+0000006): Beginning DB transaction mkupQbTE
(3)(+0000006): {better-bibtex +32} Translators.install: Citation graph not reinstalling 6fe297b7f506baa6891c1f3c60946cd8-45cd41e0f0886212f775ff496e60c0c4
(3)(+0000002): {better-bibtex +2} Translators.install: installed = true
(4)(+0000020): CREATE TEMPORARY TABLE tagDelete AS SELECT tagID FROM tags WHERE tagID NOT IN (SELECT tagID FROM itemTags)
(3)(+0000004): {better-bibtex +22} Translators.install: BetterBibTeX JSON not reinstalling e71bafc74fd9463e32e018a190832a99-d9525b9cd18b860be2ce0b44821c1c5a
(3)(+0000002): {better-bibtex +4} Translators.install: installed = true
(4)(+0000014): CREATE INDEX tagDelete_tagID ON tagDelete(tagID)
(3)(+0000004): {better-bibtex +18} Translators.install: Better BibTeX Citation Key Quick Copy not reinstalling 42417dd2bd21c624a384e95976ce486e-be4de93098e45b13ec42986fe5a07408
(3)(+0000002): {better-bibtex +2} Translators.install: installed = true
(4)(+0000020): SELECT tagID AS id, name FROM tagDelete JOIN tags USING (tagID)
(3)(+0000006): {better-bibtex +26} Translators.install: Better BibTeX not reinstalling 9ea5eb7fff2f05a7795585408954ad68-641a872cf57846b65b662116a2ae77bf
(3)(+0000002): {better-bibtex +2} Translators.install: installed = true
(4)(+0000052): DROP TABLE tagDelete
(3)(+0000004): {better-bibtex +54} Translators.install: Collected notes not reinstalling c703a44eb5768ec2a8d148fe2baa0bf1-0ceb75b7b7d3da751443454decb4c208
(3)(+0000000): {better-bibtex +2} Translators.install: installed = true
(3)(+0000022): {better-bibtex +22} Translators.install: Better CSL JSON not reinstalling 6df3e3b331212ef521ddf84f05047b7e-e8566bfd727019db753d9009885d29e0
(3)(+0000002): {better-bibtex +2} Translators.install: installed = true
(4)(+0000032): Committed DB transaction mkupQbTE
(4)(+0000008): Beginning DB transaction EoU9Nok9
(3)(+0000018): {better-bibtex +58} Translators.install: Better BibLaTeX not reinstalling 9b4c8736cc13d620417cd1693f0084ee-f5251945667e2b301ee41c2021a53571
(3)(+0000004): {better-bibtex +4} Startup progress: Installiere kompilierte Export-Module took 0.296 s
(3)(+0000004): {better-bibtex +4} Startup progress: done
(3)(+0000004): {better-bibtex +4} events: emitted ["loaded"]
(3)(+0000004): {better-bibtex +4} events: got loaded
(3)(+0000002): {better-bibtex +2} Better BibTeX load finished successfully
(4)(+0000048): Committed DB transaction EoU9Nok9
(3)(+0000008): Purged data tables in 394 ms
(4)(+0001402): SELECT COUNT(*) FROM settings WHERE setting='mImport' AND key='cleanup'
(3)(+0003204): Scheduling next feed update
(4)(+0000002): SELECT ( CASE WHEN lastCheck IS NULL THEN 0 ELSE strftime('%s', lastCheck) + refreshInterval * 60 - strftime('%s', 'now') END ) AS nextCheck FROM feeds WHERE refreshInterval IS NOT NULL ORDER BY nextCheck ASC LIMIT 1
(3)(+0000002): No feeds with auto-update
(3)(+0000952): Collection.getName() deprecated -- use Collection.name
(3)(+0000004): Translate: All translator detect calls and RPC calls complete:
(3)(+0000002): TEI: 25
(3)(+0000000): Zotero RDF: 25
(3)(+0000002): Better BibLaTeX: 50
(3)(+0000000): Bibliontology RDF: 50
(3)(+0000002): MODS: 50
(3)(+0000000): Simple Evernote Export: 50
(3)(+0000002): BetterBibTeX JSON: 99
(3)(+0000000): Better BibTeX Citation Key Quick Copy: 100
(3)(+0000002): Better CSL JSON: 100
(3)(+0000000): Better CSL YAML: 100
(3)(+0000002): BibLaTeX: 100
(3)(+0000000): Bookmarks: 100
(3)(+0000002): Citation graph: 100
(3)(+0000000): Collected notes: 100
(3)(+0000000): CSL JSON: 100
(3)(+0000002): CSV: 100
(3)(+0000000): Endnote XML: 100
(3)(+0000002): Refer/BibIX: 100
(3)(+0000000): RefWorks Tagged: 100
(3)(+0000002): RIS: 100
(3)(+0000000): Unqualified Dublin Core RDF: 100
(3)(+0000002): Wikipedia Citation Templates: 100
(3)(+0000000): Better BibTeX: 199
(3)(+0000002): BibTeX: 200
(3)(+0000000): COinS: 310
(3)(+0000030): zotero-better-bibtex: loading content/ExportOptions.ts
(3)(+0000002): zotero-better-bibtex: loaded content/ExportOptions.ts
(3)(+0000038): {better-bibtex +5716} export-options add event handler for export-option-exportFileData
(3)(+0000002): {better-bibtex +2} export-options add event handler for export-option-keepUpdated
(3)(+0002878): {better-bibtex +2878} clicked export-option-keepUpdated
(3)(+0013074): {better-bibtex +13074} AutoExport.add {"type":"collection","id":6,"path":"/home/spiollinux/Seafile/Studium/Semester9/Großer Beleg/paper_hashtag_federation/literature.bib","status":"done","translatorID":"f895aa0d-f28e-47fe-b247-2ea77c6ed583","exportNotes":true,"useJournalAbbreviation":false,"DOIandURL":"both","asciiBibLaTeX":false,"asciiBibTeX":true,"biblatexExtendedNameFormat":false,"bibtexParticleNoOp":false,"bibtexURL":"url"}
(4)(+0000006): Translate: Binding sandbox to http://www.example.com/
(3)(+0000006): Getting contents of /home/spiollinux/Zotero/translators/Better BibLaTeX.js
(4)(+0000092): Translate: Parsing code for Better BibLaTeX (f895aa0d-f28e-47fe-b247-2ea77c6ed583, 2019-05-06 17:10:32)
(3)(+0000054): Translate: zotero-better-bibtex: loading translators/Better BibLaTeX.ts
(3)(+0000002): Translate: zotero-better-bibtex: loading translators/bibtex/reference.ts
(3)(+0000002): Translate: zotero-better-bibtex: loading translators/lib/exporter.ts
(3)(+0000002): Translate: zotero-better-bibtex: loading translators/bibtex/jabref.ts
(3)(+0000000): Translate: zotero-better-bibtex: loading translators/lib/debug.ts
(3)(+0000002): Translate: zotero-better-bibtex: loaded translators/lib/debug.ts
(3)(+0000000): Translate: zotero-better-bibtex: loaded translators/bibtex/jabref.ts
(3)(+0000002): Translate: zotero-better-bibtex: loading gen/itemfields.ts
(3)(+0000008): Translate: zotero-better-bibtex: loaded gen/itemfields.ts
(3)(+0000020): Translate: zotero-better-bibtex: loaded translators/lib/exporter.ts
(3)(+0000002): Translate: zotero-better-bibtex: loading translators/bibtex/unicode_translator.ts
(3)(+0000014): Translate: zotero-better-bibtex: loaded translators/bibtex/unicode_translator.ts
(3)(+0000002): Translate: zotero-better-bibtex: loading translators/bibtex/datefield.ts
(3)(+0000000): Translate: zotero-better-bibtex: loaded translators/bibtex/datefield.ts
(3)(+0000002): Translate: zotero-better-bibtex: loading content/arXiv.ts
(3)(+0000002): Translate: zotero-better-bibtex: loaded content/arXiv.ts
(3)(+0000004): Translate: zotero-better-bibtex: loaded translators/bibtex/reference.ts
(3)(+0000002): Translate: zotero-better-bibtex: loaded translators/Better BibLaTeX.ts
(3)(+0000018): Starting full-text content processor
(1)(+0000002): [Exception... "Component returned failure code: 0x80520012 (NS_ERROR_FILE_NOT_FOUND) [nsIFileOutputStream.init]" nsresult: "0x80520012 (NS_ERROR_FILE_NOT_FOUND)" location: "JS frame :: chrome://zotero/content/xpcom/translation/translate_firefox.js :: Zotero.Translate.IO.Write :: line 950" data: no] Zotero.Translate.IO.Write@chrome://zotero/content/xpcom/translation/translate_firefox.js:950:3 rest@chrome://zotero/content/xpcom/translation/translate.js:2605:18 Zotero.Translate.Export.prototype._prepareTranslation</<@chrome://zotero/content/xpcom/translation/translate.js:2587:35 tryCatcher@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/util.js:16:16 module.exports/Promise.prototype._settlePromiseFromHandler@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/promise.js:512:13 module.exports/Promise.prototype._settlePromise@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/promise.js:569:13 module.exports/Promise.prototype._settlePromiseCtx@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/promise.js:606:5 Async.prototype._drainQueue@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/async.js:138:9 From previous event: captureStackTrace@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/debuggability.js:829:23 CapturedTrace@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/debuggability.js:721:5 longStackTracesCaptureStackTrace@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/debuggability.js:400:19 module.exports/Promise.prototype._then@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/promise.js:232:9 module.exports/Promise.prototype._passThrough@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/finally.js:94:12 module.exports/Promise.prototype.finally@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/finally.js:103:12 PromiseSpawn@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/generators.js:36:25 module.exports/Promise.coroutine/<@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/generators.js:197:21 exportCollection@chrome://zotero/content/fileInterface.js:169:5 ZoteroPane</_collectionContextMenuOptions<.oncommand@chrome://zotero/content/zoteroPane.js:2452:22 ZoteroPane</this.onCollectionContextMenuSelect@chrome://zotero/content/zoteroPane.js:2367:7 oncommand@chrome://zotero/content/standalone/standalone.xul:1:1
(3)(+0001282): {better-bibtex +1526} idle, saving better-bibtex
(4)(+0000008): Beginning DB transaction 3mea2qYu
(4)(+0000008): SELECT name FROM "better-bibtex"
(4)(+0000006): REPLACE INTO "better-bibtex" (name, data) VALUES (?, ?) ['better-bibtex.autoexport', '{"name":"autoexport","data":[{"type":"collection","id":2,"path":"/home/spiollinux/Seafile/Studium/Semester8/HS Technischer Datenschutz/latex-paper/mybib.bib","status":"done","translatorID":"ca65189f-8815-4afe-8c8b-8c7c15f0edca","exportNotes":false,"useJournalAbbreviation":false,"error":"TypeError: this.itemType is undefined","meta":{"revision":95,"created":1528755826840,"version":0,"updated":1557167050984},"$loki":2,"DOIandURL":"both","asciiBibLaTeX":false,"asciiBibTeX":true,"biblatexExtendedNameFormat":false,"bibtexParticleNoOp":false,"bibtexURL":"off"},{"type":"collection","id":4,"path":"/home/spiollinux/Seafile/Studium/Semester8/Influential OS Research/latex-paper/mybib.bib","status":"done","translatorID":"ca65189f-8815-4afe-8c8b-8c7c15f0edca","exportNotes":false,"useJournalAbbreviation":false,"DOIandURL":"both","asciiBibLaTeX":false,"asciiBibTeX":true,"biblatexExtendedNameFormat":false,"bibtexParticleNoOp":false,"bibtexURL":"url","error":"TypeError: this.itemType is undefined","meta":{"revision":301,"created":1536092646776,"version":0,"updated":1557167050988},"$loki":3},{"type":"collection","id":8,"path":"/home/spiollinux/Seafile/Studium/Semester9/OS Reading Group/NixOS_paper/NixOS_presentation.bib","status":"done","translatorID":"ca65189f-8815-4afe-8c8b-8c7c15f0edca","exportNotes":false,"useJournalAbbreviation":false,"DOIandURL":"both","asciiBibLaTeX":false,"asciiBibTeX":true,"biblatexExtendedNameFormat":false,"bibtexParticleNoOp":false,"bibtexURL":"url","error":"TypeError: this.itemType is undefined","meta":{"revision":30,"created":1542849273047,"version":0,"updated":1557167050990},"$loki":4},{"type":"collection","id":6,"path":"/home/spiollinux/tmp/zotest/Großer Beleg.bib","status":"done","translatorID":"f895aa0d-f28e-47fe-b247-2ea77c6ed583","exportNotes":true,"useJournalAbbreviation":false,"DOIandURL":"both","asciiBibLaTeX":false,"asciiBibTeX":true,"biblatexExtendedNameFormat":false,"bibtexParticleNoOp":false,"bibtexURL":"url","error":"TypeError: this.itemType is undefined","meta":{"revision":8,"created":1557158019218,"version":0,"updated":1557167050992},"$loki":12},{"type":"collection","id":6,"path":"/home/spiollinux/Seafile/Studium/Semester9/Großer Beleg/literature.bib","status":"done","translatorID":"f895aa0d-f28e-47fe-b247-2ea77c6ed583","exportNotes":true,"useJournalAbbreviation":false,"DOIandURL":"both","asciiBibLaTeX":false,"asciiBibTeX":true,"biblatexExtendedNameFormat":false,"bibtexParticleNoOp":false,"bibtexURL":"url","error":"","meta":{"revision":0,"created":1557163836796,"version":0},"$loki":13},{"type":"collection","id":6,"path":"/home/spiollinux/Seafile/Studium/Semester9/Großer Beleg/paper_hashtag_federation/literature.bib","status":"done","translatorID":"f895aa0d-f28e-47fe-b247-2ea77c6ed583","exportNotes":true,"useJournalAbbreviation":false,"DOIandURL":"both","asciiBibLaTeX":false,"asciiBibTeX":true,"biblatexExtendedNameFormat":false,"bibtexParticleNoOp":false,"bibtexURL":"url","error":"","meta":{"revision":0,"created":1557167099446,"version":0},"$loki":14}],"idIndex":[2,3,4,12,13,14],"binaryIndices":{"type":{"name":"type","dirty":true,"values":[0,1,2,3,4]},"id":{"name":"id","dirty":true,"values":[0,1]},"status":{"name":"status","dirty":true,"values":[0,1]},"path":{"name":"path","dirty":true,"values":[0,1,5,3,2,4]},"exportNotes":{"name":"exportNotes","dirty":true,"values":[0,1]},"translatorID":{"name":"translatorID","dirty":true,"values":[0,1,2,3,4,5]},"useJournalAbbreviation":{"name":"useJournalAbbreviation","dirty":true,"values":[0,1]}},"constraints":null,"uniqueNames":["path"],"transforms":{},"objType":"autoexport","dirty":true,"cachedIndex":null,"cachedBinaryIndex":null,"cachedData":null,"adaptiveBinaryIndices":false,"transactional":false,"cloneObjects":true,"cloneMethod":"parse-stringify","asyncListeners":false,"disableMeta":false,"disableChangesApi":true,"disableDeltaChangesApi":true,"autoupdate":false,"serializableIndices":true,"ttl":null,"maxId":14,"DynamicViews":[],"events":{"insert":[],"update":[],"pre-insert":[],"pre-update":[],"close":[],"flushbuffer":[],"error":[],"delete":[null],"warning":[null]},"changes":[]}']
(4)(+0000004): REPLACE INTO "better-bibtex" (name, data) VALUES (?, ?) ['better-bibtex', '{"filename":"better-bibtex","collections":["better-bibtex.citekey","better-bibtex.autoexport"],"databaseVersion":1.5,"engineVersion":1.5,"autosave":false,"autosaveInterval":5000,"autosaveHandle":null,"throttledSaves":false,"options":{"env":"NA","serializationMethod":"normal","destructureDelimiter":"$<\n"},"persistenceAdapter":null,"throttledSavePending":false,"throttledCallbacks":[],"verbose":false,"events":{"init":[null],"loaded":[],"flushChanges":[],"close":[],"changes":[],"warning":[]},"ENV":"NA"}']
(4)(+0000018): Committed DB transaction 3mea2qYu
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment