http://atutor.ca/atutor/mantis/view.php?id=3059

diff --git a/docs/admin/language_editor.php b/docs/admin/language_editor.php
index 67bc81c..121bbb1 100644 (file)
--- a/docs/admin/language_editor.php
+++ b/docs/admin/language_editor.php
@@ -70,7 +70,7 @@ if (isset($_GET['filter'], $_GET['search'])) {
                // search `term` and `text` only
                if (strlen($word) > 1) {
                        $word = str_replace(array('%','_'), array('\%', '\_'), $word);
-                       $words[$key] = "(`term` LIKE '%$word%' OR `text` LIKE '%$word%')";
+                       $words[$key] = "(CAST(`term` AS CHAR) LIKE '%$word%' OR CAST(`text` AS CHAR) LIKE '%$word%')";
                } else {
                        unset($words[$key]);
                }

diff --git a/docs/admin/translator.php b/docs/admin/translator.php
index 8f31897..5c2ba9c 100644 (file)
--- a/docs/admin/translator.php
+++ b/docs/admin/translator.php
@@ -537,7 +537,7 @@ function display_search_terms ($variable, $term1, $lang_code, $new, $updated) {
 
        $_REQUEST['search_term'] = $addslashes($_REQUEST['search_term']);
 
-       $sql    = "SELECT term, revised_date+0  AS r_date FROM ".TABLE_PREFIX."language_text WHERE (variable LIKE '%$_REQUEST[search_term]%' OR text LIKE '%$_REQUEST[search_term]%') AND (`language_code`='$_SESSION[language]' OR `language_code`='en') GROUP BY `term` ORDER BY `term`";
+       $sql    = "SELECT term, revised_date+0  AS r_date FROM ".TABLE_PREFIX."language_text WHERE (variable LIKE '%$_REQUEST[search_term]%' OR CAST(`text` AS CHAR) LIKE '%$_REQUEST[search_term]%') AND (`language_code`='$_SESSION[language]' OR `language_code`='en') GROUP BY `term` ORDER BY `term`";
        $result = mysql_query($sql, $db);
 
        $t_keys = array();
@@ -545,7 +545,7 @@ function display_search_terms ($variable, $term1, $lang_code, $new, $updated) {
                $t_keys[$row['term']] = $row['r_date'];
        }
 
-       $sql    = "SELECT *, revised_date+0 AS r_date FROM ".TABLE_PREFIX."language_text WHERE (variable LIKE '%$_REQUEST[search_term]%' OR text LIKE '%$_REQUEST[search_term]%') AND (language_code='en' OR language_code='$_SESSION[language]') GROUP BY `term` ORDER BY term";
+       $sql    = "SELECT *, revised_date+0 AS r_date FROM ".TABLE_PREFIX."language_text WHERE (variable LIKE '%$_REQUEST[search_term]%' OR CAST(`text` AS CHAR) LIKE '%$_REQUEST[search_term]%') AND (language_code='en' OR language_code='$_SESSION[language]') GROUP BY `term` ORDER BY term";
        $result = mysql_query($sql, $db);
 
        if (mysql_num_rows($result) == 0) {