MDL-22540 portfoliolib - cross db text comparison requires sql_compare_text() to...

diff --git a/lib/portfoliolib.php b/lib/portfoliolib.php
index 661b9c1..c0f2aac 100644 (file)
--- 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));
     }