Anyone know how to fix this problem?

philippa
I'm getting this message-- with an alarming red exclamation mark and after Zotero tries to auto-sync:

"[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 136" data: no] [QUERY: DELETE FROM items WHERE itemID=?] [ERROR: constraint failed]"
Any ideas what's up?
  • dstillman
    Generate a Debug ID for a sync attempt and post it here.
  • philippa
    Dan: I did as you suggested and performed the debug operation. But after I'd performed the sync operation, the 'preferences' window would not open again, so I couldn't complete the instructions.

    I sent the error report through to you again; it's the same message as above.

    Now what?
  • dstillman
    We'll need a Debug ID to debug this. I believe you can leave the preferences window open during the sync and just click the button to submit the debug output. (You can on OS X, at least—I don't have access to Windows at the moment.)

    Be sure to restart Firefox before trying again.
  • philippa
    The advanced preferences pane automatically closes as soon as I hit the sync button in Zotero. I cannot persuade it to stay open.

    The sync operation is still producing the alarming exclamation mark. Would reinstalling Zotero be another way to go? I am clearly not going to be able to send you a debug ID at this rate.
  • philippa
    Ignore my last: I finally got this to work! I managed to send the debug ID to you. Do I need to post the Debug ID number here too?

    When I opened the results pane, here's what the text said:

    (4)(+0000000): Registering observer for [collection,search,share,group,bucket] in notifier with hash 7N'

    (5)(+0000003): SELECT itemTypeID AS id, typeName AS name FROM itemTypes WHERE display=2 ORDER BY typeName

    (5)(+0000001): SELECT itemTypeID AS id, typeName AS name FROM itemTypes WHERE display=1 ORDER BY typeName
  • dstillman
    You need to enable debug logging, perform the sync operation, and then submit the Debug ID.
  • philippa
    Debug ID submitted. ID number is D1087963497.
  • dstillman
    You're sending empty (i.e., three-line) debug logs. Again, you need to perform the sync after enabling debug logging and before submitting the output. The "lines logged" number should go up considerably after you perform a sync.
  • philippa
    I'm doing exactly what you describe above, and I get the same three or four line debug output every time. I am following your sequence but I never get a bigger output.

    I'm on my work machine today and I'm not getting the exclamation mark there. I'm also not seeing in the library materials I added over the weekend on my home computer, so I assume syncing isn't actually occurring.
  • philippa
    Try this one: Debug ID D1612649675
  • dstillman
    OK, well, that Debug ID does have output, but we need debug output from the computer that actually demonstrates the problem. This just shows everything working correctly.
  • philippa
    OK, Dan. This debug is from the problem computer. The Debug ID is D1121374333.
  • philippa
    Any news on this, Dan? I'm still getting the sync error.
  • philippa
    I'd love some feedback here... the problem hasn't magically gone away and I have provided a debug report.
  • dstillman
    If you don't mind, could you upload your database to the DB Repair Tool and e-mail the Upload ID from the tool to support@zot....org, with a link to this thread? You can ignore the download links the tool provides.
  • dstillman
    OK, looks like the DB Repair Tool actually will fix this for you, so use the download link if you still have it or re-upload and grab the resulting file.

    We'll also fix this in Zotero itself.
  • philippa
    Perfect: it worked! Thanks much, Dan.
Sign In or Register to comment.