Conversion not performed

aladinoster commented 3 years ago

Describe the bug

It seems extraction is undone, see gif

After checking the destination folder, there are no new files.

To Reproduce Steps to reproduce the behavior:

Go to 'selected notes'
Right Click on 'item'
Scroll down to 'Mdnotes → Export to markdown'

Expected behavior I expected the markdown file to be created in the Zotero item or the destination folder

Screenshots

Desktop (please complete the following information):

OS: MacOS Big Sur
Zotero version: [v5.0.96.1]
Mdnotes version: [v0.1.3]
Zotfile version: [v5.0.16]
BetterBibtex version: [v5.2.138]

Additional context No

padasch commented 3 years ago

I have this issue as well and have the same desktop specs as you stated. Additionally, when I select another export option, the file is created but the field {{notesContent}} is not exported.

celtickuma commented 3 years ago

Same: Description, To Reproduce, Expected Behavior. Desktop: OS: MacOS Catalina 10.15.7 Zotero version: [v5.0.96.1] Mdnotes version: [v0.1.3] Zotfile version: [v5.0.16] BetterBibtex version: [v5.2.138]

When I select Create Full Export Note, the file is created but the field {{notesContent}} is not exported. The file is empty.

argenos commented 3 years ago

@celtickuma @aladinoster @padasch Could you please add screenshots of your mdnotes settings? @padasch are you also on Mac?

celtickuma commented 3 years ago

Sorry. I already killed it, but I had tried all the options in preferences, with no change in behavior. Reverting to v.0.1.2 resolved all issues. Normal export with all right click menu options available. If you want I can go back to .3 and reproduce.

padasch commented 3 years ago

Thanks for the swift reply! Here are the settings and specs:

OS: MacOS Big Sur 11.2.3 Zotero: 5.0.96.1 Mdnotes: 0.1.3 Zotfile: 5.0.16 BetterBibtex: 5.2.138

mdnotes_settings1 mdnotes_settings2

argenos commented 3 years ago

@padasch alright, most things look alright. I assume you edited the image to hide your vault folder, could you maybe describe where that folder lives? Are both your Export directory and template directory the same? Double check that it's not malformed. Another thing, any modifications in the hidden preferences?

argenos commented 3 years ago

I added a few debug messages to this build: mdnotes-0.1.3-fx.zip. To instal it you need to change the extension from zip to xpi.

After installing this version, could you go to Help > Debug output logging > Enable. Try exporting to markdown once again. After that, Help > Debug output logging > View output > File >Save. It should generate an HTML file that you can upload it to this issue by dragging and dropping it here.

aladinoster commented 3 years ago

@argenos, thanks for your time spent on this issue.

I have the following Md Notes configuration

And the following log after installing the last version of the plugin, the one on the this thread:

version => 5.0.96.1, platform => MacIntel, oscpu => Intel Mac OS X 10.16, locale => en-GB, appName => Zotero, appVersion => 5.0.96.1, extensions => Zotero LibreOffice Integration (5.0.25.SA.5.0.96.1, extension), Zotero Word for Mac Integration (5.0.36.SA.5.0.96.1, extension), ZotFile (5.0.16, extension), Zotero DOI Manager (1.3.9, extension), Zotero Scholar Citations (2.0.4, extension), Zotero Memento (1.0.0, extension), Zotero MAS MetaData (0.1.6, extension), Better BibTex for Zotero (5.2.138, extension), Mdnotes for Zotero (0.1.3, extension)

(3)(+0030404): Starting full-text content processor

(3)(+0003889): Viewing item in pane 0

(3)(+0000000): Refreshing item box

(3)(+0000042): adding better-sentencecase

(3)(+0000050): Refreshing item row map

(4)(+0000508): 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 [1, 'http://arxiv.org/abs/1909.06710']

(3)(+0006172): Setting mode to 'edit'

(3)(+0000000): Refreshing attachment box

(4)(+0000002): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(4)(+0000003): SELECT synced FROM fulltextItems WHERE itemID=? [3]

(3)(+0000003): Setting mode to note

(3)(+0000003): Setting mode to note

(3)(+0000006): Reloading tags box

(3)(+0000002): Refreshing note editor

(3)(+0000001): No editor yet

(3)(+0000000): Loading resource://zotero/tinymce/note.html?locale=en-GB&dir=ltr

(4)(+0000011): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(4)(+0000018): SELECT synced FROM fulltextItems WHERE itemID=? [3]

(4)(+0000007): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(3)(+0000163): Setting content to <p xmlns="http://www.w3.org/1999/xhtml" id="title"><strong>Contents</strong></p><ul xmlns="http://www.w3.org/1999/xhtml" style="list-style-type: none; padding-left:0px" id="toc"><li><a href="zotero://open-pdf/0_9LZG2ZR8/1">I Introduction</a></li><li style="padding-top:8px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">II Related Work</a><ul style="list-style-type: none; padding-left:12px"><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">II-A Behaviour Cloning</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">II-B Reinforcement Learning</a></li></ul></li><li style="padding-top:8px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">III Approach</a><ul style="list-style-type: none; padding-left:12px"><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">III-A Benchmark for Driving in Dense Traffic</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/3">III-B Vehicle Model</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/3">III-C Network Architecture and Policy Parameterisation</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">III-D Ego-vehicle Observations</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">III-E Reward Function</a></li></ul></li><li style="padding-top:8px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">IV Experimental Results</a><ul style="list-style-type: none; padding-left:12px"><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">IV-A Baselines</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/5">IV-B Evaluation Metrics</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/5">IV-C Quantitative Results</a></li></ul></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/5">V Conclusion</a></li></ul>

(4)(+0000444): SELECT synced FROM fulltextItems WHERE itemID=? [3]

(4)(+0000001): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(3)(+0000011): MIME type application/pdf cannot be handled internally

(4)(+0012178): 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 [1, 'http://arxiv.org/abs/1909.06710']

argenos commented 3 years ago

@aladinoster I unfortunately do not see any mdnotes output there. Could you try exporting to markdown once the debug mode is enabled?

aladinoster commented 3 years ago

@argenos I have this log when restarting with debug mode enabled.

Log:


version => 5.0.96.1, platform => MacIntel, oscpu => Intel Mac OS X 10.16, locale => en-GB, appName => Zotero, appVersion => 5.0.96.1, extensions => Zotero LibreOffice Integration (5.0.25.SA.5.0.96.1, extension), Zotero Word for Mac Integration (5.0.36.SA.5.0.96.1, extension), ZotFile (5.0.16, extension), Zotero DOI Manager (1.3.9, extension), Zotero Scholar Citations (2.0.4, extension), Zotero Memento (1.0.0, extension), Zotero MAS MetaData (0.1.6, extension), Better BibTex for Zotero (5.2.138, extension), Mdnotes for Zotero (0.1.3, extension)

(3)(+0000000): Using data directory /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero

(3)(+0000006): IPC: Initializing pipe at /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/pipes/1616766637873

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

(3)(+0000000): /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/zotero.sqlite

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

(4)(+0000003): PRAGMA page_size

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

(4)(+0000001): PRAGMA foreign_keys=true

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

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

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

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

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

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

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

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

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

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

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

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

(4)(+0000002): Beginning DB transaction E2CchVLG

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

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

(3)(+0000001): Updating custom tables

(4)(+0000001): DELETE FROM itemTypesCombined

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

(4)(+0000001): DELETE FROM fieldsCombined WHERE fieldID NOT IN (SELECT fieldID FROM itemData)

(4)(+0000001): DELETE FROM itemTypeFieldsCombined

(4)(+0000001): DELETE FROM baseFieldMappingsCombined

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

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

(4)(+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

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

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

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

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

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

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

(3)(+0000000): Updating custom tables

(4)(+0000001): DELETE FROM itemTypesCombined

(4)(+0000000): DELETE FROM fieldsCombined WHERE fieldID NOT IN (SELECT fieldID FROM itemData)

(4)(+0000001): DELETE FROM itemTypeFieldsCombined

(4)(+0000000): DELETE FROM baseFieldMappingsCombined

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

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

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

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

(4)(+0000002): Committed DB transaction E2CchVLG

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

(4)(+0000001): Beginning DB transaction qEZNtiPt

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

(4)(+0000002): Committed DB transaction qEZNtiPt

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

(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 FROM libraries L WHERE type NOT IN (?,?) ['feed', 'group']

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

(4)(+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)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(4)(+0000002): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE typeName IN ('book', 'bookSection', 'journalArticle', 'newspaperArticle', 'document')

(4)(+0000002): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE display != 0 AND display NOT IN ('book', 'bookSection', 'journalArticle', 'newspaperArticle', 'document') AND name != 'webpage'

(4)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE display=0

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

(4)(+0000003): SELECT * FROM fieldFormats

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

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

(4)(+0000009): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined

(4)(+0000006): 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)

(4)(+0000020): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined

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

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

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

(3)(+0000001): PluginInstaller: fetching addon info

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

(4)(+0000003): SELECT DISTINCT fieldID FROM baseFieldMappingsCombined

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

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

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

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

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

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

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

(3)(+0000001): Running unlock callbacks

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

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

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

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

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

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

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

(3)(+0000001): Registering URIContentListener

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

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

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

(3)(+0000001): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/locate/engines.json

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

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

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

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

(4)(+0000006): SELECT tagID, name FROM tags

(4)(+0000003): SELECT * FROM creators

(3)(+0000002): Loading collection relations

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

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

(3)(+0000000): Loading item relations

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

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

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

(3)(+0000003): Getting contents of /Users/andresladino/Library/Application Support/Zotero/Profiles/e1lbekel.default/retractions.json

(4)(+0000028): 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)

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

(3)(+0000002): Loading synced settings for library 1

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

(3)(+0000002): Loading all collections in My Library

(3)(+0000000): Loading primaryData for collections in My Library

(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]

(3)(+0000012): Loaded primaryData in My Library in 13 ms

(3)(+0000001): Loading childCollections for collections in My Library

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

(3)(+0000001): Loaded childCollections in My Library in 1 ms

(3)(+0000000): Loading childItems for collections in My Library

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

(3)(+0000000): Loaded childItems in My Library in 1 ms

(3)(+0000001): Loading relations for collections in My Library

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

(3)(+0000001): Loaded relations in My Library in 1 ms

(3)(+0000000): Loaded collections in My Library in 18 ms

(3)(+0000001): Loading all searches in My Library

(3)(+0000000): Loading primaryData for searches in My Library

(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]

(3)(+0000001): Loaded primaryData in My Library in 1 ms

(3)(+0000000): Loading conditions for searches in My Library

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

(3)(+0000000): Loaded conditions in My Library in 1 ms

(3)(+0000000): Loaded searches in My Library in 2 ms

(3)(+0000001): Initializing Quick Copy

(3)(+0000001): Running initialization callbacks

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

(3)(+0000001): Initializing Zotero pane

(3)(+0000004): Creating collections view with id TEypVj2h

(3)(+0000001): Refreshing collections pane

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

(3)(+0000030): Rendering tag selector

(3)(+0000004): Rendering tag list

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

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

(3)(+0000000): ZoteroMacWordIntegration: Initializing integration pipes

(3)(+0000000): IPC: Initializing pipe at /Users/Shared/.zoteroIntegrationPipe_andresladino

(3)(+0000001): IPC: Initializing pipe at /Users/andresladino/Library/Containers/com.microsoft.Word/Data/.zoteroIntegrationPipe

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

(4)(+0000032): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (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) || ' and ' || (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) || ' and ' || (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 END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID IN (12,16,15,17,14,5,13)

(3)(+0000007): Loaded items in 7ms

(3)(+0000002): Creating items view with id 8aBoMi2X

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

(3)(+0000001): Loading all items in My Library

(3)(+0000000): Loading primaryData for items in My Library

(4)(+0000001): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (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) || ' and ' || (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) || ' and ' || (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 END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? [1]

(3)(+0000020): Loaded primaryData in My Library in 21 ms

(3)(+0000001): Loading creators for items in My Library

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

(3)(+0000004): Loaded creators in My Library in 4 ms

(3)(+0000000): Loading itemData for items in My Library

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

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

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

(3)(+0000004): Loaded itemData in My Library in 15 ms

(3)(+0000000): Loading note for items in My Library

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

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

(3)(+0000001): Loaded note in My Library in 8 ms

(3)(+0000000): Loading childItems for items in My Library

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

(3)(+0000001): Rendering tag selector

(3)(+0000001): Rendering tag list

(3)(+0000005): Tag selector updated

(4)(+0000001): SELECT parentItemID, N.itemID, title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemNotes N JOIN items I ON (N.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [1]

(4)(+0000001): SELECT itemID FROM items I WHERE libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments UNION SELECT itemID FROM itemNotes) [1]

(3)(+0000002): Loaded childItems in My Library in 12 ms

(3)(+0000000): Loading tags for items in My Library

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

(3)(+0000004): Loaded tags in My Library in 5 ms

(3)(+0000001): Loading collections for items in My Library

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

(3)(+0000001): Loaded collections in My Library in 1 ms

(3)(+0000000): Loading relations for items in My Library

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

(3)(+0000001): Loaded relations in My Library in 2 ms

(3)(+0000000): Loaded items in My Library in 70 ms

(3)(+0000000): Setting tree for L1 items view 8aBoMi2X

(3)(+0000002): Refreshing items list for 8aBoMi2X

(4)(+0000006): CREATE TEMPORARY TABLE tmpSearchResults_X5DL1bjv 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=?)) [1]

(4)(+0000001): CREATE INDEX tmpSearchResults_X5DL1bjv_itemID ON tmpSearchResults_X5DL1bjv(itemID)

(4)(+0000001): 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_X5DL1bjv) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_X5DL1bjv)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_X5DL1bjv))) [1]

(4)(+0000004): DROP TABLE IF EXISTS tmpSearchResults_X5DL1bjv

(3)(+0000003): Sorting items list by title, firstCreator, date, dateAdded ascending for 5 items

(3)(+0000002): Sorted 5 items in 2 ms

(3)(+0000000): Refreshed open parents in 0 ms

(3)(+0000002): Rendering tag selector

(3)(+0000002): Rendering tag list

(3)(+0000004): Tag selector updated

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

(3)(+0000001): Creating tmpSearchResults_3XcEfrde with 13 items

(3)(+0000002): Set tree for items view 8aBoMi2X in 30 ms

(3)(+0000001): User interface ready in 2483 ms

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

(4)(+0000003): CREATE UNIQUE INDEX tmpSearchResults_3XcEfrde_itemID ON tmpSearchResults_3XcEfrde(itemID)

(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 [18, '']

(4)(+0000159): 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 [1, 'http://arxiv.org/abs/1909.06710']

(4)(+0000004): 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 [8, 'http://arxiv.org/abs/1904.09503']

(4)(+0000003): 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 [20, '']

(4)(+0000003): 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 [6, '10/gfpj79']

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

(3)(+0000025): Sorted tags in 1 ms

(3)(+0000000): Rendering tag selector

(3)(+0000006): Rendering tag list

(3)(+0000017): Tag selector updated

(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 [8, 'http://arxiv.org/abs/1904.09503']

(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 [20, '']

(3)(+0001702): Viewing item in pane 0

(3)(+0000000): Refreshing item box

(3)(+0000047): adding better-sentencecase

(3)(+0000073): Refreshing item row map

(4)(+0000426): 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 [1, 'http://arxiv.org/abs/1909.06710']

(3)(+0000457): Setting mode to 'edit'

(3)(+0000000): Refreshing attachment box

(4)(+0000001): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(4)(+0000004): SELECT synced FROM fulltextItems WHERE itemID=? [3]

(3)(+0000004): Setting mode to note

(3)(+0000003): Setting mode to note

(3)(+0000008): Reloading tags box

(3)(+0000002): Refreshing note editor

(3)(+0000000): No editor yet

(3)(+0000000): Loading resource://zotero/tinymce/note.html?locale=en-GB&dir=ltr

(4)(+0000009): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

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

(4)(+0000002): Sync not enabled -- skipping auto-sync

(4)(+0000005): SELECT synced FROM fulltextItems WHERE itemID=? [3]

(4)(+0000005): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(3)(+0000221): Setting content to <p xmlns="http://www.w3.org/1999/xhtml" id="title"><strong>Contents</strong></p><ul xmlns="http://www.w3.org/1999/xhtml" style="list-style-type: none; padding-left:0px" id="toc"><li><a href="zotero://open-pdf/0_9LZG2ZR8/1">I Introduction</a></li><li style="padding-top:8px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">II Related Work</a><ul style="list-style-type: none; padding-left:12px"><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">II-A Behaviour Cloning</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">II-B Reinforcement Learning</a></li></ul></li><li style="padding-top:8px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">III Approach</a><ul style="list-style-type: none; padding-left:12px"><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">III-A Benchmark for Driving in Dense Traffic</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/3">III-B Vehicle Model</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/3">III-C Network Architecture and Policy Parameterisation</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">III-D Ego-vehicle Observations</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">III-E Reward Function</a></li></ul></li><li style="padding-top:8px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">IV Experimental Results</a><ul style="list-style-type: none; padding-left:12px"><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">IV-A Baselines</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/5">IV-B Evaluation Metrics</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/5">IV-C Quantitative Results</a></li></ul></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/5">V Conclusion</a></li></ul>

(3)(+0000179): Viewing attachment 1/9LZG2ZR8

(3)(+0000003): Opening /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/storage/9LZG2ZR8/Saxena et al_2020_Driving in Dense Traffic with Model-Free Reinforcement Learning.pdf

(3)(+0000001): Notifier.trigger('open', 'file', [3]) called [observers: 2]

(3)(+0000001): Launching /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/storage/9LZG2ZR8/Saxena et al_2020_Driving in Dense Traffic with Model-Free Reinforcement Learning.pdf with /Applications/Highlights.app

(3)(+0000003): Running /usr/bin/open '/Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/storage/9LZG2ZR8/Saxena et al_2020_Driving in Dense Traffic with Model-Free Reinforcement Learning.pdf' '-a' '/Applications/Highlights.app'

(3)(+0000225): WebSocket connection opened

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

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

(4)(+0000049): 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 [1, 'http://arxiv.org/abs/1909.06710']

(3)(+0000104): WebSocket message: {"event":"subscriptionsCreated","subscriptions":[{"topics":["styles","translators"]}],"errors":[]}

(3)(+0000203): Updating bundled files

(3)(+0000001): Initializing translators

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

(3)(+0000680): Cached 560 translators in 680 ms

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

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

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

(3)(+0000001): Getting contents of input stream

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

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

(3)(+0000001): Initializing styles

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/american-medical-association.csl

(3)(+0000004): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/modern-humanities-research-association.csl

(3)(+0000003): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/american-political-science-association.csl

(3)(+0000003): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/elsevier-harvard.csl

(3)(+0000001): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/american-chemical-society.csl

(3)(+0000003): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/ieee.csl

(3)(+0000003): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/vancouver.csl

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/nature.csl

(3)(+0000003): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/harvard-cite-them-right.csl

(3)(+0000003): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/chicago-fullnote-bibliography.csl

(3)(+0000005): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/apa.csl

(3)(+0000007): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/chicago-author-date.csl

(3)(+0000004): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/modern-language-association.csl

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/american-sociological-association.csl

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/chicago-note-bibliography.csl

(3)(+0000007): Cached 15 styles in 54 ms

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

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

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

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

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

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

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

(3)(+0000002): Getting contents of input stream

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

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

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

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

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

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

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

(3)(+0000002): HTTP POST "styles=%5B%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-medical-association%22%2C%22updated%22%3A1588472596%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%2Fmodern-humanities-research-association%22%2C%22updated%22%3A1607556470%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fmodern-humanities-research-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%2Felsevier-harvard%22%2C%22updated%22%3A1548172632%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Felsevier-harvard%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-chemical-society%22%2C%22updated%22%3A1583882370%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org…" (2966 chars) to https://repo.zotero.org/repo/updated?last=1616766620&version=5.0.96.1&m=3

(3)(+0000560): HTTP POST https://repo.zotero.org/repo/updated?last=1616766620&version=5.0.96.1&m=3 succeeded with 200

(4)(+0000001): Beginning DB transaction DTVJ43eR

(4)(+0000002): REPLACE INTO version (schema,version) VALUES (?,?) ['repository', 1616766646]

(4)(+0000005): REPLACE INTO version (schema,version) VALUES (?,?) ['lastcheck', 1616766647]

(4)(+0000007): Committed DB transaction DTVJ43eR

(3)(+0000001): All translators and styles are up-to-date

(3)(+0000001): Initializing DB backup idle observer

(4)(+0000003): Beginning DB transaction lnAFIkri

(4)(+0000006): SELECT key AS domainPath, value AS format FROM settings WHERE setting='quickCopySite'

(3)(+0000005): {better-bibtex} +null Zotero ready, let's roll!

(3)(+0000000): {better-bibtex} +1 Startup progress: Waiting for Zotero database took 7.264 s

(3)(+0000001): {better-bibtex} +1 Startup progress: Loading citation keys...

(4)(+0000004): Committed DB transaction lnAFIkri

(4)(+0000001): Beginning DB transaction WGrIS8ss

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

(4)(+0000003): CREATE INDEX tagDelete_tagID ON tagDelete(tagID)

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

(3)(+0000002): [better-bibtex] Asynchronously opening database 'better-bibtex'

(3)(+0000000): /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/better-bibtex.sqlite

(4)(+0000002): DROP TABLE tagDelete

(4)(+0000002): Committed DB transaction WGrIS8ss

(4)(+0000002): Beginning DB transaction faZc1TGN

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

(4)(+0000003): Committed DB transaction faZc1TGN

(3)(+0000000): Purged data tables in 44 ms

(4)(+0000006): PRAGMA page_size

(4)(+0000001): PRAGMA cache_size=250

(4)(+0000005): PRAGMA foreign_keys=true

(3)(+0000001): Initializing DB backup idle observer

(4)(+0000000): PRAGMA integrity_check(1)

(4)(+0000002): CREATE TABLE IF NOT EXISTS "better-bibtex" (name TEXT PRIMARY KEY NOT NULL, data TEXT NOT NULL)

(4)(+0000003): SELECT name, data FROM "better-bibtex" ORDER BY name ASC

(4)(+0000111): SELECT itemID, strftime("%s", dateModified) * 1000 AS modified FROM items WHERE itemID NOT IN (select itemID from deletedItems)

(3)(+0000119): {better-bibtex} +279 jieba enabled: false

(4)(+0000001): select itemTypeID, typeName from itemTypes

(4)(+0000003): select fieldID, fieldName from fields

(3)(+0000007): {better-bibtex} +11 Startup progress: Loading citation keys took 0.291 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Starting serialisation cache...

(3)(+0000003): {better-bibtex} +3 Startup progress: Starting serialisation cache took 0.003 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Initializing auto-export...

(3)(+0000002): {better-bibtex} +1 pathSearch: looking for git in {"path":["/usr/bin","/bin","/usr/sbin","/sbin"],"pathext":[""],"sep":"/"}

(3)(+0000003): {better-bibtex} +4 pathSearch: git found at /usr/bin/git

(3)(+0000000): {better-bibtex} +0 Startup progress: Initializing auto-export took 0.005 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Waiting for Zotero translators...

(3)(+0000001): {better-bibtex} +1 Startup progress: Waiting for Zotero translators took 0.001 s

(3)(+0000001): {better-bibtex} +0 Startup progress: 50...

(4)(+0000000): Beginning DB transaction hrnrxvu9

(4)(+0000002): SELECT items.itemID, itemDataValues.value as extra FROM items JOIN itemData on itemData.itemID = items.itemID JOIN fields on fields.fieldID = itemData.fieldID JOIN itemDataValues on itemData.valueID = itemDataValues.valueID WHERE items.itemID NOT IN (select itemID from deletedItems) AND fields.fieldName = 'extra' AND (itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ?) ['%bibtex:%', '%bibtex[%', '%bibtex*[%', '%bibtex{%', '%bibtex*{%', '%biblatexcitekey:%', '%biblatexcitekey[%', '%biblatexcitekey*[%', '%biblatexcitekey{%', '%biblatexcitekey*{%', '%biblatex:%', '%biblatex[%', '%biblatex*[%', '%biblatex{%', '%biblatex*{%', '%biblatexdata:%', '%biblatexdata[%', '%biblatexdata*[%', '%biblatexdata{%', '%biblatexdata*{%']

(4)(+0000003): Committed DB transaction hrnrxvu9

(3)(+0000000): {better-bibtex} +6 Startup progress: 50 took 0.006 s

(3)(+0000001): {better-bibtex} +1 Startup progress: 50...

(3)(+0000000): {better-bibtex} +0 Startup progress: 50 took 0.001 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Loading journal abbreviator...

(3)(+0000000): {better-bibtex} +0 Startup progress: Loading journal abbreviator took 0 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Installing bundled translators...

(1)(+0000000): Unknown item type 'annotation'

(3)(+0000079): {better-bibtex} +79 Startup progress: Installing bundled translators took 0.079 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Starting key manager...

(4)(+0000004): SELECT item.itemID, item.libraryID, item.key, extra.value as extra, item.itemTypeID FROM items item LEFT JOIN itemData field ON field.itemID = item.itemID AND field.fieldID = 16 LEFT JOIN itemDataValues extra ON extra.valueID = field.valueID WHERE item.itemID NOT IN (select itemID from deletedItems) AND item.itemTypeID NOT IN (2, 26)

(4)(+0000006): ATTACH DATABASE ":memory:" AS betterbibtexcitekeys

(4)(+0000000): CREATE TABLE betterbibtexcitekeys.citekeys (itemID PRIMARY KEY, itemKey, citekey)

(4)(+0000002): Beginning DB transaction 2Xf2E30W

(4)(+0000001): INSERT INTO betterbibtexcitekeys.citekeys (itemID, itemKey, citekey) VALUES (?, ?, ?) [1, 'SWYTVVPL', 'saxenaDrivingDenseTraffic2020']

(4)(+0000001): INSERT INTO betterbibtexcitekeys.citekeys (itemID, itemKey, citekey) VALUES (?, ?, ?) [6, 'C3VMJPTC', 'schwartingPlanningDecisionMakingAutonomous2018']

(4)(+0000002): INSERT INTO betterbibtexcitekeys.citekeys (itemID, itemKey, citekey) VALUES (?, ?, ?) [8, 'XJNXHZS6', 'chenModelfreeDeepReinforcement2019']

(4)(+0000003): INSERT INTO betterbibtexcitekeys.citekeys (itemID, itemKey, citekey) VALUES (?, ?, ?) [18, 'DMI79QSI', 'zotero-18']

(4)(+0000001): INSERT INTO betterbibtexcitekeys.citekeys (itemID, itemKey, citekey) VALUES (?, ?, ?) [20, 'AKRM3Z8K', 'niaziOptimalControlUrban2021']

(4)(+0000002): Committed DB transaction 2Xf2E30W

(3)(+0000003): {better-bibtex} +24 Startup progress: Starting key manager took 0.024 s

(3)(+0000000): {better-bibtex} +1 Startup progress: Starting auto-export...

(3)(+0000000): {better-bibtex} +0 Startup progress: Starting auto-export took 0.001 s

(3)(+0000001): {better-bibtex} +1 Startup progress: done

(4)(+0000002): Unregistering notifier observer in notifier with id 'itembox_cD'

(3)(+0000006): {better-bibtex} +8 Better BibTeX load finished successfully

(4)(+0001706): Beginning DB transaction tka1cpDU

(4)(+0000001): SELECT name FROM "better-bibtex"

(4)(+0000001): REPLACE INTO "better-bibtex" (name, data) VALUES (?, ?) ['better-bibtex.citekey', '{"name":"citekey","data":[{"citekey":"saxenaDrivingDenseTraffic2020","pinned":false,"itemID":1,"libraryID":1,"itemKey":"SWYTVVPL","meta":{"revision":5,"created":1616651331850,"version":0,"updated":1616766646720},"$loki":1},{"citekey":"schwartingPlanningDecisionMakingAutonomous2018","pinned":false,"itemID":6,"libraryID":1,"itemKey":"C3VMJPTC","meta":{"revision":5,"created":1616651331851,"version":0,"updated":1616766646720},"$loki":2},{"citekey":"chenModelfreeDeepReinforcement2019","pinned":false,"itemID":8,"libraryID":1,"itemKey":"XJNXHZS6","meta":{"revision":5,"created":1616651331852,"version":0,"updated":1616766646719},"$loki":3},{"itemID":18,"libraryID":1,"itemKey":"DMI79QSI","pinned":false,"citekey":"zotero-18","meta":{"revision":3,"created":1616682216951,"version":0,"updated":1616766646719},"$loki":4},{"itemID":20,"libraryID":1,"itemKey":"AKRM3Z8K","pinned":false,"citekey":"niaziOptimalControlUrban2021","meta":{"revision":4,"created":1616682261660,"version":0,"updated":1616766646718},"$loki":5}],"idIndex":null,"binaryIndices":{"itemID":{"name":"itemID","dirty":false,"values":[0,1,2,3,4]},"itemKey":{"name":"itemKey","dirty":true,"values":[]},"libraryID":{"name":"libraryID","dirty":true,"values":[0,1,2,3,4]},"citekey":{"name":"citekey","dirty":false,"values":[2,4,0,1,3]},"pinned":{"name":"pinned","dirty":true,"values":[]}},"constraints":null,"uniqueNames":["itemID"],"transforms":{},"objType":"citekey","dirty":true,"cachedIndex":null,"cachedBinaryIndex":null,"cachedData":null,"adaptiveBinaryIndices":false,"transactional":false,"cloneObjects":true,"cloneMethod":"parse-stringify","asyncListeners":false,"disableMeta":false,"disableChangesApi":true,"disableDeltaChangesApi":true,"autoupdate":false,"serializableIndices":true,"disableFreeze":true,"ttl":null,"maxId":5,"DynamicViews":[],"events":{"insert":[],"update":[],"pre-insert":[],"pre-update":[],"close":[],"flushbuffer":[],"error":[],"delete":[null],"warning":[null]},"changes":[],"dirtyIds":[]}']

(4)(+0000000): REPLACE INTO "better-bibtex" (name, data) VALUES (?, ?) ['better-bibtex', '{"filename":"better-bibtex","collections":["better-bibtex.citekey","better-bibtex.autoexport"],"databaseVersion":1.5,"engineVersion":1.5,"autosave":false,"autosaveInterval":5000,"autosaveHandle":null,"throttledSaves":false,"options":{"env":"NA","serializationMethod":"normal","destructureDelimiter":"$<\n"},"persistenceAdapter":null,"throttledSavePending":false,"throttledCallbacks":[],"verbose":false,"events":{"init":[null],"loaded":[],"flushChanges":[],"close":[],"changes":[],"warning":[]},"ENV":"NA"}']

(4)(+0000002): Committed DB transaction tka1cpDU

(4)(+0001552): SELECT COUNT(*) FROM settings WHERE setting='mImport' AND key='cleanup'

(4)(+0000884): SELECT synced FROM fulltextItems WHERE itemID=? [3]

(4)(+0000002): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(3)(+0000021): MIME type application/pdf cannot be handled internally

(3)(+0000400): Scheduling next feed update

(4)(+0000000): SELECT ( CASE WHEN lastCheck IS NULL THEN 0 ELSE strftime('%s', lastCheck) + refreshInterval * 60 - strftime('%s', 'now') END ) AS nextCheck FROM feeds WHERE refreshInterval IS NOT NULL ORDER BY nextCheck ASC LIMIT 1

(3)(+0000001): No feeds with auto-update

(4)(+0014519): 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 [1, 'http://arxiv.org/abs/1909.06710']

(3)(+0004385): Starting full-text content processor

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

(4)(+0000001): SELECT itemID FROM fulltextItems WHERE synced=2

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

(3)(+0000000): Unregistering full-text content processor idle observer

(3)(+0000000): Stopping full-text content processor

padasch commented 3 years ago

@padasch alright, most things look alright. I assume you edited the image to hide your vault folder, could you maybe describe where that folder lives? Are both your Export directory and template directory the same? Double check that it's not malformed. Another thing, any modifications in the hidden preferences?

I double checked to make sure that my templates directory is correctly linked and holds the correctly named template. Also checked that the export directory is correct. I once enabled the option for extensions.zotfile.pdfExtraction.colorAnnotations but now disabled it. Using your new plugin + fresh install + try to export md did not create any file anymore (previously did) and gave this error:

Debug Output.txt

argenos commented 3 years ago

@padasch @aladinoster I also/still don't see any mdnotes output on your logs. After restarting and enabling the debug messages, did you use the right-click menu to export to markdown again? 🤔

aladinoster commented 3 years ago

@argenos, it's weird because it seems the conversion is not triggered, I registered the following video summarizing what I do

padasch commented 3 years ago

Yes, I did - is there another way to export to md? Tried both, selecting the pdf item for export and the "top level" item of the paper (don't know how this is called)...

I tried downgrading to 0.1.2. as was suggested before but the error persists. Before, at least a file was created with Abstract and Metadata. But now, nothing is created anymore 🙈

celtickuma commented 3 years ago

0.1.2 works perfectly in Catalina. Files contain expected content, export to external directory, and is saved with the record.

On Fri, Mar 26, 2021 at 10:33 AM padasch @.***> wrote:

Yes, I did - is there another way to export to md? Tried both, selecting the pdf item for export and the "top level" item of the paper (don't know how this is called)...

I tried downgrading to 0.1.2. as was suggested before but the error persists. Before, at least a file was created with Abstract and Metadata. But now, nothing is created anymore 🙈

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/argenos/zotero-mdnotes/issues/80#issuecomment-808266710, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALKKDDGLYAWH4CPS6LRHYL3TFSLKFANCNFSM4ZYVMWTQ .

argenos commented 3 years ago

hmmm I unfortunately don't have a mac to test this on, but we can try one more thing based on the plugins I see active on your logs to rule out some interference like in #53. Two options: Temporarily disable all plugiins except Zotfile, Better Bibtex and mdnotes or creating a new profile where only those three are included.

celtickuma commented 3 years ago

This is informational only. Tested on a second MacBookPro (mid2014 Retina) configured as above (Catalina). original 0.1.3 fails. 0.1.2 works as expected. Files created correctly with correct content.

padasch commented 3 years ago

For summary, I list all pathways I tested here. Note that I have all my templates set up the same, so I am not sure which export option picks which template. I used the released package 0.1.3 (not fix) for this, hope this helps:

Note: Item with annot. means that I first extracted annotations from the pdf via right-click -> manage attachments -> extract annotations

Export as	Item without ann.	Item with annot.
Markdown	Md is created but {{noteContent}} is not filled	Md is created where {{noteContent}} is replaced by a wiki link to a file with name of annotations file
Batch	nothing happens	Md is created with all annotations but nothing else of the template and name is citekey + name of annotations file
Mdnotes file	same as with export as Markdown	Same as with export as Markdown

As a workaround, one can just copy-paste the annotations from the batch export file into the one of the export as markdown file. The ideal-world would be simply clicking on the zotero item without having to first extract the annotations and then have these annotations inserted into a template.

Thanks a lot for what you are doing here! The zotero-obsidian workflow will make my thesis writing a breeze! 🙌

Edit: Enabling the short DOI Plugin makes the "Batch" export option go away and thus disables the described workaround. EditEdit: The table above was created without having any plugin enabled except the trinity mdnotes, bbt, zotfile.

argenos commented 3 years ago

@padasch thanks for the detailed testing! The fact that it works under some circumstances is good news. There may be a mix of template confusion in play, but I don't think that is the cause of your bug. I have one more guess that we could try: On the very first line of your Zotero note, remove the parenthesis with the date and time (essentially naming it "Yellow Annotations") and try to export.

argenos commented 3 years ago

It might be that there is a fix for this in the pre-release now: https://github.com/argenos/zotero-mdnotes/releases/ I think this might have been a bug introduced in #67 (at least I hope)

padasch commented 3 years ago

@argenos thanks for the prerelease! I've tested out both your suggestions. Changing the title of the annotation in zotero works partially because it adds a hyphen to the export document ("paper2020 -" instead of just "paper2020" which makes quick cross-referencing in obsidian a bit "ugly" looking but works :) The pre-release unfortunately did not change anything :/

aladinoster commented 3 years ago

@argenos Sorry for my late reply, thanks for the pre-release, I've just tried the new alpha version, but still I have the same experience:

[JavaScript Error: "getAttachments() cannot be called on attachment items" {file: "chrome://zotero/content/xpcom/data/item.js" line: 3238}]

version => 5.0.96.1, platform => MacIntel, oscpu => Intel Mac OS X 10.16, locale => en-GB, appName => Zotero, appVersion => 5.0.96.1, extensions => Zotero LibreOffice Integration (5.0.25.SA.5.0.96.1, extension), Zotero Word for Mac Integration (5.0.36.SA.5.0.96.1, extension), ZotFile (5.0.16, extension), Zotero DOI Manager (1.3.9, extension), Zotero Scholar Citations (2.0.4, extension), Zotero Memento (1.0.0, extension), Zotero MAS MetaData (0.1.6, extension), Better BibTex for Zotero (5.2.138, extension), Mdnotes for Zotero (0.1.3, extension)

(3)(+0000000): Using data directory /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero

(3)(+0000003): IPC: Initializing pipe at /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/pipes/1617005203358

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

(3)(+0000000): /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/zotero.sqlite

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

(4)(+0000002): PRAGMA page_size

(4)(+0000002): PRAGMA cache_size=2000

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

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

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

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

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

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

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

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

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

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

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

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

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

(4)(+0000002): Beginning DB transaction 06UVzyDR

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

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

(3)(+0000000): Updating custom tables

(4)(+0000001): DELETE FROM itemTypesCombined

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

(4)(+0000001): DELETE FROM fieldsCombined WHERE fieldID NOT IN (SELECT fieldID FROM itemData)

(4)(+0000001): DELETE FROM itemTypeFieldsCombined

(4)(+0000001): DELETE FROM baseFieldMappingsCombined

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

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

(4)(+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

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

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

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

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

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

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

(3)(+0000001): Updating custom tables

(4)(+0000000): DELETE FROM itemTypesCombined

(4)(+0000000): DELETE FROM fieldsCombined WHERE fieldID NOT IN (SELECT fieldID FROM itemData)

(4)(+0000001): DELETE FROM itemTypeFieldsCombined

(4)(+0000000): DELETE FROM baseFieldMappingsCombined

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

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

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

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

(4)(+0000001): Committed DB transaction 06UVzyDR

(4)(+0000001): PRAGMA foreign_keys = true

(4)(+0000001): Beginning DB transaction 4H4TtLcF

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

(4)(+0000001): Committed DB transaction 4H4TtLcF

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(4)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE typeName IN ('book', 'bookSection', 'journalArticle', 'newspaperArticle', 'document')

(4)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE display != 0 AND display NOT IN ('book', 'bookSection', 'journalArticle', 'newspaperArticle', 'document') AND name != 'webpage'

(4)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE display=0

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

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

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

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

(4)(+0000006): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined

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

(4)(+0000015): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined

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

(4)(+0000003): SELECT DISTINCT fieldID FROM baseFieldMappingsCombined

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

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

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

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

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

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

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

(3)(+0000001): Running unlock callbacks

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

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

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

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

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

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

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

(3)(+0000000): Registering URIContentListener

(4)(+0000001): SELECT * FROM proxies

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

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

(3)(+0000001): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/locate/engines.json

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

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

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

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

(4)(+0000006): SELECT tagID, name FROM tags

(4)(+0000001): SELECT * FROM creators

(3)(+0000001): Loading collection relations

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

(3)(+0000000): Loaded collection relations in 1 ms

(3)(+0000000): Loading item relations

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

(3)(+0000001): Loaded item relations in 0 ms

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

(3)(+0000003): Getting contents of /Users/andresladino/Library/Application Support/Zotero/Profiles/e1lbekel.default/retractions.json

(4)(+0000036): 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)

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

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

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

(3)(+0000001): Loading all collections in My Library

(3)(+0000000): Loading primaryData for collections in My Library

(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]

(3)(+0000002): Loaded primaryData in My Library in 3 ms

(3)(+0000000): Loading childCollections for collections in My Library

(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]

(3)(+0000000): Loaded childCollections in My Library in 1 ms

(3)(+0000001): Loading childItems for collections in My Library

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

(3)(+0000001): Loaded childItems in My Library in 1 ms

(3)(+0000000): Loading relations for collections in My Library

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

(3)(+0000001): Loaded relations in My Library in 1 ms

(3)(+0000000): Loaded collections in My Library in 7 ms

(3)(+0000000): Loading all searches in My Library

(3)(+0000001): Loading primaryData for searches in My Library

(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]

(3)(+0000001): Loaded primaryData in My Library in 1 ms

(3)(+0000001): Loading conditions for searches in My Library

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

(3)(+0000000): Loaded conditions in My Library in 0 ms

(3)(+0000001): Loaded searches in My Library in 4 ms

(3)(+0000000): Initializing Quick Copy

(3)(+0000001): Running initialization callbacks

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

(3)(+0000001): Initializing Zotero pane

(3)(+0000004): Creating collections view with id h3m1HfxT

(3)(+0000000): Refreshing collections pane

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

(3)(+0000025): Rendering tag selector

(3)(+0000004): Rendering tag list

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

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

(3)(+0000000): ZoteroMacWordIntegration: Initializing integration pipes

(3)(+0000000): IPC: Initializing pipe at /Users/Shared/.zoteroIntegrationPipe_andresladino

(3)(+0000000): IPC: Initializing pipe at /Users/andresladino/Library/Containers/com.microsoft.Word/Data/.zoteroIntegrationPipe

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

(4)(+0000029): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (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) || ' and ' || (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) || ' and ' || (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 END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID IN (12,16,15,17,14,5,13)

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

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

(3)(+0000001): PluginInstaller: fetching addon info

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

(3)(+0000006): Loaded items in 11ms

(3)(+0000004): Creating items view with id TVa6L7Nf

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

(3)(+0000001): Loading all items in My Library

(3)(+0000000): Loading primaryData for items in My Library

(4)(+0000001): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (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) || ' and ' || (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) || ' and ' || (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 END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? [1]

(3)(+0000019): Loaded primaryData in My Library in 20 ms

(3)(+0000000): Loading creators for items in My Library

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

(3)(+0000003): Loaded creators in My Library in 4 ms

(3)(+0000000): Loading itemData for items in My Library

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

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

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

(3)(+0000003): Loaded itemData in My Library in 12 ms

(3)(+0000000): Loading note for items in My Library

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

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

(3)(+0000000): Loaded note in My Library in 6 ms

(3)(+0000001): Loading childItems for items in My Library

(4)(+0000000): SELECT parentItemID, A.itemID, value AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAttachments A JOIN items I ON (A.parentItemID=I.itemID) LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [1]

(4)(+0000001): SELECT parentItemID, N.itemID, title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemNotes N JOIN items I ON (N.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [1]

(4)(+0000003): SELECT itemID FROM items I WHERE libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments UNION SELECT itemID FROM itemNotes) [1]

(3)(+0000002): Rendering tag selector

(3)(+0000002): Rendering tag list

(3)(+0000005): Tag selector updated

(3)(+0000000): Loaded childItems in My Library in 13 ms

(3)(+0000001): Loading tags for items in My Library

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

(3)(+0000004): Loaded tags in My Library in 4 ms

(3)(+0000000): Loading collections for items in My Library

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

(3)(+0000001): Loaded collections in My Library in 1 ms

(3)(+0000001): Loading relations for items in My Library

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

(3)(+0000001): Loaded relations in My Library in 2 ms

(3)(+0000000): Loaded items in My Library in 64 ms

(3)(+0000001): Setting tree for L1 items view TVa6L7Nf

(3)(+0000001): Refreshing items list for TVa6L7Nf

(4)(+0000010): CREATE TEMPORARY TABLE tmpSearchResults_mVsCcmNd 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=?)) [1]

(4)(+0000002): CREATE INDEX tmpSearchResults_mVsCcmNd_itemID ON tmpSearchResults_mVsCcmNd(itemID)

(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_mVsCcmNd) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_mVsCcmNd)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_mVsCcmNd))) [1]

(4)(+0000003): DROP TABLE IF EXISTS tmpSearchResults_mVsCcmNd

(3)(+0000002): Sorting items list by title, firstCreator, date, dateAdded ascending for 5 items

(3)(+0000001): Sorted 5 items in 1 ms

(3)(+0000000): Refreshed open parents in 0 ms

(3)(+0000003): Rendering tag selector

(3)(+0000002): Rendering tag list

(3)(+0000007): Tag selector updated

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

(3)(+0000001): Creating tmpSearchResults_fOvFQcIa with 15 items

(3)(+0000002): Set tree for items view TVa6L7Nf in 34 ms

(3)(+0000000): User interface ready in 1970 ms

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

(4)(+0000031): 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 [18, '']

(4)(+0000111): 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 [1, 'http://arxiv.org/abs/1909.06710']

(4)(+0000002): 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 [8, 'http://arxiv.org/abs/1904.09503']

(4)(+0000002): 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 [20, '']

(4)(+0000002): 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 [6, '10/gfpj79']

(4)(+0000002): CREATE UNIQUE INDEX tmpSearchResults_fOvFQcIa_itemID ON tmpSearchResults_fOvFQcIa(itemID)

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

(3)(+0000007): Sorted tags in 1 ms

(3)(+0000000): Rendering tag selector

(3)(+0000003): Rendering tag list

(3)(+0000019): Tag selector updated

(3)(+0001472): Viewing item in pane 0

(3)(+0000000): Refreshing item box

(3)(+0000050): adding better-sentencecase

(3)(+0000708): WebSocket connection opened

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

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

(3)(+0000127): WebSocket message: {"event":"subscriptionsCreated","subscriptions":[{"topics":["styles","translators"]}],"errors":[]}

(3)(+0000016): Viewing item in pane 0

(3)(+0000001): Refreshing item box

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

(4)(+0000002): Sync not enabled -- skipping auto-sync

(3)(+0000421): Refreshing item row map

(4)(+0000377): 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 [1, 'http://arxiv.org/abs/1909.06710']

(3)(+0000202): Updating bundled files

(3)(+0000001): Initializing translators

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

(3)(+0000366): Cached 560 translators in 366 ms

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

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

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

(3)(+0000001): Getting contents of input stream

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

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

(3)(+0000000): Initializing styles

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/american-medical-association.csl

(3)(+0000003): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/modern-humanities-research-association.csl

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/american-political-science-association.csl

(3)(+0000001): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/elsevier-harvard.csl

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/american-chemical-society.csl

(3)(+0000001): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/ieee.csl

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/vancouver.csl

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/nature.csl

(3)(+0000001): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/harvard-cite-them-right.csl

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/chicago-fullnote-bibliography.csl

(3)(+0000004): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/apa.csl

(3)(+0000004): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/chicago-author-date.csl

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/modern-language-association.csl

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/american-sociological-association.csl

(3)(+0000002): Getting contents of /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/styles/chicago-note-bibliography.csl

(3)(+0000005): Cached 15 styles in 37 ms

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(3)(+0000002): HTTP POST "styles=%5B%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-medical-association%22%2C%22updated%22%3A1588472596%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%2Fmodern-humanities-research-association%22%2C%22updated%22%3A1607556470%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fmodern-humanities-research-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%2Felsevier-harvard%22%2C%22updated%22%3A1548172632%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Felsevier-harvard%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-chemical-society%22%2C%22updated%22%3A1583882370%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org…" (2966 chars) to https://repo.zotero.org/repo/updated?last=1617005199&version=5.0.96.1&m=3

(3)(+0000358): HTTP POST https://repo.zotero.org/repo/updated?last=1617005199&version=5.0.96.1&m=3 succeeded with 200

(4)(+0000001): Beginning DB transaction sDPL6Fvi

(4)(+0000002): REPLACE INTO version (schema,version) VALUES (?,?) ['repository', 1617005211]

(4)(+0000000): REPLACE INTO version (schema,version) VALUES (?,?) ['lastcheck', 1617005211]

(4)(+0000002): Committed DB transaction sDPL6Fvi

(3)(+0000001): All translators and styles are up-to-date

(3)(+0000000): Initializing DB backup idle observer

(4)(+0000002): Beginning DB transaction 1C1TVR6j

(4)(+0000002): SELECT key AS domainPath, value AS format FROM settings WHERE setting='quickCopySite'

(3)(+0000003): {better-bibtex} +null Zotero ready, let's roll!

(3)(+0000000): {better-bibtex} +0 Startup progress: Waiting for Zotero database took 6.311 s

(3)(+0000001): {better-bibtex} +1 Startup progress: Loading citation keys...

(4)(+0000002): Committed DB transaction 1C1TVR6j

(4)(+0000000): Beginning DB transaction tW4zAyNF

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

(4)(+0000001): CREATE INDEX tagDelete_tagID ON tagDelete(tagID)

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

(3)(+0000001): [better-bibtex] Asynchronously opening database 'better-bibtex'

(3)(+0000000): /Users/andresladino/Dropbox/03-Research/00-Bibliography/02-Zotero/better-bibtex.sqlite

(4)(+0000000): DROP TABLE tagDelete

(4)(+0000001): Committed DB transaction tW4zAyNF

(4)(+0000001): Beginning DB transaction zQkIz9E0

(4)(+0000001): PRAGMA main.locking_mode=EXCLUSIVE

(4)(+0000001): PRAGMA page_size

(4)(+0000002): Committed DB transaction zQkIz9E0

(3)(+0000001): Purged data tables in 19 ms

(4)(+0000000): PRAGMA cache_size=250

(4)(+0000001): PRAGMA foreign_keys=true

(3)(+0000001): Initializing DB backup idle observer

(4)(+0000001): PRAGMA integrity_check(1)

(4)(+0000000): CREATE TABLE IF NOT EXISTS "better-bibtex" (name TEXT PRIMARY KEY NOT NULL, data TEXT NOT NULL)

(4)(+0000001): SELECT name, data FROM "better-bibtex" ORDER BY name ASC

(4)(+0000053): SELECT itemID, strftime("%s", dateModified) * 1000 AS modified FROM items WHERE itemID NOT IN (select itemID from deletedItems)

(3)(+0000074): {better-bibtex} +144 jieba enabled: false

(4)(+0000000): select itemTypeID, typeName from itemTypes

(4)(+0000001): select fieldID, fieldName from fields

(3)(+0000004): {better-bibtex} +5 Startup progress: Loading citation keys took 0.15 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Starting serialisation cache...

(3)(+0000002): {better-bibtex} +2 Startup progress: Starting serialisation cache took 0.001 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Initializing auto-export...

(3)(+0000000): {better-bibtex} +0 pathSearch: looking for git in {"path":["/usr/bin","/bin","/usr/sbin","/sbin"],"pathext":[""],"sep":"/"}

(3)(+0000001): {better-bibtex} +1 pathSearch: git found at /usr/bin/git

(3)(+0000001): {better-bibtex} +1 Startup progress: Initializing auto-export took 0.003 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Waiting for Zotero translators...

(3)(+0000000): {better-bibtex} +0 Startup progress: Waiting for Zotero translators took 0 s

(3)(+0000001): {better-bibtex} +0 Startup progress: 50...

(4)(+0000000): Beginning DB transaction HIYjBl7K

(4)(+0000001): SELECT items.itemID, itemDataValues.value as extra FROM items JOIN itemData on itemData.itemID = items.itemID JOIN fields on fields.fieldID = itemData.fieldID JOIN itemDataValues on itemData.valueID = itemDataValues.valueID WHERE items.itemID NOT IN (select itemID from deletedItems) AND fields.fieldName = 'extra' AND (itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ? OR itemDataValues.value like ?) ['%bibtex:%', '%bibtex[%', '%bibtex*[%', '%bibtex{%', '%bibtex*{%', '%biblatexcitekey:%', '%biblatexcitekey[%', '%biblatexcitekey*[%', '%biblatexcitekey{%', '%biblatexcitekey*{%', '%biblatex:%', '%biblatex[%', '%biblatex*[%', '%biblatex{%', '%biblatex*{%', '%biblatexdata:%', '%biblatexdata[%', '%biblatexdata*[%', '%biblatexdata{%', '%biblatexdata*{%']

(4)(+0000001): Committed DB transaction HIYjBl7K

(3)(+0000000): {better-bibtex} +3 Startup progress: 50 took 0.003 s

(3)(+0000000): {better-bibtex} +0 Startup progress: 50...

(3)(+0000000): {better-bibtex} +0 Startup progress: 50 took 0 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Loading journal abbreviator...

(3)(+0000000): {better-bibtex} +0 Startup progress: Loading journal abbreviator took 0 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Installing bundled translators...

(1)(+0000001): Unknown item type 'annotation'

(3)(+0000036): {better-bibtex} +37 Startup progress: Installing bundled translators took 0.037 s

(3)(+0000000): {better-bibtex} +0 Startup progress: Starting key manager...

(4)(+0000000): SELECT item.itemID, item.libraryID, item.key, extra.value as extra, item.itemTypeID FROM items item LEFT JOIN itemData field ON field.itemID = item.itemID AND field.fieldID = 16 LEFT JOIN itemDataValues extra ON extra.valueID = field.valueID WHERE item.itemID NOT IN (select itemID from deletedItems) AND item.itemTypeID NOT IN (2, 26)

(4)(+0000004): ATTACH DATABASE ":memory:" AS betterbibtexcitekeys

(4)(+0000000): CREATE TABLE betterbibtexcitekeys.citekeys (itemID PRIMARY KEY, itemKey, citekey)

(4)(+0000001): Beginning DB transaction URfeEDxr

(4)(+0000000): INSERT INTO betterbibtexcitekeys.citekeys (itemID, itemKey, citekey) VALUES (?, ?, ?) [1, 'SWYTVVPL', 'saxenaDrivingDenseTraffic2020']

(4)(+0000001): INSERT INTO betterbibtexcitekeys.citekeys (itemID, itemKey, citekey) VALUES (?, ?, ?) [6, 'C3VMJPTC', 'schwartingPlanningDecisionMakingAutonomous2018']

(4)(+0000000): INSERT INTO betterbibtexcitekeys.citekeys (itemID, itemKey, citekey) VALUES (?, ?, ?) [8, 'XJNXHZS6', 'chenModelfreeDeepReinforcement2019']

(4)(+0000001): INSERT INTO betterbibtexcitekeys.citekeys (itemID, itemKey, citekey) VALUES (?, ?, ?) [18, 'DMI79QSI', 'zotero-18']

(4)(+0000001): INSERT INTO betterbibtexcitekeys.citekeys (itemID, itemKey, citekey) VALUES (?, ?, ?) [20, 'AKRM3Z8K', 'niaziOptimalControlUrban2021']

(4)(+0000001): Committed DB transaction URfeEDxr

(3)(+0000001): {better-bibtex} +9 Startup progress: Starting key manager took 0.009 s

(3)(+0000000): {better-bibtex} +1 Startup progress: Starting auto-export...

(3)(+0000000): {better-bibtex} +0 Startup progress: Starting auto-export took 0.001 s

(3)(+0000000): {better-bibtex} +0 Startup progress: done

(4)(+0000002): Unregistering notifier observer in notifier with id 'itembox_eI'

(3)(+0000003): {better-bibtex} +5 Better BibTeX load finished successfully

(4)(+0000029): 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 [1, 'http://arxiv.org/abs/1909.06710']

(4)(+0000004): 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 [1, 'http://arxiv.org/abs/1909.06710']

(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 [1, 'http://arxiv.org/abs/1909.06710']

(4)(+0000002): 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 [1, 'http://arxiv.org/abs/1909.06710']

(3)(+0000002): MIME type application/pdf cannot be handled internally

(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 [1, 'http://arxiv.org/abs/1909.06710']

(4)(+0000493): 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 [1, 'http://arxiv.org/abs/1909.06710']

(3)(+0000742): Setting mode to 'edit'

(3)(+0000000): Refreshing attachment box

(4)(+0000002): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(4)(+0000004): SELECT synced FROM fulltextItems WHERE itemID=? [3]

(3)(+0000004): Setting mode to note

(3)(+0000003): Setting mode to note

(3)(+0000008): Reloading tags box

(3)(+0000002): Refreshing note editor

(3)(+0000000): No editor yet

(3)(+0000001): Loading resource://zotero/tinymce/note.html?locale=en-GB&dir=ltr

(4)(+0000015): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(4)(+0000024): SELECT synced FROM fulltextItems WHERE itemID=? [3]

(4)(+0000011): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(3)(+0000239): Setting content to <p xmlns="http://www.w3.org/1999/xhtml" id="title"><strong>Contents</strong></p><ul xmlns="http://www.w3.org/1999/xhtml" style="list-style-type: none; padding-left:0px" id="toc"><li><a href="zotero://open-pdf/0_9LZG2ZR8/1">I Introduction</a></li><li style="padding-top:8px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">II Related Work</a><ul style="list-style-type: none; padding-left:12px"><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">II-A Behaviour Cloning</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">II-B Reinforcement Learning</a></li></ul></li><li style="padding-top:8px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">III Approach</a><ul style="list-style-type: none; padding-left:12px"><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/2">III-A Benchmark for Driving in Dense Traffic</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/3">III-B Vehicle Model</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/3">III-C Network Architecture and Policy Parameterisation</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">III-D Ego-vehicle Observations</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">III-E Reward Function</a></li></ul></li><li style="padding-top:8px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">IV Experimental Results</a><ul style="list-style-type: none; padding-left:12px"><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/4">IV-A Baselines</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/5">IV-B Evaluation Metrics</a></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/5">IV-C Quantitative Results</a></li></ul></li><li style="padding-top:4px"><a href="zotero://open-pdf/0_9LZG2ZR8/5">V Conclusion</a></li></ul>

(4)(+0000057): SELECT synced FROM fulltextItems WHERE itemID=? [3]

(4)(+0000028): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(3)(+0000010): MIME type application/pdf cannot be handled internally

(4)(+0001271): Beginning DB transaction SndVbUFh

(4)(+0000001): SELECT name FROM "better-bibtex"

(4)(+0000001): REPLACE INTO "better-bibtex" (name, data) VALUES (?, ?) ['better-bibtex.citekey', '{"name":"citekey","data":[{"citekey":"saxenaDrivingDenseTraffic2020","pinned":false,"itemID":1,"libraryID":1,"itemKey":"SWYTVVPL","meta":{"revision":13,"created":1616651331850,"version":0,"updated":1617005210861},"$loki":1},{"citekey":"schwartingPlanningDecisionMakingAutonomous2018","pinned":false,"itemID":6,"libraryID":1,"itemKey":"C3VMJPTC","meta":{"revision":13,"created":1616651331851,"version":0,"updated":1617005210860},"$loki":2},{"citekey":"chenModelfreeDeepReinforcement2019","pinned":false,"itemID":8,"libraryID":1,"itemKey":"XJNXHZS6","meta":{"revision":13,"created":1616651331852,"version":0,"updated":1617005210860},"$loki":3},{"itemID":18,"libraryID":1,"itemKey":"DMI79QSI","pinned":false,"citekey":"zotero-18","meta":{"revision":11,"created":1616682216951,"version":0,"updated":1617005210860},"$loki":4},{"itemID":20,"libraryID":1,"itemKey":"AKRM3Z8K","pinned":false,"citekey":"niaziOptimalControlUrban2021","meta":{"revision":12,"created":1616682261660,"version":0,"updated":1617005210860},"$loki":5}],"idIndex":null,"binaryIndices":{"itemID":{"name":"itemID","dirty":false,"values":[0,1,2,3,4]},"itemKey":{"name":"itemKey","dirty":true,"values":[]},"libraryID":{"name":"libraryID","dirty":true,"values":[0,1,2,3,4]},"citekey":{"name":"citekey","dirty":false,"values":[2,4,0,1,3]},"pinned":{"name":"pinned","dirty":true,"values":[]}},"constraints":null,"uniqueNames":["itemID"],"transforms":{},"objType":"citekey","dirty":true,"cachedIndex":null,"cachedBinaryIndex":null,"cachedData":null,"adaptiveBinaryIndices":false,"transactional":false,"cloneObjects":true,"cloneMethod":"parse-stringify","asyncListeners":false,"disableMeta":false,"disableChangesApi":true,"disableDeltaChangesApi":true,"autoupdate":false,"serializableIndices":true,"disableFreeze":true,"ttl":null,"maxId":5,"DynamicViews":[],"events":{"insert":[],"update":[],"pre-insert":[],"pre-update":[],"close":[],"flushbuffer":[],"error":[],"delete":[null],"warning":[null]},"changes":[],"dirtyIds":[]}']

(4)(+0000001): REPLACE INTO "better-bibtex" (name, data) VALUES (?, ?) ['better-bibtex', '{"filename":"better-bibtex","collections":["better-bibtex.citekey","better-bibtex.autoexport"],"databaseVersion":1.5,"engineVersion":1.5,"autosave":false,"autosaveInterval":5000,"autosaveHandle":null,"throttledSaves":false,"options":{"env":"NA","serializationMethod":"normal","destructureDelimiter":"$<\n"},"persistenceAdapter":null,"throttledSavePending":false,"throttledCallbacks":[],"verbose":false,"events":{"init":[null],"loaded":[],"flushChanges":[],"close":[],"changes":[],"warning":[]},"ENV":"NA"}']

(4)(+0000003): Committed DB transaction SndVbUFh

(4)(+0001247): SELECT COUNT(*) FROM settings WHERE setting='mImport' AND key='cleanup'

(3)(+0000265): Created hidden browser (0)

(3)(+0000318): Scheduling next feed update

(4)(+0000000): SELECT ( CASE WHEN lastCheck IS NULL THEN 0 ELSE strftime('%s', lastCheck) + refreshInterval * 60 - strftime('%s', 'now') END ) AS nextCheck FROM feeds WHERE refreshInterval IS NOT NULL ORDER BY nextCheck ASC LIMIT 1

(3)(+0000001): No feeds with auto-update

(2)(+0005754): WARNING: Zotero.Collection.prototype.parent has been deprecated -- use .parentID or .parentKey

(2)(+0000000): WARNING: Zotero.Collection.prototype.parent has been deprecated -- use .parentID or .parentKey

(2)(+0000000): WARNING: Zotero.Collection.prototype.parent has been deprecated -- use .parentID or .parentKey

(4)(+0000016): Beginning DB transaction 4S2Gbt4g

(3)(+0000002): Deleted hidden browser (0)

(4)(+0000006): Saving data for new item to database

(4)(+0000003): INSERT INTO items (itemID, libraryID, key, clientDateModified, itemTypeID, dateAdded, dateModified) VALUES (?,?,?,?,?,?,?) [23, 1, '5UT6KN96', '2021-03-29 08:07:01', 26, '2021-03-29 08:07:01', '2021-03-29 08:07:01']

(3)(+0000003): Notifier.trigger('add', 'item', [23], {}) queued

(3)(+0000001): Notifier.trigger('modify', 'item', [1], {}) queued

(4)(+0000000): SELECT COUNT(*) FROM itemNotes WHERE itemID=? [23]

(4)(+0000003): INSERT INTO itemNotes (itemID, parentItemID, note, title) VALUES (?,?,?,?) [23, 1, '<div class="zotero-note znv1"><p><b>Yellow Annotations (29/03/2021, 10:07:01)</b><p><p>"The traditional methods fail to take into account the fact that the actions taken by an agent affect the behaviour of other vehicles on the road. In this work, we rely on the ability of deep reinforcement learning to implicitly model such interactions and learn a continuous control policy over the action space of an autonomous vehicle" (<a href="zotero://open-pdf/library/items/9LZG2ZR8?page=1">Saxena et al 2020:5385</a>)</p><p>"we present a model-free reinforcement learning based solution that does not need any explicit model of intervehicle interactions," (<a href="zotero://open-pdf/library/items/9LZG2ZR8?page=1">Saxena et al 2020:5385</a>)</p><p>"We must rely on implicit or explicit models of joint interactions between the agents in the scene [33]" (<a href="zotero://open-pdf/library/items/9LZG2ZR8?page=1">Saxena et al 2020:5385</a>)</p><p><i>To avoid the car to stay stationary as optimal solution (trivial one)<br> (<a href="zotero://open-pdf/library/items/9LZG2ZR8?page=1">note on p.5385</a>)</i></p><br><p>"we use reinforcement learning to learn a low-level, continuous-control policy for driving amongst dense traffic. The continuous control aspect has been addressed previously [8]," (<a href="zotero://open-pdf/library/items/9LZG2ZR8?page=2">Saxena et al 2020:5386</a>)</p></div>', 'Yellow Annotations (29/03/2021, 10:07:01)"The traditional methods fail to take into account the fact that the actions ta']

(3)(+0000002): Loading primaryData for 1 item in My Library

(4)(+0000001): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (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) || ' and ' || (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) || ' and ' || (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 END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? AND O.itemID IN (1) [1]

(3)(+0000003): Loaded primaryData in My Library in 4 ms

(3)(+0000001): Loading childItems for 1 item in My Library

(4)(+0000000): SELECT parentItemID, A.itemID, value AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAttachments A JOIN items I ON (A.parentItemID=I.itemID) LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (1) ORDER BY parentItemID [1]

(4)(+0000002): 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=? AND parentItemID IN (1) ORDER BY parentItemID [1]

(4)(+0000001): SELECT itemID FROM items I WHERE libraryID=? AND itemID IN (1) AND itemID NOT IN (SELECT itemID FROM itemAttachments UNION SELECT itemID FROM itemNotes) [1]

(3)(+0000001): Loaded childItems in My Library in 5 ms

(4)(+0000001): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (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) || ' and ' || (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) || ' and ' || (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 END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID=? [23]

(3)(+0000003): Loading note for 1 item in My Library

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

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

(3)(+0000002): Loaded note in My Library in 3 ms

(4)(+0000001): Saving data for new item to database

(4)(+0000001): INSERT INTO items (itemID, libraryID, key, clientDateModified, itemTypeID, dateAdded, dateModified) VALUES (?,?,?,?,?,?,?) [24, 1, 'LSJ3QR4N', '2021-03-29 08:07:01', 26, '2021-03-29 08:07:01', '2021-03-29 08:07:01']

(3)(+0000001): Notifier.trigger('add', 'item', [24], {}) queued

(3)(+0000000): Notifier.trigger('modify', 'item', [1], {}) queued

(4)(+0000000): SELECT COUNT(*) FROM itemNotes WHERE itemID=? [24]

(4)(+0000001): INSERT INTO itemNotes (itemID, parentItemID, note, title) VALUES (?,?,?,?) [24, 1, '<div class="zotero-note znv1"><p><b>Green Annotations (29/03/2021, 10:07:01)</b><p><p>"approaches differ in terms of the input observation, action space, policy parameterisation, or additional outputs (like uncertainty estimates for the chosen action), but they all still rely on labeled datasets" (<a href="zotero://open-pdf/library/items/9LZG2ZR8?page=2">Saxena et al 2020:5386</a>)</p><p><i>Former approaches are suppervised<br> (<a href="zotero://open-pdf/library/items/9LZG2ZR8?page=2">note on p.5386</a>)</i></p><br></div>', 'Green Annotations (29/03/2021, 10:07:01)"approaches differ in terms of the input observation, action space, policy param']

(3)(+0000001): Loading primaryData for 1 item in My Library

(4)(+0000000): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (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) || ' and ' || (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) || ' and ' || (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 END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? AND O.itemID IN (1) [1]

(3)(+0000001): Loaded primaryData in My Library in 1 ms

(3)(+0000001): Loading childItems for 1 item in My Library

(4)(+0000000): SELECT parentItemID, A.itemID, value AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAttachments A JOIN items I ON (A.parentItemID=I.itemID) LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? AND parentItemID IN (1) ORDER BY parentItemID [1]

(4)(+0000002): 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=? AND parentItemID IN (1) ORDER BY parentItemID [1]

(4)(+0000000): SELECT itemID FROM items I WHERE libraryID=? AND itemID IN (1) AND itemID NOT IN (SELECT itemID FROM itemAttachments UNION SELECT itemID FROM itemNotes) [1]

(3)(+0000001): Loaded childItems in My Library in 3 ms

(4)(+0000001): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (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) || ' and ' || (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) || ' and ' || (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 END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID=? [24]

(3)(+0000001): Loading note for 1 item in My Library

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

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

(3)(+0000001): Loaded note in My Library in 2 ms

(4)(+0000001): Committed DB transaction 4S2Gbt4g

(3)(+0000001): Committing notifier event queue [add-item: 2] [modify-item: 1]

(3)(+0000000): Notifier.trigger('add', 'item', [23,24], {"23":{},"24":{}}) called [observers: 19]

(3)(+0000004): Yielding for refresh promise

(1)(+0000004): Error: getAttachments() cannot be called on attachment items Zotero.Item.prototype.getAttachments@chrome://zotero/content/xpcom/data/item.js:3238:11 isSignposted@chrome://zotero_memento/content/scripts/Signpost.js:25:24 sendReq@chrome://zotero_memento/content/scripts/IaPusher.js:352:14 notify@chrome://zotero_memento/content/scripts/ZoteroArchive.js:16:23 Zotero.Notifier</this.trigger<@chrome://zotero/content/xpcom/notifier.js:137:38

(3)(+0000002): [scholar-citations] skipping item "Yellow Annotations (29/03/2021, 10:07:01)"The traditional methods fail to take into account the fact that the actions ta" it has either an empty title or is missing creator information

(3)(+0000000): [scholar-citations] skipping item "Green Annotations (29/03/2021, 10:07:01)"approaches differ in terms of the input observation, action space, policy param" it has either an empty title or is missing creator information

(3)(+0000003): Notifier.trigger('modify', 'item', [1], {"1":{}}) called [observers: 19]

(3)(+0000012): Yielding for refresh promise

(3)(+0000001): Sorting items list by title, firstCreator, date, dateAdded ascending for 1 item

(3)(+0000001): Sorted 1 item in 2 ms

(3)(+0000001): Yielding for select promise

(4)(+0000004): DROP TABLE IF EXISTS tmpSearchResults_fOvFQcIa

(4)(+0000006): 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 [1, 'http://arxiv.org/abs/1909.06710']

(4)(+0002306): Beginning DB transaction iQg2K4GB

(4)(+0000002): SELECT name FROM "better-bibtex"

(4)(+0000002): REPLACE INTO "better-bibtex" (name, data) VALUES (?, ?) ['better-bibtex.citekey', '{"name":"citekey","data":[{"citekey":"saxenaDrivingDenseTraffic2020","pinned":false,"itemID":1,"libraryID":1,"itemKey":"SWYTVVPL","meta":{"revision":13,"created":1616651331850,"version":0,"updated":1617005210861},"$loki":1},{"citekey":"schwartingPlanningDecisionMakingAutonomous2018","pinned":false,"itemID":6,"libraryID":1,"itemKey":"C3VMJPTC","meta":{"revision":13,"created":1616651331851,"version":0,"updated":1617005210860},"$loki":2},{"citekey":"chenModelfreeDeepReinforcement2019","pinned":false,"itemID":8,"libraryID":1,"itemKey":"XJNXHZS6","meta":{"revision":13,"created":1616651331852,"version":0,"updated":1617005210860},"$loki":3},{"itemID":18,"libraryID":1,"itemKey":"DMI79QSI","pinned":false,"citekey":"zotero-18","meta":{"revision":11,"created":1616682216951,"version":0,"updated":1617005210860},"$loki":4},{"itemID":20,"libraryID":1,"itemKey":"AKRM3Z8K","pinned":false,"citekey":"niaziOptimalControlUrban2021","meta":{"revision":12,"created":1616682261660,"version":0,"updated":1617005210860},"$loki":5}],"idIndex":null,"binaryIndices":{"itemID":{"name":"itemID","dirty":false,"values":[0,1,2,3,4]},"itemKey":{"name":"itemKey","dirty":true,"values":[]},"libraryID":{"name":"libraryID","dirty":false,"values":[0,1,2,3,4]},"citekey":{"name":"citekey","dirty":false,"values":[2,4,0,1,3]},"pinned":{"name":"pinned","dirty":true,"values":[]}},"constraints":null,"uniqueNames":["itemID"],"transforms":{},"objType":"citekey","dirty":true,"cachedIndex":null,"cachedBinaryIndex":null,"cachedData":null,"adaptiveBinaryIndices":false,"transactional":false,"cloneObjects":true,"cloneMethod":"parse-stringify","asyncListeners":false,"disableMeta":false,"disableChangesApi":true,"disableDeltaChangesApi":true,"autoupdate":false,"serializableIndices":true,"disableFreeze":true,"ttl":null,"maxId":5,"DynamicViews":[],"events":{"insert":[],"update":[],"pre-insert":[],"pre-update":[],"close":[],"flushbuffer":[],"error":[],"delete":[null],"warning":[null]},"changes":[],"dirtyIds":[]}']

(4)(+0000002): REPLACE INTO "better-bibtex" (name, data) VALUES (?, ?) ['better-bibtex', '{"filename":"better-bibtex","collections":["better-bibtex.citekey","better-bibtex.autoexport"],"databaseVersion":1.5,"engineVersion":1.5,"autosave":false,"autosaveInterval":5000,"autosaveHandle":null,"throttledSaves":false,"options":{"env":"NA","serializationMethod":"normal","destructureDelimiter":"$<\n"},"persistenceAdapter":null,"throttledSavePending":false,"throttledCallbacks":[],"verbose":false,"events":{"init":[null],"loaded":[],"flushChanges":[],"close":[],"changes":[],"warning":[]},"ENV":"NA"}']

(4)(+0000004): Committed DB transaction iQg2K4GB

(4)(+0000672): SELECT synced FROM fulltextItems WHERE itemID=? [3]

(4)(+0000003): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=? [3]

(3)(+0000010): MIME type application/pdf cannot be handled internally

(4)(+0003543): 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 [1, 'http://arxiv.org/abs/1909.06710']

(3)(+0000471): Viewing item in pane 0

(3)(+0000000): Refreshing item box

(3)(+0000036): adding better-sentencecase

(4)(+0000211): 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 [1, 'http://arxiv.org/abs/1909.06710']

(4)(+0000003): 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 [1, 'http://arxiv.org/abs/1909.06710']

(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 [1, 'http://arxiv.org/abs/1909.06710']

(4)(+0000003): 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 [1, 'http://arxiv.org/abs/1909.06710']

(3)(+0000002): MIME type application/pdf cannot be handled internally

(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 [1, 'http://arxiv.org/abs/1909.06710']

(4)(+0000346): 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 [1, 'http://arxiv.org/abs/1909.06710']

(3)(+0006139): Starting full-text content processor

(3)(+0014510): Exporting a regular Zotero item

(3)(+0000041): Error:

argenos commented 3 years ago

@aladinoster @padasch I think those are two good clues. The log output indicates that mdnotes is also being loaded now, but failing during export. It sounds to me like there is some issue when creating titles for the yellow Zotero notes. Could you change this on your Zotfile preferences to confirm?

Go into the Zotero preferences Advanced > Config Editor and then filter by zotfile.pdf
Edit the value of extensions.zotfile.pdfExtraction.formatNoteTitle and remove the %(date) part
Repeat the same if you are using colours during your extraction with the extensions.zotfile.pdfExtraction.formatNoteTitleColor preference

padasch commented 3 years ago

Hmm unfortunately this did not fix it. When exporting to the Zotero Note Template, I don't get the template but all the notes. On the other hand, when exporting to the Mdnotes Default Template I get all the fields except for {{noteContent}}...

argenos commented 3 years ago

I think that’s just confusion around the templates. Try setting mdnotes preferences back to the defaults and temporarily remove any the template directory if you chose one. Then select the yellow Zotero note and click on Export to markdown, does the note get exported?

padasch commented 3 years ago

Okay, I removed the template folder and exported the yellow annotation note with "export to markdwon". As before, the export of the note works but the title of the .md is not turned into the citationkey although it has a bullet point saying + there is no additional information except for the notes, see screenshots (the paper I'm trying to export has the citation key Kovenock2018).

argenos commented 3 years ago

@padasch this looks promising! I see in your settings you're using split files. Could you try the Batch export to markdown? You will get multiple files with the configuration you had currently. I might need to make the docs clearer, in the meantime here is the bit that goes into how the files are exported: Configuration - Zotero mdnotes

padasch commented 3 years ago

Using batch export to markdown gives me the two files shown in scree shots from zotero and obsidian. Thanks for the link - definitely helpful for a better understanding!

argenos commented 3 years ago

This looks better! We are still missing one file though with the metadata! Are you still using the “Split file” setting? I’ll try to set up another debug build next week to try and pinpoint the issue.

padasch commented 3 years ago

Yes, I was still using „split file“ in the screenshots of my previous comment. Nice, thanks for your work here! Really appreciated :)

Am 03.04.2021 um 10:49 schrieb Argentina Ortega Sáinz @.***>:

This looks better! We are still missing one file though with the metadata! Are you still using the “Split file” setting? I’ll try to set up another debug build next week to try and pinpoint the issue. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/argenos/zotero-mdnotes/issues/80#issuecomment-812836305, or unsubscribe https://github.com/notifications/unsubscribe-auth/ATIWOYML4VNQVITYXH6GOVLTG3JCJANCNFSM4ZYVMWTQ.

einalex commented 3 years ago

@argenos this might be related: noteContent fails to appear for me in cases where the note's first line contains a forward slash or minus or equals or quote (/, -, =, ')....and likely a lot more characters on version 0.1.3 cause this error. I guess the content needs escaping.

argenos commented 3 years ago

@einalex thanks! I was suspecting something along those lines, but from what I could tell the note title should be sanitized in theory. Perhaps in practice something else is going on.

tophee commented 2 years ago

I am having the same problem as the OP (nothing happens when I try to export a note to md). I am getting the following error message in the log:

(3)(+0016307): Exporting a Zotero note

(3)(+0000004): SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data noteToMarkdown@chrome://mdnotes/content/mdnotes.js:362:14 getZoteroNoteFileContents@chrome://mdnotes/content/mdnotes.js:733:14 exportToMarkdownMenu@chrome://mdnotes/content/mdnotes.js:1030:26

sunpeng96 commented 8 months ago

I have the same problem. When I cancel ‘using the citekey of the entry as the file title’. Zotero can export markdown.

argenos / zotero-mdnotes

Conversion not performed #80