1778447000996	addons.xpi-utils	WARN	Add-on zotero-scihub@example.com is not compatible with application version.

[JavaScript Error: "Error: Failed to load resource://services-settings/remote-settings.sys.mjs"]

While creating services from category 'profile-after-change', could not create service for entry 'RemotePermissionService', contract ID '@mozilla.org/remote-permission-service;1'

1778447001070	addons.xpi-utils	WARN	Add-on zotero-scihub@example.com is not compatible with application version.

[JavaScript Error: "Error: Failed to load resource://services-settings/remote-settings.sys.mjs" {file: "resource://gre/modules/EssentialDomainsRemoteSettings.sys.mjs" line: 41}]

[JavaScript Error: "Error: Failed to load resource://services-settings/remote-settings.sys.mjs" {file: "resource://gre/modules/SimpleURIUnknownSchemesRemoteObserver.sys.mjs" line: 45}]

appName => Zotero, version => 9.0.2 (x64), os => Linux 7.0.2 #1 SMP PREEMPT_DYNAMIC Mon Apr 27 16:36:44 CDT 2026, locale => en-US, extensions => Sci-Hub Plugin for Zotero (2.0.0, extension, disabled)

=========================================================

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

(3)(+0000000): /home/alan/Documents/Zotero/zotero.sqlite

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

(4)(+0000000): PRAGMA page_size

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

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

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

(3)(+0000000): Getting contents of [xpconnect wrapped nsIChannel]

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

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

(3)(+0000000): Getting contents of [xpconnect wrapped nsIChannel]

(3)(+0000001): Updating custom tables

(4)(+0000000): PRAGMA foreign_keys

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

(4)(+0000001): DELETE FROM itemTypesCombined

(4)(+0000000): DELETE FROM fieldsCombined

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

(3)(+0000001): Getting contents of [xpconnect wrapped nsIChannel]

(3)(+0000001): Updating user data tables from version 123 to 125

(4)(+0000000): ALTER TABLE itemAttachments ADD COLUMN lastRead INT

(4)(+0000002): CREATE INDEX itemAttachments_lastRead ON itemAttachments(lastRead)

(4)(+0000001): ALTER TABLE libraries ADD COLUMN isAdmin INT NOT NULL DEFAULT 0

(4)(+0000001): UPDATE groups SET version = 0

(4)(+0000001): REPLACE INTO version (schema,version) VALUES (?,?) ['userdata', 125]

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

(3)(+0000000): Getting contents of [xpconnect wrapped nsIChannel]

(3)(+0000001): Updating custom tables

(4)(+0000000): PRAGMA foreign_keys

(4)(+0000000): DELETE FROM itemTypesCombined

(4)(+0000000): DELETE FROM fieldsCombined

(4)(+0000000): 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)(+0000000): INSERT INTO fieldsCombined SELECT fieldID, fieldName, NULL AS label, fieldFormatID, 0 AS custom FROM fields UNION SELECT customFieldID + 10000 AS fieldID, fieldName, label, NULL, 1 AS custom FROM customFields

(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

(4)(+0000018): Committed DB transaction fT2fffvD

(3)(+0000000): Checking database schema integrity

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

(4)(+0000001): SELECT COUNT(*) FROM itemTypeFieldsCombined

(4)(+0000000): SELECT itemTypeID FROM itemTypes WHERE typeName='attachment'

(4)(+0000000): SELECT itemTypeID FROM itemTypes WHERE typeName='note'

(4)(+0000000): SELECT itemTypeID FROM itemTypes WHERE typeName='annotation'

(4)(+0000000): SELECT CASE type WHEN 'table' THEN 'table:' || tbl_name WHEN 'index' THEN 'index:' || name WHEN 'trigger' THEN 'trigger:' || name END FROM sqlite_master WHERE type IN ('table', 'index', 'trigger')

(3)(+0000001): Getting contents of [xpconnect wrapped nsIChannel]

(4)(+0000003): PRAGMA foreign_key_check

(4)(+0001007): SELECT COUNT(*) > 0 FROM items WHERE itemTypeID IS NULL

(4)(+0000000): SELECT COUNT(*) > 0 FROM itemAttachments JOIN items USING (itemID) WHERE itemTypeID != 14

(4)(+0000001): SELECT COUNT(*) > 0 FROM itemData WHERE fieldID NOT IN (SELECT fieldID FROM itemTypeFieldsCombined WHERE itemTypeID=(SELECT itemTypeID FROM items WHERE itemID=itemData.itemID))

(4)(+0000242): SELECT COUNT(*) > 0 FROM items WHERE itemTypeID=14 AND itemID NOT IN (SELECT itemID FROM itemAttachments)

(4)(+0000002): SELECT COUNT(*) > 0 FROM items WHERE itemTypeID=37 AND itemID NOT IN (SELECT itemID FROM itemAnnotations)

(4)(+0000000): SELECT COUNT(*) > 0 FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM items WHERE itemTypeID=1) AND linkMode != 4

(4)(+0000001): SELECT COUNT(*) > 0 FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM items WHERE itemTypeID IN (14, 37))

(4)(+0000002): SELECT COUNT(*) > 0 FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM items WHERE itemTypeID IN (1, 14, 37))

(4)(+0000002): SELECT COUNT(*) > 0 FROM creators WHERE firstName='' AND lastName=''

(4)(+0000000): SELECT COUNT(*) > 0 FROM fulltextItemWords WHERE itemID NOT IN (SELECT itemID FROM items WHERE itemTypeID=14)

(4)(+0000353): SELECT COUNT(*) > 0 FROM fulltextItems WHERE itemID NOT IN (SELECT itemID FROM items WHERE itemTypeID=14)

(4)(+0000001): SELECT COUNT(*) > 0 FROM itemAttachments WHERE linkMode NOT IN (0,1,2,3,4)

(4)(+0000001): SELECT COUNT(*) > 0 FROM creators WHERE fieldMode = 1 AND firstName != ''

(4)(+0000000): SELECT COUNT(*) > 0 FROM settings WHERE setting='account' AND key='userID' AND TYPEOF(value)='text'

(4)(+0000000): SELECT collectionID, parentCollectionID FROM collections

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

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

(3)(+0000000): Updating global schema to version 42

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

(4)(+0000000): 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)(+0000000): SELECT COALESCE(MAX(customItemTypeID) + 1, 1) FROM customItemTypes

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

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

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

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

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

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

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

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

(4)(+0000000): SELECT itemTypeID AS id, typeName AS name FROM itemTypes

(4)(+0000001): SELECT fieldID AS id, fieldName AS name FROM fields

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

(4)(+0000007): DELETE FROM itemTypeFields

(4)(+0000001): DELETE FROM baseFieldMappings

(4)(+0000000): DELETE FROM itemTypeCreatorTypes

(4)(+0000000): INSERT INTO itemTypeFields VALUES (12, 110, 0, 0), (12, 90, 0, 1), (12, 59, 0, 2), (12, 61, 0, 3), (12, 14, 0, 4), (12, 133, 0, 5), (12, 26, 0, 6), (12, 126, 0, 7), (12, 1, 0, 8), (12, 27, 0, 9), (12, 123, 0, 10), (12, 19, 0, 11), (12, 116, 0, 12), (12, 87, 0, 13), (12, 62, 0, 14), (12, 18, 0, 15), (12, 2, 0, 16), (12, 22, 0, 17), (14, 110, 0, 0), (14, 27, 0, 1), (14, 1, 0, 2), (26, 110, 0, 0), (26, 90, 0, 1), (26, 71, 0, 2), (26, 28, 0, 3), (26, 4, 0, 4), (26, 45, 0, 5), (26, 72, 0, 6), (26, 7, 0, 7), (26, 14, 0, 8), (26, 77, 0, 9), (26, 11, 0, 10), (26, 26, 0, 11), (26, 126, 0, 12), (26, 1, 0, 13), (26, 27, 0, 14), (26, 123, 0, 15), (26, 19, 0, 16), (26, 116, 0, 17), (26, 87, 0, 18), (26, 62, 0, 19), (26, 18, 0, 20), (26, 2, 0, 21), (26, 22, 0, 22), (16, 110, 0, 0), (16, 90, 0, 1), (16, 93, 0, 2), (16, 36, 0, 3), (16, 94, 0, 4), (16, 15, 0, 5), (16, 95, 0, 6), (16, 41, 0, 7), (16, 40, 0, 8), (16, 42, 0, 9), (16, 14, 0, 10), (16, 26, 0, 11), (16, 126, 0, 12), (16, 1, 0, 13), (16, 27, 0, 14), (16, 116, 0, 15), (16, 87, 0, 16), (16, 2, 0, 17), (16, 22, 0, 18), (23, 110, 0, 0), (23, 90, 0, 1), (23, 107, 0, 2), (23, 70, 0, 3), (23, 14, 0, 4), (23, 26, 0, 5), (23, 126, 0, 6), (23, 1, 0, 7), (23, 27, 0, 8), (23, 13, 0, 9), (23, 116, 0, 10), (23, 87, 0, 11), (23, 2, 0, 12), (23, 22, 0, 13), (2, 110, 0, 0), (2, 90, 0, 1), (2, 3, 0, 2), (2, 30, 0, 3), (2, 4, 0, 4), (2, 45, 0, 5), (2, 6, 0, 6), (2, 14, 0, 7), (2, 8, 0, 8), (2, 7, 0, 9), (2, 134, 0, 10), (2, 135, 0, 11), (2, 136, 0, 12), (2, 130, 0, 13), (2, 118, 0, 14), (2, 11, 0, 15), (2, 26, 0, 16), (2, 126, 0, 17), (2, 1, 0, 18), (2, 27, 0, 19), (2, 13, 0, 20), (2, 123, 0, 21), (2, 19, 0, 22), (2, 116, 0, 23), (2, 87, 0, 24), (2, 62, 0, 25), (2, 18, 0, 26), (2, 2, 0, 27), (2, 22, 0, 28), (3, 110, 0, 0), (3, 90, 0, 1), (3, 115, 0, 2), (3, 3, 0, 3), (3, 30, 0, 4), (3, 4, 0, 5), (3, 45, 0, 6), (3, 6, 0, 7), (3, 14, 0, 8), (3, 8, 0, 9), (3, 7, 0, 10), (3, 134, 0, 11), (3, 135, 0, 12), (3, 136, 0, 13), (3, 130, 0, 14), (3, 10, 0, 15), (3, 11, 0, 16), (3, 26, 0, 17), (3, 126, 0, 18), (3, 1, 0, 19), (3, 27, 0, 20), (3, 13, 0, 21), (3, 123, 0, 22), (3, 19, 0, 23), (3, 116, 0, 24), (3, 87, 0, 25), (3, 62, 0, 26), (3, 18, 0, 27), (3, 2, 0, 28), (3, 22, 0, 29), (17, 111, 0, 0), (17, 90, 0, 1), (17, 44, 0, 2), (17, 96, 0, 3), (17, 117, 0, 4), (17, 43, 0, 5), (17, 97, 0, 6), (17, 98, 0, 7), (17, 42, 0, 8), (17, 26, 0, 9), (17, 126, 0, 10), (17, 1, 0, 11), (17, 27, 0, 12), (17, 116, 0, 13), (17, 87, 0, 14), (17, 2, 0, 15), (17, 22, 0, 16), (32, 110, 0, 0), (32, 90, 0, 1), (32, 28, 0, 2), (32, 81, 0, 3), (32, 14, 0, 4), (32, 82, 0, 5), (32, 83, 0, 6), (32, 7, 0, 7), (32, 88, 0, 8), (32, 2, 0, 9), (32, 126, 0, 10), (32, 1, 0, 11), (32, 27, 0, 12), (32, 26, 0, 13), (32, 11, 0, 14), (32, 123, 0, 15), (32, 19, 0, 16), (32, 62, 0, 17), (32, 18, 0, 18), (32, 116, 0, 19), (32, 22, 0, 20), (33, 110, 0, 0), (33, 90, 0, 1), (33, 114, 0, 2), (33, 84, 0, 3), (33, 8, 0, 4), (33, 7, 0, 5), (33, 14, 0, 6), (33, 133, 0, 7), (33, 4, 0, 8), (33, 5, 0, 9), (33, 45, 0, 10), (33, 10, 0, 11), (33, 3, 0, 12), (33, 30, 0, 13), (33, 26, 0, 14), (33, 11, 0, 15), (33, 126, 0, 16), (33, 1, 0, 17), (33, 27, 0, 18), (33, 13, 0, 19), (33, 123, 0, 20), (33, 19, 0, 21), (33, 116, 0, 22), (33, 87, 0, 23), (33, 62, 0, 24), (33, 18, 0, 25), (33, 2, 0, 26), (33, 22, 0, 27), (39, 110, 0, 0), (39, 90, 0, 1), (39, 128, 0, 2), (39, 108, 0, 3), (39, 81, 0, 4), (39, 14, 0, 5), (39, 124, 0, 6), (39, 129, 0, 7), (39, 130, 0, 8), (39, 26, 0, 9), (39, 126, 0, 10), (39, 1, 0, 11), (39, 27, 0, 12), (39, 123, 0, 13), (39, 19, 0, 14), (39, 116, 0, 15), (39, 87, 0, 16), (39, 62, 0, 17), (39, 18, 0, 18), (39, 2, 0, 19), (39, 22, 0, 20), (36, 110, 0, 0), (36, 90, 0, 1), (36, 86, 0, 2), (36, 3, 0, 3), (36, 30, 0, 4), (36, 4, 0, 5), (36, 45, 0, 6), (36, 6, 0, 7), (36, 14, 0, 8), (36, 8, 0, 9), (36, 7, 0, 10), (36, 10, 0, 11), (36, 11, 0, 12), (36, 26, 0, 13), (36, 126, 0, 14), (36, 1, 0, 15), (36, 27, 0, 16), (36, 123, 0, 17), (36, 19, 0, 18), (36, 116, 0, 19), (36, 87, 0, 20), (36, 62, 0, 21), (36, 18, 0, 22), (36, 2, 0, 23), (36, 22, 0, 24), (34, 110, 0, 0), (34, 90, 0, 1), (34, 108, 0, 2), (34, 14, 0, 3), (34, 8, 0, 4), (34, 7, 0, 5), (34, 26, 0, 6), (34, 126, 0, 7), (34, 1, 0, 8), (34, 27, 0, 9), (34, 123, 0, 10), (34, 19, 0, 11), (34, 116, 0, 12), (34, 87, 0, 13), (34, 62, 0, 14), (34, 18, 0, 15), (34, 2, 0, 16), (34, 22, 0, 17), (21, 113, 0, 0), (21, 90, 0, 1), (21, 14, 0, 2), (21, 26, 0, 3), (21, 126, 0, 4), (21, 1, 0, 5), (21, 27, 0, 6), (21, 116, 0, 7), (21, 87, 0, 8), (21, 2, 0, 9), (21, 22, 0, 10), (35, 110, 0, 0), (35, 90, 0, 1), (35, 85, 0, 2), (35, 3, 0, 3), (35, 30, 0, 4), (35, 4, 0, 5), (35, 45, 0, 6), (35, 6, 0, 7), (35, 14, 0, 8), (35, 8, 0, 9), (35, 7, 0, 10), (35, 10, 0, 11), (35, 11, 0, 12), (35, 26, 0, 13), (35, 126, 0, 14), (35, 1, 0, 15), (35, 27, 0, 16), (35, 123, 0, 17), (35, 19, 0, 18), (35, 116, 0, 19), (35, 87, 0, 20), (35, 62, 0, 21), (35, 18, 0, 22), (35, 2, 0, 23), (35, 22, 0, 24), (11, 110, 0, 0), (11, 90, 0, 1), (11, 21, 0, 2), (11, 7, 0, 3), (11, 14, 0, 4), (11, 122, 0, 5), (11, 63, 0, 6), (11, 77, 0, 7), (11, 26, 0, 8), (11, 126, 0, 9), (11, 1, 0, 10), (11, 27, 0, 11), (11, 123, 0, 12), (11, 19, 0, 13), (11, 116, 0, 14), (11, 87, 0, 15), (11, 62, 0, 16), (11, 18, 0, 17), (11, 2, 0, 18), (11, 22, 0, 19), (25, 110, 0, 0), (25, 90, 0, 1), (25, 104, 0, 2), (25, 79, 0, 3), (25, 14, 0, 4), (25, 26, 0, 5), (25, 126, 0, 6), (25, 1, 0, 7), (25, 27, 0, 8), (25, 116, 0, 9), (25, 87, 0, 10), (25, 2, 0, 11), (25, 22, 0, 12), (18, 110, 0, 0), (18, 90, 0, 1), (18, 46, 0, 2), (18, 8, 0, 3), (18, 45, 0, 4), (18, 99, 0, 5), (18, 10, 0, 6), (18, 41, 0, 7), (18, 40, 0, 8), (18, 42, 0, 9), (18, 14, 0, 10), (18, 7, 0, 11), (18, 26, 0, 12), (18, 126, 0, 13), (18, 1, 0, 14), (18, 27, 0, 15), (18, 116, 0, 16), (18, 87, 0, 17), (18, 2, 0, 18), (18, 22, 0, 19), (24, 110, 0, 0), (24, 90, 0, 1), (24, 14, 0, 2), (24, 26, 0, 3), (24, 126, 0, 4), (24, 1, 0, 5), (24, 27, 0, 6), (24, 116, 0, 7), (24, 87, 0, 8), (24, 2, 0, 9), (24, 22, 0, 10), (10, 110, 0, 0), (10, 90, 0, 1), (10, 64, 0, 2), (10, 14, 0, 3), (10, 8, 0, 4), (10, 7, 0, 5), (10, 26, 0, 6), (10, 126, 0, 7), (10, 1, 0, 8), (10, 27, 0, 9), (10, 123, 0, 10), (10, 19, 0, 11), (10, 116, 0, 12), (10, 87, 0, 13), (10, 62, 0, 14), (10, 18, 0, 15), (10, 2, 0, 16), (10, 22, 0, 17), (4, 110, 0, 0), (4, 90, 0, 1), (4, 12, 0, 2), (4, 8, 0, 3), (4, 7, 0, 4), (4, 14, 0, 5), (4, 4, 0, 6), (4, 5, 0, 7), (4, 15, 0, 8), (4, 137, 0, 9), (4, 138, 0, 10), (4, 10, 0, 11), (4, 3, 0, 12), (4, 28, 0, 13), (4, 29, 0, 14), (4, 25, 0, 15), (4, 26, 0, 16), (4, 126, 0, 17), (4, 1, 0, 18), (4, 27, 0, 19), (4, 139, 0, 20), (4, 140, 0, 21), (4, 13, 0, 22), (4, 123, 0, 23), (4, 19, 0, 24), (4, 116, 0, 25), (4, 87, 0, 26), (4, 62, 0, 27), (4, 18, 0, 28), (4, 2, 0, 29), (4, 22, 0, 30), (8, 110, 0, 0), (8, 90, 0, 1), (8, 65, 0, 2), (8, 14, 0, 3), (8, 133, 0, 4), (8, 26, 0, 5), (8, 126, 0, 6), (8, 1, 0, 7), (8, 27, 0, 8), (8, 123, 0, 9), (8, 19, 0, 10), (8, 116, 0, 11), (8, 87, 0, 12), (8, 62, 0, 13), (8, 18, 0, 14), (8, 2, 0, 15), (8, 22, 0, 16), (5, 110, 0, 0), (5, 90, 0, 1), (5, 12, 0, 2), (5, 8, 0, 3), (5, 7, 0, 4), (5, 14, 0, 5), (5, 4, 0, 6), (5, 5, 0, 7), (5, 10, 0, 8), (5, 13, 0, 9), (5, 26, 0, 10), (5, 126, 0, 11), (5, 1, 0, 12), (5, 27, 0, 13), (5, 123, 0, 14), (5, 19, 0, 15), (5, 116, 0, 16), (5, 87, 0, 17), (5, 62, 0, 18), (5, 18, 0, 19), (5, 2, 0, 20), (5, 22, 0, 21), (9, 110, 0, 0), (9, 90, 0, 1), (9, 66, 0, 2), (9, 31, 0, 3), (9, 7, 0, 4), (9, 14, 0, 5), (9, 118, 0, 6), (9, 60, 0, 7), (9, 26, 0, 8), (9, 126, 0, 9), (9, 1, 0, 10), (9, 27, 0, 11), (9, 123, 0, 12), (9, 19, 0, 13), (9, 116, 0, 14), (9, 87, 0, 15), (9, 62, 0, 16), (9, 18, 0, 17), (9, 2, 0, 18), (9, 22, 0, 19), (22, 110, 0, 0), (22, 90, 0, 1), (22, 67, 0, 2), (22, 68, 0, 3), (22, 28, 0, 4), (22, 6, 0, 5), (22, 8, 0, 6), (22, 7, 0, 7), (22, 14, 0, 8), (22, 26, 0, 9), (22, 11, 0, 10), (22, 126, 0, 11), (22, 1, 0, 12), (22, 27, 0, 13), (22, 123, 0, 14), (22, 19, 0, 15), (22, 116, 0, 16), (22, 87, 0, 17), (22, 62, 0, 18), (22, 18, 0, 19), (22, 2, 0, 20), (22, 22, 0, 21), (6, 110, 0, 0), (6, 90, 0, 1), (6, 12, 0, 2), (6, 8, 0, 3), (6, 7, 0, 4), (6, 14, 0, 5), (6, 4, 0, 6), (6, 5, 0, 7), (6, 6, 0, 8), (6, 15, 0, 9), (6, 10, 0, 10), (6, 13, 0, 11), (6, 26, 0, 12), (6, 126, 0, 13), (6, 1, 0, 14), (6, 27, 0, 15), (6, 123, 0, 16), (6, 19, 0, 17), (6, 116, 0, 18), (6, 87, 0, 19), (6, 62, 0, 20), (6, 18, 0, 21), (6, 2, 0, 22), (6, 22, 0, 23), (19, 110, 0, 0), (19, 90, 0, 1), (19, 7, 0, 2), (19, 102, 0, 3), (19, 48, 0, 4), (19, 120, 0, 5), (19, 50, 0, 6), (19, 121, 0, 7), (19, 10, 0, 8), (19, 103, 0, 9), (19, 51, 0, 10), (19, 52, 0, 11), (19, 141, 0, 12), (19, 53, 0, 13), (19, 54, 0, 14), (19, 26, 0, 15), (19, 126, 0, 16), (19, 1, 0, 17), (19, 27, 0, 18), (19, 116, 0, 19), (19, 87, 0, 20), (19, 2, 0, 21), (19, 22, 0, 22), (31, 110, 0, 0), (31, 90, 0, 1), (31, 28, 0, 2), (31, 105, 0, 3), (31, 80, 0, 4), (31, 14, 0, 5), (31, 8, 0, 6), (31, 7, 0, 7), (31, 77, 0, 8), (31, 26, 0, 9), (31, 126, 0, 10), (31, 1, 0, 11), (31, 27, 0, 12), (31, 116, 0, 13), (31, 87, 0, 14), (31, 2, 0, 15), (31, 22, 0, 16), (38, 110, 0, 0), (38, 90, 0, 1), (38, 122, 0, 2), (38, 124, 0, 3), (38, 125, 0, 4), (38, 7, 0, 5), (38, 14, 0, 6), (38, 3, 0, 7), (38, 30, 0, 8), (38, 26, 0, 9), (38, 126, 0, 10), (38, 1, 0, 11), (38, 27, 0, 12), (38, 123, 0, 13), (38, 19, 0, 14), (38, 116, 0, 15), (38, 87, 0, 16), (38, 62, 0, 17), (38, 18, 0, 18), (38, 2, 0, 19), (38, 22, 0, 20), (27, 110, 0, 0), (27, 90, 0, 1), (27, 74, 0, 2), (27, 14, 0, 3), (27, 75, 0, 4), (27, 7, 0, 5), (27, 3, 0, 6), (27, 142, 0, 7), (27, 26, 0, 8), (27, 126, 0, 9), (27, 1, 0, 10), (27, 27, 0, 11), (27, 116, 0, 12), (27, 87, 0, 13), (27, 2, 0, 14), (27, 22, 0, 15), (30, 110, 0, 0), (30, 90, 0, 1), (30, 119, 0, 2), (30, 105, 0, 3), (30, 71, 0, 4), (30, 78, 0, 5), (30, 7, 0, 6), (30, 14, 0, 7), (30, 77, 0, 8), (30, 26, 0, 9), (30, 126, 0, 10), (30, 1, 0, 11), (30, 27, 0, 12), (30, 123, 0, 13), (30, 19, 0, 14), (30, 116, 0, 15), (30, 87, 0, 16), (30, 62, 0, 17), (30, 18, 0, 18), (30, 2, 0, 19), (30, 22, 0, 20), (15, 110, 0, 0), (15, 90, 0, 1), (15, 92, 0, 2), (15, 32, 0, 3), (15, 31, 0, 4), (15, 7, 0, 5), (15, 14, 0, 6), (15, 28, 0, 7), (15, 30, 0, 8), (15, 10, 0, 9), (15, 26, 0, 10), (15, 11, 0, 11), (15, 126, 0, 12), (15, 1, 0, 13), (15, 27, 0, 14), (15, 13, 0, 15), (15, 123, 0, 16), (15, 19, 0, 17), (15, 116, 0, 18), (15, 87, 0, 19), (15, 62, 0, 20), (15, 18, 0, 21), (15, 2, 0, 22), (15, 22, 0, 23), (40, 110, 0, 0), (40, 90, 0, 1), (40, 132, 0, 2), (40, 46, 0, 3), (40, 108, 0, 4), (40, 60, 0, 5), (40, 81, 0, 6), (40, 6, 0, 7), (40, 131, 0, 8), (40, 14, 0, 9), (40, 8, 0, 10), (40, 7, 0, 11), (40, 137, 0, 12), (40, 138, 0, 13), (40, 11, 0, 14), (40, 26, 0, 15), (40, 126, 0, 16), (40, 1, 0, 17), (40, 27, 0, 18), (40, 123, 0, 19), (40, 19, 0, 20), (40, 116, 0, 21), (40, 118, 0, 22), (40, 87, 0, 23), (40, 62, 0, 24), (40, 18, 0, 25), (40, 2, 0, 26), (40, 22, 0, 27), (20, 112, 0, 0), (20, 90, 0, 1), (20, 36, 0, 2), (20, 55, 0, 3), (20, 101, 0, 4), (20, 100, 0, 5), (20, 10, 0, 6), (20, 15, 0, 7), (20, 40, 0, 8), (20, 42, 0, 9), (20, 26, 0, 10), (20, 126, 0, 11), (20, 1, 0, 12), (20, 27, 0, 13), (20, 116, 0, 14), (20, 87, 0, 15), (20, 2, 0, 16), (20, 22, 0, 17), (7, 110, 0, 0), (7, 90, 0, 1), (7, 69, 0, 2), (7, 89, 0, 3), (7, 7, 0, 4), (7, 14, 0, 5), (7, 3, 0, 6), (7, 30, 0, 7), (7, 118, 0, 8), (7, 26, 0, 9), (7, 11, 0, 10), (7, 126, 0, 11), (7, 1, 0, 12), (7, 27, 0, 13), (7, 13, 0, 14), (7, 123, 0, 15), (7, 19, 0, 16), (7, 116, 0, 17), (7, 87, 0, 18), (7, 62, 0, 19), (7, 18, 0, 20), (7, 2, 0, 21), (7, 22, 0, 22), (29, 110, 0, 0), (29, 90, 0, 1), (29, 119, 0, 2), (29, 105, 0, 3), (29, 63, 0, 4), (29, 78, 0, 5), (29, 7, 0, 6), (29, 14, 0, 7), (29, 77, 0, 8), (29, 26, 0, 9), (29, 126, 0, 10), (29, 1, 0, 11), (29, 27, 0, 12), (29, 123, 0, 13), (29, 19, 0, 14), (29, 116, 0, 15), (29, 87, 0, 16), (29, 62, 0, 17), (29, 18, 0, 18), (29, 2, 0, 19), (29, 22, 0, 20), (28, 110, 0, 0), (28, 90, 0, 1), (28, 63, 0, 2), (28, 28, 0, 3), (28, 4, 0, 4), (28, 45, 0, 5), (28, 76, 0, 6), (28, 7, 0, 7), (28, 14, 0, 8), (28, 77, 0, 9), (28, 11, 0, 10), (28, 26, 0, 11), (28, 126, 0, 12), (28, 1, 0, 13), (28, 27, 0, 14), (28, 123, 0, 15), (28, 19, 0, 16), (28, 116, 0, 17), (28, 87, 0, 18), (28, 62, 0, 19), (28, 18, 0, 20), (28, 2, 0, 21), (28, 22, 0, 22), (13, 110, 0, 0), (13, 90, 0, 1), (13, 91, 0, 2), (13, 70, 0, 3), (13, 14, 0, 4), (13, 8, 0, 5), (13, 7, 0, 6), (13, 26, 0, 7), (13, 126, 0, 8), (13, 1, 0, 9), (13, 27, 0, 10), (13, 116, 0, 11), (13, 87, 0, 12), (13, 2, 0, 13), (13, 22, 0, 14)

(4)(+0000003): INSERT INTO baseFieldMappings VALUES (12, 109, 59), (26, 109, 71), (26, 8, 72), (16, 60, 93), (16, 4, 94), (16, 10, 95), (16, 127, 41), (23, 12, 107), (23, 108, 70), (2, 109, 130), (3, 12, 115), (3, 109, 130), (17, 110, 111), (17, 127, 44), (17, 14, 96), (17, 60, 117), (17, 4, 97), (17, 10, 98), (32, 8, 83), (33, 12, 114), (39, 60, 128), (39, 8, 124), (39, 7, 129), (39, 109, 130), (36, 12, 86), (21, 110, 113), (35, 12, 85), (11, 8, 21), (11, 108, 122), (11, 109, 63), (25, 12, 104), (25, 108, 79), (18, 60, 99), (18, 127, 41), (10, 109, 64), (8, 108, 65), (9, 108, 66), (9, 8, 31), (22, 108, 67), (19, 127, 120), (19, 60, 50), (19, 14, 52), (19, 134, 141), (19, 131, 54), (31, 60, 105), (31, 109, 80), (38, 108, 122), (38, 8, 124), (38, 60, 125), (27, 108, 74), (27, 12, 142), (30, 12, 119), (30, 60, 105), (30, 109, 71), (30, 8, 78), (15, 60, 92), (15, 108, 32), (15, 8, 31), (40, 127, 132), (20, 110, 112), (20, 60, 101), (20, 14, 100), (7, 108, 69), (7, 8, 89), (29, 12, 119), (29, 60, 105), (29, 109, 63), (29, 8, 78), (28, 109, 63), (28, 8, 76), (13, 12, 91), (13, 108, 70)

(4)(+0000000): INSERT INTO itemTypeCreatorTypes VALUES (12, 22, 1), (12, 2, 0), (26, 17, 1), (26, 30, 0), (26, 18, 0), (26, 19, 0), (26, 4, 0), (26, 2, 0), (16, 12, 1), (16, 28, 0), (16, 2, 0), (23, 1, 1), (23, 4, 0), (23, 23, 0), (23, 2, 0), (2, 1, 1), (2, 2, 0), (2, 3, 0), (2, 4, 0), (2, 5, 0), (3, 1, 1), (3, 2, 0), (3, 3, 0), (3, 29, 0), (3, 4, 0), (3, 5, 0), (17, 1, 1), (17, 13, 0), (17, 2, 0), (32, 21, 1), (32, 2, 0), (33, 1, 1), (33, 2, 0), (33, 3, 0), (33, 4, 0), (33, 5, 0), (39, 1, 1), (39, 2, 0), (36, 1, 1), (36, 2, 0), (36, 3, 0), (36, 4, 0), (36, 5, 0), (34, 1, 1), (34, 2, 0), (34, 3, 0), (34, 4, 0), (34, 27, 0), (21, 1, 1), (21, 4, 0), (21, 2, 0), (21, 16, 0), (35, 1, 1), (35, 2, 0), (35, 3, 0), (35, 4, 0), (35, 5, 0), (11, 8, 1), (11, 10, 0), (11, 9, 0), (11, 11, 0), (11, 31, 0), (11, 25, 0), (11, 32, 0), (11, 4, 0), (11, 2, 0), (25, 1, 1), (25, 2, 0), (18, 2, 1), (24, 1, 1), (24, 2, 0), (24, 16, 0), (10, 6, 1), (10, 2, 0), (10, 7, 0), (10, 4, 0), (4, 1, 1), (4, 2, 0), (4, 3, 0), (4, 4, 0), (4, 27, 0), (8, 1, 1), (8, 16, 0), (8, 2, 0), (8, 4, 0), (5, 1, 1), (5, 2, 0), (5, 4, 0), (5, 27, 0), (9, 1, 1), (9, 2, 0), (9, 4, 0), (22, 20, 1), (22, 2, 0), (22, 5, 0), (6, 1, 1), (6, 2, 0), (6, 4, 0), (6, 27, 0), (19, 14, 1), (19, 15, 0), (19, 2, 0), (31, 26, 1), (31, 25, 0), (31, 10, 0), (31, 33, 0), (31, 34, 0), (31, 8, 0), (31, 9, 0), (31, 11, 0), (31, 4, 0), (31, 2, 0), (38, 1, 1), (38, 2, 0), (38, 3, 0), (38, 4, 0), (38, 27, 0), (27, 24, 1), (27, 35, 0), (27, 36, 0), (27, 2, 0), (27, 4, 0), (30, 37, 1), (30, 31, 0), (30, 25, 0), (30, 10, 0), (30, 33, 0), (30, 34, 0), (30, 8, 0), (30, 9, 0), (30, 11, 0), (30, 4, 0), (30, 2, 0), (15, 1, 1), (15, 3, 0), (15, 2, 0), (15, 4, 0), (15, 5, 0), (40, 1, 1), (40, 3, 0), (40, 2, 0), (20, 1, 1), (20, 2, 0), (7, 1, 1), (7, 2, 0), (29, 8, 1), (29, 10, 0), (29, 33, 0), (29, 34, 0), (29, 9, 0), (29, 11, 0), (29, 31, 0), (29, 25, 0), (29, 32, 0), (29, 4, 0), (29, 2, 0), (28, 37, 1), (28, 8, 0), (28, 10, 0), (28, 9, 0), (28, 33, 0), (28, 11, 0), (28, 31, 0), (28, 25, 0), (28, 32, 0), (28, 4, 0), (28, 2, 0), (13, 1, 1), (13, 2, 0), (13, 4, 0)

(4)(+0000065): REPLACE INTO settings VALUES ('globalSchema', 'data', :data)

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

(3)(+0000001): Getting contents of [xpconnect wrapped nsIChannel]

(3)(+0000008): Updating custom tables

(4)(+0000000): PRAGMA foreign_keys

(4)(+0000001): DELETE FROM itemTypesCombined

(4)(+0000000): DELETE FROM fieldsCombined

(4)(+0000001): DELETE FROM itemTypeFieldsCombined

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

(4)(+0000001): 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 ('webpage', 'attachment', 'note', 'annotation')

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

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

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

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

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

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

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

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

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

(4)(+0000006): 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)(+0000005): SELECT itemTypeID, creatorTypeID FROM itemTypeCreatorTypes WHERE primaryField=1

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

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

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

(4)(+0000003): REPLACE INTO settings VALUES ('globalSchema', 'migrateExtra', 1)

(4)(+0000011): Committed DB transaction oUy4LsQO

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