Library doesn't sync

Elena_Heller · April 14, 2022

Hello,

My ID is 697722567.

My Zotero app doesn't sync the libraries. I can see them online but not in the app.
I have tried reinstalling the app and have also waited for it to sync but it doesn't work.
It always says preparing sync

dstillman · April 14, 2022

JavaScript Error: "Error(s) encountered during statement execution: no such column: IA.authorName [QUERY: SELECT itemID, IA.parentItemID, IA.type, IA.authorName, IA.text, IA.comment, IA.color, IA.sortIndex, IA.isExternal FROM items JOIN itemAnnotations IA USING (itemID) WHERE libraryID=?] [PARAMS: 1] [ERROR: no such column: IA.authorName]" {file: "chrome://zotero/content/xpcom/db.js" line: 680}]

Can you go to your Zotero data directory, open the 'logs' folder, and email the upgrade.log file to support@zotero.org with a link to this thread? (We'll respond here.)

dstillman · April 16, 2022

What's the date of the upgrade.log file you sent? The problem here was from a database upgrade made by a version of the Zotero beta from last November that you were running. Has this problem been happening since then, or have you not used Zotero for a while?

In any case, you should be able to fix this by going to Tools → Developer → Run JavaScript and running the following command, and then restarting Zotero:

await Zotero.DB.queryAsync("UPDATE version SET version=119 WHERE schema='userdata' AND version=120")