You'll have to provide more information than "sporadically". Note that you can only drag the same item to a given group library (or from a given group library to the local library) once.
Well I guess it seems to work approximately 1 out of 25 times. I can not tell if it is discriminating against certain types of references. We are trying to use 2.0b4 in our research association. Everyone is having similar problems. One of our researchers found that if the full screen mode was toggled then the Drag and Drop worked fine. I tried to do the same but had no luck. Another researcher initially encountered the problem but now it works fine for him. This is all the information I have.
Hopefully someone in your association would be able to run with debugging output: http://www.zotero.org/support/debug_output and could monitor/report the difference between when an item is accepted and when it is not.
Intermittent problems are probably to-be-expected in the beta, but we'd all benefit from having more precise recipes of what usually works and what usually does not.
zotero(3): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
zotero(5): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
zotero(5): Binding parameter 1 of type int: 49
zotero(5): 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)
zotero(5): Binding parameter 1 of type int: 49
zotero(3): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 50
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 50
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 49
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 49
zotero(3): DATE: retrieved with algorithms: ({year:2000, month:5, day:1})
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 1
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(5): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name
zotero(5): Binding parameter 1 of type int: 2
zotero(3): Switching lastCreatorFieldMode to 0
zotero(5): SELECT key AS domainPath, value AS format FROM settings WHERE setting='quickCopySite' AND (key LIKE ? OR key LIKE ?)
zotero(5): Binding parameter 1 of type string: "%zotero.org%"
zotero(5): Binding parameter 2 of type string: "/%"
zotero(4): Translate: Binding sandbox to http://www.example.com/
zotero(3): Translate: Searching for translators for an undisclosed location
zotero(4): Translate: Parsing code for Zotero RDF
zotero(4): Translate: Setting configure option getCollections to true
zotero(4): Translate: Setting configure option dataMode to rdf
zotero(4): Translate: Setting display option exportNotes to true
zotero(4): Translate: Setting display option exportFileData to false
zotero(4): Translate: Parsing code for MODS
zotero(4): Translate: Setting display option exportNotes to true
zotero(4): Translate: Parsing code for Refer/BibIX
zotero(4): Translate: Setting configure option dataMode to line
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(4): Translate: Parsing code for RIS
zotero(4): Translate: Setting configure option dataMode to line
zotero(4): Translate: Setting display option exportNotes to true
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(4): Translate: Parsing code for Unqualified Dublin Core RDF
zotero(4): Translate: Setting configure option dataMode to rdf
zotero(4): Translate: Parsing code for Wikipedia Citation Templates
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(4): Translate: Parsing code for BibTeX
zotero(4): Translate: Setting configure option dataMode to block
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(3): Dragging with format Chicago Manual of Style (Note without Bibliography)
zotero(5): SELECT creatorTypeID FROM itemTypeCreatorTypes WHERE itemTypeID=? AND primaryField=1
zotero(5): Binding parameter 1 of type int: 2
zotero(3): DATE: retrieved with algorithms: ({year:2003, month:8, day:1})
zotero(3): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
zotero(5): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): 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)
zotero(5): Binding parameter 1 of type int: 54
zotero(3): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 55
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 55
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 54
zotero(3): DATE: retrieved with algorithms: ({year:2003, month:8, day:1})
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 2
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 8
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 9
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 3
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(5): Binding parameter 6 of type string: "NV83VT4Z"
zotero(5): Decreasing transaction level to 0
zotero(3): skipping itemTypeID
zotero(3): skipping libraryID
zotero(5): SELECT I.itemID, I.dateAdded, I.dateModified, I.key, 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) || ' and ' || (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 NATURAL JOIN creatorTypes 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) || ' and ' || (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 NATURAL JOIN creatorTypes 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) || ' and ' || (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 FROM items I WHERE itemID=?
zotero(5): 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) || ' and ' || (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 NATURAL JOIN creatorTypes 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) || ' and ' || (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 NATURAL JOIN creatorTypes 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) || ' and ' || (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 FROM items I WHERE 1 AND I.itemID IN (74)
zotero(5): Transaction in progress -- increasing level to 1
zotero(5): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): 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)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): SELECT charsetID FROM itemAttachments WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 55
zotero(1): Invalid character set null
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 55
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 55
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 54
zotero(5): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): 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)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT fieldName FROM fields WHERE fieldID IN (SELECT fieldID FROM itemData WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): SELECT creatorID FROM creators WHERE creatorDataID=? AND libraryID=?
zotero(5): Binding parameter 1 of type int: 48
zotero(5): Binding parameter 2 of type int: 25758
zotero(5): Decreasing transaction level to 0
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): Transaction in progress -- increasing level to 1
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(4): Updating database with new item data
zotero(5): UPDATE items SET dateModified=?, clientDateModified=? WHERE itemID=?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:10:36"
zotero(5): Binding parameter 2 of type string: "2009-05-28 21:10:36"
zotero(5): Binding parameter 3 of type int: 74
zotero(5): SELECT valueID FROM itemDataValues WHERE value=?
zotero(5): INSERT INTO itemDataValues VALUES (?,?)
zotero(5): REPLACE INTO itemData VALUES (?,?,?)
zotero(4): Creator 0 has changed
zotero(5): DELETE FROM itemCreators WHERE itemID=? AND orderIndex=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): Binding parameter 2 of type int: 0
zotero(5): INSERT INTO itemCreators VALUES (?,?,?,?)
zotero(5): 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) || ' and ' || (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 NATURAL JOIN creatorTypes 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) || ' and ' || (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 NATURAL JOIN creatorTypes 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) || ' and ' || (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 FROM items I WHERE 1 AND I.itemID IN (74)
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(5): Binding parameter 3 of type string: "owl:sameAs"
zotero(5): Binding parameter 4 of type string: "http://zotero.org/groups/747/items/NV83VT4Z"
zotero(5): Transaction in progress -- increasing level to 1
zotero(5): Transaction in progress -- increasing level to 2
zotero(5): SELECT IFNULL(MAX(orderIndex)+1, 0) FROM collectionItems WHERE collectionID=?
zotero(5): Binding parameter 1 of type int: 4
zotero(5): INSERT OR IGNORE INTO collectionItems VALUES (?,?,?)
zotero(5): Binding parameter 1 of type int: 4
zotero(5): Binding parameter 2 of type int: 74
zotero(5): Binding parameter 3 of type int: 1
zotero(5): UPDATE collections SET dateModified=?, clientDateModified=? WHERE collectionID=?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:10:36"
zotero(5): Binding parameter 2 of type string: "2009-05-28 21:10:36"
zotero(5): Binding parameter 3 of type int: 4
zotero(5): Decreasing transaction level to 1
zotero(3): Reloading collections 4
zotero(5): 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 (4)
zotero(5): 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)
zotero(3): Notifier.trigger('add', 'item', [74]) called [observers: 5]
zotero(4): Calling notify() on observer with hash 'yQ'
zotero(5): Beginning DB transaction
zotero(3): Beginning Notifier event queue
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(4): Calling notify() on observer with hash 'EU'
zotero(3): CANCELLING
zotero(3): Setting auto-sync timeout to 15 seconds
zotero(4): Calling notify() on observer with hash 'Ge'
zotero(4): Calling notify() on observer with hash 'ol'
zotero(4): Calling notify() on observer with hash 'cQ'
zotero(3): Refreshing item box
zotero(5): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name
zotero(5): Binding parameter 1 of type int: 2
zotero(3): Switching lastCreatorFieldMode to 0
zotero(3): Notifier.trigger('modify', 'item', [74]) called [observers: 5]
zotero(4): Calling notify() on observer with hash 'yQ'
zotero(5): Beginning DB transaction
zotero(3): Beginning Notifier event queue
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(4): Calling notify() on observer with hash 'EU'
zotero(3): CANCELLING
zotero(3): Setting auto-sync timeout to 15 seconds
zotero(4): Calling notify() on observer with hash 'Ge'
zotero(4): Calling notify() on observer with hash 'ol'
zotero(4): Calling notify() on observer with hash 'cQ'
zotero(3): Refreshing item box
zotero(5): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name
zotero(5): Binding parameter 1 of type int: 2
zotero(3): Switching lastCreatorFieldMode to 0
zotero(3): Notifier.trigger('add', 'collection-item', [4-74]) called [observers: 5]
zotero(4): Calling notify() on observer with hash 'yQ'
zotero(4): Calling notify() on observer with hash 'EU'
zotero(5): Transaction in progress -- increasing level to 1
zotero(5): CREATE TEMPORARY TABLE tmpSearchResults_fyrBQ838 AS SELECT itemID FROM items WHERE itemID NOT 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))
zotero(5): CREATE INDEX tmpSearchResults_fyrBQ838_itemID ON tmpSearchResults_fyrBQ838(itemID)
zotero(5): SELECT itemID FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems)) AND (itemID IN (SELECT itemID FROM tmpSearchResults_fyrBQ838) OR itemID IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_fyrBQ838)) OR itemID IN (SELECT itemID FROM itemNotes WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_fyrBQ838)))
zotero(5): DROP TABLE tmpSearchResults_fyrBQ838
zotero(5): Decreasing transaction level to 0
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(3): Refreshing item box
zotero(5): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name
zotero(5): Binding parameter 1 of type int: 2
zotero(3): Switching lastCreatorFieldMode to 0
zotero(3): Updating tag selector with current tags
zotero(5): Beginning DB transaction
zotero(3): Beginning Notifier event queue
zotero(5): CREATE TEMPORARY TABLE tmpSearchResults_6xJzlJs8 AS SELECT itemID FROM items WHERE itemID NOT 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))
zotero(5): CREATE INDEX tmpSearchResults_6xJzlJs8_itemID ON tmpSearchResults_6xJzlJs8(itemID)
zotero(5): SELECT itemID FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems)) AND (itemID IN (SELECT itemID FROM tmpSearchResults_6xJzlJs8) OR itemID IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_6xJzlJs8)) OR itemID IN (SELECT itemID FROM itemNotes WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_6xJzlJs8)))
zotero(5): INSERT INTO tmpSearchResults_ylK2AAb8 VALUES (?)
zotero(5): CREATE INDEX tmpSearchResults_ylK2AAb8_itemID ON tmpSearchResults_ylK2AAb8(itemID)
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(5): SELECT DISTINCT tagID, name, type FROM itemTags NATURAL JOIN tags WHERE itemID IN (SELECT itemID FROM tmpSearchResults_ylK2AAb8)
zotero(5): DROP TABLE tmpSearchResults_ylK2AAb8
zotero(3): Refreshing tags selector
zotero(5): SELECT tagID, name FROM tags WHERE libraryID IS NULL AND type IN (0,1)
zotero(4): Calling notify() on observer with hash 'cQ'
zotero(3): Refreshing item box
zotero(5): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name
zotero(5): Binding parameter 1 of type int: 2
zotero(3): Switching lastCreatorFieldMode to 0
zotero(3): Beginning server sync
zotero(5): SELECT version FROM version WHERE schema='lastremotesync'
Yes; that is what it is supposed to look like (and hopefully a mod will be able to snip it).
I'm sorry I wasn't more clear: we're looking for either records/behavior that will usually lead to the bug and/or we're looking for a minimal excerpt of the debug output that would let us know what zotero might be doing when it should be copying that record to the group.
zotero(5): SELECT ROWID FROM savedSearches WHERE clientDateModified>?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:01:28"
zotero(3): Getting updated local tags
zotero(5): SELECT ROWID FROM tags WHERE clientDateModified<?
zotero(5): Binding parameter 1 of type string: "0000-00-00 00:00:00"
zotero(5): SELECT ROWID FROM tags WHERE clientDateModified>?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:01:28"
zotero(3): Getting updated local relations
zotero(5): SELECT ROWID FROM relations WHERE clientDateModified<?
zotero(5): Binding parameter 1 of type string: "0000-00-00 00:00:00"
zotero(5): SELECT ROWID FROM relations WHERE clientDateModified>?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:01:28"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 10
zotero(5): SELECT version FROM version WHERE schema='syncdeletelog'
zotero(5): SELECT syncObjectTypeID, libraryID, key FROM syncDeleteLog WHERE timestamp>? ORDER BY timestamp
zotero(5): Binding parameter 1 of type int: 1243544488
zotero(3): No changes received from server
zotero(3): Processing locally changed creators
zotero(3): Processing locally changed items
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "NV83VT4Z"
zotero(5): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): 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)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(3): Processing locally changed collections
zotero(5): SELECT ROWID FROM collections WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "X4JIG28G"
zotero(5): SELECT collectionID AS id, 0 AS type, collectionName AS collectionName, key FROM collections WHERE parentCollectionID=?1 UNION SELECT itemID AS id, 1 AS type, NULL AS collectionName, key FROM collectionItems JOIN items USING (itemID) WHERE collectionID=?1
zotero(5): Binding parameter 1 of type int: 4
zotero(3): Processing locally changed searches
zotero(3): Processing locally changed tags
zotero(3): Processing locally changed relations
zotero(5): SELECT ROWID FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type string: "10"
2) Are you positive copies of the items you're trying to drag don't already exist in the target library?
3) Do the same items fail every time?
4) Restart Firefox, try to drag an item that fails, and, if the menu option is activated, send in an error report using Report Errors under the gear menu and post the Report ID here.
I have a similar problem. When I try to drag from my library to the group library the cursor never changes from the generic dragging cursor (the circle with the bar through it) to the arrow with a small grey box under it like it would were I dragging things around in it. Strangely I was able to drag materials into the group library the first time I tried it but it has not worked since.
My error report number is 1164793691 which hopefully captures the event. Thanks!
Whoops. It does work with items that are not in the group library somewhere, although it strips notes and attached snapshots/pdf's even though I can attach both to the group's library normally. I guess this was a design choice, although it seems a bit unusual to me. It also works if some (but not all) of the items are already in the group library.
I guess this was a design choice, although it seems a bit unusual to me.
What are you referring to? The stripping of notes and attachments is a temporary limitation that will be addressed. Given the different ways group libraries might be used, however, the desired behavior is not as straightforward as it might seem.
http://www.zotero.org/support/debug_output
and could monitor/report the difference between when an item is accepted and when it is not.
Intermittent problems are probably to-be-expected in the beta, but we'd all benefit from having more precise recipes of what usually works and what usually does not.
zotero(5): SELECT key AS domainPath, value AS format FROM settings WHERE setting='quickCopySite' AND (key LIKE ? OR key LIKE ?)
zotero(5): Binding parameter 1 of type string: "%google.ca%"
zotero(5): Binding parameter 2 of type string: "/%"
zotero(4): Translate: Binding sandbox to http://www.example.com/
zotero(3): Translate: Searching for translators for an undisclosed location
zotero(4): Translate: Parsing code for Zotero RDF
zotero(4): Translate: Setting configure option getCollections to true
zotero(4): Translate: Setting configure option dataMode to rdf
zotero(4): Translate: Setting display option exportNotes to true
zotero(4): Translate: Setting display option exportFileData to false
zotero(4): Translate: Parsing code for MODS
zotero(4): Translate: Setting display option exportNotes to true
zotero(4): Translate: Parsing code for Refer/BibIX
zotero(4): Translate: Setting configure option dataMode to line
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(4): Translate: Parsing code for RIS
zotero(4): Translate: Setting configure option dataMode to line
zotero(4): Translate: Setting display option exportNotes to true
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(4): Translate: Parsing code for Unqualified Dublin Core RDF
zotero(4): Translate: Setting configure option dataMode to rdf
zotero(4): Translate: Parsing code for Wikipedia Citation Templates
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(4): Translate: Parsing code for BibTeX
zotero(4): Translate: Setting configure option dataMode to block
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(3): Dragging with format Chicago Manual of Style (Note without Bibliography)
zotero(5): SELECT creatorTypeID FROM itemTypeCreatorTypes WHERE itemTypeID=? AND primaryField=1
zotero(3): DATE: could not apply algorithms
zotero(3): DATE: got year (2000, June 1, )
zotero(3): DATE: got month (5, 1, )
zotero(3): DATE: got day (1, , )
zotero(3): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
zotero(5): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
zotero(5): Binding parameter 1 of type int: 49
zotero(5): 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)
zotero(5): Binding parameter 1 of type int: 49
zotero(3): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 50
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 50
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 49
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 49
zotero(3): DATE: retrieved with algorithms: ({year:2000, month:5, day:1})
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 1
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(3): '0' => "http://zotero.org/groups/747/items/SFZM4MSK"
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "SFZM4MSK"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 1
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(3): '0' => "http://zotero.org/groups/747/items/SFZM4MSK"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "SFZM4MSK"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 1
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(3): '0' => "http://zotero.org/groups/747/items/SFZM4MSK"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "SFZM4MSK"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 1
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(3): '0' => "http://zotero.org/groups/747/items/SFZM4MSK"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "SFZM4MSK"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 1
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(3): '0' => "http://zotero.org/groups/747/items/SFZM4MSK"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "SFZM4MSK"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 1
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/I5UT6ZVQ"
zotero(3): Refreshing item box
zotero(5): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name
zotero(5): Binding parameter 1 of type int: 2
zotero(3): Switching lastCreatorFieldMode to 0
zotero(5): SELECT key AS domainPath, value AS format FROM settings WHERE setting='quickCopySite' AND (key LIKE ? OR key LIKE ?)
zotero(5): Binding parameter 1 of type string: "%zotero.org%"
zotero(5): Binding parameter 2 of type string: "/%"
zotero(4): Translate: Binding sandbox to http://www.example.com/
zotero(3): Translate: Searching for translators for an undisclosed location
zotero(4): Translate: Parsing code for Zotero RDF
zotero(4): Translate: Setting configure option getCollections to true
zotero(4): Translate: Setting configure option dataMode to rdf
zotero(4): Translate: Setting display option exportNotes to true
zotero(4): Translate: Setting display option exportFileData to false
zotero(4): Translate: Parsing code for MODS
zotero(4): Translate: Setting display option exportNotes to true
zotero(4): Translate: Parsing code for Refer/BibIX
zotero(4): Translate: Setting configure option dataMode to line
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(4): Translate: Parsing code for RIS
zotero(4): Translate: Setting configure option dataMode to line
zotero(4): Translate: Setting display option exportNotes to true
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(4): Translate: Parsing code for Unqualified Dublin Core RDF
zotero(4): Translate: Setting configure option dataMode to rdf
zotero(4): Translate: Parsing code for Wikipedia Citation Templates
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(4): Translate: Parsing code for BibTeX
zotero(4): Translate: Setting configure option dataMode to block
zotero(4): Translate: Setting display option exportCharset to UTF-8
zotero(3): Dragging with format Chicago Manual of Style (Note without Bibliography)
zotero(5): SELECT creatorTypeID FROM itemTypeCreatorTypes WHERE itemTypeID=? AND primaryField=1
zotero(5): Binding parameter 1 of type int: 2
zotero(3): DATE: retrieved with algorithms: ({year:2003, month:8, day:1})
zotero(3): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
zotero(5): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): 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)
zotero(5): Binding parameter 1 of type int: 54
zotero(3): Zotero.Item.toArray() is deprecated -- use Zotero.Item.serialize()
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 55
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 55
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 54
zotero(3): DATE: retrieved with algorithms: ({year:2003, month:8, day:1})
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 2
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 8
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 9
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 3
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
'1' => "http://zotero.org/groups/747/items/9BNZ8N23"
'2' => "http://zotero.org/groups/747/items/TETGZTT6"
'3' => "http://zotero.org/groups/747/items/X34557AE"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "8KZA7F6T"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/8KZA7F6T' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "9BNZ8N23"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/9BNZ8N23' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "TETGZTT6"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/TETGZTT6' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "X34557AE"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/X34557AE' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 2
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 8
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 9
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 3
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(3): '0' => "http://zotero.org/groups/747/items/8KZA7F6T"
'1' => "http://zotero.org/groups/747/items/9BNZ8N23"
'2' => "http://zotero.org/groups/747/items/TETGZTT6"
'3' => "http://zotero.org/groups/747/items/X34557AE"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "8KZA7F6T"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/8KZA7F6T' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "9BNZ8N23"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/9BNZ8N23' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "TETGZTT6"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/TETGZTT6' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "X34557AE"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/X34557AE' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 2
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 8
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 9
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 3
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(3): '0' => "http://zotero.org/groups/747/items/8KZA7F6T"
'1' => "http://zotero.org/groups/747/items/9BNZ8N23"
'2' => "http://zotero.org/groups/747/items/TETGZTT6"
'3' => "http://zotero.org/groups/747/items/X34557AE"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "8KZA7F6T"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/8KZA7F6T' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "9BNZ8N23"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/9BNZ8N23' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "TETGZTT6"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/TETGZTT6' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "X34557AE"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/X34557AE' not found in Zotero.Item.getLinkedItem()
zotero(5): Beginning DB transaction
zotero(3): Beginning Notifier event queue
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 2
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 8
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 9
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 3
zotero(5): SELECT ROWID FROM relations WHERE 1 AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "owl:sameAs"
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(3): '0' => "http://zotero.org/groups/747/items/8KZA7F6T"
'1' => "http://zotero.org/groups/747/items/9BNZ8N23"
'2' => "http://zotero.org/groups/747/items/TETGZTT6"
'3' => "http://zotero.org/groups/747/items/X34557AE"
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "8KZA7F6T"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/8KZA7F6T' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "9BNZ8N23"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/9BNZ8N23' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "TETGZTT6"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/TETGZTT6' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryID FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type string: "747"
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "X34557AE"
zotero(2): Referenced linked item 'http://zotero.org/groups/747/items/X34557AE' not found in Zotero.Item.getLinkedItem()
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): Transaction in progress -- increasing level to 1
zotero(3): Saving data for new item to database
zotero(5): INSERT INTO items (itemTypeID, dateAdded, dateModified, clientDateModified, libraryID, key) VALUES (?, ?, ?, ?, ?, ?)
zotero(5): Binding parameter 1 of type int: 2
zotero(5): Binding parameter 2 of type string: "2009-05-28 21:10:36"
zotero(5): Binding parameter 3 of type string: "2009-05-28 21:10:36"
zotero(5): Binding parameter 4 of type string: "2009-05-28 21:10:36"
zotero(5): Binding parameter 6 of type string: "NV83VT4Z"
zotero(5): Decreasing transaction level to 0
zotero(3): skipping itemTypeID
zotero(3): skipping libraryID
zotero(5): SELECT I.itemID, I.dateAdded, I.dateModified, I.key, 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) || ' and ' || (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 NATURAL JOIN creatorTypes 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) || ' and ' || (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 NATURAL JOIN creatorTypes 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) || ' and ' || (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 FROM items I WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(3): Reloading items 74
zotero(3): Notifier.trigger('add', 'item', [74]) queued
zotero(3): Cloning item 54
zotero(5): Transaction in progress -- increasing level to 1
zotero(5): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): 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)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): SELECT charsetID FROM itemAttachments WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 55
zotero(1): Invalid character set null
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 55
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 55
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 54
zotero(5): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): 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)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT fieldName FROM fields WHERE fieldID IN (SELECT fieldID FROM itemData WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 54
zotero(5): SELECT creatorID FROM creators WHERE creatorDataID=? AND libraryID=?
zotero(5): Binding parameter 1 of type int: 48
zotero(5): Binding parameter 2 of type int: 25758
zotero(5): Decreasing transaction level to 0
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT G.* FROM groups G WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): SELECT COUNT(*) FROM groups WHERE groupID=?
zotero(5): Binding parameter 1 of type int: 747
zotero(5): Transaction in progress -- increasing level to 1
zotero(5): SELECT COUNT(*) FROM items WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(4): Updating database with new item data
zotero(5): UPDATE items SET dateModified=?, clientDateModified=? WHERE itemID=?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:10:36"
zotero(5): Binding parameter 2 of type string: "2009-05-28 21:10:36"
zotero(5): Binding parameter 3 of type int: 74
zotero(5): SELECT valueID FROM itemDataValues WHERE value=?
zotero(5): INSERT INTO itemDataValues VALUES (?,?)
zotero(5): REPLACE INTO itemData VALUES (?,?,?)
zotero(4): Creator 0 has changed
zotero(5): DELETE FROM itemCreators WHERE itemID=? AND orderIndex=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): Binding parameter 2 of type int: 0
zotero(5): INSERT INTO itemCreators VALUES (?,?,?,?)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): Binding parameter 2 of type int: 48
zotero(5): Binding parameter 3 of type int: 1
zotero(5): Binding parameter 4 of type int: 0
zotero(5): Decreasing transaction level to 0
zotero(3): Reloading items 74
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT libraryType FROM libraries WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT groupID FROM groups WHERE libraryID=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): Binding parameter 3 of type string: "http://zotero.org/groups/747/items/NV83VT4Z"
zotero(5): SELECT ROWID FROM relations WHERE 1 AND subject=? AND predicate=? AND object=?
zotero(5): Binding parameter 1 of type string: "http://zotero.org/groups/747/items/NV83VT4Z"
zotero(5): Binding parameter 2 of type string: "owl:sameAs"
zotero(5): Binding parameter 3 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='libraryID'
zotero(5): INSERT INTO relations (libraryID, subject, predicate, object) VALUES (?, ?, ?, ?)
zotero(5): Binding parameter 1 of type int: 27177
zotero(5): Binding parameter 2 of type string: "http://zotero.org/users/26698/items/IZZ72V4P"
zotero(5): Binding parameter 3 of type string: "owl:sameAs"
zotero(5): Binding parameter 4 of type string: "http://zotero.org/groups/747/items/NV83VT4Z"
zotero(5): Transaction in progress -- increasing level to 1
zotero(5): Transaction in progress -- increasing level to 2
zotero(5): SELECT IFNULL(MAX(orderIndex)+1, 0) FROM collectionItems WHERE collectionID=?
zotero(5): Binding parameter 1 of type int: 4
zotero(5): INSERT OR IGNORE INTO collectionItems VALUES (?,?,?)
zotero(5): Binding parameter 1 of type int: 4
zotero(5): Binding parameter 2 of type int: 74
zotero(5): Binding parameter 3 of type int: 1
zotero(5): UPDATE collections SET dateModified=?, clientDateModified=? WHERE collectionID=?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:10:36"
zotero(5): Binding parameter 2 of type string: "2009-05-28 21:10:36"
zotero(5): Binding parameter 3 of type int: 4
zotero(5): Decreasing transaction level to 1
zotero(3): Reloading collections 4
zotero(5): 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 (4)
zotero(5): 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)
zotero(5): Binding parameter 1 of type int: 4
zotero(3): Notifier.trigger('add', 'collection-item', [4-74]) queued
zotero(5): Decreasing transaction level to 0
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(3): Committing Notifier event queue [add-item: 1] [modify-item: 1] [add-collection-item: 1]
zotero(3): Notifier.trigger('add', 'item', [74]) called [observers: 5]
zotero(4): Calling notify() on observer with hash 'yQ'
zotero(5): Beginning DB transaction
zotero(3): Beginning Notifier event queue
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(4): Calling notify() on observer with hash 'EU'
zotero(3): CANCELLING
zotero(3): Setting auto-sync timeout to 15 seconds
zotero(4): Calling notify() on observer with hash 'Ge'
zotero(4): Calling notify() on observer with hash 'ol'
zotero(4): Calling notify() on observer with hash 'cQ'
zotero(3): Refreshing item box
zotero(5): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name
zotero(5): Binding parameter 1 of type int: 2
zotero(3): Switching lastCreatorFieldMode to 0
zotero(3): Notifier.trigger('modify', 'item', [74]) called [observers: 5]
zotero(4): Calling notify() on observer with hash 'yQ'
zotero(5): Beginning DB transaction
zotero(3): Beginning Notifier event queue
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(4): Calling notify() on observer with hash 'EU'
zotero(3): CANCELLING
zotero(3): Setting auto-sync timeout to 15 seconds
zotero(4): Calling notify() on observer with hash 'Ge'
zotero(4): Calling notify() on observer with hash 'ol'
zotero(4): Calling notify() on observer with hash 'cQ'
zotero(3): Refreshing item box
zotero(5): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name
zotero(5): Binding parameter 1 of type int: 2
zotero(3): Switching lastCreatorFieldMode to 0
zotero(3): Notifier.trigger('add', 'collection-item', [4-74]) called [observers: 5]
zotero(4): Calling notify() on observer with hash 'yQ'
zotero(4): Calling notify() on observer with hash 'EU'
zotero(3): CANCELLING
zotero(4): Calling notify() on observer with hash 'Ge'
zotero(4): Calling notify() on observer with hash 'ol'
zotero(5): SELECT tagID, name, type FROM tags
zotero(3): Refreshing items list
zotero(5): Beginning DB transaction
zotero(3): Beginning Notifier event queue
zotero(3): Caching fields [title,date,firstCreator,numChildren]
zotero(5): Transaction in progress -- increasing level to 1
zotero(5): CREATE TEMPORARY TABLE tmpSearchResults_fyrBQ838 AS SELECT itemID FROM items WHERE itemID NOT 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))
zotero(5): CREATE INDEX tmpSearchResults_fyrBQ838_itemID ON tmpSearchResults_fyrBQ838(itemID)
zotero(5): SELECT itemID FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems)) AND (itemID IN (SELECT itemID FROM tmpSearchResults_fyrBQ838) OR itemID IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_fyrBQ838)) OR itemID IN (SELECT itemID FROM itemNotes WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_fyrBQ838)))
zotero(5): DROP TABLE tmpSearchResults_fyrBQ838
zotero(5): Decreasing transaction level to 0
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(3): Refreshing item box
zotero(5): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name
zotero(5): Binding parameter 1 of type int: 2
zotero(3): Switching lastCreatorFieldMode to 0
zotero(3): Updating tag selector with current tags
zotero(5): Beginning DB transaction
zotero(3): Beginning Notifier event queue
zotero(5): CREATE TEMPORARY TABLE tmpSearchResults_6xJzlJs8 AS SELECT itemID FROM items WHERE itemID NOT 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))
zotero(5): CREATE INDEX tmpSearchResults_6xJzlJs8_itemID ON tmpSearchResults_6xJzlJs8(itemID)
zotero(5): SELECT itemID FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems)) AND (itemID IN (SELECT itemID FROM tmpSearchResults_6xJzlJs8) OR itemID IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_6xJzlJs8)) OR itemID IN (SELECT itemID FROM itemNotes WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_6xJzlJs8)))
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(5): Beginning DB transaction
zotero(3): Beginning Notifier event queue
zotero(5): CREATE TEMPORARY TABLE tmpSearchResults_ylK2AAb8 (itemID INT)
zotero(5): INSERT INTO tmpSearchResults_ylK2AAb8 VALUES (?)
zotero(5): CREATE INDEX tmpSearchResults_ylK2AAb8_itemID ON tmpSearchResults_ylK2AAb8(itemID)
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(5): SELECT DISTINCT tagID, name, type FROM itemTags NATURAL JOIN tags WHERE itemID IN (SELECT itemID FROM tmpSearchResults_ylK2AAb8)
zotero(5): DROP TABLE tmpSearchResults_ylK2AAb8
zotero(3): Refreshing tags selector
zotero(5): SELECT tagID, name FROM tags WHERE libraryID IS NULL AND type IN (0,1)
zotero(4): Calling notify() on observer with hash 'cQ'
zotero(3): Refreshing item box
zotero(5): SELECT creatorTypeID AS id, creatorType AS name FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name
zotero(5): Binding parameter 1 of type int: 2
zotero(3): Switching lastCreatorFieldMode to 0
zotero(3): Beginning server sync
zotero(5): SELECT version FROM version WHERE schema='lastremotesync'
zotero(3): HTTP POST version=5&sessionid=********&lastsync=1243544464&lock=1 to https://sync.zotero.org/updated
zotero(3): <?xml version="1.0"?>
<response version="5" timestamp="1243545028" userID="26698" defaultLibraryID="27177" earliest="1243527361"><updated/></response>
zotero(5): Beginning DB transaction
zotero(3): Beginning Notifier event queue
zotero(5): SELECT key, value FROM settings WHERE setting='account' AND key='username'
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='userID'
zotero(5): SELECT value FROM settings WHERE setting='account' AND key='libraryID'
zotero(5): REPLACE INTO settings VALUES ('account', 'username', ?)
zotero(5): Binding parameter 1 of type string: "AngelaGabereau"
zotero(5): SELECT version FROM version WHERE schema='lastlocalsync'
zotero(3): Getting updated local creators
zotero(5): SELECT ROWID FROM creators WHERE clientDateModified<?
zotero(5): Binding parameter 1 of type string: "0000-00-00 00:00:00"
zotero(5): SELECT ROWID FROM creators WHERE clientDateModified>?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:01:28"
zotero(3): Getting updated local items
zotero(5): SELECT ROWID FROM items WHERE clientDateModified<?
zotero(5): Binding parameter 1 of type string: "0000-00-00 00:00:00"
zotero(5): SELECT ROWID FROM items WHERE clientDateModified>?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:01:28"
zotero(3): Getting updated local collections
zotero(5): SELECT ROWID FROM collections WHERE clientDateModified<?
zotero(5): Binding parameter 1 of type string: "0000-00-00 00:00:00"
zotero(5): SELECT ROWID FROM collections WHERE clientDateModified>?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:01:28"
zotero(3): Getting updated local searches
zotero(5): SELECT ROWID FROM savedSearches WHERE clientDateModified<?
zotero(5): Binding parameter 1 of type string: "0000-00-00 00:00:00"
I'm sorry I wasn't more clear: we're looking for either records/behavior that will usually lead to the bug and/or we're looking for a minimal excerpt of the debug output that would let us know what zotero might be doing when it should be copying that record to the group.
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:01:28"
zotero(3): Getting updated local tags
zotero(5): SELECT ROWID FROM tags WHERE clientDateModified<?
zotero(5): Binding parameter 1 of type string: "0000-00-00 00:00:00"
zotero(5): SELECT ROWID FROM tags WHERE clientDateModified>?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:01:28"
zotero(3): Getting updated local relations
zotero(5): SELECT ROWID FROM relations WHERE clientDateModified<?
zotero(5): Binding parameter 1 of type string: "0000-00-00 00:00:00"
zotero(5): SELECT ROWID FROM relations WHERE clientDateModified>?
zotero(5): Binding parameter 1 of type string: "2009-05-28 21:01:28"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 10
zotero(5): SELECT version FROM version WHERE schema='syncdeletelog'
zotero(5): SELECT syncObjectTypeID, libraryID, key FROM syncDeleteLog WHERE timestamp>? ORDER BY timestamp
zotero(5): Binding parameter 1 of type int: 1243544488
zotero(3): No changes received from server
zotero(3): Processing locally changed creators
zotero(3): Processing locally changed items
zotero(5): SELECT ROWID FROM items WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "NV83VT4Z"
zotero(5): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT COUNT(*) FROM deletedItems WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): 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)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(5): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
zotero(5): Binding parameter 1 of type int: 74
zotero(3): Processing locally changed collections
zotero(5): SELECT ROWID FROM collections WHERE libraryID=? AND key=?
zotero(5): Binding parameter 1 of type int: 25758
zotero(5): Binding parameter 2 of type string: "X4JIG28G"
zotero(5): SELECT collectionID AS id, 0 AS type, collectionName AS collectionName, key FROM collections WHERE parentCollectionID=?1 UNION SELECT itemID AS id, 1 AS type, NULL AS collectionName, key FROM collectionItems JOIN items USING (itemID) WHERE collectionID=?1
zotero(5): Binding parameter 1 of type int: 4
zotero(3): Processing locally changed searches
zotero(3): Processing locally changed tags
zotero(3): Processing locally changed relations
zotero(5): SELECT ROWID FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type string: "10"
zotero(5): SELECT * FROM relations WHERE ROWID=?
zotero(5): Binding parameter 1 of type int: 10
zotero(3): Processing locally deleted creators
zotero(3): Processing locally deleted items
zotero(3): Processing locally deleted collections
zotero(3): Processing locally deleted searches
zotero(3): Processing locally deleted tags
zotero(3): Processing locally deleted relations
zotero(3): <data version="5">
<items>
<item libraryID="25758" key="NV83VT4Z" itemType="book" dateAdded="2009-05-28 21:10:36" dateModified="2009-05-28 21:10:36">
<field name="title">Hive Of Dreams</field>
<field name="publisher">Oregon State University Press</field>
<field name="date">2003-09-01 2003-09-01</field>
<field name="ISBN">0870715550</field>
<field name="repository">Amazon.com</field>
<creator libraryID="25758" key="R7EVRJMN" creatorType="author" index="0"/>
</item>
</items>
<collections>
<collection libraryID="25758" key="X4JIG28G" name="Obx" dateAdded="2009-05-20 19:54:49" dateModified="2009-05-28 21:10:36">
<items>24QVZUW2 NV83VT4Z</items>
</collection>
</collections>
<relations>
<relation>
<subject>http://zotero.org/users/26698/items/IZZ72V4P</subject>
<predicate>owl:sameAs</predicate>
<object>http://zotero.org/groups/747/items/NV83VT4Z</object>
</relation>
</relations>
</data>
zotero(5): REPLACE INTO version VALUES ('lastremotesync', ?)
zotero(5): Binding parameter 1 of type int: 1243545028
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(3): HTTP POST 542 bytes to https://sync.zotero.org/upload?gzip=1 (gzipped from 1678 bytes; 68% savings)
zotero(3): <?xml version="1.0"?>
<response version="5" timestamp="1243545028"><uploaded/></response>
zotero(5): Beginning DB transaction
zotero(3): Beginning Notifier event queue
zotero(5): DELETE FROM syncDeleteLog WHERE timestamp<?
zotero(5): Binding parameter 1 of type int: 1243545052
zotero(5): REPLACE INTO version VALUES ('lastlocalsync', ?)
zotero(5): Binding parameter 1 of type int: 1243545052
zotero(5): REPLACE INTO version VALUES ('lastremotesync', ?)
zotero(5): Binding parameter 1 of type int: 1243545028
zotero(5): Committing transaction
zotero(3): Resetting Notifier event queue
zotero(3): Releasing session lock
2) Are you positive copies of the items you're trying to drag don't already exist in the target library?
3) Do the same items fail every time?
4) Restart Firefox, try to drag an item that fails, and, if the menu option is activated, send in an error report using Report Errors under the gear menu and post the Report ID here.
My error report number is 1164793691 which hopefully captures the event. Thanks!
Thanks!