From 61091a5457aa4ac1f6693d29242c01fa86aa1f75 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Fr=C3=A9d=C3=A9ric=20Massart?= Date: Tue, 1 May 2018 20:02:09 +0800 Subject: [PATCH] MDL-62167 core_badges: Remove usage of a reserved keyword of Oracle --- badges/classes/privacy/provider.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/badges/classes/privacy/provider.php b/badges/classes/privacy/provider.php index 376ba42bca7..1b198cb1be1 100644 --- a/badges/classes/privacy/provider.php +++ b/badges/classes/privacy/provider.php @@ -299,10 +299,10 @@ class provider implements if (in_array($userid, $contexts[CONTEXT_USER])) { // Export the badges. - $uid = $DB->sql_concat_join("'-'", ['b.id', 'COALESCE(bc.id, 0)', 'COALESCE(bi.id, 0)', + $uniqueid = $DB->sql_concat_join("'-'", ['b.id', 'COALESCE(bc.id, 0)', 'COALESCE(bi.id, 0)', 'COALESCE(bma.id, 0)', 'COALESCE(bcm.id, 0)']); $sql = " - SELECT $uid AS uid, b.id, + SELECT $uniqueid AS uniqueid, b.id, bi.id AS biid, bi.dateissued, bi.dateexpire, bi.uniquehash, bma.id AS bmaid, bma.datemet, bma.issuerid, bcm.id AS bcmid, -- 2.11.4.GIT