Advanced Search Plus

I've run into a small problem with the new version. When testing carts, I frequently just try to retrieve really cheap products to buy. If you add in the price function with no keywords as I normally do, I get an error:

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 e.toc_chapter, e.toc_sort_order, e.pages_title' at line 1 :: SELECT * from ezpages e where (e.status_header = 1 or e.status_footer = 1 or e.status_sidebox = 1) and order by e.toc_chapter, e.toc_sort_order, e.pages_title ==> (as called by) /home/domain/public_html/includes/modules/coffee/advanced_search_ezpages.php on line 77 <== in /home/domain/public_html/includes/classes/db/mysql/query_factory.php on line 155

puhycz:

Hi, I have problem with this plugin. It works all great, but no showing catregory name in results. The $listing->fields['categories_id'] in tpl_modules_advanced_search_categories.php is clean... Where will be problem?

Many thanks.

I'm having this issue too. I'm running 2.03 of the module on Zen Cart 1.5.5e.

In tpl_modules_advanced_search_categories.php, if I change

 
        $lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new). '">' . $listing->fields['categories_[B]name[/B]'] . '</a></h3><div class="listingDescription">'. zen_trunc_string(zen_clean_html(stripslashes(zen_get_category_description($listing->fields['categories_id'], $_SESSION['languages_id'])))) . '</div>' ;                

to

        $lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new). '">' . $listing->fields['categories_[B]id[/B]'] . '</a></h3><div class="listingDescription">'. zen_trunc_string(zen_clean_html(stripslashes(zen_get_category_description($listing->fields['categories_id'], $_SESSION['languages_id'])))) . '</div>' ;                

I do see a hyperlink to the category ID number.

I love this module and it fixes what I consider to be a big oversight in Zen Cart, so I'm hoping this can be resolved.

I've started updates to this module, watch for the 1.55f release shortly :)

Gamethrall:

I'm having this issue too. I'm running 2.03 of the module on Zen Cart 1.5.5e.

In tpl_modules_advanced_search_categories.php, if I change

    $lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new). '">' . $listing->fields['categories_[B]name[/B]'] . '</a></h3><div class="listingDescription">'. zen_trunc_string(zen_clean_html(stripslashes(zen_get_category_description($listing->fields['categories_id'], $_SESSION['languages_id'])))) . '</div>' ;                

> 
> to 
> ```
        $lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new). '">' . $listing->fields['categories_[B]id[/B]'] . '</a></h3><div class="listingDescription">'. zen_trunc_string(zen_clean_html(stripslashes(zen_get_category_description($listing->fields['categories_id'], $_SESSION['languages_id'])))) . '</div>' ;                

I do see a hyperlink to the category ID number.

I love this module and it fixes what I consider to be a big oversight in Zen Cart, so I'm hoping this can be resolved.

The Fix:
includes/modules/YOUR_TEMPLATE/advanced_search_categories.php
**
replace line 45**
$select_str_cat = "SELECT DISTINCT " . $select_column_list_cat . "cd.categories_description, cd.categories_id, c.parent_id ";

with this:
$select_str_cat = "SELECT DISTINCT " . $select_column_list_cat . "cd.categories_description, cd.categories_id, c.parent_id**, cd.categories_name** ";

This will display the correctly named category name below the image as a clickable link.

Advanced Search Plus has been rewritten to work with 1.56c and will be submitted shortly.

This module has been included in the Twitch Base6 core.

All known bugs have been fixed, some new features added.

Thanks for your support! :cheers:

This module generates PHP Warning logs when used with PHP 7.x
Specifically
PHP Warning: Use of undefined constant CATEGORY_LIST_NAME - assumed 'CATEGORY_LIST_NAME' in advanced_search_categories.php on line 15.
PHP Warning: Use of undefined constant CATEGORY_LIST_IMAGE - assumed 'CATEGORY_LIST_IMAGE' in advanced_search_categories.php on line 16.

The issue here seems to be that the module doesn't contain any SQL commands to add these to the configuration table.

I simply added them to the end of Configuration > Product Listing as that is where the Product versions of these defines are set.

If you wish to do the same, run this from admin Tools > Install SQL Patches

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function, val_function) VALUES
(NULL, 'Display Category Image', 'CATEGORY_LIST_IMAGE', '0', 'Do you want to display the Category Image?', 8, 50, NULL, 'NOW()', NULL, NULL, NULL),
(NULL, 'Display Category Name', 'CATEGORY_LIST_NAME', '1', 'Do you want to display the Category Name?', 8, 51, NULL, 'NOW()', NULL, NULL, NULL);

Hello. Are there any updates on this plugin? I don't see it updated on the ZC site or your own. Or is anyone using an alternative?

jsquared:

Hello. Are there any updates on this plugin? I don't see it updated on the ZC site or your own. Or is anyone using an alternative?

Yes public releases are on the way, I'm almost finished Twitch Wholesale PRO then all Twitch modules will be updated

twitchtoo:

Advanced Search Plus has been rewritten to work with 1.56c and will be submitted shortly.

This module has been included in the Twitch Base6 core.

All known bugs have been fixed, some new features added.

Thanks for your support! :cheers:
Was this ever submitted?

lat9:

Was this ever submitted?

Twitch Advanced Search Plus for 1.55f

and

Twitch Advanced Search Plus for 1.56c

have been submitted to the forum plugins...

today.

:eek:

I'll take a short break and get one made for 1.57c tonight.

Submitted to the forum plugins:

Twitch Advanced Search Plus (Public Release)
21a for ZenCart v1.57c
June 24.2021

Updates for 1.57c...

• PHP each() function deprecated - fixed in - includes/modules/advanced_search_categories.php (line 23)
• Added Category Path display switch in Admin

Zen Cart 1.57c fileset included.

Not backwards compatible with previous versions.

***And ***

Twitch Advanced Search Plus (Public Release)
20j for ZenCart v1.56c
June 24.2021

Updates for 1.56c...

• Master ON/OFF switch
• Properly displays category name, category path - breadcrumb text for categories and products
• Control Category Image and Name display on product listing
• Integrates with Twitch Product Listing Advanced for 1.56c (module not included) This module allows advanced user/admin control of product listing features old and new, along with Twitch MRC (product groups) compatibility.

** - PHP each() function deprecated - fixed in - includes/modules/advanced_search_categories.php (line 23)**

These replace any previous versions for their respective Zen Cart version only.

If my work has helped you today in any way, show your appreciation with things like positive feedback or donations.
Find me at https://www.twitchtoo.com

:cheers:

Available for 1.57 here:
https://www.zen-cart.com/downloads.php?do=file&id=822

Hi,

Thank you twitchtoo for creating this fabulous plugin! I have installed it in my v.1.5.8 cart and it works great, brings up and shows images of my search results. The one thing is if you simply type in a Search query and hit Enter, it comes up with the buffering circle and continues and continues.

Have I done something wrong in my install or have a setting in Admin wrong? I don't want customers turned off from using the Search if they use it this way rather than waiting that millisecond and having the results come up.

Any ideas on how I could fix this??

Thank you for your help.