Zen Cart Product Tags (and Tag Cloud): Support Thread

[lat9]

Here is the myDEBUG

[28-Dec-2019 14:55:53 UTC] Request URI: /index.php?main_page=advanced_search_result&keyword=IntelliMouse&search_in_description=1&categories_id=1&inc_subcat=1&manufacturers_id=&pfrom=&pto=&dfrom=&dto=, IP address: 
#1  trigger_error() called at [/.../..../public_html/includes/classes/db/mysql/query_factory.php:171]
#2  queryFactory->show_error() called at [/...../....../public_html/includes/classes/db/mysql/query_factory.php:143]
#3  queryFactory->set_error() called at [/...../...../public_html/includes/classes/db/mysql/query_factory.php:270]
#4  queryFactory->Execute() called at [/....../....../public_html/includes/classes/split_page_results.php:78]
#5  splitPageResults->__construct() called at [/...../....../public_html/includes/modules/pages/advanced_search_result/header_php.php:476]
#6  require(/...../...../public_html/includes/modules/pages/advanced_search_result/header_php.php) called at [/....../....../public_html/index.php:36]
--> PHP Fatal error: 1305:FUNCTION .................17OR does not exist :: select count(distinct p.products_id) as total  FROM (zen_products p              LEFT JOIN zen_manufacturers m              USING(manufacturers_id), zen_products_description pd, zen_categories c, zen_tags t,  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 LEFT JOIN zen_tags_to_products t2p ON t2p.tag_mapping_id = p.products_id  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 p2c.products_id = p.products_id                     AND p2c.products_id = pd.products_id                     AND (p2c.categories_id = 1 OR p2c.categories_id in ( 4, 5, 6, 7, 8, 9, 16, 17OR ( t.tag_id = t2p.tag_id AND t.languages_id = 1 AND t.tag_name LIKE '%intellimouse%') )) AND ((pd.products_name LIKE '%intellimouse%'                                          OR p.products_model                                          LIKE '%intellimouse%'                                          OR m.manufacturers_name                                          LIKE '%intellimouse%' OR (mtpd.metatags_keywords                         LIKE '%intellimouse%'                         AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description                         LIKE '%intellimouse%'                         AND mtpd.metatags_description !='') OR pd.products_description                           LIKE '%intellimouse%') OR ( t.tag_id = t2p.tag_id AND t.languages_id = 1 AND t.tag_name LIKE '%intellimouse%') )) ==> (as called by) /............/............../public_html/includes/classes/split_page_results.php on line 78 <== in /......../............./public_html/includes/classes/db/mysql/query_factory.php on line 171.

Thanks, that's a big help. I should have a correction available 'soon'.