1064 Error JA Multilanguage Component

Forums    Public Forums    JA Multilingual Component    1064 Error JA Multilanguage Component

Tagged: ,

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • 66geo Friend
    February 13, 2016 at 10:53 am #882347

    Hi,

    When i go form Translation Manager ->Assiciation Manager-> virtuemart products or categories i get this error:

    1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ AS dt ON (st.virtuemart_product_id = dt.virtuemart_product_id) WHERE st.`vir’ at line 3 SQL=SELECT st.virtuemart_product_id AS sourceid, dt.virtuemart_product_id AS newid FROM bv10l_virtuemart_products_en_gb AS st INNER JOIN bv10l_virtuemartproducts AS dt ON (st.virtuemart_product_id = dt.virtuemart_product_id) WHERE st.virtuemart_product_id=252

    How can i fix this?

    Luna Garden Moderator
    February 15, 2016 at 10:46 am #883406

    Hi,

    It’s confirmed that there is an issue here with our extension. The developer is working on it, I will be back to you as soon as there is update.

    Mo0nlight Moderator
    February 16, 2016 at 10:19 am #884243

    Hi

    You can try with my tweak below:

    • Open the file : administrator/components/com_jalang/helpers/translator/translator.php

    • Look for this snippet of code :
                    $query->select('st.'.$adapter->primarykey.' AS sourceid, dt.'.$adapter->primarykey.' AS newid');
                $query->from($from_table .' AS st');
                $query->innerJoin($to_table. ' AS dt ON (st.'.$adapter->primarykey.' = dt.'.$adapter->primarykey.')');

    around the line : 476-479

    Change to

                    $query->select('st.'.$adapter->primarykey.' AS sourceid');
                $query->from($from_table .' AS st');
                if (!preg_match('/virtuemart/', $table)) {
                    $query->select('dt.'.$adapter->primarykey.' AS newid');
                    $query->innerJoin($to_table. ' AS dt ON (st.'.$adapter->primarykey.' = dt.'.$adapter->primarykey.')');
                }

    And find this line

    $aMap[$row->sourceid][$this->toLangTag] = $row->newid;

    Around line : 491

    Change to :

    $aMap[$row->sourceid][$this->toLangTag] = !empty($row->newid) ? $row->newid : $row->sourceid;

    Regards

    urmisstery Friend
    April 1, 2016 at 5:38 pm #908100
    This reply has been marked as private.
    Luna Garden Moderator
    April 5, 2016 at 7:48 am #909404

    Hi,

    Did you get any error message or warning while using this component ?
    Could you capture it then we can know which problem to help you out.

    ingmardevos Friend
    October 11, 2016 at 3:45 pm #975412

    Hi, I have the same issue.
    1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ AS dt ON (st.virtuemart_category_id = dt.virtuemart_category_id) WHERE st.`v’ at line 3 SQL=SELECT st.virtuemart_category_id AS sourceid,dt.virtuemart_category_id AS newid FROM #__virtuemart_categories_nl_nl AS st INNER JOIN #__virtuemartcategories AS dt ON (st.virtuemart_category_id = dt.virtuemart_category_id) WHERE st.virtuemart_category_id=1

    Also when selecting Virtuemart products from the association manager..
    Checked for the code as suggested in feb 2016, but the code is not present in that file. Guess it has been changed already in updates.

    Using VM 3.0.18 and JA Multilang 1.0.9.

    Thanks

    Mo0nlight Moderator
    October 14, 2016 at 2:59 am #976167

    Hi,
    Kindly try the suggestion given in this thread to fix the problem .
    If the problem still present, please post your site URL admin info in private Reply option .
    I will check it on your site
    Regards.

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)

This topic contains 6 replies, has 5 voices, and was last updated by  Mo0nlight 7 years, 6 months ago.

We moved to new unified forum. Please post all new support queries in our New Forum

Important Notice :

New Unified Portal is live

Must Read

Jump to forum

Categories