[Done 1.3.8] New Products box and multilanguage issue

[syr2000]

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

[syr2000]

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'] . "'

[jwmartinez]

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

[Ajeh]

Thanks for the update ...

Moving over to Bug Fixes ...

[deejson]

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"

[studiotucker]

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.....