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

[lat9]

Coming soon! I'm wrapping up the distribution for the Zen Cart Product's "Tag Cloud" plugin.

This plugin, like its WordPress equivalent, enables your store to display a "Tag Cloud" sidebox through which your customers can search for your products using their defined "tags".

The admin-level handling uses a bit of AJAX to allow you to easily define those tags. The plugin requires a couple of admin-level core-file edits, for Zen Cart 1.5.6 and later, to add notifications that are already "baked into" Zen Cart 1.5.7 and later to enable those definitions.

[lat9]

I've just submitted v1.0.0 to the Zen Cart moderators for review; I'll post back here when it's available for download (https://www.zen-cart.com/downloads.php?do=file&id=2262).

[lat9]

I've just submitted v1.0.0 to the Zen Cart moderators for review; I'll post back here when it's available for download (https://www.zen-cart.com/downloads.php?do=file&id=2262).

Now available for download.

[Ingar]

Hello. I have just installed the plugin. It's hard to say why at the moment but it seems to get negatively affected the site's "search by keyword" functionality. The feature doesn't work any longer, in fact it completely crashed. The advanced search gives you the following message: "WARNING: An Error occurred, please refresh the page and try again".http://ingars.org/
Here you can compare. http://ingars.000webhostapp.com/. There is no plugin installed

[lat9]

Hello. I have just installed the plugin. It's hard to say why at the moment but it seems to get negatively affected the site's "search by keyword" functionality. The feature doesn't work any longer, in fact it completely crashed. The advanced search gives you the following message: "WARNING: An Error occurred, please refresh the page and try again".http://ingars.org/
Here you can compare. http://ingars.000webhostapp.com/. There is no plugin installed

FWIW, I just tried an "advanced search" with no warning on the ingars.org site. When you saw that error message, did you find an associated myDEBUG*.log file in the store's /logs sub-directory?

[Ingar]

Just experimenting looking for mouse.


But in fact there is a mouse on sale. See the other hoster

than you choose hardware + include subcategories checker and finally the warning message. I'll pull out the log.

[lat9]

What version of Zen Cart is in use? Did that fluorspar template make any changes to the default /includes/modules/pages/advanced_search_result/header_php.php file?

[Ingar]

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.

[Ingar]

What version of Zen Cart is in use? Did that fluorspar template make any changes to the default /includes/modules/pages/advanced_search_result/header_php.php file?

The v1.5.6c. I don't know. Will check it out.

[Ingar]

No it appears the template does not have "advanced_search_result" folder at all.