Upgrade Storagesync issues with selected computers (error code 0x80630003)
188BET靠谱吗Greetings -- We run a shared Zotero library for research references in our Environmental Studies Program, and I have upwards of 150 students sharing this library this semester.In most cases syncing is not an issue, in spite of the rather large size of the library (~2K records): e.g., I installed Z on a fresh laptop yesterday and synced from scratch in about 10 minutes.
But certain of my students are having continued sync problems on their computers.188BET靠谱吗In all cases these are students who installed Zotero last fall and synced then, but not since (perhaps a month plus delay).188BET靠谱吗They have all told me they've upgraded their Zotero apps to latest (and some are using Firefox, others standalone).In many (not all) cases, they are presented with a relatively large number (~50) of local/server duplicates to decide on!but in the end their local records do not successfully sync with our group library (i.e., we cannot view them).
Below is the error output from those students who have provided it to me.I see several forum threads from the last six months with this error code (presumably sql?), which generally recommend installation of a development XPI.At this point, what should they install to address the sync problem?
Many thanks,
Jim P.
***
[Exception...188BET靠谱吗"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 :: :: line 145" data: no] [QUERY: UPDATE tags SET name=?, type=?, dateAdded=?, dateModified=?, clientDateModified=?, libraryID=?, key=?WHERE tagID=?] [ERROR: columns libraryID, name, type are not unique]
But certain of my students are having continued sync problems on their computers.188BET靠谱吗In all cases these are students who installed Zotero last fall and synced then, but not since (perhaps a month plus delay).188BET靠谱吗They have all told me they've upgraded their Zotero apps to latest (and some are using Firefox, others standalone).In many (not all) cases, they are presented with a relatively large number (~50) of local/server duplicates to decide on!but in the end their local records do not successfully sync with our group library (i.e., we cannot view them).
Below is the error output from those students who have provided it to me.I see several forum threads from the last six months with this error code (presumably sql?), which generally recommend installation of a development XPI.At this point, what should they install to address the sync problem?
Many thanks,
Jim P.
***
[Exception...188BET靠谱吗"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 :: :: line 145" data: no] [QUERY: UPDATE tags SET name=?, type=?, dateAdded=?, dateModified=?, clientDateModified=?, libraryID=?, key=?WHERE tagID=?] [ERROR: columns libraryID, name, type are not unique]
188BET靠谱吗Also, have them check database integrity in the advanced tab of the Zotero preferences.
188BET靠谱吗As for the right version - they should install/update to the most recent stable version of Zotero - i.e.3.0.1.There is no more recent sync code in the dev xpi.
Many thanks,
Jim
This raises a huge issue.188BET靠谱吗There is no way we can control whether all users of our shared library have synced recently with updated versions of Zotero!188BET靠谱吗we have somewhat greater, but certainly not perfect, control over the version of Zotero installed on our shared computers at our institution.We cannot therefore guarantee that this will not happen at any time in future!That's a very big worry I have right now: one bad sync and all our work seems to have reverted some some older version of collections, tags, perhaps even records.
Two possibilities, one of them immediate but not perfect, the other not immediate but possibly better:
(1) Every time we do a big cleanup/change to the shared library, we store a backup, then restore if needed.This sounds fine, except if we have to restore from this backup it will undo any more recent changes other users have (correctly) made.
188BET靠谱吗(2) Perhaps in future Zotero will offer more granular privileges to members in its group library, according to role (admin vs.member), thus allowing us admin oversight of certain elements such as tags or collection titles.I doubt this could be incorporated into the app itself (i.e., reduce certain functionalities by role of user as per Sync prefs), so maybe it would be incorporated into the sync process itself.
I'm really wary of going back to our group library and redoing our work from this morning without some clarity on the above!please advise.
Thanks,
Jim P.
1.) should work w/o problems.
2.) sounds quite hard to do - how would we set what users can and cannot change?
Restricting editing to admins will prevent any edits from users, so yes, that should prevent this issue, too.
I'm especially concerned as to whether we could see a repeat if any of our users' personal computers, or any of our shared institutional computers, are running a pre-3.0.1 (e.g., 2.1) version!this is gonna be hard for us to fix immediately, though we can in time.Can you please clarify whether this is the source of our current problem?We just don't want to see continued repeats of these problem syncs messing with our group library.
Thanks,
Jim
I'll check with affected users to confirm the above.
Thanks,
Jim
Jim
"I can confirm that I did not change tags before attempting to sync and have not changed tags at all this year."