From ca8874dcee218318ae0ee8c8a42fad4a395053ab Mon Sep 17 00:00:00 2001
From: jerome <jerome>
Date: Mon, 3 Aug 2009 04:02:39 +0000
Subject: [PATCH] installation MDL-19984 fix SQL error during upgrade process

---
 lib/db/upgrade.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index 0534cc6585..2def886abf 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -2441,7 +2441,7 @@ WHERE gradeitemid IS NOT NULL AND grademax IS NOT NULL");
             // Find a category to put the courses in:
             $categories = $DB->get_records_sql('SELECT * ' .
                     'FROM {course_categories} ' .
-                    'WHERE name ilike \'misc%\' ' .
+                    'WHERE name like \'misc%\' ' .
                     'ORDER BY id asc');
             if (!empty($categories)) {
                 $category = array_shift($categories);
-- 
2.39.5