Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040008.sql
===================================================================
diff -u -rd8cad0ad05b4177fc1b94cdfd4808b357cc2457d -r42cec7b569b71ae6cb9ad03c6e8385e396a53ed0
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040008.sql	(.../patch02040008.sql)	(revision d8cad0ad05b4177fc1b94cdfd4808b357cc2457d)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040008.sql	(.../patch02040008.sql)	(revision 42cec7b569b71ae6cb9ad03c6e8385e396a53ed0)
@@ -5,8 +5,10 @@
 UPDATE lams_learning_activity AS act
  JOIN  lams_learning_transition AS trans_to
   ON trans_to.to_activity_id = act.activity_id
+  AND trans_to.transition_type = 0
  JOIN lams_learning_transition AS trans_from
   ON trans_from.from_activity_id = act.activity_id
+  AND trans_to.transition_type = 0
  SET act.transition_from_id = trans_from.transition_id,
      act.transition_to_id = trans_to.transition_id;