From 033d656617bd841586d7d9585ce7896c47c26fb1 Mon Sep 17 00:00:00 2001 From: "Eloy Lafuente (stronk7)" Date: Sun, 9 Oct 2011 22:15:27 +0200 Subject: [PATCH] MDL-29520 - mysql multitable delete, outer join some tables --- question/engine/datalib.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/question/engine/datalib.php b/question/engine/datalib.php index a0eeb38282d..092eaa15851 100644 --- a/question/engine/datalib.php +++ b/question/engine/datalib.php @@ -695,8 +695,8 @@ ORDER BY DELETE qu, qa, qas, qasd FROM {question_usages} qu JOIN {question_attempts} qa ON qa.questionusageid = qu.id - JOIN {question_attempt_steps} qas ON qas.questionattemptid = qa.id - JOIN {question_attempt_step_data} qasd ON qasd.attemptstepid = qas.id + LEFT JOIN {question_attempt_steps} qas ON qas.questionattemptid = qa.id + LEFT JOIN {question_attempt_step_data} qasd ON qasd.attemptstepid = qas.id WHERE qu.id ' . $qubaids->usage_id_in(), $qubaids->usage_id_in_params()); } @@ -713,7 +713,7 @@ ORDER BY $this->db->execute(' DELETE qas, qasd FROM {question_attempt_steps} qas - JOIN {question_attempt_step_data} qasd ON qasd.attemptstepid = qas.id + LEFT JOIN {question_attempt_step_data} qasd ON qasd.attemptstepid = qas.id WHERE qas.questionattemptid ' . $test, $params); } -- 2.36.1