From b11bbdd16db70c14e69974d63a6bc18fb2efc730 Mon Sep 17 00:00:00 2001 From: Eloy Lafuente Date: Sun, 23 May 2010 09:23:05 +0000 Subject: [PATCH] MDL-22540 portfoliolib - cross db text comparison requires sql_compare_text() to be used --- lib/portfoliolib.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/portfoliolib.php b/lib/portfoliolib.php index 661b9c117d4..c0f2aac73fd 100644 --- a/lib/portfoliolib.php +++ b/lib/portfoliolib.php @@ -506,7 +506,7 @@ function portfolio_instances($visibleonly=true, $useronly=true) { if ($useronly) { $sql .= ' AND id NOT IN ( SELECT instance FROM {portfolio_instance_user} - WHERE userid = ? AND name = ? AND value = ? + WHERE userid = ? AND name = ? AND ' . $DB->sql_compare_text('value') . ' = ? )'; $values = array_merge($values, array($USER->id, 'visible', 0)); } -- 2.17.1