Unable to open database file

edited October 12, 2019
Error: Error(s) encountered during statement execution: unable to open database file [QUERY: INSERT INTO itemTypesCombined SELECT itemTypeID, typeName, display, 0 AS custom FROM itemTypes UNION SELECT customItemTypeID + 10000 AS itemTypeID, typeName, display, 1 AS custom FROM customItemTypes] [PARAMS: ] [ERROR: unable to open database file]
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
  • [JavaScript Error: "Error(s) encountered during statement execution: unable to open database file [QUERY: DROP TABLE IF EXISTS tmpSearchResults_6IauPkE6] [PARAMS: ] [ERROR: unable to open database file]" {file: "chrome://zotero/content/xpcom/db.js" line: 670}]

    [JavaScript Error: "Error(s) encountered during statement execution: unable to open database file [QUERY: DROP TABLE IF EXISTS tmpSearchResults_6IauPkE6] [PARAMS: ] [ERROR: unable to open database file]" {file: "chrome://zotero/content/xpcom/db.js" line: 670}]
    Zotero.DBConnection.prototype.queryAsync<@chrome://zotero/content/xpcom/db.js:670:10
    tryCatcher@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/util.js:16:16
    module.exports/PromiseSpawn.prototype._promiseRejected@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/generators.js:106:18
    module.exports/Promise.prototype._settlePromise@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/promise.js:576:17
    module.exports/Promise.prototype._settlePromise0@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/promise.js:614:5
    module.exports/Promise.prototype._settlePromises@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/promise.js:689:13
    Async.prototype._drainQueue@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/async.js:133:13
    Async.prototype._drainQueues@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/async.js:143:5
    Async/this.drainQueues@resource://gre/modules/commonjs/toolkit/loader.js -> resource://zotero/bluebird/async.js:17:9


    [JavaScript Error: "Error: Error(s) encountered during statement execution: unable to open database file [QUERY: DROP TABLE IF EXISTS tmpSearchResults_6IauPkE6] [PARAMS: ] [ERROR: unable to open database file]" {file: "chrome://zotero/content/xpcom/db.js" line: 670}]

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

    [JavaScript Error: "Translators not yet loaded"]

    version => 5.0.63, platform => Win32, oscpu => Windows NT 10.0; WOW64, locale => zh-CN, appName => Zotero, appVersion => 5.0.63, extensions => Zotero LibreOffice Integration (5.0.14.SA.5.0.63, extension), Zotero Word for Windows Integration (5.0.12.SA.5.0.63, extension)
  • While it shouldn't matter, start by upgrading to the latest version of Zotero, currently 5.0.76.

    If you still get the same error after that, there's a problem either with file permissions in your Zotero data directory or with security software on your computer preventing Zotero from accessing its database.
  • edited October 14, 2019
    Thanks, I have found the problem that zotero and other softwares cannot create the temporal files. I reinstalled the system and It works. Finally, Thanks again.
Sign In or Register to comment.