www

commit f93f7384a6d9e288ff32d4dfb81fba6316104cdb
parent 85876c36a6ae0d6b0d4c99b2bc58b0ed97f3294f
Author: Dan Stillman <dstillman@zotero.org>
Date:   Fri, 22 May 2009 02:07:22 +0000

Fix incorrectly entered MIME types and the DB bug in 2.0b4 that caused it


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

3 files changed, 6 insertions(+), 1 deletion(-)
diff --git a/chrome/content/zotero/xpcom/db.js b/chrome/content/zotero/xpcom/db.js
@@ -265,6 +265,7 @@ Zotero.DBConnection.prototype.getStatement = function (sql, params, checkParams)
 			
 			params.splice(i, 1);
 			i--;
+			lastNullParamIndex--;
 			continue;
 		}
 		if (!params.length) {
diff --git a/chrome/content/zotero/xpcom/schema.js b/chrome/content/zotero/xpcom/schema.js
@@ -2386,6 +2386,10 @@ Zotero.Schema = new function(){
 					Zotero.DB.query("DROP TABLE tmpEmptyCreators");
 					Zotero.DB.query("DELETE FROM creatorData WHERE firstName='' AND lastName=''");
 				}
+				
+				if (i==56) {
+					Zotero.DB.query("UPDATE itemAttachments SET mimeType=charsetID, charsetID=NULL WHERE charsetID REGEXP '[a-zA-Z0-9\-]+/[a-zA-Z0-9\-]'");
+				}
 			}
 			
 			_updateDBVersion('userdata', toVersion);
diff --git a/userdata.sql b/userdata.sql
@@ -1,4 +1,4 @@
--- 55
+-- 56
 
 -- This file creates tables containing user-specific data for new users --
 -- any changes made here must be mirrored in transition steps in schema.js::_migrateSchema()