Joom!Fish 2.0 and VirtueMart 1.1 - Report the bugs here

[ph0enix]

even if countries are translated, the everytime are displayed in english in customer account, user registration and so on...

Patched VirtueMart 1.1.4 and 1.1.5 (Joomla 1.5) to solve country list translation issue.

Patches available there:

http://forum.virtuemart.net/index.php?topic=70195.msg248085#msg248085

Please test it

[alainroger]

this only solve my issue in user account but not in checkout
i as thinking that they use both the same function getcountry_by_code but it seems not: -(

[ph0enix]

Try to patch administrator/components/com_virtuemart/classes/ps_checkout.php

[kruti]

Hello,

First of all Thanks a lot for such a nice component..!!!

Configurations:
Joomla: 1.5.18
Joomfish: 2.0.4
Virtuemart: 1.1.4 stable

I am using two languages. one is German(default) and the other is English

What issue I am facing is, I have attributes for each products entered throgh the option available in "Product Status" tab. Its translation is working fine. I am able to translate it. After that I am following below steps:

1) Select produt & its attributes
2) Click on add to cart page
3) on cart page, I am changing my current language to english

Here comes the issue, Everything get translated but not the product attributes which I have selected. And updated price is also not showing which should be.

Can anyone Please give a solution to this ? It would be great if anyone can help me out.

Thanks in advanced. Looking forward for the favourable response.

Regards,
Kruti

[fersan]

Version Joomla 1..5.15

VirtueMart 1.1.3

DB function failed with error number 1146
Table 'Sql_5.jos_vm_affiliate_sale' doesn't exist SQL=SELECT c.order_id as id, c.order_id, c.visit_id as title, c.visit_id, c.affiliate_id, c.rate, 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_affiliate_sale as c LEFT JOIN jos_jf_content as jfc ON c.order_id=jfc.reference_id AND jfc.reference_field='visit_id' AND jfc.reference_table='vm_affiliate_sale' AND jfc.language_id=1 LEFT JOIN jos_languages as jfl ON jfc.language_id=jfl.id ORDER BY c.visit_id LIMIT 0, 20

This table doesn't exist, what I can do?

[fozwart]

I have a webshop in the dutch language. If I change to english everything changes to the english language exept the name of the product. If I go to the productdetails all details including the name of the product is in the english language. What is wrong, the translations are in place.

[Indy]

That is happening to me exactly right now... if you or someone know what happen, please share the knowledge... Is turning me crazyyyyyy. and was working before I think.

I have a webshop in the dutch language. If I change to english everything changes to the english language exept the name of the product. If I go to the productdetails all details including the name of the product is in the english language. What is wrong, the translations are in place.

[lgmsampaio]

If your product name doesn't appear translated, please check this link. It worked for me:

http://www.joomfish.eu/forum/viewtopic.php?f=24&t=5393

Good luck

[Gambalunga]

I am developing a multilingual Italian/English site.

Joomla version 1.5.22
Joom!Fish version 2.04
Vituemart version 1.1.6

Firstly I found that I could not modify the database table as the field `attribute_sku_id` was reported to already exist. -- #1060 - Duplicate column name 'attribute_sku_id'
I took that to indicate that the latest version of Virtuemart had been updated to include this field.

Everything seemed to be going well until I tried to do the translations for "VirtueMart Product Attributes SKU"
The following error message was returned:

DB function failed with error number 1054
Unknown column 'c.attribute_sku_id' in 'field list' SQL=SELECT c.attribute_sku_id as id, c.attribute_sku_id, c.product_id, c.attribute_name as title, c.attribute_name, c.attribute_list, 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_sku as c LEFT JOIN jos_jf_content as jfc ON c.attribute_sku_id=jfc.reference_id AND jfc.reference_field='attribute_name' AND jfc.reference_table='vm_product_attribute_sku' AND jfc.language_id=1 LEFT JOIN jos_languages as jfl ON jfc.language_id=jfl.id ORDER BY c.attribute_name LIMIT 0, 20

While writing this post I went to phpMyAdmin and entered the SQL code again. The same SQL error as reported above was returned however when I tried the translation again everything worked fine.

Does anyone have any idea what the problem may be? I don't know SQL all that well. Is it possible I now have more than one column with the same name?

[Gambalunga]

I found the solution of the problem where you were getting error when trying to edit the virtuemart store information. Actually the developer who coded this plugin named the file as vm_store_info.xml while the table name was kept as vm_vendor.

<table name="vm_vendor">
<field type="referenceid" name="vendor_id" translate="0">ID</field>
<field type="titletext" name="vendor_store_name" translate="0">Store Name</field>
<field type="textarea" name="vendor_store_desc" translate="1">Description</field>
<field type="textarea" name="vendor_terms_of_service" translate="1">Terms of service</field>
</table>

So either you change the filename to vm_vendor.xml or change the table name to vm_store_info and install the plugin again!

Rgds,
LKL
Always Joomla!
http://www.cmsjoomla.in

I tried changing the table name and got the following Joom!Fish error when I tried to open the translation:
DB function failed with error number 1146
Table 'ulij3sf2_jpack.jos_vm_store_info' doesn't exist.......etc

I guess it is obvious that changing the table name in the xml will not work! Who knows what problems changing the table name in the database could cause.

Changing the file name to vm_vendor.xml worked the only thing is that even though the translation is done, saved and published the published icon always shows red. Notwithstanding this the translation is actually published. Also it is not possible to delete the translation.

I am updating this because I have also found another error in the code. Replace the two lines:

Code: Select all

        <field type="textarea" name="vendor_store_desc" translate="1">Description</field>
        <field type="textarea" name="vendor_terms_of_service" translate="1">Terms of service</field>


With:

Code: Select all

        <field type="htmltext" name="vendor_store_desc" translate="1">Description</field>
        <field type="htmltext" name="vendor_terms_of_service" translate="1">Terms of service</field>


To get the correct field types.