Falang Translation plugin crash Virtuemart 2?

[Artanis]

Hello!

I have serious problem - I'm using Joomla 2.5 and have installed VM2. Today I configured VM2 - put all my products, categories, taxes, deliveries, etc. Tested it all - worked like a charm. Even added UTF-8 fonts for PDF Invoice generation. The problem started when I activated Falang translation plugin - as I understand from couple people like me on different forums, there is compatiblity problem between VM2 built in multi-language support and the Falang translation module. The worst part is that now the VM2 shop is not working even after disabling Falang. When I enter in Product menu in VM2 Administration panel it shows red error square saying:

Code Select Expand

vmError: exeSortSearchListQuery Table 'abaslv.abaslv_virtuemart_products_lv_lv' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `abaslv_virtuemart_products_lv_lv` as l JOIN `abaslv_virtuemart_products` AS p using (`virtuemart_product_id`) ORDER BY p.virtuemart_product_id DESC LIMIT 0, 6

vmError: exeSortSearchListQuery Table 'abaslv.abaslv_virtuemart_categories_lv_lv' doesn't exist SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `abaslv_virtuemart_categories_lv_lv` l JOIN `abaslv_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `abaslv_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name ASC

As far as I understand, Falang plugin tried to make new columns for translation, but that interfere with VM2 internal ones. Does anyone have stunbled upon this same problem? Is there any better solution than simply put backup of database and Joomla files, and insert all products from beginning, trying not to use Falang at all? Please help..

Best regards, Arthur

[marianaf]

hello artanis,

same problem here found a solution?

thank you

Mariana

[sbou]

Hi,

Actually Falang don't work with virtuemart.

This problem just come from a query (see main threat falang-virtuemart)

There are no workaround but the solution is not far.

Stéphane

[ajg]

Hi Stéphane!

Have you already found a solution for this problem...? Or is there another way to fix this.


Thanks,
Annika

[sbou]

look at this thread

https://forum.virtuemart.net/index.php?topic=97880.msg336759#msg336759

Stéphane

[Artanis]

Have you already found a solution for this problem...?

I ended up dropping Falang and used Jooma and VM2 buil-in multilanguage functionality - it actually works pretty well after few tune-up's.