How to solve this???

There was an error starting Zotero.

You can report this problem in the Zotero Forums.

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=? AND itemID IN (5, 8, 10, 12, 13, 15, 16, 18, 19, 20, 23)] [PARAMS: 1] [ERROR: no such column: IA.authorName]
Zotero.DBConnection.prototype.queryAsync@chrome://zotero/content/xpcom/db.js:680:13
From previous event:
Zotero.Schema</this.migrateExtraFields@chrome://zotero/content/xpcom/schema.js:691:11
  • As far as we know, this would've been caused by a database upgrade made by a version of the Zotero beta from two years ago. Has this problem been happening since then, or have you not used Zotero for a while? Do you recall previously using the beta?

    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 BETWEEN 120 AND 122")
Sign In or Register to comment.