Duplicates in advanced search results by price

[gandalfsmith]

New install of V1.5
Template = Bloom Blue Theme

Changes - all products use the product_music type to be entered in admin
(ie) music_genre = Ocassion
(ie) record_company = Recipent

If you look at the site and the drop downs to do a search by Ocassion or Receipent they all work fine (not showing duplicates)
http://wickerwarehouse.co.uk/lladro/...ic_genre_id=13
http://wickerwarehouse.co.uk/lladro/...d_company_id=2

HOWEVER if you do the search by price
http://wickerwarehouse.co.uk/lladro/...dvanced_search - or
http://wickerwarehouse.co.uk/lladro/...dto=&x=22&y=16

It brings up DUPLICATES. There are no duplicate products in admin, it is not showing any linked products in admin and have checked the database.

I have re-checked the tpl_advanced_search_default and tpl_advanced_search_results and these files have NOT been changed at all - still the origional ones.

I am stumped. Site is not live yet as still trying to fix this issue. Any help or suggestions would be appreciated.

[gandalfsmith]

Anyone willing to help me with this please, I am at a loss as to what to check next and I have been trying to read alot of other posts but maybe I am not understanding what I need to change.

[Ajeh]

Could you make sure that the files:
/includes/modules/pages/advanced_search/header_php.php
/includes/modules/pages/advanced_search_results/header_php.php
/includes/index_filters/music_genre_filter.php
/includes/index_filters/default_filter.php

are current and match the clean files from Zen Cart v1.5 ...

What happens if you switch to the Classic Template?

[gandalfsmith]

Thank you so much for replying - see my notes below next to yours.

Could you make sure that the files:
/includes/modules/pages/advanced_search/header_php.php (current & match clean file from v1.5) - used Winmerge
/includes/modules/pages/advanced_search_results/header_php.php (current & matches clean file from v1.5)
/includes/index_filters/music_genre_filter.php (current & matches clean file from v1.5)
/includes/index_filters/default_filter.php (different - see code difference below)

are current and match the clean files from Zen Cart v1.5 ...

What happens if you switch to the Classic Template?

Interesting - it returns the result as "There is no product that matches the search criteria." This is when I do a search by from - to price. (i.e. 51 to 100)

In the file default_filter.php I have the following differences:
Line 3 - * SNAF version 1.0
All other code is the same, except for this section added in from line 143 to 161
//=========== bof SNAF (add order by to listing sql)
if(isset($_GET['disp_order']) and $_GET['disp_order']!='')
{
require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER));
// strip off any existing order by just in case
$listing_temp = explode('order by',$listing_sql);
$listing_sql = $listing_temp[0].$order_by;
}
//=========== eof SNAF (add order by to listing sql)

//=========== bof SNAF (use filter or not)
if(zen_get_configuration_key_value('USE_PRODUCT_LISTING_FILTER_FOR_PRODUCT_LISTI NG')=='True')
{
$show_product_listing_filter = true;
}else{
$show_product_listing_filter = false;
}

//=========== bof SNAF (use filter or not)

[gandalfsmith]

PS: If I replace that file with the origional default_filter.php file I still get the same problem? (duplicates in the search) this is if I use my saved drop down searches or even if I start a new advanced search and put in a from and to price.

[Ajeh]

I cannot reproduce this issue ...

I do not know if it is your add on or not ...

What happens if you replaces that file with the original file?

[gandalfsmith]

I cannot reproduce this issue ...

I do not know if it is your add on or not ...

What happens if you replaces that file with the original file?

I have replaced the file with the origional and it still does the exact same thing - duplicates the results. Have a look at
http://wickerwarehouse.co.uk/lladro/...dto=&x=22&y=16

Or go to advanced search (just click on the word search at the top) and do a search by from and to price only. The results would say (Displaying 1 to 4 (of 4 products)

however there are 8 products on the current page - 4 of which are duplicated.

[Ajeh]

Maybe someone who uses that add on can jump in to help you ...

I cannot reproduce this in a clean v1.5 ...

[gandalfsmith]

Thank you. I have reposted it into the SNAF thread. Thanks for all your time in trying to help me - greatly appreciated

[DivaVocals]

Thank you. I have reposted it into the SNAF thread. Thanks for all your time in trying to help me - greatly appreciated

Gonna re-post what I posted on the SNAF support thread here.. seems like this discussion should be continued here since it is likely a problem with your template.. (Is it a Pixemus or 12Leaves template??)

Don't think it's SNAF.. Just tried it and I can't replicate this issue on my client's site.. no matter what I try I don't get duplicate products the way your site does..

Another quick test you could try is to see if your template has an override file for the advanced search page.. This seems like a logical place to start to look for an issue.. This might narrow things down a bit..

Also you might want to contact the provider of your template and see if they can help troubleshoot.. I should think they would want to fix the issue if it is an issue with their template (which seems most likely..)