Database-Upgrade-Error - unable to open database

andybrandy

Hi,

without having consciously changed anything, Zotero Firefox Addon 4.0.16 stopped working at the worst possible time (writing papers at the moment).
I would really appreciate any help to resolve this issue ASAP. It has worked flawlessly for years and I depend on it.

kind regards
Andy


When starting Firefox 25.0.1 the firefox symbol shows a yellow triangle with exclamation mark on top of it. Clicking it gives the following error message:
===========================
Database-Upgrade-Error
[[Exception... "Component returned failure code: 0x80520015 (NS_ERROR_FILE_ACCESS_DENIED) [mozIStorageConnection.executeSimpleSQL]" nsresult: "0x80520015 (NS_ERROR_FILE_ACCESS_DENIED)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: Zotero.DBConnection.prototype.query :: line 149" data: no] [QUERY: DELETE FROM itemTypesCombined] [ERROR: unable to open database file]
===========================




The Debugging set in the addon settings give:
============================
[JavaScript Error: "[Exception... "Component returned failure code: 0x80520015 (NS_ERROR_FILE_ACCESS_DENIED) [mozIStorageConnection.executeSimpleSQL]" nsresult: "0x80520015 (NS_ERROR_FILE_ACCESS_DENIED)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: Zotero.DBConnection.prototype.query :: line 149" data: no] [QUERY: DELETE FROM itemTypesCombined] [ERROR: unable to open database file]" {file: "chrome://zotero/content/xpcom/zotero.js" line: 709}]

PAC file installed from http://it.ise.fhg.de/findproxy.pac

[JavaScript Error: "Zotero.Proxies.proxies.slice is not a function" {file: "chrome://zotero/content/preferences/preferences_proxies.js" line: 87}]

[JavaScript Error: "this.editor is null" {file: "chrome://browser/content/urlbarBindings.xml" line: 161}]

[JavaScript Error: "this.editor is null" {file: "chrome://browser/content/urlbarBindings.xml" line: 161}]

[JavaScript Error: "Die Zeichenkodierung des Reintext-Dokuments wurde nicht deklariert. Das Dokument wird in manchen Browser-Konfigurationen mit verstümmeltem Text dargestellt, wenn das Dokument Zeichen außerhalb des US-ASCII-Bereichs enthält. Die Zeichenkodierung der Seite muss im Transferprotokoll deklariert werden oder die Datei muss eine Byte-Order-Markierung als Kodierungssignatur verwenden." {file: "zotero://debug/" line: 0}]

[JavaScript Error: "TypeError: _observers is undefined" {file: "chrome://zotero/content/xpcom/mimeTypeHandler.js" line: 99}]

[JavaScript Error: "TypeError: _observers is undefined" {file: "chrome://zotero/content/xpcom/mimeTypeHandler.js" line: 99}]

[JavaScript Error: "$tree.dw_tree is not a function" {file: "https://www.zotero.org/support/lib/exe/js.php?tseed=1375914067" line: 1}]

[JavaScript Error: "History.getState is not a function" {file: "https://www.zotero.org/static/js/_zoterowwwAll.bugly.1387412779.js" line: 4477}]

[JavaScript Error: "[Exception... "Component returned failure code: 0x8000ffff (NS_ERROR_UNEXPECTED) [nsIPrefBranch.getCharPref]" nsresult: "0x8000ffff (NS_ERROR_UNEXPECTED)" location: "JS frame :: chrome://browser/content/aboutDialog.js :: init :: line 14" data: no]" {file: "chrome://browser/content/aboutDialog.js" line: 32}]

[JavaScript Error: "[Exception... "Component returned failure code: 0x8000ffff (NS_ERROR_UNEXPECTED) [nsIPrefBranch.getCharPref]" nsresult: "0x8000ffff (NS_ERROR_UNEXPECTED)" location: "JS frame :: chrome://browser/content/aboutDialog.js :: init :: line 14" data: no]" {file: "chrome://browser/content/aboutDialog.js" line: 32}]

[JavaScript Error: "Zotero.Proxies.proxies.slice is not a function" {file: "chrome://zotero/content/preferences/preferences_proxies.js" line: 87}]

version => 4.0.16, platform => Win32, oscpu => Windows NT 6.1; WOW64, locale => de-DE, appName => Firefox, appVersion => 25.0.1

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

(3)(+0000000): Using data directory C:\Users\abrand\Dokumente\-- Literatur\Zotero DB

(3)(+0000001): Loading in full mode

(3)(+0000000): Opening database 'zotero'

(5)(+0000004): PRAGMA locking_mode=EXCLUSIVE

(5)(+0000001): SELECT version FROM version WHERE schema='userdata'

(5)(+0000001): SELECT version FROM version WHERE schema='userdata2'

(5)(+0000002): Beginning DB transaction

(3)(+0000000): Beginning Notifier event queue

(5)(+0000000): SELECT version FROM version WHERE schema='system'

(3)(+0000001): Updating custom tables

(5)(+0000001): DELETE FROM itemTypesCombined

(3)(+0000000): [Exception... "Component returned failure code: 0x80520015 (NS_ERROR_FILE_ACCESS_DENIED) [mozIStorageConnection.executeSimpleSQL]" nsresult: "0x80520015 (NS_ERROR_FILE_ACCESS_DENIED)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: Zotero.DBConnection.prototype.query :: line 149" data: no] [QUERY: DELETE FROM itemTypesCombined] [ERROR: unable to open database file]

(5)(+0000000): Rolling back transaction

(3)(+0000000): Resetting Notifier event queue

(3)(+0000002): Initialized in 182 ms

(3)(+0110123): Getting Zotero sync password

(3)(+0000013): Username not set before getting Zotero.Sync.Storage.WebDAV.password

(1)(+0347529): Skipping backup of database 'zotero'

(3)(+0262006): Username not set before getting Zotero.Sync.Storage.WebDAV.password
=========================================================

adamsmith

First, make sure you have a back-up of your zotero data folder:
http://www.zotero.org/support/zotero_data
Then, update to Zotero 4.0.17, restart your computer and try again.

edit: actually, never mind the repair tool: you getting a file access error. This is typically a permissions or security software issue on Windows. Check file permissions in your data folder and if those look right, temporarily disable security software.

andybrandy

the update to 4.0.17 didn't change anything.

As for the access rights to that folder. I've tried everything, giving full access to 'everyone'.
It is a company machine and I can't shut down the sophos endpoint protection and IT claims not to have changed anything.

Wasted 3 hours on this already and got 7 hours left to finish this paper. :(

Thanks anyways!

aurimas

is your database synced with Zotero.org? Do you have a backup otherwise?

Edit: find the sqlite file in your data directory, right-click -> Properties, and see if it has the read-only flag set

andybrandy

database is synced and I got tons of backups of course. it's just, that I can't use it at my work computer anymore.

it is set to read and write. Security settings are set to "everyone" for the entire folder.

aurimas

in that case you can either rename or delete your Zotero data directory (close Zotero first), let Zotero recreate it, and sync your data. This would at least let you continue working, you can debug it further later if necessary. If that doesn't work, then you can try moving the location of your data directory somewhere else (this may be a bit more involved if you can't access Zotero Preferences).