Package: libreoffice-zotero-integration
Version: 4.0.29.5+dfsg-1
Severity: important
Dear Maintainer,
although the libreoffice-zotero-extension installs the icon bar succesfully
clicking on these icons don't have any effect, therefore rendering this
extension useless. The debug log inside Zotero contains several errors.
Thanks for your help!
Maria
-- JRE Version --
Aus aptitude:
openjdk-8-jre: 8u91-b14-2
Aus LibreOffice:
Oracle Corporation 1.8.0_91
-- System Information:
Debian Release: stretch/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 4.5.0-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages libreoffice-zotero-integration depends on:
ii libjackson2-annotations-java 2.7.3-1
ii libjackson2-core-java 2.7.3-1
ii libjackson2-databind-java 2.7.4-1
ii libjna-java 4.2.2-1
ii libreoffice-java-common 1:5.1.3-2
ii ure 5.1.3-2
ii xul-ext-zotero 4.0.29.5+dfsg-1
ii zotero-standalone 4.0.29.5+dfsg-1
Versions of packages libreoffice-zotero-integration recommends:
ii libreoffice-writer 1:5.1.3-2
libreoffice-zotero-integration suggests no packages.
-- no debconf information
*** /home/poetic-terrorist/Downloads/debug-zotero-integration_16-06-03.txt
[JavaScript Error: "Translator with ID f46cc903-c447-47d6-a2cf-c75ed22dc96b
already loaded from "CAIRN Info.js"" {file:
"file:///home/user/.mozilla/firefox/user.Zotero/zotero/translators/Cairn.info.js"
line: 0}]
[JavaScript Error: "Overwriting translator with same filename 'Cairn.info.js'
in Zotero.Schema.updateBundledFiles()" {file:
"chrome://zotero/content/xpcom/schema.js" line: 809}]
1464956550372 addons.update-checker WARN Update manifest for
[email protected] did not contain an updates property
[JavaScript Error: "updateButton is null" {file:
"chrome://zotero/content/preferences/preferences_search.js" line: 152}]
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "updateButton is null" {file:
"chrome://zotero/content/preferences/preferences_search.js" line: 152}]
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
[JavaScript Error: "TypeError: temp is null" {file:
"chrome://global/content/bindings/preferences.xml" line: 1210}]
getPreferenceElement@chrome://global/content/bindings/preferences.xml:1210:11
userChangedValue@chrome://global/content/bindings/preferences.xml:1250:25
onxblcommand@chrome://global/content/bindings/preferences.xml:1289:9
version => 4.0.29.5+dfsg-1, platform => Linux x86_64, oscpu => Linux x86_64,
locale => en-US, appName => Zotero, appVersion => 4.0.29.5+dfsg-1
=========================================================
(3)(+0000000): Refreshing styles list
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":4,"day":20}
(3)(+0000001): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":3,"day":30}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2010,"month":6,"day":26}
(3)(+0000001): DATE: retrieved with algorithms:
{"order":"ymd","year":2016,"month":4,"day":25}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2010,"month":6,"day":26}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":6}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":11,"day":16}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":7,"day":15}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":7,"day":15}
(3)(+0000001): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":10}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":6}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":2,"day":14}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":4,"day":20}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":4,"day":16}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":10}
(3)(+0000001): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":11,"day":16}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":3}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":7,"day":22}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":11,"day":16}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":21}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2009,"month":8,"day":13}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2016,"month":2,"day":10}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":4,"day":30}
(3)(+0000001): DATE: retrieved with algorithms:
{"order":"ymd","year":2016,"month":2,"day":10}
(3)(+1267732): Viewing item in pane 0
(3)(+0000001): Refreshing item box
(5)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM
itemTypesCombined
(3)(+0000019): DATE: retrieved with algorithms:
{"order":"dmy","month":11,"day":15,"year":1989}
(5)(+0000008): SELECT creatorTypeID AS id, creatorType AS name FROM
itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY
primaryField=1 DESC, name
(5)(+0000001): Binding parameter 1 of type int: 35
(5)(+0000000): SELECT creatorTypeID AS id, creatorType AS name FROM
creatorTypes
(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators
WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 178
(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 85
(3)(+0000001): Loading data for creator 85 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 85
(5)(+0001495): SELECT collectionID FROM collections WHERE collectionID IN
(SELECT collectionID FROM collectionItems WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 178
(3)(+0531779): Refreshing styles list
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":4,"day":20}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":3,"day":30}
(3)(+0000001): DATE: retrieved with algorithms:
{"order":"ymd","year":2010,"month":6,"day":26}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2016,"month":4,"day":25}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2010,"month":6,"day":26}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":6}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":11,"day":16}
(3)(+0000001): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":7,"day":15}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":7,"day":15}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":10}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":6}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":2,"day":14}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":4,"day":20}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":4,"day":16}
(3)(+0000001): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":10}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":11,"day":16}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":3}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":7,"day":22}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2015,"month":11,"day":16}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":8,"day":21}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2009,"month":8,"day":13}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2016,"month":2,"day":10}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2014,"month":4,"day":30}
(3)(+0000000): DATE: retrieved with algorithms:
{"order":"ymd","year":2016,"month":2,"day":10}
(5)(+0372253): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000001): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE
libraryID IS NULL AND dateDeleted<=DATE('NOW', '-30 DAYS')
(5)(+0000003): Transaction in progress -- increasing level to 1
(3)(+0000000): Deleting item 446
(5)(+0000000): Transaction in progress -- increasing level to 2
(5)(+0000001): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 446
(5)(+0000009): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000002): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators
WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
(5)(+0000001): Binding parameter 1 of type int: 249
(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 250
(3)(+0000000): Loading data for creator 249 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 249
(3)(+0000001): Loading data for creator 250 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 250
(5)(+0000001): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE
sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL
JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT
JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND
A.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT linkMode FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT charsetID AS id, charset AS name FROM charsets
(1)(+0000004): Invalid character set null
(5)(+0000001): SELECT path FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000001): Binding parameter 1 of type int: 446
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 226
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000001): Binding parameter 1 of type int: 227
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 228
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 229
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 230
(5)(+0000001): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 231
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): SELECT itemID FROM itemNotes WHERE sourceItemID=?1 UNION SELECT
itemID FROM itemAttachments WHERE sourceItemID=?1
(5)(+0000000): Binding parameter 1 of type int: 446
(3)(+0000000): Deleting item 447
(5)(+0000001): Transaction in progress -- increasing level to 3
(1)(+0000000): Invalid character set null
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT sourceItemID FROM itemAttachments WHERE itemID=447
(3)(+0000000): getAttachmentLinkMode() deprecated -- use .attachmentLinkMode
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT rowid FROM fulltextItems WHERE itemID=? LIMIT 1
(5)(+0000001): Binding parameter 1 of type int: 447
(5)(+0000000): Decreasing transaction level to 3
(3)(+0000000): Clearing full-text cache file for item 447
(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND
key='userID'
(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND
key='localUserKey'
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/U833EXH7";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/U833EXH7";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 3
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000001): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000002): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 447
(5)(+0000000): Decreasing transaction level to 2
(3)(+0000000): Notifier.trigger('modify', 'item', [446]) queued
(3)(+0000000): Notifier.trigger('delete', 'item', [447]) queued
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/3VGW8ENK";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/3VGW8ENK";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 2
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): DELETE FROM itemCreators WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000001): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): DELETE FROM itemTags WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000001): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 446
(5)(+0000000): Decreasing transaction level to 1
(3)(+0000000): Notifier.trigger('delete', 'item', [446]) queued
(3)(+0000000): Deleting item 72
(5)(+0000000): Transaction in progress -- increasing level to 2
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000001): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 72
(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators
WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE
sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL
JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT
JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND
A.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): SELECT itemID FROM itemNotes WHERE sourceItemID=?1 UNION SELECT
itemID FROM itemAttachments WHERE sourceItemID=?1
(5)(+0000000): Binding parameter 1 of type int: 72
(3)(+0000000): Deleting item 109
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): SELECT linkMode FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000001): SELECT mimeType FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(1)(+0000000): Invalid character set null
(5)(+0000000): SELECT path FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): SELECT sourceItemID FROM itemAttachments WHERE itemID=109
(3)(+0000000): getAttachmentLinkMode() deprecated -- use .attachmentLinkMode
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT rowid FROM fulltextItems WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000001): Decreasing transaction level to 3
(3)(+0000000): Clearing full-text cache file for item 109
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/SIFGNKRX";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/SIFGNKRX";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 3
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 109
(5)(+0000000): Decreasing transaction level to 2
(3)(+0000000): Notifier.trigger('modify', 'item', [72]) queued
(3)(+0000000): Notifier.trigger('delete', 'item', [109]) queued
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/4JX7MT83";
(5)(+0000001): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/4JX7MT83";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 2
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): DELETE FROM itemCreators WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 72
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 72
(5)(+0000000): Decreasing transaction level to 1
(3)(+0000000): Notifier.trigger('delete', 'item', [72]) queued
(3)(+0000000): Deleting item 70
(5)(+0000000): Transaction in progress -- increasing level to 2
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators
WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 50
(3)(+0000000): Loading data for creator 50 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 50
(5)(+0000001): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE
sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL
JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT
JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND
A.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000001): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 69
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 45
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 46
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT itemID FROM collectionItems WHERE collectionID=? AND
itemID NOT IN (SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL) AND
itemID NOT IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT
NULL)
(5)(+0000000): Binding parameter 1 of type int: 6
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): DELETE FROM collectionItems WHERE collectionID=? AND itemID=?
(5)(+0000000): Binding parameter 1 of type int: 6
(5)(+0000000): Binding parameter 2 of type int: 70
(5)(+0000000): UPDATE collections SET dateModified=?, clientDateModified=?
WHERE collectionID=?
(5)(+0000001): Binding parameter 1 of type string: "2016-06-03 13:10:40"
(5)(+0000000): Binding parameter 2 of type string: "2016-06-03 13:10:40"
(5)(+0000000): Binding parameter 3 of type int: 6
(5)(+0000000): Decreasing transaction level to 2
(3)(+0000000): Reloading collections 6
(5)(+0000000): SELECT C.*, (SELECT COUNT(*) FROM collections WHERE
parentCollectionID=C.collectionID)!=0 AS hasChildCollections, (SELECT COUNT(*)
FROM collectionItems WHERE collectionID=C.collectionID)!=0 AS hasChildItems
FROM collections C WHERE 1 AND collectionID IN (6)
(3)(+0000000): Notifier.trigger('remove', 'collection-item', [6-70]) queued
(5)(+0000000): SELECT itemID FROM itemNotes WHERE sourceItemID=?1 UNION SELECT
itemID FROM itemAttachments WHERE sourceItemID=?1
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/5FCBES3R";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/5FCBES3R";
(5)(+0000001): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 2
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): DELETE FROM itemCreators WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): DELETE FROM itemTags WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000001): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 70
(5)(+0000000): Decreasing transaction level to 1
(3)(+0000000): Notifier.trigger('delete', 'item', [70]) queued
(3)(+0000000): Deleting item 472
(5)(+0000000): Transaction in progress -- increasing level to 2
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators
WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 258
(3)(+0000000): Loading data for creator 258 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 258
(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE
sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL
JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT
JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND
A.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): SELECT itemID FROM itemNotes WHERE sourceItemID=?1 UNION SELECT
itemID FROM itemAttachments WHERE sourceItemID=?1
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/9JNSWB57";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/9JNSWB57";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 2
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): DELETE FROM itemCreators WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 472
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 472
(5)(+0000000): Decreasing transaction level to 1
(3)(+0000000): Notifier.trigger('delete', 'item', [472]) queued
(3)(+0000000): Deleting item 450
(5)(+0000000): Transaction in progress -- increasing level to 2
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000001): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators
WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 251
(3)(+0000000): Loading data for creator 251 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 251
(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE
sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000001): Binding parameter 1 of type int: 450
(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL
JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT
JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND
A.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT linkMode FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT path FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000001): SELECT note FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): SELECT itemID FROM itemNotes WHERE sourceItemID=?1 UNION SELECT
itemID FROM itemAttachments WHERE sourceItemID=?1
(5)(+0000000): Binding parameter 1 of type int: 450
(3)(+0000000): Deleting item 451
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000001): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT sourceItemID FROM itemAttachments WHERE itemID=451
(3)(+0000000): getAttachmentLinkMode() deprecated -- use .attachmentLinkMode
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT rowid FROM fulltextItems WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): DELETE FROM fulltextItemWords WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 451
(5)(+0000030): DELETE FROM fulltextItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000001): Decreasing transaction level to 3
(3)(+0000000): Clearing full-text cache file for item 451
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/QP88K3MR";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/QP88K3MR";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 3
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000001): Binding parameter 1 of type int: 451
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000001): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 451
(5)(+0000000): Decreasing transaction level to 2
(3)(+0000000): Notifier.trigger('modify', 'item', [450]) queued
(3)(+0000000): Notifier.trigger('delete', 'item', [451]) queued
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000001): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/A2R68I58";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/A2R68I58";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 2
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): DELETE FROM itemCreators WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000001): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 450
(5)(+0000000): Decreasing transaction level to 1
(3)(+0000000): Notifier.trigger('delete', 'item', [450]) queued
(3)(+0000000): Deleting item 452
(5)(+0000000): Transaction in progress -- increasing level to 2
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 452
(5)(+0000000): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 452
(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators
WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 252
(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 253
(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
(5)(+0000001): Binding parameter 1 of type int: 254
(3)(+0000000): Loading data for creator 252 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 252
(3)(+0000000): Loading data for creator 253 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 253
(3)(+0000001): Loading data for creator 254 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 254
(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE
sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL
JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT
JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND
A.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT linkMode FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(1)(+0000000): Invalid character set null
(5)(+0000000): SELECT path FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 232
(5)(+0000001): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 233
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 228
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 234
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 235
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 236
(5)(+0000001): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 238
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 239
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 237
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 240
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 241
(5)(+0000001): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): SELECT itemID FROM itemNotes WHERE sourceItemID=?1 UNION SELECT
itemID FROM itemAttachments WHERE sourceItemID=?1
(5)(+0000000): Binding parameter 1 of type int: 452
(3)(+0000000): Deleting item 453
(5)(+0000000): Transaction in progress -- increasing level to 3
(1)(+0000000): Invalid character set null
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000001): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT sourceItemID FROM itemAttachments WHERE itemID=453
(3)(+0000000): getAttachmentLinkMode() deprecated -- use .attachmentLinkMode
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT rowid FROM fulltextItems WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): Decreasing transaction level to 3
(3)(+0000000): Clearing full-text cache file for item 453
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/3TUAINKU";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/3TUAINKU";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 3
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000001): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 453
(5)(+0000000): Decreasing transaction level to 2
(3)(+0000000): Notifier.trigger('modify', 'item', [452]) queued
(3)(+0000000): Notifier.trigger('delete', 'item', [453]) queued
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000001): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/AC9IFENU";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/AC9IFENU";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 2
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): DELETE FROM itemCreators WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000001): DELETE FROM itemTags WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 452
(5)(+0000000): Decreasing transaction level to 1
(3)(+0000000): Notifier.trigger('delete', 'item', [452]) queued
(3)(+0000000): Deleting item 454
(5)(+0000000): Transaction in progress -- increasing level to 2
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000001): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators
WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE
sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL
JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT
JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND
A.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT linkMode FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT path FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000001): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT linkMode FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(1)(+0000000): Invalid character set null
(5)(+0000000): SELECT path FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): SELECT itemID FROM itemNotes WHERE sourceItemID=?1 UNION SELECT
itemID FROM itemAttachments WHERE sourceItemID=?1
(5)(+0000000): Binding parameter 1 of type int: 454
(3)(+0000000): Deleting item 455
(5)(+0000000): Transaction in progress -- increasing level to 3
(1)(+0000000): Invalid character set null
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT sourceItemID FROM itemAttachments WHERE itemID=455
(3)(+0000000): getAttachmentLinkMode() deprecated -- use .attachmentLinkMode
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT rowid FROM fulltextItems WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): Decreasing transaction level to 3
(3)(+0000000): Clearing full-text cache file for item 455
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/SPNHPITT";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/SPNHPITT";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 3
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000001): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 455
(5)(+0000000): Decreasing transaction level to 2
(3)(+0000000): Notifier.trigger('modify', 'item', [454]) queued
(3)(+0000001): Notifier.trigger('delete', 'item', [455]) queued
(3)(+0000000): Deleting item 456
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT sourceItemID FROM itemAttachments WHERE itemID=456
(3)(+0000000): getAttachmentLinkMode() deprecated -- use .attachmentLinkMode
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT rowid FROM fulltextItems WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): DELETE FROM fulltextItemWords WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000001): DELETE FROM fulltextItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): Decreasing transaction level to 3
(3)(+0000000): Clearing full-text cache file for item 456
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/FH34VX4K";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/FH34VX4K";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 3
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 456
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 456
(5)(+0000000): Decreasing transaction level to 2
(3)(+0000000): Notifier.trigger('modify', 'item', [454]) queued
(3)(+0000000): Notifier.trigger('delete', 'item', [456]) queued
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/BRAKVD2G";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/BRAKVD2G";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 2
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 454
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 454
(5)(+0000000): Decreasing transaction level to 1
(3)(+0000000): Notifier.trigger('delete', 'item', [454]) queued
(3)(+0000000): Deleting item 481
(5)(+0000000): Transaction in progress -- increasing level to 2
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT linkMode FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(1)(+0000001): Invalid character set null
(5)(+0000000): SELECT path FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT sourceItemID FROM itemAttachments WHERE itemID=481
(3)(+0000000): getAttachmentLinkMode() deprecated -- use .attachmentLinkMode
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT rowid FROM fulltextItems WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): DELETE FROM fulltextItemWords WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): DELETE FROM fulltextItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): Decreasing transaction level to 2
(3)(+0000000): Clearing full-text cache file for item 481
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/CB58T57C";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/CB58T57C";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 2
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000001): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 481
(5)(+0000000): Decreasing transaction level to 1
(3)(+0000000): Notifier.trigger('delete', 'item', [481]) queued
(3)(+0000000): Deleting item 471
(5)(+0000000): Transaction in progress -- increasing level to 2
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000001): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators
WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 200
(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 236
(3)(+0000000): Loading data for creator 200 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 200
(3)(+0000000): Loading data for creator 236 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 236
(5)(+0000001): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE
sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL
JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT
JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND
A.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 243
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 177
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): SELECT itemID FROM itemNotes WHERE sourceItemID=?1 UNION SELECT
itemID FROM itemAttachments WHERE sourceItemID=?1
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/KZBZZ73A";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/KZBZZ73A";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 2
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): DELETE FROM itemCreators WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000001): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): DELETE FROM itemTags WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 471
(5)(+0000000): Decreasing transaction level to 1
(3)(+0000000): Notifier.trigger('delete', 'item', [471]) queued
(5)(+0000000): Decreasing transaction level to 0
(3)(+0000000): Notifier.trigger('refresh', 'trash', [0]) queued
(5)(+0000000): Committing transaction
(5)(+0000045): SELECT I.*, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC
LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 0
THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN
creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM
itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN
itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY
orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators IC NATURAL
JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT
(SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN
creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' )
END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND
creatorTypeID IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM
itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName
FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' und
' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex
LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN
creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN
(3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM
itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL
WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL
JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 2 THEN
(SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex
LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators
NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER
BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators
NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND
creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS
firstCreator, (SELECT COUNT(*) FROM itemNotes INo WHERE sourceItemID=I.itemID
AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT
COUNT(*) FROM itemAttachments IA WHERE sourceItemID=I.itemID AND IA.itemID NOT
IN (SELECT itemID FROM deletedItems)) AS numAttachments, (CASE I.itemTypeID
WHEN 14 THEN (SELECT sourceItemID FROM itemAttachments IA WHERE
IA.itemID=I.itemID) WHEN 1 THEN (SELECT sourceItemID FROM itemNotes INo WHERE
INo.itemID=I.itemID) END) AS sourceItemID FROM items I WHERE 1 AND I.itemID IN
(446)
(2)(+0000001): Item 446 doesn't exist
(5)(+0000000): SELECT I.*, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC
LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 0
THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN
creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM
itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN
itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY
orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators IC NATURAL
JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT
(SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN
creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' )
END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND
creatorTypeID IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM
itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName
FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' und
' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex
LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN
creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN
(3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM
itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL
WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL
JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 2 THEN
(SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex
LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators
NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER
BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators
NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND
creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS
firstCreator, (SELECT COUNT(*) FROM itemNotes INo WHERE sourceItemID=I.itemID
AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT
COUNT(*) FROM itemAttachments IA WHERE sourceItemID=I.itemID AND IA.itemID NOT
IN (SELECT itemID FROM deletedItems)) AS numAttachments, (CASE I.itemTypeID
WHEN 14 THEN (SELECT sourceItemID FROM itemAttachments IA WHERE
IA.itemID=I.itemID) WHEN 1 THEN (SELECT sourceItemID FROM itemNotes INo WHERE
INo.itemID=I.itemID) END) AS sourceItemID FROM items I WHERE 1 AND I.itemID IN
(72)
(2)(+0000000): Item 72 doesn't exist
(5)(+0000000): SELECT I.*, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC
LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 0
THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN
creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM
itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN
itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY
orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators IC NATURAL
JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT
(SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN
creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' )
END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND
creatorTypeID IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM
itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName
FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' und
' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex
LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN
creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN
(3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM
itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL
WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL
JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 2 THEN
(SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex
LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators
NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER
BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators
NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND
creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS
firstCreator, (SELECT COUNT(*) FROM itemNotes INo WHERE sourceItemID=I.itemID
AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT
COUNT(*) FROM itemAttachments IA WHERE sourceItemID=I.itemID AND IA.itemID NOT
IN (SELECT itemID FROM deletedItems)) AS numAttachments, (CASE I.itemTypeID
WHEN 14 THEN (SELECT sourceItemID FROM itemAttachments IA WHERE
IA.itemID=I.itemID) WHEN 1 THEN (SELECT sourceItemID FROM itemNotes INo WHERE
INo.itemID=I.itemID) END) AS sourceItemID FROM items I WHERE 1 AND I.itemID IN
(450)
(2)(+0000001): Item 450 doesn't exist
(5)(+0000000): SELECT I.*, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC
LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 0
THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN
creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM
itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN
itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY
orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators IC NATURAL
JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT
(SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN
creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' )
END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND
creatorTypeID IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM
itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName
FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' und
' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex
LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN
creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN
(3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM
itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL
WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL
JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 2 THEN
(SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex
LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators
NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER
BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators
NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND
creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS
firstCreator, (SELECT COUNT(*) FROM itemNotes INo WHERE sourceItemID=I.itemID
AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT
COUNT(*) FROM itemAttachments IA WHERE sourceItemID=I.itemID AND IA.itemID NOT
IN (SELECT itemID FROM deletedItems)) AS numAttachments, (CASE I.itemTypeID
WHEN 14 THEN (SELECT sourceItemID FROM itemAttachments IA WHERE
IA.itemID=I.itemID) WHEN 1 THEN (SELECT sourceItemID FROM itemNotes INo WHERE
INo.itemID=I.itemID) END) AS sourceItemID FROM items I WHERE 1 AND I.itemID IN
(452)
(2)(+0000001): Item 452 doesn't exist
(5)(+0000000): SELECT I.*, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC
LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 0
THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN
creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM
itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN
itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY
orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators IC NATURAL
JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT
(SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN
creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' )
END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND
creatorTypeID IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM
itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName
FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' und
' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex
LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN
creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN
(3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM
itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL
WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL
JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 2 THEN
(SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex
LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators
NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER
BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators
NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND
creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS
firstCreator, (SELECT COUNT(*) FROM itemNotes INo WHERE sourceItemID=I.itemID
AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT
COUNT(*) FROM itemAttachments IA WHERE sourceItemID=I.itemID AND IA.itemID NOT
IN (SELECT itemID FROM deletedItems)) AS numAttachments, (CASE I.itemTypeID
WHEN 14 THEN (SELECT sourceItemID FROM itemAttachments IA WHERE
IA.itemID=I.itemID) WHEN 1 THEN (SELECT sourceItemID FROM itemNotes INo WHERE
INo.itemID=I.itemID) END) AS sourceItemID FROM items I WHERE 1 AND I.itemID IN
(454)
(2)(+0000001): Item 454 doesn't exist
(5)(+0000000): SELECT I.*, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC
LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 0
THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN
creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM
itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN
itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY
orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators IC NATURAL
JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT
(SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN
creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' )
END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND
creatorTypeID IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM
itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName
FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' und
' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex
LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN
creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN
(3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM
itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL
WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL
JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 2 THEN
(SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex
LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators
NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER
BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators
NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND
creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS
firstCreator, (SELECT COUNT(*) FROM itemNotes INo WHERE sourceItemID=I.itemID
AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT
COUNT(*) FROM itemAttachments IA WHERE sourceItemID=I.itemID AND IA.itemID NOT
IN (SELECT itemID FROM deletedItems)) AS numAttachments, (CASE I.itemTypeID
WHEN 14 THEN (SELECT sourceItemID FROM itemAttachments IA WHERE
IA.itemID=I.itemID) WHEN 1 THEN (SELECT sourceItemID FROM itemNotes INo WHERE
INo.itemID=I.itemID) END) AS sourceItemID FROM items I WHERE 1 AND I.itemID IN
(454)
(2)(+0000001): Item 454 doesn't exist
(3)(+0000000): Resetting Notifier event queue
(3)(+0000000): Committing Notifier event queue [delete-item: 15] [remove-
collection-item: 1] [refresh-trash: 1]
(3)(+0000000): Notifier.trigger('delete', 'item',
[447,446,109,72,70,472,451,450,453,452,455,456,454,481,471]) called [observers:
8]
(4)(+0000000): Calling notify('delete') on observer with hash 'Jf'
(4)(+0000000): Calling notify('delete') on observer with hash 'jb'
(4)(+0000000): Calling notify('delete') on observer with hash '8s'
(5)(+0000000): UPDATE syncObjectTypes SET name='relation' WHERE
syncObjectTypeID=6 AND name='relations'
(5)(+0000000): SELECT * FROM syncObjectTypes
(5)(+0000000): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000000): REPLACE INTO syncDeleteLog VALUES (?, ?, ?, ?)
(5)(+0000001): INSERT INTO storageDeleteLog VALUES (?, ?, ?)
(5)(+0000000): Committing transaction
(3)(+0000018): Resetting Notifier event queue
(4)(+0000000): Calling notify('delete') on observer with hash 'vQ'
(4)(+0000001): Calling notify('delete') on observer with hash 'Y3'
(4)(+0000000): Calling notify('delete') on observer with hash 'Wm'
(4)(+0000000): Calling notify('delete') on observer with hash '3z'
(3)(+0000002): Viewing item in pane 0
(3)(+0000001): Refreshing item box
(3)(+0000019): DATE: retrieved with algorithms:
{"order":"dmy","month":11,"day":15,"year":1989}
(4)(+0000013): Calling notify('delete') on observer with hash 'h8'
(3)(+0000000): Notifier.trigger('remove', 'collection-item', [6-70]) called
[observers: 8]
(4)(+0000000): Calling notify('remove') on observer with hash 'Jf'
(4)(+0000000): Calling notify('remove') on observer with hash 'jb'
(4)(+0000000): Calling notify('remove') on observer with hash '8s'
(4)(+0000000): Calling notify('remove') on observer with hash 'vQ'
(4)(+0000000): Calling notify('remove') on observer with hash 'Y3'
(4)(+0000000): Calling notify('remove') on observer with hash 'Wm'
(4)(+0000000): Calling notify('remove') on observer with hash '3z'
(4)(+0000000): Calling notify('remove') on observer with hash 'h8'
(3)(+0000000): Notifier.trigger('refresh', 'trash', [0]) called [observers: 8]
(4)(+0000000): Calling notify('refresh') on observer with hash 'Jf'
(4)(+0000000): Calling notify('refresh') on observer with hash 'jb'
(4)(+0000000): Calling notify('refresh') on observer with hash '8s'
(4)(+0000000): Calling notify('refresh') on observer with hash 'vQ'
(4)(+0000000): Calling notify('refresh') on observer with hash 'Y3'
(4)(+0000000): Calling notify('refresh') on observer with hash 'Wm'
(5)(+0000000): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE
libraryID IS NULL
(4)(+0000000): Calling notify('refresh') on observer with hash '3z'
(4)(+0000000): Calling notify('refresh') on observer with hash 'h8'
(3)(+0000000): Emptied 9 item(s) from trash in 235 ms
(5)(+0000033): DROP TABLE tmpSearchResults_3XqCE9mF
(3)(+0000001): Refreshing items list
(5)(+0000002): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(3)(+0000000): Caching fields [title,date,firstCreator]
(5)(+0000000): Transaction in progress -- increasing level to 1
(5)(+0000001): CREATE TEMPORARY TABLE tmpSearchResults_v53c7SHl AS SELECT
itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION
SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN
(SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments
WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM
deletedItems) ) AND (itemID NOT IN (SELECT itemID FROM itemNotes WHERE
sourceItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAttachments
WHERE sourceItemID IS NOT NULL)) AND itemID IN (SELECT itemID FROM items WHERE
(libraryID IS NULL))
(5)(+0000001): CREATE INDEX tmpSearchResults_v53c7SHl_itemID ON
tmpSearchResults_v53c7SHl(itemID)
(5)(+0000000): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT
itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION
SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN
(SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments
WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM
deletedItems) )) AND (itemID IN (SELECT itemID FROM tmpSearchResults_v53c7SHl)
OR itemID IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IN (SELECT
itemID FROM tmpSearchResults_v53c7SHl)) OR itemID IN (SELECT itemID FROM
itemNotes WHERE sourceItemID IN (SELECT itemID FROM
tmpSearchResults_v53c7SHl)))
(5)(+0000001): DROP TABLE tmpSearchResults_v53c7SHl
(5)(+0000000): Decreasing transaction level to 0
(5)(+0000002): Committing transaction
(3)(+0000000): Resetting Notifier event queue
(3)(+0000000): Sorting items list by firstCreator, date, title, dateAdded
ascending
(3)(+0000029): Sorted items list in 29 ms
(3)(+0000001): Viewing item in pane 0
(3)(+0000000): Refreshing item box
(3)(+0000006): DATE: retrieved with algorithms:
{"order":"dmy","month":11,"day":15,"year":1989}
(3)(+0000010): Updating tag selector with current tags
(5)(+0000001): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000000): CREATE TEMPORARY TABLE tmpSearchResults_wnSKiAGy (itemID INT)
(5)(+0000000): INSERT INTO tmpSearchResults_wnSKiAGy SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ?
(5)(+0000001): INSERT INTO tmpSearchResults_wnSKiAGy SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ? UNION SELECT ?
UNION SELECT ?
(5)(+0000001): CREATE INDEX tmpSearchResults_wnSKiAGy_itemID ON
tmpSearchResults_wnSKiAGy(itemID)
(5)(+0000000): Committing transaction
(3)(+0000000): Resetting Notifier event queue
(5)(+0000000): SELECT DISTINCT tagID, name, type FROM itemTags NATURAL JOIN
tags WHERE itemID IN (SELECT itemID FROM tmpSearchResults_wnSKiAGy)
(3)(+0000006): Refreshing tags selector
(5)(+0000034): SELECT tagID, name FROM tags WHERE libraryID IS NULL AND type IN
(0,1)
(5)(+0004871): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000002): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE
libraryID IS NULL AND dateDeleted<=DATE('NOW', '-30 DAYS')
(5)(+0000001): Transaction in progress -- increasing level to 1
(3)(+0000001): Deleting item 448
(5)(+0000000): Transaction in progress -- increasing level to 2
(5)(+0000001): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000013): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000002): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators
WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000004): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE
sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000001): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL
JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT
JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND
A.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000001): Binding parameter 1 of type int: 449
(5)(+0000001): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): SELECT linkMode FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): SELECT mimeType FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000001): SELECT charsetID FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(1)(+0000000): Invalid character set null
(5)(+0000000): SELECT path FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000001): Binding parameter 1 of type int: 226
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 227
(5)(+0000001): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 228
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 229
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000000): Binding parameter 1 of type int: 230
(5)(+0000000): SELECT itemID FROM itemTags WHERE tagID=?
(5)(+0000001): Binding parameter 1 of type int: 231
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): SELECT itemID FROM itemNotes WHERE sourceItemID=?1 UNION SELECT
itemID FROM itemAttachments WHERE sourceItemID=?1
(5)(+0000000): Binding parameter 1 of type int: 448
(3)(+0000001): Deleting item 449
(5)(+0000000): Transaction in progress -- increasing level to 3
(1)(+0000000): Invalid character set null
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000001): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): SELECT sourceItemID FROM itemAttachments WHERE itemID=449
(3)(+0000000): getAttachmentLinkMode() deprecated -- use .attachmentLinkMode
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT rowid FROM fulltextItems WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): Decreasing transaction level to 3
(3)(+0000000): Clearing full-text cache file for item 449
(5)(+0000000): Transaction in progress -- increasing level to 4
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/8U3MBF7R";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/8U3MBF7R";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 3
(5)(+0000001): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000001): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 449
(5)(+0000001): Decreasing transaction level to 2
(3)(+0000000): Notifier.trigger('modify', 'item', [448]) queued
(3)(+0000000): Notifier.trigger('delete', 'item', [449]) queued
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/PQJZRZ6U";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/PQJZRZ6U";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000000): Decreasing transaction level to 2
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000001): DELETE FROM itemCreators WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): DELETE FROM itemTags WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000001): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 448
(5)(+0000000): Decreasing transaction level to 1
(3)(+0000001): Notifier.trigger('delete', 'item', [448]) queued
(3)(+0000000): Deleting item 430
(5)(+0000000): Transaction in progress -- increasing level to 2
(5)(+0000000): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues
WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000001): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators
WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 430
(3)(+0000001): Loading data for creator 235 in Zotero.Creator.load()
(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD
WHERE creatorID=?
(5)(+0000000): Binding parameter 1 of type int: 235
(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE
sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL
JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT
JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND
A.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000001): Binding parameter 1 of type int: 430
(5)(+0000000): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): SELECT collectionID FROM collectionItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): SELECT itemID FROM itemNotes WHERE sourceItemID=?1 UNION SELECT
itemID FROM itemAttachments WHERE sourceItemID=?1
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): Transaction in progress -- increasing level to 3
(5)(+0000000): SELECT ROWID FROM relations WHERE (subject=? OR object=?) AND
predicate != ?
(5)(+0000000): Binding parameter 1 of type string:
"http://zotero.org/users/local/9IcTITai/items/W4IQCBA3";
(5)(+0000000): Binding parameter 2 of type string:
"http://zotero.org/users/local/9IcTITai/items/W4IQCBA3";
(5)(+0000000): Binding parameter 3 of type string: "dc:isReplacedBy"
(5)(+0000001): Decreasing transaction level to 2
(5)(+0000000): DELETE FROM annotations WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): DELETE FROM highlights WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): DELETE FROM deletedItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): SELECT rowid FROM itemCreators WHERE itemID=? LIMIT 1
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): DELETE FROM itemCreators WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): DELETE FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): DELETE FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): DELETE FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): DELETE FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM
itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): DELETE FROM itemData WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000001): DELETE FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 430
(5)(+0000000): Decreasing transaction level to 1
(3)(+0000000): Notifier.trigger('delete', 'item', [430]) queued
(5)(+0000000): Decreasing transaction level to 0
(3)(+0000000): Notifier.trigger('refresh', 'trash', [0]) queued
(5)(+0000000): Committing transaction
(5)(+0000017): SELECT I.*, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC
LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 0
THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN
creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM
itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN
itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND
ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY
orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators IC NATURAL
JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT
(SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN
creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON
(IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE
itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' )
END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND
creatorTypeID IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM
itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName
FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE
itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' und
' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex
LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN
creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN
(3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM
itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL
WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL
JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 2 THEN
(SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN
creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex
LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators
NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER
BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators
NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND
creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS
firstCreator, (SELECT COUNT(*) FROM itemNotes INo WHERE sourceItemID=I.itemID
AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT
COUNT(*) FROM itemAttachments IA WHERE sourceItemID=I.itemID AND IA.itemID NOT
IN (SELECT itemID FROM deletedItems)) AS numAttachments, (CASE I.itemTypeID
WHEN 14 THEN (SELECT sourceItemID FROM itemAttachments IA WHERE
IA.itemID=I.itemID) WHEN 1 THEN (SELECT sourceItemID FROM itemNotes INo WHERE
INo.itemID=I.itemID) END) AS sourceItemID FROM items I WHERE 1 AND I.itemID IN
(448)
(2)(+0000001): Item 448 doesn't exist
(3)(+0000000): Resetting Notifier event queue
(3)(+0000000): Committing Notifier event queue [delete-item: 3] [refresh-trash:
1]
(3)(+0000000): Notifier.trigger('delete', 'item', [449,448,430]) called
[observers: 8]
(4)(+0000000): Calling notify('delete') on observer with hash 'Jf'
(4)(+0000000): Calling notify('delete') on observer with hash 'jb'
(4)(+0000000): Calling notify('delete') on observer with hash '8s'
(5)(+0000000): Beginning DB transaction
(3)(+0000001): Beginning Notifier event queue
(5)(+0000000): REPLACE INTO syncDeleteLog VALUES (?, ?, ?, ?)
(5)(+0000000): INSERT INTO storageDeleteLog VALUES (?, ?, ?)
(5)(+0000000): Committing transaction
(3)(+0000017): Resetting Notifier event queue
(4)(+0000000): Calling notify('delete') on observer with hash 'vQ'
(4)(+0000000): Calling notify('delete') on observer with hash 'Y3'
(4)(+0000000): Calling notify('delete') on observer with hash 'Wm'
(4)(+0000000): Calling notify('delete') on observer with hash '3z'
(3)(+0000001): Viewing item in pane 0
(3)(+0000000): Refreshing item box
(3)(+0000006): DATE: retrieved with algorithms:
{"order":"dmy","month":11,"day":15,"year":1989}
(4)(+0000011): Calling notify('delete') on observer with hash 'h8'
(3)(+0000000): Notifier.trigger('refresh', 'trash', [0]) called [observers: 8]
(4)(+0000000): Calling notify('refresh') on observer with hash 'Jf'
(4)(+0000000): Calling notify('refresh') on observer with hash 'jb'
(4)(+0000000): Calling notify('refresh') on observer with hash '8s'
(4)(+0000000): Calling notify('refresh') on observer with hash 'vQ'
(4)(+0000000): Calling notify('refresh') on observer with hash 'Y3'
(4)(+0000000): Calling notify('refresh') on observer with hash 'Wm'
(5)(+0000000): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE
libraryID IS NULL
(4)(+0000001): Calling notify('refresh') on observer with hash '3z'
(4)(+0000000): Calling notify('refresh') on observer with hash 'h8'
(3)(+0000000): Emptied 2 item(s) from trash in 102 ms
(5)(+0005001): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000001): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE
libraryID IS NULL AND dateDeleted<=DATE('NOW', '-30 DAYS')
(5)(+0000000): Committing transaction
