#7 search does not work

[Anonymous]

Originally created by: rodnove... (code.google.com)@gmail.com

module catalog/model/catalog/product.php, function getProductsByKeyword and getTotalProductsByKeyword missing function LCASE(). Needs:
                       if (!$description) {
                                $sql .= " AND (LCASE(pd.name) LIKE '%" . $this->db->escape($keyword) . "%'"; // <----- missing here
                        } else {
                                $sql .= " AND (LCASE(pd.name) LIKE '%" . $this->db->escape($keyword) . "%' OR LCASE(pd.description) LIKE '%" . $this->db->escape($keyword) . "%'"; // <----- missing here

                        if (!$model) {
                                $sql .= ")";
                        } else {
                                $sql .= " OR LCASE(p.model) LIKE '%" . $this->db->escape($keyword) . "%')";// <----- missing here
                        }

P.S.: Sorry my google translate. :)