Falang - no translation in category view

Phoca Cart - complex e-commerce extension
DiegoCZ
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 19 Jun 2020, 08:05

Falang - no translation in category view

Post by DiegoCZ » 19 Jun 2020, 08:21

Hi, I would like to use Phoca Cart with the Falang extension. I installed the free version of Falang and Phoca Cart Falang plugin (v3.0.0). Translations work OK with category names and product detail pages but it does not work with product names (titles) in the table view of category (multiple products on one page). In this view the product titles remain in the original language. Should I edit the Falang xml file somehow? Thank you very much for your help.

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42734
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Falang - no translation in category view

Post by Jan » 22 Jun 2020, 12:04

Hmmm, not sure what can be changed there (in the xml):

Image

Does not only the "title" work or all product items (title, description, description_long, ...)

Can you paste a screenshot on which place do you get the problems?

Jan
If you find Phoca extensions useful, please support the project

DiegoCZ
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 19 Jun 2020, 08:05

Re: Falang - no translation in category view

Post by DiegoCZ » 23 Jun 2020, 10:40

Hi, thank you for your reply. The translation works well on the product detail page but neither product title nor description translation works on the category view - screen here: https://ibb.co/dDJWYpk
Maybe the free version of Falang is somehow limited in this function.

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42734
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Falang - no translation in category view

Post by Jan » 23 Jun 2020, 23:10

Hi, hmmm, category and item view - both get the variables from the same database tables, hard to say, did you ask on Falang forum?

Jan
If you find Phoca extensions useful, please support the project

sbou
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 01 Jul 2020, 16:27

Re: Falang - no translation in category view

Post by sbou » 01 Jul 2020, 16:28

Hi,

I have found the query who make problem
in the file components/com_phocacart/models/category.php line 222,
Falang don't like the group_concat , i don't know how it's utlised in the query but when you remove it , falang translate the product name in the category view


$columns = 'a.id, a.title, a.image, a.alias, a.unit_amount, a.unit_unit, a.description, a.sku, a.ean, a.upc, a.type, a.points_received, a.price_original,'
.' a.stock, a.stock_calculation, a.min_quantity, a.min_multiple_quantity, a.stockstatus_a_id, a.stockstatus_n_id,'
.' a.date, a.sales, a.featured, a.external_id, a.unit_amount, a.unit_unit, a.external_link, a.external_text,'
// .' GROUP_CONCAT(DISTINCT c.id) AS catid, GROUP_CONCAT(DISTINCT c.title) AS cattitle,'
// .' GROUP_CONCAT(DISTINCT c.alias) AS catalias, a.price,';
.' c.id AS catid, c.title AS cattitle,'
.' c.alias AS catalias, a.price,';

Stéphane
Falang Team
www.faboba.com

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42734
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Falang - no translation in category view

Post by Jan » 04 Jul 2020, 13:16

Hi, thank you very much for your tips. Hmm, will be hard to remove the group_concat as it saves a lot of additional subqueries :-( ... I will take a look at it.

Thank you, Jan
If you find Phoca extensions useful, please support the project

Post Reply