[Not a bug] Admin orders product name search is missing wildcard
OK, maybe not a bug as such, but probably not the intent ?
Seen in 1.3.8 and still in 1.3.9d.
line 716 (in 1.3.9d):
does not allow a search match in all parts of product name as leading wildcard is missing on keyword. Can be solved by adding in % as:
$search = " and (op.products_model like '%" . $keywords . "%' or op.products_name like '" . $keywords . "%')";
Note: For 1.3.8, then you need to of applied bugfix http://www.zen-cart.com/forum/showpo...7&postcount=18 for the 'Search by Product Name' field to work.
$search = " and (op.products_model like '%" . $keywords . "%' or op.products_name like '%" . $keywords . "%')";
Re: Admin orders product name search is missing wildcard
That was by design not a bug so that Product Name searches had to begin with the search word ...
Many sites will find the first word more useful on a search of a Product than searching within a Product Name ...
If you need for your specific site this change would do as you have stated ...
As to making it part of the default setting in Zen Cart, at this time it would really need to be considered as previous checks on large database tables have found that to be more of a bother than a help ...
Thanks for the suggesting!
By Natty in forum Bug Reports
Last Post: 21 Jun 2010, 05:08 PM
By keylesslocks in forum General Questions
Last Post: 9 Sep 2008, 03:21 AM
By Billyboy in forum Managing Customers and Orders
Last Post: 21 Jul 2007, 08:09 PM
By marvin in forum Managing Customers and Orders
Last Post: 1 Jul 2006, 05:44 AM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC