Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql,v
diff -u -r1.7 -r1.8
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql	6 Nov 2008 23:43:39 -0000	1.7
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql	6 Nov 2008 23:46:29 -0000	1.8
@@ -61,4 +61,4 @@
 
 -- If there were no errors, commit and restore autocommit to on
 COMMIT;
-SET AUTOCOMMIT = 0
\ No newline at end of file
+SET AUTOCOMMIT = 1;
\ No newline at end of file
Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081027_updateFrom21.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081027_updateFrom21.sql,v
diff -u -r1.1 -r1.2
--- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081027_updateFrom21.sql	27 Oct 2008 03:31:23 -0000	1.1
+++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081027_updateFrom21.sql	6 Nov 2008 23:52:44 -0000	1.2
@@ -1,3 +1,9 @@
+
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
 -- SQL statements to update from LAMS 2.1/2.1.1
 CREATE TABLE tl_lachat11_conditions (
        condition_id BIGINT(20) NOT NULL
@@ -9,4 +15,10 @@
                   REFERENCES tl_lachat11_chat(uid) ON DELETE CASCADE ON UPDATE CASCADE
 )TYPE=InnoDB;
 
-UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lachat11';
\ No newline at end of file
+UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lachat11';
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
\ No newline at end of file
Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql,v
diff -u -r1.1 -r1.2
--- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql	27 Oct 2008 00:53:02 -0000	1.1
+++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql	6 Nov 2008 23:52:43 -0000	1.2
@@ -1,5 +1,10 @@
 -- SQL statements to update from LAMS 2.1/2.1.1
 
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
 CREATE TABLE tl_lafrum11_conditions (
        condition_id BIGINT(20) NOT NULL
 	 , content_uid BIGINT(20)
@@ -18,4 +23,10 @@
                   REFERENCES tl_lafrum11_conditions(condition_id) ON DELETE CASCADE ON UPDATE CASCADE
 	 , CONSTRAINT ForumConditionQuestionToForumQuestion FOREIGN KEY (topic_uid)
                   REFERENCES tl_lafrum11_message(uid) ON DELETE CASCADE ON UPDATE CASCADE	
-)TYPE=InnoDB;
\ No newline at end of file
+)TYPE=InnoDB;
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
\ No newline at end of file
Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql,v
diff -u -r1.5 -r1.6
--- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql	4 Nov 2008 05:17:02 -0000	1.5
+++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql	6 Nov 2008 23:52:44 -0000	1.6
@@ -1,4 +1,12 @@
 -- SQL statements to update from LAMS 2.1/2.1.1
+
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
+
+-- SQL statements to update from LAMS 2.1/2.1.1
 CREATE TABLE tl_laqa11_conditions (
        condition_id BIGINT(20) NOT NULL
 	 , content_uid BIGINT(20)
@@ -25,11 +33,8 @@
 ALTER TABLE tl_laqa11_que_content MODIFY COLUMN qa_content_id BIGINT(20);
 
 SET FOREIGN_KEY_CHECKS=0;
+
 -- insert scripts for the wizard tables
-drop table if exists tl_laqa11_configuration;
-drop table if exists tl_laqa11_wizard_category;
-drop table if exists tl_laqa11_wizard_cognitive_skill;
-drop table if exists tl_laqa11_wizard_question;
 create table tl_laqa11_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid))TYPE=InnoDB;
 create table tl_laqa11_wizard_category (uid bigint not null auto_increment, title varchar(255) not null, primary key (uid))TYPE=InnoDB;
 create table tl_laqa11_wizard_cognitive_skill (uid bigint not null auto_increment, title varchar(255) not null, category_uid bigint, primary key (uid))TYPE=InnoDB;
@@ -50,3 +55,10 @@
 
 -- updating q&a to have an admin page for the qa wizard
 UPDATE lams_tool SET admin_url='tool/laqa11/laqa11admin.do' WHERE tool_signature='laqa11';
+
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20080929_updateFrom21.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20080929_updateFrom21.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20080929_updateFrom21.sql	31 Oct 2008 01:41:51 -0000	1.2
+++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20080929_updateFrom21.sql	6 Nov 2008 23:52:44 -0000	1.3
@@ -1,4 +1,10 @@
 -- SQL statements to update from LAMS 2.1/2.1.1
+
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
 CREATE TABLE tl_lantbk11_conditions (
        condition_id BIGINT(20) NOT NULL
 	 , content_uid BIGINT(20)
@@ -9,4 +15,10 @@
                   REFERENCES tl_lantbk11_notebook(uid) ON DELETE CASCADE ON UPDATE CASCADE
 )TYPE=InnoDB;
 
-UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lantbk11';
\ No newline at end of file
+UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lantbk11';
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
\ No newline at end of file
Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql,v
diff -u -r1.1 -r1.2
--- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql	22 Oct 2008 00:11:48 -0000	1.1
+++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql	6 Nov 2008 23:52:44 -0000	1.2
@@ -1,5 +1,10 @@
 -- SQL statements to update from LAMS 2.1/2.1.1
 
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
 CREATE TABLE tl_lasurv11_conditions (
        condition_id BIGINT(20) NOT NULL
 	 , content_uid BIGINT(20)
@@ -20,4 +25,10 @@
                   REFERENCES tl_lasurv11_question(uid) ON DELETE CASCADE ON UPDATE CASCADE	
 )TYPE=InnoDB;
 
-UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lasurv11';
\ No newline at end of file
+UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lasurv11';
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
\ No newline at end of file