VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: Artanis on March 18, 2012, 23:02:37 PM

Title: Falang Translation plugin crash Virtuemart 2?
Post by: Artanis on March 18, 2012, 23:02:37 PM
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:

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
Title: Re: Falang Translation plugin crash Virtuemart 2?
Post by: marianaf on April 17, 2012, 13:24:14 PM
hello artanis,

same problem here :( found a solution?

thank you

Mariana
Title: Re: Falang Translation plugin crash Virtuemart 2?
Post by: sbou on April 17, 2012, 15:14:37 PM
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
Title: Re: Falang Translation plugin crash Virtuemart 2?
Post by: ajg on May 15, 2012, 13:03:11 PM
Hi Stéphane!

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


Thanks,
Annika
Title: Re: Falang Translation plugin crash Virtuemart 2?
Post by: sbou on May 15, 2012, 14:40:56 PM
look at this thread

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

Stéphane
Title: Re: Falang Translation plugin crash Virtuemart 2?
Post by: Artanis on July 01, 2012, 22:40:47 PM
Quote from: ajg on May 15, 2012, 13:03:11 PMHave 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.