Advanced Search Plus

[delia]

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

[Gamethrall]

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_name'] . '</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_id'] . '</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.

[twitchtoo]

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

[twitchtoo]

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_name'] . '</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_id'] . '</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.

[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!

[strelitzia]

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);

[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?

[twitchtoo]

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

[lat9]

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!

Was this ever submitted?

[twitchtoo]

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.




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