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
    edited March 27, 2022
    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.
Sign In or Register to comment.