Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql
===================================================================
diff -u -refb2ec520c430c4361de9ce26492bc18de4eba2f -rf1c2d9fdf1755b9fb82145c61e706b4e51a55373
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql	(.../patch0013_updateFrom21.sql)	(revision efb2ec520c430c4361de9ce26492bc18de4eba2f)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql	(.../patch0013_updateFrom21.sql)	(revision f1c2d9fdf1755b9fb82145c61e706b4e51a55373)
@@ -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-------------------------
+
 -- LDEV1909 - Competence Editor Update Scripts ---------------------------------
 CREATE TABLE lams_competence (
        competence_id BIGINT NOT NULL UNIQUE auto_increment
@@ -49,4 +55,10 @@
 VALUES (10, 14, 'Condition Gate', 'Gate: Opens if conditions are met', 
 	'learning/gate.do?method=knockGate', 'learning/gate.do?method=knockGate', null, null, 
 	'monitoring/gateExportPortfolio?mode=teacher', 'monitoring/gate.do?method=viewGate', 
-	'monitoring/gate.do?method=viewGate', now()	);
\ No newline at end of file
+	'monitoring/gate.do?method=viewGate', now()	);
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 0
\ No newline at end of file