Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040008.sql
===================================================================
diff -u -r42cec7b569b71ae6cb9ad03c6e8385e396a53ed0 -rb76a4e3c1671ae8ec885d76976976971ca6a02ff
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040008.sql	(.../patch02040008.sql)	(revision 42cec7b569b71ae6cb9ad03c6e8385e396a53ed0)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040008.sql	(.../patch02040008.sql)	(revision b76a4e3c1671ae8ec885d76976976971ca6a02ff)
@@ -8,7 +8,7 @@
   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
+  AND trans_from.transition_type = 0
  SET act.transition_from_id = trans_from.transition_id,
      act.transition_to_id = trans_to.transition_id;