Can't translate product attributes with joomfish

[Kiwi01]

Hi,

i have a huge problem with the translation of virtuemart product attributes.

When I translate a product attribute (table 'virtuemart product attributes') into english and save the translation there's still the german version in the frontend. In the table 'virtuemart product attributes' is the correct translation stored (it's also published and 'state' is ok). Maybe there is something wrong with the mysql-db??? I hope someone can help me, i can't find hints in the web.

I use Joomla 1.5.10, Virtuemart 1.1.3 and Joomfish 2.0.3

Thanks!!

Regards
Kiwi01

[gby]

Problem solved in virtuemart 1.1.4

In ps_product_attribute.php of /classe in virtuemart admin

Search arround the line 312 add a differentiator type ID attribute_id from the table _product_attribute

Code:
    while( $db_sku->next_record() ) {
                        $q = "SELECT attribute_id, attribute_name, attribute_value, product_id " ;
                        $q .= "FROM #__{vm}_product_attribute WHERE " ;



That and the trans is good

[heavyaris]

hello guys, i cannot translate the product attributes, in joomfish i am receiving this error message:

Code: [Select]

DB function failed with error number 1054
Unknown column 'c.id' in 'field list' SQL=SELECT c.id, c.attribute_name, c.attribute_value as title, c.attribute_value, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.name as language, jfc.reference_id as jfc_refid FROM jos_vm_product_attribute as c LEFT JOIN jos_jf_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='attribute_value' AND jfc.reference_table='vm_product_attribute' AND jfc.language_id=2 LEFT JOIN jos_languages as jfl ON jfc.language_id=jfl.id ORDER BY c.attribute_valuewhat can i do?
please help me .

i have joomfish V2.0.4 (Lightning), Joomla! 1.5.18 Stable and  VirtueMart 1.1.4 stable 

[lgmsampaio]

Hi guys

I've applied the fix that gby suggested, but I had no effect in my page.

After some hours of "trying", I realized that in my case I should change the select that is around line 549, and not 312.

The select statement is exactly same, but I believe that belongs to different function.