www

commit 86afad9b355deaff4f18fa85ee42f78f41a04d9c
parent 55d7ac1351b794476775e6766979604a16e69797
Author: Dan Stillman <dstillman@zotero.org>
Date:   Mon, 11 Nov 2013 23:00:32 -0500

Fix "columns itemID, tagID are not unique" sync error

I'm not sure what's causing this, but it will quite likely go away in
4.1 regardless.

Diffstat:
M
chrome/content/zotero/xpcom/data/tag.js
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/chrome/content/zotero/xpcom/data/tag.js b/chrome/content/zotero/xpcom/data/tag.js
@@ -459,7 +459,7 @@ Zotero.Tag.prototype.save = function (full) {
 			}
 			
 			if (newids.length) {
-				var sql = "INSERT INTO itemTags (itemID, tagID) VALUES (?,?)";
+				var sql = "INSERT OR IGNORE INTO itemTags (itemID, tagID) VALUES (?,?)";
 				var insertStatement = Zotero.DB.getStatement(sql);
 				
 				var pairs = [];