I tried advance_search_result page code that came in module and it caused search function to stop on my site. For each keyword it shows no matching product found. Any idea who to merge this file or fix this issue?
I tried advance_search_result page code that came in module and it caused search function to stop on my site. For each keyword it shows no matching product found. Any idea who to merge this file or fix this issue?
If you continue to have problems with this plugin you may want to try CSAR - https://www.zen-cart.com/downloads.php?do=file&id=1234 - which gives you even more flexibility. The mod has been recently updated.
Version 2.1.1 is for ZC 1.5.4 only though.
but CSAR does not hide categories right?
if im using zen 1.5.1 do i use csar v2.0 only
My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.
does the current version work with 1.5.1
I downloaded it however the however I can't get the installation link to work that tells you how to install it. When I click on it, just void comes up. Can I get the installation instructions sent to me?
Hello
having trouble with the addon:
- did a proper instal, I did run the sql command, open and saved the categories (and subcategories within them) ... now when I use the search box for a product that is not hidden, I get the following message
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by p.products_sort_order, pd.products_name limit 15' at line 1
in:
[SELECT DISTINCT p.products_image, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status, p.master_categories_id FROM (zen_products p LEFT JOIN zen_manufacturers m USING(manufacturers_id), zen_products_description pd, zen_categories c, zen_products_to_categories p2c ) LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%bof001%' OR p.products_model LIKE '%bof001%' OR m.manufacturers_name LIKE '%bof001%' OR (mtpd.metatags_keywords LIKE '%bof001%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%bof001%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%bof001%') )) order by p.products_sort_order, pd.products_name order by p.products_sort_order, pd.products_name limit 15]
any suggestion where the problem come from ?
thanks
My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.
Bookmarks