Problem with Zotero update for mac (Error: no such column)
Hi all,
I've just updated Zotero on my macbook after a period of inactivity, and first had no library. I looked through the forums and opened my zotero.sqlite file with the zotero app, hoping that would solve the issue. Now Zotero won't open and I got this error message. Does anyone know what this means? Thanks so much!
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 (16, 21, 29, 38, 43, 45, 56, 64, 84, 88, 92, 93, 97, 99, 109, 111, 114, 116, 113, 126, 129, 130, 131, 132)] [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
I've just updated Zotero on my macbook after a period of inactivity, and first had no library. I looked through the forums and opened my zotero.sqlite file with the zotero app, hoping that would solve the issue. Now Zotero won't open and I got this error message. Does anyone know what this means? Thanks so much!
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 (16, 21, 29, 38, 43, 45, 56, 64, 84, 88, 92, 93, 97, 99, 109, 111, 114, 116, 113, 126, 129, 130, 131, 132)] [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
You should be able to fix it 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")
Unfortunately I can't properly open Zotero at the moment – the error message comes up. When I open Zotero preferences, I don't have a tools bar anywhere.