Zotero 6 crashes on macOS High Sierra

misha_rosly

Hello! Zotero won't start on my Mac for a week now. Tried removing it completely.

Database upgrade error

Error: Error(s) encountered during statement execution: unable to open database file [QUERY: DELETE FROM itemTypesCombined] [PARAMS: ] [ERROR: unable to open database file]
Zotero.DBConnection.prototype.queryAsync@chrome://zotero/content/xpcom/db.js:680:13
From previous event:
ZoteroService@file:///Applications/Zotero.app/Contents/Resources/components/zotero-service.js:346:7
@chrome://zotero/content/include.js:4:14

dstillman

unable to open database file

This is generally due to either a permissions problem in your Zotero data directory or security software on the system preventing Zotero from reading/writing to its data directory.

misha_rosly

Thanks a lot, dstillman! I now checked my /Users//Zotero folder permissions. They seem ok. I don't use any security software aside what is provided with osx.

When I go past the popup window to Zotero Preferences and try to establish synchronisation I get an error:

Zotero.Sync.Runner is undefined

Btw, what does it all have to do with Chrome?

misha_rosly

Thanks again

dstillman

That's not referring to Chrome the browser — disregard.

Nothing is going to work in Zotero if you're getting a startup error, so don't try.

What are the permissions on the zotero.sqlite file?

Are there other .sqlite or .sqlite-journal files, and if so, what are the permissions on those?

misha_rosly

There are

zotero.sqlite
zotero.sqlite.1.bak
zotero.sqlite.111.bak
zotero.sqlite.bak

I set permissions to Zotero folder and its contents to "everyone: read&write"

dstillman

I assume you've tried restarting your computer?

If your data is all online, you can also try closing Zotero, moving zotero.sqlite to a temporary folder on your desktop, and letting Zotero recreate the file and pull down your data via sync. Not sure what else to tell you — this really just means Zotero isn't able to open the file for some reason.

misha_rosly

Dear dstillman! Here is the log. Maybe this will shed some light?

[JavaScript Error: "Error(s) encountered during statement execution: unable to open database file [QUERY: DELETE FROM itemTypesCombined] [PARAMS: ] [ERROR: unable to open database file]" {file: "chrome://zotero/content/xpcom/db.js" line: 680}]

[JavaScript Error: "Error(s) encountered during statement execution: unable to open database file [QUERY: DELETE FROM itemTypesCombined] [PARAMS: ] [ERROR: unable to open database file]" {file: "chrome://zotero/content/xpcom/db.js" line: 680}]

[JavaScript Error: "Error: Error(s) encountered during statement execution: unable to open database file [QUERY: REPLACE INTO settings VALUES ('db', 'integrityCheck', 1)] [PARAMS: ] [ERROR: unable to open database file]" {file: "chrome://zotero/content/xpcom/db.js" line: 680}]

version => 6.0.4, platform => MacIntel, oscpu => Intel Mac OS X 10.13, locale => en-US, appName => Zotero, appVersion => 6.0.4, extensions => Zotero LibreOffice Integration (6.0.0.SA.6.0.4, extension), Zotero Word for Mac Integration (6.0.0.SA.6.0.4, extension)

=========================================================

(4)(+0000000): PRAGMA foreign_keys = false

(4)(+0000002): Beginning DB transaction BHVoVdsY

(3)(+0000002): HTTP GET resource://zotero/schema/system.sql

(3)(+0000003): HTTP GET resource://zotero/schema/system.sql succeeded with 200

(3)(+0000001): Updating custom tables

(4)(+0000000): PRAGMA foreign_keys

(4)(+0000001): SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND tbl_name=? ['customItemTypes']

(4)(+0000017): DELETE FROM itemTypesCombined

(1)(+0000240): Rolled back DB transaction BHVoVdsY

(1)(+0000000): Error(s) encountered during statement execution: unable to open database file [QUERY: DELETE FROM itemTypesCombined] [PARAMS: ] [ERROR: unable to open database file]

(4)(+0000001): PRAGMA foreign_keys = true

dstillman

Same answer as above.