From e88370a6a3774150a682fa66316aef8140d2cd2d Mon Sep 17 00:00:00 2001 From: martinlanghoff Date: Tue, 4 Dec 2007 06:25:56 +0000 Subject: [PATCH] blocks/online_users: Remove SQL "id,id" which causes errors on Oracle - MDL-12425 Credit for the fix goes to Dennis Rochford --- blocks/online_users/block_online_users.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/blocks/online_users/block_online_users.php b/blocks/online_users/block_online_users.php index 06bec16b73..13c14ad7ae 100644 --- a/blocks/online_users/block_online_users.php +++ b/blocks/online_users/block_online_users.php @@ -89,7 +89,7 @@ class block_online_users extends block_base { // user has a hidden role assigned at this context or any parent contexts, // ignore this user - $SQL = "SELECT id,id FROM {$CFG->prefix}role_assignments + $SQL = "SELECT id FROM {$CFG->prefix}role_assignments WHERE userid = $puser->id AND contextid $pcontext AND hidden = 1"; -- 2.39.5