I'm using v.1.5.1
I've added products with the following product name:
Disney Winnie the Pooh - Doing Important Things
Disney Winnie the Pooh - Friends are as Sweet as Honey
Disney Winnie the Pooh - Movie Book & CD Collection
but when i search for 'winnie' or 'Winnie' it says no result!
I've added products with the following product name:
Disney Winnie the Pooh - Doing Important Things
Disney Winnie the Pooh - Friends are as Sweet as Honey
Disney Winnie the Pooh - Movie Book & CD Collection
but when i search for 'winnie' or 'Winnie' it says no result!
open: admin/model/catalog/product.php
change lines 348 -358 into:
and lines 656 - 666 into:
the wildcards bevore the filters were missing...
change lines 348 -358 into:
Code: Select all
if (!empty($data['filter_name'])) {
$sql .= " AND LCASE(pd.name) LIKE '%" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "%'";
}
if (!empty($data['filter_model'])) {
$sql .= " AND LCASE(p.model) LIKE '%" . $this->db->escape(utf8_strtolower($data['filter_model'])) . "%'";
}
if (!empty($data['filter_price'])) {
$sql .= " AND p.price LIKE '%" . $this->db->escape($data['filter_price']) . "%'";
}
and lines 656 - 666 into:
Code: Select all
if (!empty($data['filter_name'])) {
$sql .= " AND LCASE(pd.name) LIKE '%" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "%'";
}
if (!empty($data['filter_model'])) {
$sql .= " AND LCASE(p.model) LIKE '%" . $this->db->escape(utf8_strtolower($data['filter_model'])) . "%'";
}
if (!empty($data['filter_price'])) {
$sql .= " AND p.price LIKE '%" . $this->db->escape($data['filter_price']) . "%'";
}
the wildcards bevore the filters were missing...
work for me on 1.5.5.1, thxsmartexport wrote:open: admin/model/catalog/product.php
change lines 348 -358 into:
Code: Select all
if (!empty($data['filter_name'])) { $sql .= " AND LCASE(pd.name) LIKE '%" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "%'"; } if (!empty($data['filter_model'])) { $sql .= " AND LCASE(p.model) LIKE '%" . $this->db->escape(utf8_strtolower($data['filter_model'])) . "%'"; } if (!empty($data['filter_price'])) { $sql .= " AND p.price LIKE '%" . $this->db->escape($data['filter_price']) . "%'"; }
and lines 656 - 666 into:
Code: Select all
if (!empty($data['filter_name'])) { $sql .= " AND LCASE(pd.name) LIKE '%" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "%'"; } if (!empty($data['filter_model'])) { $sql .= " AND LCASE(p.model) LIKE '%" . $this->db->escape(utf8_strtolower($data['filter_model'])) . "%'"; } if (!empty($data['filter_price'])) { $sql .= " AND p.price LIKE '%" . $this->db->escape($data['filter_price']) . "%'"; }
the wildcards bevore the filters were missing...
Baju Muslim Baju Pria Baju Anak Baju Korea Sparepart Printer Baju Muslim JNE Surabaya
Who is online
Users browsing this forum: No registered users and 101 guests