www

commit 11b05a5a41b8eac5f1531aa834838d657e0b188d
parent 8660095c549da3298e8f3bcd8adbc18e61deae8e
Author: Dan Stillman <dstillman@zotero.org>
Date:   Sun, 26 Oct 2008 22:58:44 +0000

Fix upgrade error with empty data values and tags


Diffstat:
M
chrome/content/zotero/xpcom/schema.js
 | 
4
++++

1 file changed, 4 insertions(+), 0 deletions(-)
diff --git a/chrome/content/zotero/xpcom/schema.js b/chrome/content/zotero/xpcom/schema.js
@@ -2051,6 +2051,8 @@ Zotero.Schema = new function(){
 				}
 				
 				if (i==45) {
+					Zotero.DB.query("DELETE FROM itemData WHERE valueID IN (SELECT valueID FROM itemDataValues WHERE value REGEXP '^\\s*$')");
+					Zotero.DB.query("DELETE FROM itemDataValues WHERE value REGEXP '^\\s*$'");
 					var rows = Zotero.DB.query("SELECT * FROM itemDataValues WHERE value REGEXP '(^\\s+|\\s+$)'");
 					if (rows) {
 						for each(var row in rows) {
@@ -2081,6 +2083,8 @@ Zotero.Schema = new function(){
 						}
 					}
 					
+					Zotero.DB.query("DELETE FROM itemTags WHERE tagID IN (SELECT tagID FROM tags WHERE name REGEXP '^\\s*$')");
+					Zotero.DB.query("DELETE FROM tags WHERE name REGEXP '^\\s*$'");
 					var rows = Zotero.DB.query("SELECT * FROM tags WHERE name REGEXP '(^\\s+|\\s+$)'");
 					if (rows) {
 						for each(var row in rows) {