From 602654f358f2da6fa416e3acfecd973fac596051 Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Fri, 26 Oct 2007 07:58:23 +0000
Subject: [PATCH] merged fix for MDL-11532, updatesql needs to run after every
 'round' otherwises nothing to pull from the context table

---
 lib/accesslib.php | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

diff --git a/lib/accesslib.php b/lib/accesslib.php
index f7602c7f7f..4f36f5a994 100755
--- a/lib/accesslib.php
+++ b/lib/accesslib.php
@@ -4737,11 +4737,13 @@ function build_context_path($force=false, $feedback=false) {
                                        WHERE temp.id = ctx.id)
                        $ctxemptyclause";
         execute_sql($sql, $feedback);
+        
+        // this is needed after every loop
+        // MDL-11532
+        execute_sql($updatesql, $feedback);
+        execute_sql($udelsql, $feedback);
     }
 
-    execute_sql($updatesql, $feedback);
-    execute_sql($udelsql, $feedback);
-
     // Courses -- except sitecourse
     $sql = "INSERT INTO {$CFG->prefix}context_temp (id, path, depth)
             SELECT ctx.id, ".sql_concat('pctx.path', "'/'", 'ctx.id').", pctx.depth+1
-- 
2.39.5