From 8df73369cef024c8623cc6e3d0d81866a9162709 Mon Sep 17 00:00:00 2001 From: skodak Date: Sat, 29 Sep 2007 16:26:13 +0000 Subject: [PATCH] MDL-11517 reserved word MOD used in table alias in questions backup code --- mod/quiz/backuplib.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/mod/quiz/backuplib.php b/mod/quiz/backuplib.php index a50e0b7e6..202bb166d 100644 --- a/mod/quiz/backuplib.php +++ b/mod/quiz/backuplib.php @@ -51,10 +51,10 @@ // then, all categories from this course's modules' contexts. // using 'dummykeyname' in sql because otherwise get_records_sql_menu returns an error // if two key names are the same. - $cmcontexts = get_records_sql_menu("SELECT c.id, c.id AS dummykeyname FROM {$CFG->prefix}modules mod, + $cmcontexts = get_records_sql_menu("SELECT c.id, c.id AS dummykeyname FROM {$CFG->prefix}modules m, {$CFG->prefix}course_modules cm, {$CFG->prefix}context c - WHERE mod.name = 'quiz' AND mod.id = cm.module AND cm.id = c.instanceid + WHERE m.name = 'quiz' AND m.id = cm.module AND cm.id = c.instanceid AND c.contextlevel = ".CONTEXT_MODULE." AND cm.course = $course"); if ($cmcontexts){ $status = $status && execute_sql("INSERT INTO {$CFG->prefix}backup_ids -- 2.11.4.GIT