Standalone not syncing with server
When I opened Zotero today and tried to sync with the server (on two different computers), I keep getting and error:
"[Exception... "Component returned failure code: 0x80630003 (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]" nsresult: "0x80630003 (NS_ERROR_STORAGE_CONSTRAINT)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: Zotero.DBConnection.prototype.query :: line 145" data: no] [QUERY: INSERT INTO tags (tagID, name, type, dateAdded, dateModified, clientDateModified, libraryID, key) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [ERROR: UNIQUE constraint failed: tags.libraryID, tags.name, tags.type]"
I still have plenty of storage available so I'm not sure what the problem is. Report ID is 1625026734.
Any clue what is going on?
"[Exception... "Component returned failure code: 0x80630003 (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]" nsresult: "0x80630003 (NS_ERROR_STORAGE_CONSTRAINT)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: Zotero.DBConnection.prototype.query :: line 145" data: no] [QUERY: INSERT INTO tags (tagID, name, type, dateAdded, dateModified, clientDateModified, libraryID, key) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [ERROR: UNIQUE constraint failed: tags.libraryID, tags.name, tags.type]"
I still have plenty of storage available so I'm not sure what the problem is. Report ID is 1625026734.
Any clue what is going on?
just as directed in that thread, install the latest beta from https://www.zotero.org/support/dev_builds
You can switch back to the regular version (simply by installing it from zotero.org/download) when Zotero 4.0.21 comes out.
Either way, the sync just started working again so something must have gone through. Thanks for your help!
Anyway, if this is working now you can and should reinstall 4.0.20.2 of Zotero for Firefox so you're not running the beta anymore.
Edit: Followed the steps to check database integrity. No errors were found and the syncing issue was not resolved.
[ERROR: UNIQUE constraint failed: tags.libraryID, tags.name, tags.type]
as the original poster. If you just received just any sync error, chances are this doesn't apply to you.
[Exception... "Component returned failure code: 0x80630003 (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]" nsresult: "0x80630003 (NS_ERROR_STORAGE_CONSTRAINT)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: Zotero.DBConnection.prototype.query :: line 145" data: no] [QUERY: INSERT INTO tags (tagID, name, type, dateAdded, dateModified, clientDateModified, libraryID, key) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [ERROR: UNIQUE constraint failed: tags.libraryID, tags.name, tags.type]