From b55d0869e9b36280d20ba9c720a06c7a41fbfaba Mon Sep 17 00:00:00 2001
From: ashleyholman <ashleyholman>
Date: Mon, 19 Oct 2009 00:18:23 +0000
Subject: [PATCH] MDL-20578 forum_print_overview() performance: fix unnecessary
 ILIKE match to make better use of log_coumodact_ix index

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

diff --git a/mod/forum/lib.php b/mod/forum/lib.php
index 82463152cc..b10bf07589 100644
--- a/mod/forum/lib.php
+++ b/mod/forum/lib.php
@@ -1203,7 +1203,7 @@ function forum_print_overview($courses,&$htmlarray) {
     }
     $sql = substr($sql,0,-3); // take off the last OR
 
-    $sql .= ") AND l.module = 'forum' AND action $LIKE 'add post%' "
+    $sql .= ") AND l.module = 'forum' AND action = 'add post' "
         ." AND userid != ? GROUP BY cmid,l.course,instance";
 
     $params[] = $USER->id;
-- 
2.39.5