Upgrade StorageUnable to add custom tables to Zotero database
I am writing an overlay on top of Zotero that adds some configuration settings to the Zotero database. The extension uses Zotero.DB.query() to run the SQL.
All my insert/update statements work fine. However, I have some create table statements that fail because the table sqlite_master is locked.
I have tried setting extensions.zotero.dbLockExclusive to false, but this does not change the behavior. I have also tried restoring the database from a backup copy, and the behavior is not changed.
The database does not seem to be corrupt - it's just that the Zotero's initilization SQL seems to lock the table sqlite_master, which prevents running additional DDL statements.
Any idea how to fix / work around this?
All my insert/update statements work fine. However, I have some create table statements that fail because the table sqlite_master is locked.
I have tried setting extensions.zotero.dbLockExclusive to false, but this does not change the behavior. I have also tried restoring the database from a backup copy, and the behavior is not changed.
The database does not seem to be corrupt - it's just that the Zotero's initilization SQL seems to lock the table sqlite_master, which prevents running additional DDL statements.
Any idea how to fix / work around this?
This is an old discussion that has not been active in a long time. Instead of commenting here, you should start a new discussion. If you think the content of this discussion is still relevant, you can link to it from your new discussion.