[Skip to main content](#vessel-content)

#   Syntax Error during Virtuemart product import

##

- **[3by400](/forum/user/6842-3by400 "View 3by400's Profile")**
- [![3by400's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6842.jpg)](/forum/user/6842-3by400 "View 3by400's Profile") Topic Author
- [ Offline](/forum/user/6842-3by400)

Less More

- Posts: 211
- Thank you received: 14
-
-
- [](https://3by400.com)
-

12 years 3 weeks ago [\#176681](#176681) by [3by400](/forum/user/6842-3by400 "View 3by400's Profile")  *[Syntax Error during Virtuemart product import](/forum/3-bug-report/872534-syntax-error-during-virtuemart-product-import#176681 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4 -- Error-message(debug-mod must be tuned on) -- : 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 'SELET MAX(vm&#95;id) FROM &#96;xx&#95;hikashop&#95;vm&#95;prod&#96;' at line 1 SQL=SELET MAX(vm&#95;id) FROM &#96;xx&#95;hikashop&#95;vm&#95;prod&#96;  Hi guys!  We just wanted to make you aware of this syntax error we've run into during a Virtuemart product import.  Thanks!")* was created by *[3by400](/forum/user/6842-3by400 "View 3by400's Profile")*

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4
-- Error-message(debug-mod must be tuned on) -- : 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 'SELET MAX(vm_id) FROM &#96;xx_hikashop_vm_prod&#96;' at line 1 SQL=SELET MAX(vm_id) FROM &#96;xx_hikashop_vm_prod&#96;

Hi guys!

We just wanted to make you aware of this syntax error we've run into during a Virtuemart product import.

Thanks!

---

3by400, Inc.
[ 3by400.com](https://3by400.com)
Websites that Work, Marketing that Matters

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NzI1MzQtc3ludGF4LWVycm9yLWR1cmluZy12aXJ0dWVtYXJ0LXByb2R1Y3QtaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4080
-
- [](http://obsi.dev)
-

12 years 3 weeks ago [\#176683](#176683) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Syntax Error during Virtuemart product import](/forum/3-bug-report/872534-syntax-error-during-virtuemart-product-import#176683 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4 -- Error-message(debug-mod must be tuned on) -- : 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 'SELET MAX(vm&#95;id) FROM &#96;xx&#95;hikashop&#95;vm&#95;prod&#96;' at line 1 SQL=SELET MAX(vm&#95;id) FROM &#96;xx&#95;hikashop&#95;vm&#95;prod&#96;  Hi guys!  We just wanted to make you aware of this syntax error we've run into during a Virtuemart product import.  Thanks!")*

Hi,

Thanks for the report ; I will fix the issue and Nicolas will update the package as soon as possible (in less than 3 hours).

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

The following user(s) said Thank You: [3by400](/forum/user/6842-3by400 "View 3by400's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NzI1MzQtc3ludGF4LWVycm9yLWR1cmluZy12aXJ0dWVtYXJ0LXByb2R1Y3QtaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.072 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
