"Error: Local Creator 1 not in update array"

Error: 1725017739

I get this error when I'm trying to sync:

[JavaScript Error: "[Exception... "'Local creator 1 not in update array when changing id' when calling method: [nsIDOMEventListener::handleEvent]" nsresult: "0x8057001e (NS_ERROR_XPC_JS_THREW_STRING)" location: "<unknown>" data: no]"]

Any ideas?
  • This should now be fixed on the trunk.
  • Just installed the latest trunk, and I'm still getting a sync error: Error Report #1192187598

    Here's the error report:

    [JavaScript Error: "str is undefined" {file: "chrome://zotero/content/xpcom/sync.js" line: 2295}]

    [JavaScript Error: "[Exception... "'[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageStatement.execute]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: anonymous :: line 123" data: no] [QUERY: DELETE FROM creatorData WHERE creatorDataID=?] [ERROR: constraint failed]' when calling method: [nsIDOMEventListener::handleEvent]" nsresult: "0x8057001e (NS_ERROR_XPC_JS_THREW_STRING)" location: "<unknown>" data: no]"]
  • Could you provide debug output for the 15 or so lines before "Rolling back transaction" when you get the "str is undefined" error?
  • Here are the debug lines that appear before "Rolling back transaction":


    zotero(5): SELECT MAX(MAX(creatorID, 9))+1 FROM creators

    zotero(3): Changing creator 1 id to 73

    zotero(5): SELECT COUNT(*) FROM creators WHERE creatorID=?

    zotero(5): Binding parameter 1 of type int: 1

    zotero(5): Transaction in progress -- increasing level to 2

    zotero(3): Changing creatorID 1 to 73

    zotero(5): SELECT * FROM creators WHERE creatorID=?

    zotero(5): Binding parameter 1 of type int: 1

    zotero(5): INSERT INTO creators VALUES (?, ?, ?, ?)

    zotero(5): Binding parameter 1 of type int: 73

    zotero(5): Binding parameter 2 of type int: 1

    zotero(5): Binding parameter 3 of type string: "2008-07-10 14:04:45"

    zotero(5): Binding parameter 4 of type string: "TEMPKEY"

    zotero(5): UPDATE itemCreators SET creatorID=? WHERE creatorID=?

    zotero(5): Binding parameter 1 of type int: 73

    zotero(5): Binding parameter 2 of type int: 1

    zotero(5): DELETE FROM creators WHERE creatorID=?

    zotero(5): Binding parameter 1 of type int: 1

    zotero(5): UPDATE creators SET key=? WHERE creatorID=?

    zotero(5): Binding parameter 1 of type string: "8SB6QUBN"

    zotero(5): Binding parameter 2 of type int: 73

    zotero(3): Notifier.trigger('id-change', 'creator', [1-73]) queued

    zotero(5): SELECT COUNT(*) FROM creators WHERE creatorID=?

    zotero(5): Binding parameter 1 of type int: 73

    zotero(3): Saving creator 73

    zotero(5): SELECT COUNT(*) FROM creators WHERE creatorDataID=?

    zotero(5): Binding parameter 1 of type int: 1

    zotero(5): DELETE FROM creatorData WHERE creatorDataID=?

    zotero(5): Binding parameter 1 of type int: 1

    zotero(5): Flagging nested transaction for rollback
Sign In or Register to comment.