Duplicate Product Display

[spatz4000]

I am running version 1.3.8a. I upgraded from 1.3.0. I have a mod Products with Attributes Stock.

I have pages that show products in a category, for example Halloween shows all my Halloween related products. On the 1.3.0 install this worked fine, but on my 1.3.8a install every product display is doubled. These products have different Item Numbers. In my debugging I've found that the correct install has this partial WHERE clause:

p.products_status = 1 and p.products_id = 

p2c.products_id and pd.products_id = p2c.products_id and 

pd.language_id = '1' and p2c.categories_id = '16' AND 

p.products_model LIKE 'B%' AND p.products_model LIKE 'B%' 

AND p.products_model LIKE 'B%' order by 

p.products_sort_order, pd.products_name limit 0, 6

AND p.products_model LIKE 'B%' AND p.products_model LIKE 'B%' AND p.products_model LIKE 'B%'

while on the incorrect install I have this partial WHERE clause(No LIKE filtering):

p.products_status = 1 and p.products_id = 

p2c.products_id and pd.products_id = p2c.products_id and 

pd.language_id = '1' and p2c.categories_id = '16' order by 

p.products_sort_order, pd.products_name limit 0, 6

My question, is there an admin setting or is there a PHP file I need to update/modify so that the LIKE section is added to the updated 1.3.8a install?

[Ajeh]

Be sure to check that you have applied the Known Bug Fixes for v1.3.8:
http://www.zen-cart.com/forum/showth...860#post610860

You did not specify where you have the duplicates nor an URL that we could peek at ... but this sounds like you need to apply the Bug Fixes ...

[spatz4000]

Be sure to check that you have applied the Known Bug Fixes for v1.3.8:
http://www.zen-cart.com/forum/showth...860#post610860

You did not specify where you have the duplicates nor an URL that we could peek at ... but this sounds like you need to apply the Bug Fixes ...

Every page that shows actual products. pages that show just a category image are okay, every thing else is duplicated. The site is currently on an internal development site, I'll need to see if I can expose that to the outside world.

I've seen the Known Bug fixes page, and this one http://www.zen-cart.com/forum/showpo...7&postcount=30 looked slightly relevant. I made the first fix but the second block of code is not in that file.

This entry also looked related and I applied that fix as well: http://www.zen-cart.com/forum/showpo...4&postcount=31

Applied this fix as well: http://www.zen-cart.com/forum/showpo...88&postcount=3

None of these fixes however worked and I am still seeing duplicates.

[Ajeh]

It might help to see your site as it could just be missing images and you are seeing the Product name twice in FireFox because of it ...

[spatz4000]

It might help to see your site as it could just be missing images and you are seeing the Product name twice in FireFox because of it ...

It's not missing images. I see all the images. I've attached a screen shot. The issue, at least from my point of view is that the item numbers that start with A should never be shown. Where do I control that?

[Ajeh]

Sorry ... I just cannot see enough about this issue from a picture ...

You might switch to the Classic Template to rule out if this is your template or not ...

[spatz4000]

Sorry ... I just cannot see enough about this issue from a picture ...

You might switch to the Classic Template to rule out if this is your template or not ...

Could I PM you the link to the site? It's still under development and I'd like to not expose the url to the web quite yet.

[spatz4000]

Sorry ... I just cannot see enough about this issue from a picture ...

You might switch to the Classic Template to rule out if this is your template or not ...

if I switch to the Classic template I get my sidebars header and footer and this Sales Message Goes Here in the middle content. I've added some debug print statements to the tpl_ files in my custom theme and I can confirm that the tpl_ files are being processed.

I compared the tpl_ files for the 1.3.0 install to the tpl_ files in the 1.3.8a install and aside from minor differences they are all the same. This still comes down to the SQL is not completely filtering and is passing too much to the templates. I know how to change the SQL, what I don't know is where this needs changed. Either there is some module that is doing this, or some admin setting. That is what I need to figure out.

[spatz4000]

Just to follow up with the solution to my problem. Under index_filters, there is a file called default_filters.php. This had been updated from the 1.3.0 version. Once I replaced it on my 1.3.8a install the dupes were gone.

Thanks for your help.