Post by rize » Wed Dec 07, 2011 4:17 pm

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!
winnie.png

winnie.png (14.63 KiB) Viewed 2214 times

Winnie1.png

Winnie1.png (15.27 KiB) Viewed 2214 times


New member

Posts

Joined
Fri Jul 15, 2011 11:29 am

Post by rize » Thu Dec 08, 2011 11:24 am

can anyone suggest solution to this?

New member

Posts

Joined
Fri Jul 15, 2011 11:29 am

Post by rize » Fri Dec 09, 2011 8:39 am

anyone?

New member

Posts

Joined
Fri Jul 15, 2011 11:29 am

Post by smartexport » Wed Dec 28, 2011 3:53 pm

same here. is there no bugfix?

Newbie

Posts

Joined
Wed Dec 28, 2011 3:52 pm

Post by smartexport » Wed Dec 28, 2011 3:54 pm


Newbie

Posts

Joined
Wed Dec 28, 2011 3:52 pm

Post by smartexport » Wed Dec 28, 2011 4:14 pm

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

Newbie

Posts

Joined
Wed Dec 28, 2011 3:52 pm

Post by xlam » Wed Jul 09, 2014 1:07 pm

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

Baju Muslim Baju Pria Baju Anak Baju Korea Sparepart Printer Baju Muslim JNE Surabaya


New member

Posts

Joined
Sun Dec 25, 2011 2:58 pm
Who is online

Users browsing this forum: No registered users and 101 guests