From e874292134402dceb69ee4c8174c4b8565b9984c Mon Sep 17 00:00:00 2001 From: Aaron Barnes Date: Wed, 27 Apr 2011 15:56:48 +1200 Subject: [PATCH] MDL-25594 completion: Remove unused column from query Which is also a reserved word. --- lib/completion/completion_criteria_activity.php | 1 - lib/completion/completion_criteria_duration.php | 1 - lib/completion/completion_criteria_grade.php | 1 - 3 files changed, 3 deletions(-) diff --git a/lib/completion/completion_criteria_activity.php b/lib/completion/completion_criteria_activity.php index 803dd94750c..6103731b2e1 100644 --- a/lib/completion/completion_criteria_activity.php +++ b/lib/completion/completion_criteria_activity.php @@ -193,7 +193,6 @@ class completion_criteria_activity extends completion_criteria { $sql = ' SELECT DISTINCT c.id AS course, - cr.timeend AS date, cr.id AS criteriaid, ra.userid AS userid, mc.timemodified AS timecompleted diff --git a/lib/completion/completion_criteria_duration.php b/lib/completion/completion_criteria_duration.php index bb4ab66abb0..6ce85e9b2cd 100644 --- a/lib/completion/completion_criteria_duration.php +++ b/lib/completion/completion_criteria_duration.php @@ -181,7 +181,6 @@ class completion_criteria_duration extends completion_criteria { $sql = ' SELECT c.id AS course, - cr.timeend AS date, cr.id AS criteriaid, u.id AS userid, ue.timestart AS otimestart, diff --git a/lib/completion/completion_criteria_grade.php b/lib/completion/completion_criteria_grade.php index 00e75aba568..c1ff8a07122 100644 --- a/lib/completion/completion_criteria_grade.php +++ b/lib/completion/completion_criteria_grade.php @@ -177,7 +177,6 @@ class completion_criteria_grade extends completion_criteria { $sql = ' SELECT DISTINCT c.id AS course, - cr.timeend AS date, cr.id AS criteriaid, ra.userid AS userid, gg.finalgrade AS gradefinal, -- 2.43.0