Error while syncing

Nerolf.
I have been notified one error while syncing my database. I have been prompted to communicate that error to the zotero forums. My error ID is 521833755.
«1
  • dstillman
    edited April 25, 2023
    Are you still getting an error? This may have just been a temporary glitch.
  • Nerolf.
    I have repaired the library in my own computer. However, when I tried to sync in Zotero.org I got an error and when trying to resync it, I have a warning at its left saying that I cannot do that. I got the error at sync I informed previously but just now it is impossible to refer any error text, as I am not allowed to resync.
  • dstillman
    I don't know what you mean by that. We can't help you without an error report. If you're having trouble syncing, we'd want a Debug ID for a sync attempt that produces the error.
  • Nerolf.
    My error ID is 521833755.
  • dstillman
    edited April 25, 2023
    That's not a Debug ID. Please follow my link.
  • Nerolf.
    I have done it several times and in the last one I received the debug D1206406819.
  • dstillman
    If you check your database integrity from the Advanced → Files and Folders pane of the Zotero preferences, does it pass?
  • Nerolf.
    Using that pathway, the database integrity is approved and no mistakes were found
  • Nerolf.
    Keep on waiting new instructions on syncing at Zotero.org. Thanks.
  • dstillman
    edited April 29, 2023
    Can you provide a Debug ID for Zotero startup through reproducing the error, using the "Restart with Logging Enabled…" option? If it happens on the initial auto-sync, that's all we need.
  • Nerolf.
    D604359895
  • Nerolf.
    I still reproduce the same error and I am not allowed to sync from the initial screen.
  • Nerolf.
    I would appreciate a reply.
  • dstillman
    edited May 3, 2023
    We'll need to do a little debugging. If you go to Tools → Developer → Run JavaScript and run the following code, what's the output?

    var item = await Zotero.Items.getAsync(12832);
    return item.itemType;

    (If you prefer, you can also upload your database to the DB Repair Tool and provide the Upload ID. You can ignore the download links the tool provides, but the Upload ID would let us run some tests on your database.)
  • Nerolf.
    I have uploaded my library and, after deleting three elements, I have been allowed to sync at Zotero.org. Thanks.
  • dstillman
    OK, thanks. I see the problem with the database. We'll add a fix for this.
  • dstillman
    Go to Tools → Developer → Run JavaScript and run the following code:

    var item = Zotero.Items.get(12832);
    await item.eraseTx();

    If you still get a sync error after that, provide another Debug ID.
  • Nerolf.
    I have run the code mentioned, and the recover text was:
    UnloadedDataException:`annotation´ not loaded for item (12832/1/3EDVGG75)
    being impossible to sync.
    Should I go to the Debug ID link?
  • dstillman
    edited May 8, 2023
    Are you saying you're seeing that message in the right-hand pane of the Run JavaScript window when you run the above command?
  • dstillman
    If so, run this as well, and then restart Zotero:

    await Zotero.DB.queryAsync("DELETE FROM itemNotes WHERE itemID=12832");
    await Zotero.DB.queryAsync("DELETE FROM items WHERE itemID=12832");
  • Nerolf.
    I have run the additional code referred and the return value was:
    undefined
    Anyway, Ieft Zotero, entered again and the same inability to sync persisted
  • dstillman
    OK, we need another Debug ID for a sync, then. If you ran the above, it won't be the same error.
  • Nerolf.
    Should I use this pathway?:
    Debug ID for Zotero startup using the "Restart with Logging Enabled…" option?
  • dstillman
    Sure.
  • Nerolf.
    In the Help tab, after selecting the debugging option, do I have to select send results?
  • dstillman
    edited May 8, 2023
    Yes, you need to reproduce the problem, submit the output, and tell us the Debug ID, the same way you did before.
  • Nerolf.
    D1024103778
  • dstillman
    No, you didn't log anything. See the instructions again:

    https://www.zotero.org/support/debug_output

    Again, you already did this. You just need to do the same thing again.
  • dstillman
    edited May 8, 2023
    OK, but going back to the database you uploaded last week, it looks like there's a set of PDF annotations created within a 5-minute period on November 7th that are corrupted, without any accompanying data or links to items.

    Not sure how that happened, but this in Tools → Run JavaScript will remove them:

    await Zotero.DB.queryAsync("DELETE FROM items WHERE itemTypeID IN (SELECT itemTypeID FROM itemTypes WHERE typeName='annotation') AND itemID NOT IN (SELECT itemID FROM itemAnnotations)")

    Run that, restart Zotero, and try syncing again.
  • Nerolf.
    I have run this last code and the return value was:

    Error: Error(s) encountered during statement execution: no such column:‘annotation’[QUERY:DELETE FROM items WHERE itemTypeID IN (SELECT itemTypeID FROM itemsTypes WHERE typeName=‘annotation’) AND itemID NOT IN (SELECT itemID FROM itemAnnotations)] [PARAMS: ] [ERROR:no such column: ‘annotation’]

    So, I didn´t restart Zotero, and try syncing again.s:
Sign In or Register to comment.