[Done 1.3.8] New Products box and multilanguage issue

Hello,

I'm setting up a zen-cart store and I have one little problem:

the box that shows randomly new products doesn't seem to look at the language.
I mean that it shows any new product in any language, no matter what language are you using.

My store is both in english and spanish and, of course, I want the box to show descriptions in the language beeing used..

I have a template installed (I don't think this is the cause) and the multilanguage EZ page mod.

Thanks in advance

Ok, I've just found that the following condition has to be added to the query at "whats_new.php"

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

Thanks for the solution, I was having the exact same problem.

Thanks for the update ... :smile:

Moving over to Bug Fixes ...

This problem exists in the default template, and yet I see the line you refer to in the file "new_products.php" located at includes/modules/

i see clearly the line you refer to:
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

however I still have the problem of duplicate products in the "New Products" when using the default (or any other) template.

I have not been able to locate any file named "whats_new.php"

Thanks SYR2000 for the fix....any other newbies like myself who might run into this problem, here's clearer directions.

The whats_new.php file is in the includes>modules>sideboxes folder

I added the lines as suggested by SYR2000 as shown below...

// display limits
// $display_limit = zen_get_products_new_timelimit();
$display_limit = zen_get_new_date_range();
$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;

Like magic! No more duplicates! Hope it helps someone.....