Bug: Drag-and-drop to group collections is broken in Firefox 3.0.10

The Drag and Drop function from 'My Library' to a group collection only works sporadically using Firefox 3.0.10 on both Mac OS 10.5.6 and WinXP.
  • 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.
  • Here is output for one that does not work:

    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(5): Binding parameter 1 of type int: 4

    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): 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): 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(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): '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"
  • Here is one that works:

    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"
  • 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): 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): 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 5 of type int: 25758

    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(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(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): 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(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 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(3): Notifier.trigger('modify', 'item', [74]) queued

    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(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(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): DROP TABLE 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"
  • 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"

    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
  • 1) What happens, exactly, when you try to drag?

    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!
  • amellnik: Can you answer #2 and #3?
  • 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.

    Thanks!
  • 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.
  • OK, glad to hear it.
Sign In or Register to comment.