Filter product name problem within admin

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!

can anyone suggest solution to this?

anyone?

same here. is there no bugfix?

found solution here:

http://forum.opencart.com/viewtopic.php?f=20&t=41428

open: admin/model/catalog/product.php

change lines 348 -358 into:

and lines 656 - 666 into:

the wildcards bevore the filters were missing...

smartexport 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...

work for me on 1.5.5.1, thx