URGENT! Database Connector upgrade error!

jeanniew88

I have a mac mini. Zotero works great on my macbook and was working until yesterday on the mac mini. I uninstalled, reinstalled, restarted , tried everything but to no avail. PLEASE HELP!! What does this all mean??? Thanks in advance!


Database upgrade error

Error: Error(s) encountered during statement execution: no such table: retractedItems [QUERY: ALTER TABLE retractedItems ADD COLUMN flag INT DEFAULT 0] [PARAMS: ] [ERROR: no such table: retractedItems]
Zotero.DBConnection.prototype.queryAsync<@chrome://zotero/content/xpcom/db.js:670:13
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:42Database upgrade error

Error: Error(s) encountered during statement execution: no such table: retractedItems [QUERY: ALTER TABLE retractedItems ADD COLUMN flag INT DEFAULT 0] [PARAMS: ] [ERROR: no such table: retractedItems]
Zotero.DBConnection.prototype.queryAsync<@chrome://zotero/content/xpcom/db.js:670:13
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

dstillman

If you don't mind, could you upload the database to the DB Repair Tool and post the Upload ID here? You can ignore the download link that the tool provides, which won't fix the problem, but this will let us try to figure out what went wrong in your database upgrade.

After that, if you don't want to wait for a fix, you can close Zotero on the MacBook, copy the zotero.sqlite file from the MacBook to the Mac Mini (using AirDrop, Dropbox, etc.), and place it in the Zotero data directory on the Mac Mini, replacing the zotero.sqlite file there. Zotero should then start again.

As long as you were using syncing, you shouldn't lose any recent changes you made on the Mac Mini.