www

commit b76d788133e0304bd19dfc3985d3e6fdbd12df20
parent 734472fbe409e4c474265b2a1a31088aa8bdd285
Author: Dan Stillman <dstillman@zotero.org>
Date:   Mon,  8 Nov 2010 09:29:35 +0000

Fix an issue that could cause a sync error (and maybe other tag-related problems) in very old databases


Diffstat:
M
chrome/content/zotero/xpcom/schema.js
 | 
4
++++
M
userdata.sql
 | 
2
+-

2 files changed, 5 insertions(+), 1 deletion(-)
diff --git a/chrome/content/zotero/xpcom/schema.js b/chrome/content/zotero/xpcom/schema.js
@@ -2915,6 +2915,10 @@ Zotero.Schema = new function(){
 					Zotero.DB.query("CREATE TABLE translatorCache (\n	leafName TEXT PRIMARY KEY,\n	translatorJSON TEXT,\n	code TEXT,\n	lastModifiedTime INT\n)");
 				}
 				
+				if (i==76) {
+					Zotero.DB.query("DELETE FROM itemTags WHERE tagID IS NULL");
+				}
+				
 				Zotero.wait();
 			}
 			
diff --git a/userdata.sql b/userdata.sql
@@ -1,4 +1,4 @@
--- 75
+-- 76
 
 -- Copyright (c) 2009 Center for History and New Media
 --                    George Mason University, Fairfax, Virginia, USA