Virtuemart Import Error

  • Posts: 106
  • Thank you received: 5
  • Hikaserial Standard Hikashop Business
9 years 6 months ago #201446

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 3.4.1
-- PHP version -- : 5.4.39
-- Browser(s) name and version -- : Firefox 37.0.2

Earlier, I was able to do an import successfully from Virtuemart. However, when I try to re-run the import, I get an error.

1103 Incorrect table name '' SQL=SELECT vmou.user_email FROM ``<prefix>_vm_orders` AS vmo INNER JOIN ``<prefix>_vm_order_user_info` AS vmou ON vmo.order_id = vmou.order_id WHERE vmo.order_id IN (1122,1361,10292,10732,15598)


The `` looks to be the issue. I can run that query in phpMyAdmin, without the doubled single quotes, and it runs just fine

Last edit: 9 years 6 months ago by gpraceman.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 6 months ago #201450

Hi,

Please edit the file "administrator/components/com_hikashop/helpers/importvm.php" and replace the double `` into a single `
You will find several time that double `` in some queries.
We already cleaned that part few weeks ago in our side (for the next HikaShop release) when we improved the import system to split the VM1 and the VM2 import into two different files.

Regards,

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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 106
  • Thank you received: 5
  • Hikaserial Standard Hikashop Business
9 years 6 months ago #201484

Thanks, that fixed it.

Please Log in or Create an account to join the conversation.

Time to create page: 0.056 seconds
Powered by Kunena Forum