[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 swguy in forum Bug Reports
Last Post: 27 Apr 2015, 03:47 AM
By rudyh01 in forum Basic Configuration
Last Post: 13 Dec 2011, 03:47 PM
By saitomedia in forum General Questions
Last Post: 10 Feb 2010, 08:01 AM
By keylesslocks in forum General Questions
Last Post: 9 Sep 2008, 03:21 AM
By langer in forum Bug Reports
Last Post: 7 Dec 2006, 10:34 PM
Content and Graphics Copyright (c) 2003 - 2017 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC