Could we see a Debug ID (different from a Report ID) for a sync attempt that produces this message?

Hi, Dan. Just checking to see if there has been any development on my issue. I am still getting the sync error message. On checking my library on Zotero.org, though, I find no immediately obvious sign of a sync failure: the most recent changes I make in my offline library appear in the online library when I sync. Nonetheless, the error message is troubling because something not directly detectable is perhaps not syncing. Do I need to submit a new debug report? I would gladly do that. Thanks for your help on this.

Thanks for your help on my sync issue. I updated Zotero to 5.0.40 but now it will not load my database. Find below the message it gives:

<<Message start>>

Database upgrade error

Error: Error(s) encountered during statement execution: UNIQUE constraint failed: itemRelations.itemID, itemRelations.predicateID, itemRelations.object [QUERY: UPDATE itemRelations SET object='http://zotero.org/users/4096550/items/72Q7PKVG' WHERE itemID=? AND predicateID=?] [PARAMS: 2, 2] [ERROR: UNIQUE constraint failed: itemRelations.itemID, itemRelations.predicateID, itemRelations.object]
Zotero.DBConnection.prototype.queryAsync<@chrome://zotero/content/xpcom/db.js:703:10
From previous event:
TaskImpl_handleResultValue@resource://gre/modules/Task.jsm:396:7
TaskImpl_run@resource://gre/modules/Task.jsm:327:15
TaskImpl@resource://gre/modules/Task.jsm:277:3
createAsyncFunction/asyncFunction@resource://gre/modules/Task.jsm:252:14
Task_spawn@resource://gre/modules/Task.jsm:166:12
ConnectionData.prototype<.executeTransaction/promise</transactionPromise<@resource://gre/modules/Sqlite.jsm:593:28
TaskImpl_run@resource://gre/modules/Task.jsm:319:42

<<Message end>>

Following the message, I am given the options to "Quit" or "Check for Update". Since I already updated to the latest version, Zotero tells me "No Updates Found" and gives me only a "Quit" option.

I hope this provides sufficient information to enable a solution to the problem. Since Zotero does not load the database, I cannot send you a Report ID or a Debug ID.

What am I to do? Thanks for your help.

Okay, Dan, thanks. I just finished using the manual repair tool on my database, on the off-chance that it had somehow become corrupted, but on trying to load it I got the same result as before. I will install the latest beta version now and get back to you. I hope it works. Thanks, again.

There's no need to uninstall anything. And if you're on Linux you can just extract the beta tarball to a new directory and run it from there, and then delete it afterward.

Thank you very much, guys. I did as you said: I ran the beta version and succeeded in loading my database; then I downloaded and ran the current release version, and was able to load my database and to sync it successfully with zotero.org. Thank you, thank you, thank you!