New products on main page - language problem

Hi,
I've problem with displaing new product on main page.
I'm getting both polish and english descriptions displayed for the same products.
The forum is great and I've found solutions for the same case in products_new sidebox, and products_new listing, but can't find help in that point.

My site: http://fotoobrazy.immago.pl

I've instaled:
-ZenCart 1.3.8

• template 12541
• polish localization
• column_layout_grid_for_product_listing_1-3-8.zip
• ultimate_seo_urls_2-107.zip
• zen_lightbox_1-5.zip

I'll appreciate any help.

You might run through the Known Bug Fixes for v1.3.8 ... :smile:
http://www.zen-cart.com/forum/showthread.php?p=697924

Thank you, Ajeh

I've looked throught Bug Fixes and there is nothing about "new product on main page".

As I wrote, I've found solution for What's New sidebox on forum earlier. I used the fix also for New Products listing.
But new products on main page seems to be programmed differently.

I can't cope with that :(

Please, help!
I can't even find the file responsible for the bug :unsure:

Welcome to the not-so-wonderful world of Template Monster.

You may find some help by googling the template number here in the forum.

It's going to take someone who can see the core files to fix the problem.

Turn off the SEO stuff ... does that help?

dbltoe:

Welcome to the not-so-wonderful world of Template Monster.

Yop, it's not so wonderfull

Ajeh:

Turn off the SEO stuff ... does that help?

Multilanguage new products where present before instalation of SEO.

But...
Classic template is free of this problem.
So, I've copied modules/new_products.php from template_default to MY_TEMPLATE_DIR and problem solved :D

Worse, that in 12541 template there is possibility to change positions of name, image, description, etc in admin and now everything is set in php file. Styling also is not so good.
But I'll try to merge files to display data as in 12541 but functions of classic leaving intact.
I'll let you know if I get positive efects.

Thank you for assistance :)
You are great!

Get yourself a copy of winmerge. It will help you look at the differences for each file.

dbltoe:

Get yourself a copy of winmerge. It will help you look at the differences for each file.

yes, downloaded and instaled

OK, here it is:

in /includes/modules/12541/new_products.php
I've added the same code as in WHAT'S NEW sidebox (http://www.zen-cart.com/forum/showpost.php?p=616420&postcount=26)

if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
$new_products_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_date_added, pd.products_description
from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id 
[B] and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'[/B]
where p.products_status = 1 " . $display_limit;

} else {

$new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_date_added, pd.products_description,                                            p.products_price from " . TABLE_PRODUCTS . " p   left join " . 
TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id 
 [B]and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'[/B]

left join " . TABLE_SPECIALS . " s
on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " .

TABLE_CATEGORIES . " c

where p.products_id = p2c.products_id
and p2c.categories_id = c.categories_id
and c.parent_id = '" . (int)$new_products_category_id . "'
[B]and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'[/B]
and p.products_status = 1 " . $display_limit;

}

It works for me :D