MDL-29496 Search, Course - Code applied from patch to allow courses with a blank...

diff --git a/lib/datalib.php b/lib/datalib.php
index 478156c..5034627 100644 (file)
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -717,7 +717,7 @@ function get_courses_search($searchterms, $sort='fullname ASC', $page=0, $record
     $params     = array();
     $i = 0;
 
-    $concat = $DB->sql_concat('c.summary', "' '", 'c.fullname', "' '", 'c.idnumber', "' '", 'c.shortname');
+    $concat = $DB->sql_concat("COALESCE(c.summary, ". $DB->sql_empty() .")", "' '", 'c.fullname', "' '", 'c.idnumber', "' '", 'c.shortname');
 
     foreach ($searchterms as $searchterm) {
         $i++;