Showing products from different languages

[markus75]

My Zencart is showing products from different languages.
For example if i choose english language, i see products with other languages name.
And often i see listed the same product in 3-4 languages all together at the same time in the same page.
Why happens this?
How can i do to make the site show only products of the same language (the one i choose of course!) ??

Thanks in advance for your help!

[tony_sar]

if you mean new products side box , then i guess you can limit this box to show only one product.

I had the same issue with only two languages .. no matter which language i chose , side box would display products in multiple language. now i don't know if thats zencart bug , or is it done this way.

[markus75]

Yes i mean the "New Products" side box.
It shows sometimes only 1 product, repeated 3 times in different languages. Or sometimes 2 products, with a product repeated 2 times in different languages.

I want that this sidebox shows different products but always in the language selected for the site.
How do i do this?

[angeloio]

Hi Gyus,

Yes I confirm this is happening and (according to my opinion it is a bug and zen team should be notified...).

The problem is there because in file /includes/modules/sideboxes/whats_new.php there is a query and does not take into account the selected language.

Fix:

1. First copy the file whats_new.php into /includes/modules/sideboxes/<MY_TEMPLATE>/ to ensure override mechanism compliance
2. Secondly add the following line
   

   and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' 

   just before the line
   

   and p.products_status = 1 " . $display_limit; 

   so in the end the whole query will be:
   

     $random_whats_new_sidebox_product_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name,
                                                 p.master_categories_id
                              from (" . TABLE_PRODUCTS . " p
                              left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )
                              where p.products_id = pd.products_id
                              and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                              and p.products_status = 1 " . $display_limit; 

That should do the trick...

[Ajeh]

Might peek in the Known Bugfixes for v1.3.8 ...
http://www.zen-cart.com/forum/showth...717#post659717

Seems that one is already on the list ...