New products on main page - language problem

[Immago]

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.

[Ajeh]

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

[Immago]

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

[dbltoe]

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.

[Ajeh]

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

[Immago]

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

Yop, it's not so wonderfull

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

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!

[dbltoe]

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

[Immago]

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

yes, downloaded and instaled

[Immago]

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/showpo...0&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 
 and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
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 
 and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

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 . "'
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_status = 1 " . $display_limit;

}

It works for me