Author Topic: Can't translate product attributes with joomfish  (Read 5426 times)

Kiwi01

  • Beginner
  • *
  • Posts: 1
Can't translate product attributes with joomfish
« on: October 31, 2009, 20:30:55 pm »
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

  • Beginner
  • *
  • Posts: 20
Re: Can't translate product attributes with joomfish
« Reply #1 on: February 23, 2010, 11:49:32 am »
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

  • Beginner
  • *
  • Posts: 2
Re: Can't translate product attributes with joomfish
« Reply #2 on: September 07, 2010, 12:54:04 pm »
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_value
what 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

  • Beginner
  • *
  • Posts: 2
Re: Can't translate product attributes with joomfish
« Reply #3 on: November 24, 2010, 05:56:02 am »
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.