www

commit daf313ad87fcb68aa99ff9187b8679380a9df7bc
parent 2c81638fc7fea8bbf9e15b4999806ace2601cefd
Author: Dan Stillman <dstillman@zotero.org>
Date:   Tue, 13 Oct 2009 07:46:08 +0000

Add additional repair step to 1.0->2.0 DB upgrade process


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

1 file changed, 1 insertion(+), 0 deletions(-)
diff --git a/chrome/content/zotero/xpcom/schema.js b/chrome/content/zotero/xpcom/schema.js
@@ -1582,6 +1582,7 @@ Zotero.Schema = new function(){
 					Zotero.DB.query("DELETE FROM itemTags WHERE itemID NOT IN (SELECT itemID FROM items)");
 					Zotero.DB.query("DELETE FROM itemTags WHERE tagID NOT IN (SELECT tagID FROM tags)");
 					Zotero.DB.query("DELETE FROM savedSearchConditions WHERE savedSearchID NOT IN (select savedSearchID FROM savedSearches)");
+					Zotero.DB.query("DELETE FROM items WHERE itemTypeID IS NULL");
 					
 					Zotero.DB.query("DELETE FROM itemData WHERE valueID NOT IN (SELECT valueID FROM itemDataValues)");
 					Zotero.DB.query("DELETE FROM fulltextItemWords WHERE wordID NOT IN (SELECT wordID FROM fulltextWords)");