www

commit 8197fa4ce833ccc26f4bb3ec757e7ca2c893bc71
parent 26f6f0533196630708e1eb8ab89cf2b0a1d4b251
Author: Dan Stillman <dstillman@zotero.org>
Date:   Thu,  5 Nov 2015 13:37:56 -0500

Fix LIKE binding error in Nightly loading duplicates

Diffstat:
M
chrome/content/zotero/xpcom/duplicates.js
 | 
11
+++++++++--

1 file changed, 9 insertions(+), 2 deletions(-)
diff --git a/chrome/content/zotero/xpcom/duplicates.js b/chrome/content/zotero/xpcom/duplicates.js
@@ -214,9 +214,16 @@ Zotero.Duplicates.prototype._findDuplicates = Zotero.Promise.coroutine(function*
 	// DOI
 	var sql = "SELECT itemID, value FROM items JOIN itemData USING (itemID) "
 				+ "JOIN itemDataValues USING (valueID) "
-				+ "WHERE libraryID=? AND fieldID=? AND value LIKE '10\\.%' "
+				+ "WHERE libraryID=? AND fieldID=? AND value LIKE ? "
 				+ "AND itemID NOT IN (SELECT itemID FROM deletedItems)";
-	var rows = yield Zotero.DB.queryAsync(sql, [this._libraryID, Zotero.ItemFields.getID('DOI')]);
+	var rows = yield Zotero.DB.queryAsync(
+		sql,
+		[
+			this._libraryID,
+			Zotero.ItemFields.getID('DOI'),
+			'10.%'
+		]
+	);
 	var doiCache = {};
 	if (rows.length) {
 		let newRows = [];