No, you're not doing this right. You're not logging the actual sync.
But let's me see if I can help you without that.
Run this from Tools → Developer → Run JavaScript:
return await Zotero.DB.valueQueryAsync("SELECT value FROM items JOIN itemData USING (itemID) JOIN itemDataValues USING (valueID) WHERE fieldID=(SELECT fieldID FROM fields WHERE fieldName='accessDate') AND key='PR7IY9LI'")
return await Zotero.DB.queryAsync("DELETE FROM itemData WHERE fieldID=(SELECT fieldID FROM fields WHERE fieldName='accessDate') AND valueID=(SELECT valueID FROM itemDataValues WHERE value='INVALID_SCITE_VALUE')") || 'done'
OK, so just to clarify for others who many come across this, this was caused by a bug in the Scite plugin corrupting your database. Zotero 6.0.2 now corrects the field values corrupted, and Scite plugin 1.11.5 fixes the bug:
Upgrade Storage
Debug ID: D1884619845
But let's me see if I can help you without that.
Run this from Tools → Developer → Run JavaScript:
return await Zotero.DB.valueQueryAsync("SELECT value FROM items JOIN itemData USING (itemID) JOIN itemDataValues USING (valueID) WHERE fieldID=(SELECT fieldID FROM fields WHERE fieldName='accessDate') AND key='PR7IY9LI'")What's the output?
output
return await Zotero.DB.queryAsync("DELETE FROM itemData WHERE fieldID=(SELECT fieldID FROM fields WHERE fieldName='accessDate') AND valueID=(SELECT valueID FROM itemDataValues WHERE value='INVALID_SCITE_VALUE')") || 'done'Then restart Zotero.
Thank you very much
https://forums.zotero.org/discussion/comment/402633/#Comment_402633