Phoca Forum

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.

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



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

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.

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

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

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