Tagged: error, JA Multilanguage
-
AuthorPosts
-
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) WHEREst
.virtuemart_product_id
=252How can i fix this?
Luna Garden ModeratorLuna Garden
- Join date:
- July 2011
- Posts:
- 2617
- Downloads:
- 80
- Uploads:
- 96
- Thanks:
- 78
- Thanked:
- 453 times in 425 posts
February 15, 2016 at 10:46 am #883406Mo0nlight ModeratorMo0nlight
- Join date:
- September 2014
- Posts:
- 707
- Downloads:
- 38
- Uploads:
- 107
- Thanked:
- 99 times in 97 posts
February 16, 2016 at 10:19 am #884243Hi
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
April 1, 2016 at 5:38 pm #908100This reply has been marked as private.Luna Garden ModeratorLuna Garden
- Join date:
- July 2011
- Posts:
- 2617
- Downloads:
- 80
- Uploads:
- 96
- Thanks:
- 78
- Thanked:
- 453 times in 425 posts
April 5, 2016 at 7:48 am #909404October 11, 2016 at 3:45 pm #975412Hi, 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) WHEREst
.`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) WHEREst
.virtuemart_category_id
=1Also 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 ModeratorMo0nlight
- Join date:
- September 2014
- Posts:
- 707
- Downloads:
- 38
- Uploads:
- 107
- Thanked:
- 99 times in 97 posts
October 14, 2016 at 2:59 am #976167Hi,
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. -
AuthorPosts
This topic contains 6 replies, has 5 voices, and was last updated by Mo0nlight 8 years, 1 month ago.
We moved to new unified forum. Please post all new support queries in our New Forum