From b7b88c090d4afce692d1a100da1fbb3774a12647 Mon Sep 17 00:00:00 2001 From: Petr Skoda Date: Wed, 29 Sep 2010 08:16:13 +0000 Subject: [PATCH] MDL-24339 workaround for broken parents in block instances --- lib/accesslib.php | 2 ++ 1 file changed, 2 insertions(+) diff --git a/lib/accesslib.php b/lib/accesslib.php index c45f307bdf1..77968f275e4 100755 --- a/lib/accesslib.php +++ b/lib/accesslib.php @@ -5701,12 +5701,14 @@ function build_context_path($force=false) { $DB->execute($sql); // Blocks + // pctx.path IS NOT NULL prevents fatal problems with broken block instances that point to invalid context parent $sql = "INSERT INTO {context_temp} (id, path, depth) SELECT ctx.id, ".$DB->sql_concat('pctx.path', "'/'", 'ctx.id').", pctx.depth+1 FROM {context} ctx JOIN {block_instances} bi ON ctx.instanceid = bi.id JOIN {context} pctx ON bi.parentcontextid = pctx.id WHERE ctx.contextlevel=".CONTEXT_BLOCK." + AND pctx.path IS NOT NULL AND NOT EXISTS (SELECT 'x' FROM {context_temp} temp WHERE temp.id = ctx.id) -- 2.17.1