BBT prevents start of zotero #2104

fholzm · 2022-04-11T08:57:54Z

BBT seems to cause an issue while opening Zotero. It just didn't start this morning. Meaning no window opens, but the task manager shows 30% CPU usage of Zotero and random fluctions of RAM between 500MB and 1GB. Even normal reinstallation of Zotero itself didn't fix the issue, I had to remove all userdata and reinstall. Everything works until reinstallation of BBT. The last lines in the generated log (using the command line and the -ZoteroDebugText flag) were:

zotero(3)(+0000003): PluginInstaller: fetching addon info
zotero(3)(+0000001): PluginInstaller: addon info fetched
zotero(3)(+0000000): BBT startup 1
zotero(3)(+0000001): {better-bibtex} +null Loading Better BibTeX: starting...

OS: Windows 10 Enterprise 2016 LTSB 64bit
Zotero-Version: 6.0.4
BBT-Version: 6.4.3

As Zotero won't start, I obviously can't generate a support-log.

retorquere · 2022-04-11T09:12:55Z

No other extensions installed?

fholzm · 2022-04-11T09:16:21Z

No other extensions installed?

Clean reinstall, so just the default extension for Word(?) which comes with the installation

qqobb · 2022-04-11T22:53:47Z

BBT version 6.4.2 runs without issues for me using Zotero 6.0.4 on Windows 10.

You could try to capture the debug output logging using this script:
https://gist.github.com/qqobb/65a3282493f85f0f0363e68cdb3dbb1e

Click on the "Raw" button and save the script to your computer. Then open a command prompt (cmd.exe) and try to run the script. It should start up Zotero with the debug output redirected to a text file.

It's possible that the script might not work for you, but you could try it.

fholzm · 2022-04-12T07:25:34Z

I've already generated the log, it ends when trying to load BBT: https://pastebin.com/sSch4gFd

BBT version 6.4.2 runs without issues for me using Zotero 6.0.4 on Windows 10.

I'm having this issue with version 6.4.3, not 6.4.2

retorquere · 2022-04-12T07:27:48Z

Does the problem occur for you when you install 6.4.2?

fholzm · 2022-04-12T08:02:15Z

It also occurs with other BBT versions (I've tried 6.2.10 and 6.4.2) and other Zotero versions (5.0.96). That's really strange... Also running zotero as admin didn't help.

retorquere · 2022-04-16T23:07:10Z

I've just fired up Zotero with BBT on a 24k item library on Windows 10 and Zotero starts up without issue. A new build will drop here shortly that will add more logging in the startup phase, maybe that will show where it's locking up.

github-actions · 2022-04-16T23:22:02Z

🤖 this is your friendly neighborhood build bot announcing test build 6.4.3.2398 ("startup logging")

Install in Zotero by downloading test build 6.4.3.2398, opening the Zotero "Tools" menu, selecting "Add-ons", open the gear menu in the top right, and select "Install Add-on From File...".

fholzm · 2022-05-02T06:01:20Z

Hi,
I've just wanted to install the testbuild, but the link is dead. Zotero still doesn't start with the recent builds of Zotero and BBT

retorquere · 2022-05-02T07:03:00Z

I'll be back at my pc in about 4 hours, then I can get you a new build. Test builds expire after about a week.

github-actions · 2022-05-04T11:30:29Z

🤖 this is your friendly neighborhood build bot announcing test build 6.5.3.2538 ("Merge branch 'master' into gh-2104")

Install in Zotero by downloading test build 6.5.3.2538, opening the Zotero "Tools" menu, selecting "Add-ons", open the gear menu in the top right, and select "Install Add-on From File...".

fholzm · 2022-05-04T11:54:44Z

Thanks, here's the generated log

github-actions · 2022-05-10T17:20:06Z

🤖 this is your friendly neighborhood build bot announcing test build 6.7.1.2574 ("Merge branch 'master' into gh-2104")

Install in Zotero by downloading test build 6.7.1.2574, opening the Zotero "Tools" menu, selecting "Add-ons", open the gear menu in the top right, and select "Install Add-on From File...".

retorquere · 2022-05-11T09:17:31Z

@fholzm can you try 2574?

fholzm · 2022-05-11T09:37:46Z

Zotero opens now, but it freezes when BBT initializes. The task manager shows still 30% CPU usage and strange RAM fluctuations between 500MB and 1GB. Here's the generated log

retorquere · 2022-05-11T10:04:06Z

Error, this is a private paste or is pending moderation. If this paste belongs to you, please login to Pastebin to view it.

fholzm · 2022-05-11T11:52:31Z

It should work now, click to expand!

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

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

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

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

zotero(4)(+0000020): PRAGMA page_size

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

zotero(4)(+0000000): PRAGMA foreign_keys

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

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

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

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

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

zotero(4)(+0000000): INSERT INTO itemTypesCombined SELECT itemTypeID, typeName, display, 0 AS custom FROM itemTypes UNION SELECT customItemTypeID + 10000 AS itemTypeID, typeName, display, 1 AS custom FROM customItemTypes

zotero(4)(+0000001): INSERT INTO fieldsCombined SELECT fieldID, fieldName, NULL AS label, fieldFormatID, 0 AS custom FROM fields UNION SELECT customFieldID + 10000 AS fieldID, fieldName, label, NULL, 1 AS custom FROM customFields

zotero(4)(+0000000): INSERT INTO itemTypeFieldsCombined SELECT itemTypeID, fieldID, hide, orderIndex FROM itemTypeFields UNION SELECT customItemTypeID + 10000 AS itemTypeID, COALESCE(fieldID, customFieldID + 10000) AS fieldID, hide, orderIndex FROM customItemTypeFields

zotero(4)(+0000002): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings

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

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

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

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

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

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

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

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

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

zotero(4)(+0000000): PRAGMA foreign_keys

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

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

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

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

zotero(4)(+0000000): INSERT INTO itemTypesCombined SELECT itemTypeID, typeName, display, 0 AS custom FROM itemTypes UNION SELECT customItemTypeID + 10000 AS itemTypeID, typeName, display, 1 AS custom FROM customItemTypes

zotero(4)(+0000000): INSERT INTO fieldsCombined SELECT fieldID, fieldName, NULL AS label, fieldFormatID, 0 AS custom FROM fields UNION SELECT customFieldID + 10000 AS fieldID, fieldName, label, NULL, 1 AS custom FROM customFields

zotero(4)(+0000000): INSERT INTO itemTypeFieldsCombined SELECT itemTypeID, fieldID, hide, orderIndex FROM itemTypeFields UNION SELECT customItemTypeID + 10000 AS itemTypeID, COALESCE(fieldID, customFieldID + 10000) AS fieldID, hide, orderIndex FROM customItemTypeFields

zotero(4)(+0000002): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings

zotero(4)(+0000012): Committed DB transaction lNGqFx3H

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

zotero(4)(+0000005): SELECT IT.itemTypeID, F.fieldID AS baseFieldID, BFM.fieldID FROM itemTypesCombined IT LEFT JOIN fieldsCombined F LEFT JOIN baseFieldMappingsCombined BFM ON (IT.itemTypeID=BFM.itemTypeID AND F.fieldID=BFM.baseFieldID)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

zotero(3)(+0000001): Registering URIContentListener

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

zotero(3)(+0000020): Getting contents of C:\Users\xxxx\AppData\Roaming\Zotero\Zotero\Profiles\9k05n6fa.default\retractions.json

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

zotero(3)(�[31;40m+0000260�[0m): monkey-patch: 6.0.6: BBT enabled

zotero(3)(+0000137): {better-bibtex} +null idle?: queue paused: startup

zotero(3)(+0000000): {better-bibtex} +0 scheduler: pausing

zotero(3)(�[31;40m+0001474�[0m): {better-bibtex} +1474 monkey-patching parseLibraryKeyHash

zotero(3)(+0000001): {better-bibtex} +1 monkey-patching parseLibraryKey

zotero(3)(�[31;40m+0000456�[0m): Initializing Zotero pane

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

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

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

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

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

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

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

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

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

zotero(3)(+0000000): User interface ready in 4077 ms

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

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

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

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

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

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

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

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

zotero(3)(+0000000): {better-bibtex} +0 Loading Better BibTeX: start progress meter

zotero(3)(+0000001): {better-bibtex} +0 Startup progress: waiting for Zotero locks...

zotero(3)(+0000000): {better-bibtex} +1 Startup progress: Warten auf Zotero-Datenbank...

zotero(3)(+0000005): BBT: loading ItemPane

zotero(4)(+0000048): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE libraryID=? [1]

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

zotero(3)(+0000014): Loaded items in 14ms

zotero(3)(+0000060): CollectionTree.selectWait(): selectEventsSuppressed. Not waiting to select row 1

zotero(3)(+0000044): Waiting for items to load for library 1

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

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

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

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

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

zotero(3)(+0000011): Tag selector updated

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

zotero(3)(+0000000): Loading creators for items in Meine Bibliothek

zotero(4)(+0000001): SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT JOIN itemCreators USING (itemID) WHERE libraryID=? ORDER BY itemID, orderIndex [1]

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

zotero(3)(+0000042): Loaded creators in Meine Bibliothek in 47 ms

zotero(3)(+0000000): Loading itemData for items in Meine Bibliothek

zotero(4)(+0000001): SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID) JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=? [1, 26]

zotero(4)(+0000111): SELECT itemID FROM items WHERE libraryID=? [1]

zotero(4)(+0000075): SELECT itemID, title FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments) [1]

zotero(3)(+0000030): Loaded itemData in Meine Bibliothek in 217 ms

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

zotero(4)(+0000000): SELECT itemID, note FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? [1]

zotero(4)(+0000013): SELECT itemID FROM items WHERE libraryID=? AND itemTypeID IN (?, ?) AND itemID NOT IN (SELECT itemID FROM itemNotes) [1, 26, 2]

zotero(3)(+0000005): Loaded note in Meine Bibliothek in 18 ms

zotero(3)(+0000000): Loading annotation for items in Meine Bibliothek

zotero(4)(+0000000): SELECT itemID, IA.parentItemID, IA.type, IA.authorName, IA.text, IA.comment, IA.color, IA.sortIndex, IA.isExternal FROM items JOIN itemAnnotations IA USING (itemID) WHERE libraryID=? [1]

zotero(3)(+0000006): Loaded annotation in Meine Bibliothek in 6 ms

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

zotero(4)(+0000000): SELECT itemID, IA.position, IA.pageLabel FROM items JOIN itemAnnotations IA USING (itemID) WHERE libraryID=? [1]

zotero(3)(+0000007): Loaded annotationDeferred in Meine Bibliothek in 8 ms

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

zotero(4)(+0000001): 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=1 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [1]

zotero(4)(+0000005): 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]

zotero(4)(+0000001): SELECT parentItemID, IAn.itemID, text || ' - ' || comment AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAnnotations IAn JOIN items I ON (IAn.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID, sortIndex [1]

zotero(4)(+0000009): SELECT itemID FROM items I WHERE libraryID=? [1]

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

zotero(3)(+0000000): Loading tags for items in Meine Bibliothek

zotero(4)(+0000001): SELECT itemID, name, type FROM items LEFT JOIN itemTags USING (itemID) LEFT JOIN tags USING (tagID) WHERE libraryID=? [1]

zotero(3)(+0000015): Loaded tags in Meine Bibliothek in 16 ms

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

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

zotero(3)(+0000012): Loaded collections in Meine Bibliothek in 12 ms

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

zotero(4)(+0000000): SELECT itemID, predicate, object FROM items LEFT JOIN itemRelations USING (itemID) LEFT JOIN relationPredicates USING (predicateID) WHERE libraryID=? [1]

zotero(3)(+0000012): Loaded relations in Meine Bibliothek in 11 ms

zotero(3)(+0000000): Loaded items in Meine Bibliothek in 548 ms

zotero(3)(+0000000): itemTree.changeCollectionTreeRow(): C4

zotero(3)(+0000000): Getting contents of C:\Users\xxxx\AppData\Roaming\Zotero\Zotero\Profiles\9k05n6fa.default\treePrefs.json

zotero(3)(+0000001): React CollectionTree loaded

zotero(3)(+0000001): Writing column prefs of length 2137 to file C:\Users\xxxx\AppData\Roaming\Zotero\Zotero\Profiles\9k05n6fa.default\treePrefs.json

zotero(3)(+0000020): Getting contents of C:\Users\xxxx\AppData\Roaming\Zotero\Zotero\Profiles\9k05n6fa.default\treePrefs.json

zotero(3)(+0000003): Refreshing items list for item-tree-main-default

zotero(4)(+0000007): CREATE TEMPORARY TABLE tmpSearchResults_U3fo2ztc 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 (4))) [1]

zotero(4)(+0000003): CREATE INDEX tmpSearchResults_U3fo2ztc_itemID ON tmpSearchResults_U3fo2ztc(itemID)

zotero(4)(+0000000): 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_U3fo2ztc) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_U3fo2ztc)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_U3fo2ztc))) [1]

zotero(4)(+0000003): DROP TABLE IF EXISTS tmpSearchResults_U3fo2ztc

zotero(3)(+0000010): Sorting items list by title, firstCreator, date, dateAdded ascending for 156 items

zotero(3)(+0000012): Sorted 156 items in 14 ms

zotero(3)(+0000002): Refreshed open parents in 1 ms

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

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

zotero(3)(+0000003): Tag selector updated

zotero(3)(+0000000): Updating tag selector from current view

zotero(3)(+0000001): Creating tmpSearchResults_ypk5VEz3 with 338 items

zotero(3)(+0000002): itemTree.render(). Displaying Item Tree

zotero(2)(+0000006): Storing itemTree item-tree-main-default column prefs

zotero(3)(+0000121): itemTree.render(). Displaying Item Tree

zotero(3)(+0000033): itemTree.render(). Displaying Item Tree

zotero(4)(+0000007): CREATE UNIQUE INDEX tmpSearchResults_ypk5VEz3_itemID ON tmpSearchResults_ypk5VEz3(itemID)

zotero(4)(+0000011): SELECT DISTINCT tagID || ':' || type FROM itemTags JOIN tags USING (tagID) WHERE 1 AND itemID IN (SELECT itemID FROM tmpSearchResults_ypk5VEz3) ORDER BY name COLLATE NOCASE

zotero(3)(+0000007): Sorted tags in 2 ms

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

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

zotero(3)(+0000025): Tag selector updated

zotero(4)(+0000017): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [724, 'https://ieeexplore.ieee.org/document/9729696/']

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

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

zotero(4)(+0000010): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [872, 'https://www.isca-speech.org/archive/interspeech_2020/zhang20i_interspeech.html']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [870, 'https://www.isca-speech.org/archive/interspeech_2021/zhang21f_interspeech.html']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [722, 'https://ieeexplore.ieee.org/document/9345164/']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [202, 'http://ieeexplore.ieee.org/document/403341/']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [62, '']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [886, 'https://www.sciencedirect.com/science/article/pii/S0003682X2030921X']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [467, '']

zotero(4)(+0000011): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [913, 'https://asa.scitation.org/doi/full/10.1121/1.4731227']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [30, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327018307015']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [71, 'http://www.mdpi.com/1999-4893/1/2/69']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [39, 'https://www.ingentaconnect.com/contentone/ince/incecp/1989/00001989/00000001/art00021']

zotero(4)(+0000021): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [881, '']

zotero(4)(+0000008): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [40, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327084710284']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [68, '']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [228, '']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [466, 'https://www.zotaudio.it/a2b-dsp/']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [478, 'https://www.analog.com/en/design-center/evaluation-hardware-and-software/software/a2b-software.html']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [195, 'https://linkinghub.elsevier.com/retrieve/pii/0022460X88903434']

zotero(4)(+0000019): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [197, 'https://linkinghub.elsevier.com/retrieve/pii/S0022460X85704828']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [48, 'https://www.ingentaconnect.com/content/ince/ncej/1994/00000042/00000004/art00002']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [46, 'https://www.sae.org/content/911046/']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [964, '']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [915, 'https://doi.org/10.1260/0263-0923.34.3.233']

zotero(4)(+0000024): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [870, 'https://www.isca-speech.org/archive/interspeech_2021/zhang21f_interspeech.html']

zotero(4)(+0000016): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [722, 'https://ieeexplore.ieee.org/document/9345164/']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [202, 'http://ieeexplore.ieee.org/document/403341/']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [62, '']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [886, 'https://www.sciencedirect.com/science/article/pii/S0003682X2030921X']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [467, '']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [913, 'https://asa.scitation.org/doi/full/10.1121/1.4731227']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [30, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327018307015']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [71, 'http://www.mdpi.com/1999-4893/1/2/69']

zotero(3)(+0000000): WebSocket connection opened

zotero(4)(+0000014): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [881, '']

zotero(3)(+0000003): WebSocket message: {"event":"connected","retry":10000}

zotero(3)(+0000009): WebSocket message send: {"action":"createSubscriptions","subscriptions":[{"apiKey":"********"},{"topics":["styles","translators"]}]}

zotero(4)(+0000014): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [40, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327084710284']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [68, '']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [228, '']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [466, 'https://www.zotaudio.it/a2b-dsp/']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [478, 'https://www.analog.com/en/design-center/evaluation-hardware-and-software/software/a2b-software.html']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [195, 'https://linkinghub.elsevier.com/retrieve/pii/0022460X88903434']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [197, 'https://linkinghub.elsevier.com/retrieve/pii/S0022460X85704828']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [48, 'https://www.ingentaconnect.com/content/ince/ncej/1994/00000042/00000004/art00002']

zotero(4)(+0000007): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [46, 'https://www.sae.org/content/911046/']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [964, '']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [915, 'https://doi.org/10.1260/0263-0923.34.3.233']

zotero(4)(+0000041): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [62, '']

zotero(4)(+0000014): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [886, 'https://www.sciencedirect.com/science/article/pii/S0003682X2030921X']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [467, '']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [913, 'https://asa.scitation.org/doi/full/10.1121/1.4731227']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [30, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327018307015']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [71, 'http://www.mdpi.com/1999-4893/1/2/69']

zotero(4)(+0000007): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [881, '']

zotero(4)(+0000012): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [40, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327084710284']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [68, '']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [228, '']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [466, 'https://www.zotaudio.it/a2b-dsp/']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [478, 'https://www.analog.com/en/design-center/evaluation-hardware-and-software/software/a2b-software.html']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [195, 'https://linkinghub.elsevier.com/retrieve/pii/0022460X88903434']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [197, 'https://linkinghub.elsevier.com/retrieve/pii/S0022460X85704828']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [48, 'https://www.ingentaconnect.com/content/ince/ncej/1994/00000042/00000004/art00002']

zotero(4)(+0000023): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [46, 'https://www.sae.org/content/911046/']

zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [964, '']

zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [915, 'https://doi.org/10.1260/0263-0923.34.3.233']

zotero(3)(+0000108): WebSocket message: {"event":"subscriptionsCreated","subscriptions":[{"apiKey":"********","topics":["/users/1234567","/users/1234567/publications"]},{"topics":["styles","translators"]}],"errors":[]}

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

zotero(3)(+0000006): Notifier.trigger('start', 'sync', []) called [observers: 2]

zotero(4)(+0000005): Beginning DB transaction qDey8k8A

zotero(4)(+0000033): Committed DB transaction qDey8k8A

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

zotero(4)(+0000005): CREATE TEMPORARY TABLE tagDelete AS SELECT tagID FROM tags WHERE tagID NOT IN (SELECT tagID FROM itemTags)

zotero(4)(+0000002): CREATE INDEX tagDelete_tagID ON tagDelete(tagID)

zotero(4)(+0000003): SELECT tagID AS id, name FROM tagDelete JOIN tags USING (tagID)

zotero(4)(+0000014): DROP TABLE tagDelete

zotero(4)(+0000019): Committed DB transaction aIvwPoTL

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

zotero(4)(+0000034): Committed DB transaction ILqYPPr3

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

zotero(3)(+0000001): [ConcurrentCaller] Running function (0/4 running, 0 queued)

zotero(3)(+0000001): HTTP GET https://api.zotero.org/keys/current

zotero(3)(�[31;40m+0000364�[0m): HTTP GET https://api.zotero.org/keys/current succeeded with 200

zotero(3)(+0000001): [ConcurrentCaller] Done with function (0/4 running, 0 queued)

zotero(3)(+0000001): {
"userID": 1234567
"username": "xxxx"
"displayName": ""
"access": {
"user": {
"library": true
"files": true
"notes": true
"write": true
}
"groups": {
"all": {
"library": true
"write": true
}
}
}
}

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

zotero(3)(+0000001): [ConcurrentCaller] All tasks are done

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

zotero(3)(+0000002): [ConcurrentCaller] Running function (0/4 running, 0 queued)

zotero(3)(+0000001): HTTP GET https://api.zotero.org/users/1234567/groups?format=versions

zotero(3)(+0000125): HTTP GET https://api.zotero.org/users/1234567/groups?format=versions succeeded with 200

zotero(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued)

zotero(3)(+0000001): Local groups:

zotero(3)(+0000000): []

zotero(3)(+0000000): Final libraries to sync:

zotero(3)(+0000000): [
"0": 1
]

zotero(3)(+0000001): Starting data sync for Meine Bibliothek

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

zotero(3)(+0000000): [ConcurrentCaller] All tasks are done

zotero(3)(+0000000): No settings to upload in Meine Bibliothek

zotero(4)(+0000001): SELECT O.collectionID FROM collections O WHERE libraryID=? AND synced=0 [1]

zotero(4)(+0000000): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'collection']

zotero(3)(+0000001): No collections to upload in Meine Bibliothek

zotero(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 1]

zotero(3)(+0000000): No collection deletions to upload in Meine Bibliothek

zotero(4)(+0000001): SELECT O.savedSearchID FROM savedSearches O WHERE libraryID=? AND synced=0 [1]

zotero(4)(+0000000): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'search']

zotero(3)(+0000000): No searches to upload in Meine Bibliothek

zotero(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 4]

zotero(3)(+0000001): No search deletions to upload in Meine Bibliothek

zotero(4)(+0000000): SELECT O.itemID FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) WHERE libraryID=? AND synced=0 AND (IAn.isExternal IS NULL OR IAN.isExternal=0) [1]

zotero(4)(+0000001): SELECT key FROM syncQueue WHERE libraryID=? AND syncObjectTypeID IN (SELECT syncObjectTypeID FROM syncObjectTypes WHERE name=?) [1, 'item']

zotero(3)(+0000000): No items to upload in Meine Bibliothek

zotero(4)(+0000000): SELECT key FROM syncDeleteLog WHERE libraryID=? AND syncObjectTypeID=? [1, 3]

zotero(3)(+0000000): No item deletions to upload in Meine Bibliothek

zotero(4)(+0000000): Upload result is 2

zotero(3)(+0000002): [ConcurrentCaller] Running function (0/4 running, 0 queued)

zotero(3)(+0000000): HTTP GET https://api.zotero.org/users/1234567/settings?since=1989

zotero(3)(+0000128): HTTP GET https://api.zotero.org/users/1234567/settings?since=1989 succeeded with 304

zotero(3)(+0000000): [ConcurrentCaller] Done with function (0/4 running, 0 queued)

zotero(4)(+0000001): SELECT key, lastCheck, tries FROM syncQueue WHERE libraryID=? [1]

zotero(3)(+0000000): [ConcurrentCaller] All tasks are done

zotero(3)(+0000001): Library 1 hasn't been modified -- skipping further object downloads

zotero(4)(+0000000): Download result is 3

zotero(4)(+0000001): Updating database with new library data

zotero(4)(+0000000): Beginning DB transaction FOegYRjA

zotero(4)(+0000001): UPDATE libraries SET lastSync=? WHERE libraryID=? [1652261139, 1]

zotero(4)(+0000005): Committed DB transaction FOegYRjA

zotero(3)(+0000001): Done syncing Meine Bibliothek

zotero(4)(+0000000): REPLACE INTO version (schema, version) VALUES ('lastsync', ?) [1652261140]

zotero(3)(+0000005): Starting file syncing

zotero(3)(+0000001): Starting file sync for Meine Bibliothek

zotero(3)(+0000000): Caching WebDAV credentials

zotero(3)(+0000000): Getting WebDAV password

zotero(3)(+0000002): CookieBlocker: Registering observers

zotero(3)(+0000000): CookieBlocker: Adding https://xxxx:********@cloud.xxxx.com/remote.php/dav/files/xxxxx/zotero/ to blocklist

zotero(3)(+0000001): HTTP OPTIONS https://xxxx:********@cloud.xxxx.com/remote.php/dav/files/xxxxx/zotero/

zotero(3)(+0000000): CookieBlocker: Ignoring cookies for https://xxxx:********@cloud.xxxx.com/remote.php/dav/files/xxxxx/zotero/

zotero(3)(+0000224): Updating bundled files

zotero(3)(+0000000): Initializing translators

zotero(4)(+0000000): SELECT rowid, fileName, metadataJSON, lastModifiedTime FROM translatorCache

zotero(3)(+0000166): CookieBlocker: Ignoring cookies for https://xxxx:********@cloud.xxxx.com/remote.php/dav/files/xxxxx/zotero/

zotero(3)(+0000054): Cached 686 translators in 220 ms

zotero(3)(+0000002): HTTP GET resource://zotero/schema/repotime.txt

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

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

zotero(3)(+0000000): Getting contents of input stream

zotero(4)(+0000001): SELECT version FROM version WHERE schema=? ['translators']

zotero(3)(+0000001): Installed translators are up-to-date with XPI

zotero(3)(+0000001): Initializing styles

zotero(3)(+0000002): Getting contents of C:\Users\xxxx\Zotero\styles\american-chemical-society.csl

zotero(3)(+0000003): Getting contents of C:\Users\xxxx\Zotero\styles\american-medical-association.csl

zotero(3)(+0000003): Getting contents of C:\Users\xxxx\Zotero\styles\american-political-science-association.csl

zotero(3)(+0000002): Getting contents of C:\Users\xxxx\Zotero\styles\american-sociological-association.csl

zotero(3)(+0000003): Getting contents of C:\Users\xxxx\Zotero\styles\apa.csl

zotero(3)(+0000005): Getting contents of C:\Users\xxxx\Zotero\styles\chicago-author-date.csl

zotero(3)(+0000003): Getting contents of C:\Users\xxxx\Zotero\styles\chicago-fullnote-bibliography.csl

zotero(3)(+0000005): Getting contents of C:\Users\xxxx\Zotero\styles\chicago-note-bibliography.csl

zotero(3)(+0000007): Getting contents of C:\Users\xxxx\Zotero\styles\elsevier-harvard.csl

zotero(3)(+0000002): Getting contents of C:\Users\xxxx\Zotero\styles\harvard-cite-them-right.csl

zotero(3)(+0000003): Getting contents of C:\Users\xxxx\Zotero\styles\ieee.csl

zotero(3)(+0000003): Getting contents of C:\Users\xxxx\Zotero\styles\modern-humanities-research-association.csl

zotero(3)(+0000007): Getting contents of C:\Users\xxxx\Zotero\styles\modern-language-association.csl

zotero(3)(+0000002): Getting contents of C:\Users\xxxx\Zotero\styles\nature.csl

zotero(3)(+0000001): Getting contents of C:\Users\xxxx\Zotero\styles\vancouver.csl

zotero(3)(+0000004): Cached 15 styles in 55 ms

zotero(3)(+0000000): HTTP GET chrome://zotero/content/locale/csl/locales.json

zotero(3)(+0000001): HTTP GET chrome://zotero/content/locale/csl/locales.json succeeded with 200

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

zotero(3)(+0000002): HTTP GET resource://zotero/schema/renamed-styles.json succeeded with 200

zotero(3)(+0000027): HTTP GET resource://zotero/schema/repotime.txt

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

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

zotero(3)(+0000000): Getting contents of input stream

zotero(4)(+0000001): SELECT version FROM version WHERE schema=? ['styles']

zotero(3)(+0000001): Installed styles are up-to-date with XPI

zotero(3)(+0000002): HTTP GET https://api.zotero.org/retractions/list

zotero(3)(+0000107): HTTP GET https://api.zotero.org/retractions/list succeeded with 304

zotero(3)(+0000000): Retraction list is up to date

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

zotero(3)(+0000001): Checking repository for translator and style updates

zotero(3)(+0000001): HTTP POST "styles=%5B%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-chemical-society%22%2C%22updated%22%3A1651707865%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-chemical-society%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-medical-association%22%2C%22updated%22%3A1647701879%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-medical-association%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-political-science-association%22%2C%22updated%22%3A1448384762%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-political-science-association%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-sociological-association%22%2C%22updated%22%3A1652046536%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-sociological-association%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fapa%22%2C%22updated%22%3A1643640236%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fap…" (2966 chars) to https://repo.zotero.org/repo/updated?last=1652261049&version=6.0.6&m=3

zotero(3)(+0000088): HTTP OPTIONS https://xxxx:********@cloud.xxxx.com/remote.php/dav/files/xxxxx/zotero/ succeeded with 200

zotero(3)(+0000000): WebDAV credentials cached

zotero(3)(+0000001): Zotero.Libraries.getName() is deprecated. Use Zotero.Library.prototype.name instead

zotero(3)(+0000000): Checking for locally changed attachment files in Meine Bibliothek

zotero(4)(+0000000): SELECT itemID, linkMode, path, storageModTime, storageHash, syncState FROM itemAttachments JOIN items USING (itemID) WHERE linkMode IN (?,?) AND syncState IN (?,?) AND libraryID=? [0, 1, 0, 2, 1]

zotero(4)(+0000010): Checking attachment file for item 1/25EMQND5

zotero(3)(+0000002): Mod time for 1/25EMQND5 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/2ECXQ9MY

zotero(3)(+0000002): Mod time for 1/2ECXQ9MY matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/2JF72KT5

zotero(3)(+0000002): Mod time for 1/2JF72KT5 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/2NSIEJNW

zotero(3)(+0000004): Mod time for 1/2NSIEJNW matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/2VE8QYZK

zotero(3)(+0000003): Mod time for 1/2VE8QYZK matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/343NIPT2

zotero(3)(+0000002): Mod time for 1/343NIPT2 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/393ESDEL

zotero(3)(+0000002): Mod time for 1/393ESDEL matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/3AVB9DR9

zotero(3)(+0000002): Mod time for 1/3AVB9DR9 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/3KYWTBJB

zotero(3)(+0000002): Mod time for 1/3KYWTBJB matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/3PY9S6ZG

zotero(3)(+0000007): Mod time for 1/3PY9S6ZG matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/3VDRWP5W

zotero(3)(+0000003): Mod time for 1/3VDRWP5W matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/44HYJRXW

zotero(3)(+0000002): Mod time for 1/44HYJRXW matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/44WB9YX2

zotero(3)(+0000002): Mod time for 1/44WB9YX2 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/45VEWX66

zotero(3)(+0000004): Mod time for 1/45VEWX66 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/46R8YVWF

zotero(3)(+0000003): Mod time for 1/46R8YVWF matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/4743HYQA

zotero(3)(+0000002): Mod time for 1/4743HYQA matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/47RDGJWR

zotero(3)(+0000001): Mod time for 1/47RDGJWR matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/48YG2STZ

zotero(3)(+0000001): Mod time for 1/48YG2STZ matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/49TQBDPJ

zotero(3)(+0000001): Mod time for 1/49TQBDPJ matches remote file -- skipping

zotero(3)(+0000001): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/4DKWFSBH

zotero(3)(+0000001): Mod time for 1/4DKWFSBH matches remote file -- skipping

zotero(3)(+0000001): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/4H55QNUV

zotero(3)(+0000003): Mod time for 1/4H55QNUV matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/4IMAN5UK

zotero(3)(+0000002): Mod time for 1/4IMAN5UK matches remote file -- skipping

zotero(3)(+0000001): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/4JY5DSID

zotero(3)(+0000002): Mod time for 1/4JY5DSID matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/4NKS7EHZ

zotero(3)(+0000002): Mod time for 1/4NKS7EHZ matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/4QMFPJB2

zotero(3)(+0000002): Mod time for 1/4QMFPJB2 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/4YJPLCR7

zotero(3)(+0000002): Mod time for 1/4YJPLCR7 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/4YVAMW3B

zotero(3)(+0000002): Mod time for 1/4YVAMW3B matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/58IFVJK4

zotero(3)(+0000007): Mod time for 1/58IFVJK4 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/597LF85I

zotero(3)(+0000001): Mod time for 1/597LF85I matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/5II4PSBS

zotero(3)(+0000001): Mod time for 1/5II4PSBS matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/5MZ9SZH6

zotero(3)(+0000001): Mod time for 1/5MZ9SZH6 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/5XUD9CZK

zotero(3)(+0000002): Mod time for 1/5XUD9CZK matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/5ZN9SZMS

zotero(3)(+0000003): Mod time for 1/5ZN9SZMS matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/67TLRZKR

zotero(3)(+0000004): Mod time for 1/67TLRZKR matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/6FHT8ZSR

zotero(3)(+0000002): Mod time for 1/6FHT8ZSR matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/6FMZP6JM

zotero(3)(+0000002): Mod time for 1/6FMZP6JM matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/6YN95C7N

zotero(3)(+0000002): Mod time for 1/6YN95C7N matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/6ZFCAPX3

zotero(3)(+0000001): Mod time for 1/6ZFCAPX3 matches remote file -- skipping

zotero(3)(+0000001): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/76KIHZQ5

zotero(3)(+0000001): Mod time for 1/76KIHZQ5 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/76NKMMM4

zotero(3)(+0000001): Mod time for 1/76NKMMM4 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/794RPIT4

zotero(3)(+0000002): Mod time for 1/794RPIT4 matches remote file -- skipping

zotero(3)(+0000001): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/7EIVZMHF

zotero(3)(+0000002): Mod time for 1/7EIVZMHF matches remote file -- skipping

zotero(3)(+0000001): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/7HKCXFVX

zotero(3)(+0000002): Mod time for 1/7HKCXFVX matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/7QBG36B2

zotero(3)(+0000001): Mod time for 1/7QBG36B2 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/7QFVIUAW

zotero(3)(+0000001): Mod time for 1/7QFVIUAW matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/7UXXCUCY

zotero(3)(+0000002): Mod time for 1/7UXXCUCY matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/84BLA3IL

zotero(3)(+0000002): Mod time for 1/84BLA3IL matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/85JUPZWE

zotero(3)(+0000010): Mod time for 1/85JUPZWE matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/8727FBSL

zotero(3)(+0000003): Mod time for 1/8727FBSL matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/8DZDWQFS

zotero(3)(+0000002): Mod time for 1/8DZDWQFS matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/8FQ4NLHR

zotero(3)(+0000001): Mod time for 1/8FQ4NLHR matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/8H9A23JE

zotero(3)(+0000002): Mod time for 1/8H9A23JE matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/8MHJWFP8

zotero(3)(+0000003): Mod time for 1/8MHJWFP8 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/9569FW28

zotero(3)(+0000002): Mod time for 1/9569FW28 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/9695GA3L

zotero(3)(+0000001): Mod time for 1/9695GA3L matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/96Y8JE5Z

zotero(3)(+0000002): Mod time for 1/96Y8JE5Z matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/9BX5S8EB

zotero(3)(+0000002): Mod time for 1/9BX5S8EB matches remote file -- skipping

zotero(3)(+0000001): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/9E8UC7B6

zotero(3)(+0000002): Mod time for 1/9E8UC7B6 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/9FDQZILW

zotero(3)(+0000003): Mod time for 1/9FDQZILW matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/9HJ82KHY

zotero(3)(+0000003): Mod time for 1/9HJ82KHY matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/9KJ3TRXK

zotero(3)(+0000002): Mod time for 1/9KJ3TRXK matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/9KJDZQ2Q

zotero(3)(+0000001): Mod time for 1/9KJDZQ2Q matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/9KW76HSD

zotero(3)(+0000002): Mod time for 1/9KW76HSD matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/9MLE28N9

zotero(3)(+0000001): Mod time for 1/9MLE28N9 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/9YBXCX7W

zotero(3)(+0000001): Mod time for 1/9YBXCX7W matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/9ZK8WQZU

zotero(3)(+0000008): Mod time for 1/9ZK8WQZU matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/9ZXE5C39

zotero(3)(+0000002): Mod time for 1/9ZXE5C39 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/A3YFA7PR

zotero(3)(+0000001): Mod time for 1/A3YFA7PR matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/A8SW8L6K

zotero(3)(+0000001): Mod time for 1/A8SW8L6K matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/A9BDNHSQ

zotero(3)(+0000002): Mod time for 1/A9BDNHSQ matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/AAGSGRE2

zotero(3)(+0000002): Mod time for 1/AAGSGRE2 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/ADPU6MP4

zotero(3)(+0000003): Mod time for 1/ADPU6MP4 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/AE2DCBRR

zotero(3)(+0000003): Mod time for 1/AE2DCBRR matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/AE4M9S74

zotero(3)(+0000002): Mod time for 1/AE4M9S74 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/AK2EDJYW

zotero(3)(+0000001): Mod time for 1/AK2EDJYW matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/ATAHR3G5

zotero(3)(+0000002): Mod time for 1/ATAHR3G5 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/AUTDVFE2

zotero(3)(+0000042): Mod time for 1/AUTDVFE2 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/AXEJPUC3

zotero(3)(+0000003): Mod time for 1/AXEJPUC3 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/B7I3WTBG

zotero(3)(+0000003): Mod time for 1/B7I3WTBG matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/B7S76VY8

zotero(3)(+0000002): Mod time for 1/B7S76VY8 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/BC5SXUW4

zotero(3)(+0000001): Mod time for 1/BC5SXUW4 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/BFSRM25S

zotero(3)(+0000001): Mod time for 1/BFSRM25S matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/BN57H7Q3

zotero(3)(+0000001): Mod time for 1/BN57H7Q3 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/BN6TX2XZ

zotero(3)(+0000003): Mod time for 1/BN6TX2XZ matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/BS2YYSAZ

zotero(3)(+0000003): Mod time for 1/BS2YYSAZ matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/BUD6EALM

zotero(3)(+0000003): Mod time for 1/BUD6EALM matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/BWQ9B8VT

zotero(3)(+0000002): Mod time for 1/BWQ9B8VT matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/BZQGUUWD

zotero(3)(+0000002): Mod time for 1/BZQGUUWD matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/BZVEICPL

zotero(3)(+0000002): Mod time for 1/BZVEICPL matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/C7VKC7P4

zotero(3)(+0000007): Mod time for 1/C7VKC7P4 matches remote file -- skipping

zotero(3)(+0000001): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/C8NAZJ2Y

zotero(3)(+0000001): Mod time for 1/C8NAZJ2Y matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/CG4I9237

zotero(3)(+0000001): Mod time for 1/CG4I9237 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/CQH7VKDC

zotero(3)(+0000002): Mod time for 1/CQH7VKDC matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/CXXE6RCM

zotero(3)(+0000001): Mod time for 1/CXXE6RCM matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/CYMVIZJ7

zotero(3)(+0000001): Mod time for 1/CYMVIZJ7 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/CZHAVFLA

zotero(3)(+0000007): Mod time for 1/CZHAVFLA matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/D3PWWNRJ

zotero(3)(+0000001): Mod time for 1/D3PWWNRJ matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/D6Q9VCJ9

zotero(3)(+0000001): Mod time for 1/D6Q9VCJ9 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/D9I6MQAV

zotero(3)(+0000002): Mod time for 1/D9I6MQAV matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/DC988RXS

zotero(3)(+0000001): Mod time for 1/DC988RXS matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/DFKTWVLS

zotero(3)(+0000002): HTTP POST https://repo.zotero.org/repo/updated?last=1652261049&version=6.0.6&m=3 succeeded with 200

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

zotero(4)(+0000001): REPLACE INTO version (schema,version) VALUES (?,?) ['repository', 1652261141]

zotero(3)(+0000001): Mod time for 1/DFKTWVLS matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000001): Checking attachment file for item 1/DH9UPM73

zotero(4)(+0000000): REPLACE INTO version (schema,version) VALUES (?,?) ['lastcheck', 1652261141]

zotero(3)(+0000003): Mod time for 1/DH9UPM73 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/DKAYP5RL

zotero(3)(+0000002): Mod time for 1/DKAYP5RL matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/DN6CXVU7

zotero(3)(+0000002): Mod time for 1/DN6CXVU7 matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/DTISRS2I

zotero(3)(+0000002): Mod time for 1/DTISRS2I matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/ECB34Y4V

zotero(3)(+0000002): Mod time for 1/ECB34Y4V matches remote file -- skipping

zotero(3)(+0000000): File has not changed

zotero(4)(+0000000): Checking attachment file for item 1/EEHRRW2R

zotero(4)(+0000002): Committed DB transaction epl24rXy

zotero(3)(+0000000): All translators and styles are up-to-date

zotero(3)(+0000000): Initializing DB backup idle observer

zotero(4)(+0000003): Beginning DB transaction MG2Stjpp

github-actions · 2022-05-11T12:51:44Z

🤖 this is your friendly neighborhood build bot announcing test build 6.7.1.2579 ("itempane logging")

Install in Zotero by downloading test build 6.7.1.2579, opening the Zotero "Tools" menu, selecting "Add-ons", open the gear menu in the top right, and select "Install Add-on From File...".

retorquere · 2022-05-11T12:52:46Z

BBT seems to be dormant in the last log you posted. Can you get me a new log from 2579?

retorquere · 2022-05-11T12:53:36Z

(you can also attach the log as a .txt file, which makes it easier to search for me)

fholzm · 2022-05-11T13:13:45Z

Here you go: zotero-log-202205111510.txt

It's also strange, that the BBT initialization windows is stuck in front of all other windows:

retorquere · 2022-05-12T22:09:33Z

I couldn't cause that if I wanted to. I give Zotero a title and a body and Zotero does the rest. the new log shows BBT waiting for Zotero's go-ahead, so it's not actually doing anything yet.

retorquere · 2022-05-30T22:15:18Z

I have an idea on a fix, but I'm still waiting for feedback from Zotero.

github-actions · 2022-05-31T07:36:31Z

🤖 this is your friendly neighborhood build bot announcing test build 6.7.1.2681 ("Merge branch 'master' into gh-2104")

Install in Zotero by downloading test build 6.7.1.2681, opening the Zotero "Tools" menu, selecting "Add-ons", open the gear menu in the top right, and select "Install Add-on From File...".

fholzm · 2022-06-03T10:02:12Z

Still the same issue, the log is attached

zotero-debug.txt

retorquere · 2022-06-03T10:11:26Z

Still the same point, BBT is waiting for Zotero to give the go-ahead. I'm still waiting for feedback from the Zotero devs but it's uncharacteristically quiet there. I can't really move forward without that information.

github-actions bot added the needs-support-log label Apr 11, 2022

Repository owner deleted a comment from github-actions bot Apr 11, 2022

retorquere removed the needs-support-log label Apr 11, 2022

github-actions bot added the awaiting-user-feedback label Apr 11, 2022

github-actions bot removed the awaiting-user-feedback label Apr 11, 2022

github-actions bot added the awaiting-user-feedback label Apr 12, 2022

github-actions bot removed the awaiting-user-feedback label Apr 12, 2022

github-actions bot added the awaiting-user-feedback label Apr 16, 2022

github-actions bot removed the awaiting-user-feedback label May 2, 2022

github-actions bot added the awaiting-user-feedback label May 2, 2022

retorquere added a commit that referenced this issue May 4, 2022

Merge branch 'master' into gh-2104

ac8ec91

retorquere removed the awaiting-user-feedback label May 4, 2022

retorquere added a commit that referenced this issue May 10, 2022

Merge branch 'master' into gh-2104

8930ac4

retorquere added a commit that referenced this issue May 10, 2022

Merge branch 'master' into gh-2104

5cda7e3

github-actions bot added the awaiting-user-feedback label May 11, 2022

github-actions bot removed the awaiting-user-feedback label May 11, 2022

github-actions bot added the awaiting-user-feedback label May 11, 2022

github-actions bot removed the awaiting-user-feedback label May 11, 2022

retorquere added a commit that referenced this issue May 11, 2022

Merge branch 'master' into gh-2104

d822d36

github-actions bot added the awaiting-user-feedback label May 11, 2022

github-actions bot removed the awaiting-user-feedback label May 11, 2022

github-actions bot added the awaiting-user-feedback label May 12, 2022

retorquere added a commit that referenced this issue May 30, 2022

Merge branch 'master' into gh-2104

93ff13e

retorquere added a commit that referenced this issue May 31, 2022

Merge branch 'master' into gh-2104

7310391

retorquere added a commit that referenced this issue May 31, 2022

Merge branch 'master' into gh-2104

33c8771

github-actions bot removed the awaiting-user-feedback label Jun 3, 2022

github-actions bot added the awaiting-user-feedback label Jun 3, 2022

retorquere mentioned this issue Mar 15, 2024

Zotero is not responding #2783

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

BBT prevents start of zotero #2104

BBT prevents start of zotero #2104

fholzm commented Apr 11, 2022 •

edited

retorquere commented Apr 11, 2022

fholzm commented Apr 11, 2022

qqobb commented Apr 11, 2022

fholzm commented Apr 12, 2022

retorquere commented Apr 12, 2022

fholzm commented Apr 12, 2022

retorquere commented Apr 16, 2022

github-actions bot commented Apr 16, 2022

fholzm commented May 2, 2022

retorquere commented May 2, 2022

github-actions bot commented May 4, 2022

fholzm commented May 4, 2022

github-actions bot commented May 10, 2022

retorquere commented May 11, 2022

fholzm commented May 11, 2022

retorquere commented May 11, 2022

fholzm commented May 11, 2022

github-actions bot commented May 11, 2022

retorquere commented May 11, 2022

retorquere commented May 11, 2022

fholzm commented May 11, 2022

retorquere commented May 12, 2022

retorquere commented May 30, 2022

github-actions bot commented May 31, 2022

fholzm commented Jun 3, 2022

retorquere commented Jun 3, 2022

BBT prevents start of zotero #2104

BBT prevents start of zotero #2104

Comments

fholzm commented Apr 11, 2022 • edited

retorquere commented Apr 11, 2022

fholzm commented Apr 11, 2022

qqobb commented Apr 11, 2022

fholzm commented Apr 12, 2022

retorquere commented Apr 12, 2022

fholzm commented Apr 12, 2022

retorquere commented Apr 16, 2022

github-actions bot commented Apr 16, 2022

fholzm commented May 2, 2022

retorquere commented May 2, 2022

github-actions bot commented May 4, 2022

fholzm commented May 4, 2022

github-actions bot commented May 10, 2022

retorquere commented May 11, 2022

fholzm commented May 11, 2022

retorquere commented May 11, 2022

fholzm commented May 11, 2022

github-actions bot commented May 11, 2022

retorquere commented May 11, 2022

retorquere commented May 11, 2022

fholzm commented May 11, 2022

retorquere commented May 12, 2022

retorquere commented May 30, 2022

github-actions bot commented May 31, 2022

fholzm commented Jun 3, 2022

retorquere commented Jun 3, 2022

fholzm commented Apr 11, 2022 •

edited