Error in migration from VM2

  • Posts: 206
  • Thank you received: 10
  • Hikashop Multisite
7 years 10 months ago #259048

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.5

I've got a few errors in VM2 migration, most i solved in the vm2.php,
now i see the message below when i try to import the orders and i can't find what to do, can you help me?

Got error 28 from storage engine SQL=INSERT IGNORE INTO `#__hikashop_order` (`order_number`,`order_vm_id`,`order_user_id`,`order_status`,`order_discount_code`,`order_discount_price`,`order_created`,`order_ip`,`order_currency_id`,`order_shipping_price`,`order_shipping_method`,`order_shipping_id`,`order_payment_id`,`order_payment_method`,`order_full_price`,`opmerking`,`order_modified`,`order_partner_id`,`order_partner_price`,`order_partner_paid`,`order_type`,`order_partner_currency_id`,`order_shipping_tax`,`order_discount_tax`) SELECT vmo.order_number,vmo.virtuemart_order_id,hkusr.user_id,hkc.category_name,vmo.coupon_code,vmo.coupon_discount,UNIX_TIMESTAMP(vmo.created_on),vmo.ip_address,hkcur.currency_id,vmo.order_shipment,'vm import',1,0,'vm import',vmo.order_total,vmo.customer_note,UNIX_TIMESTAMP(vmo.modified_on),0,0,0,'sale',0,vmo.order_shipment_tax,0 FROM `#__virtuemart_orders` AS vmo INNER JOIN `#__virtuemart_currencies` vmc ON vmo.order_currency = vmc.virtuemart_currency_id INNER JOIN `#__hikashop_currency` hkcur ON CONVERT(vmc.currency_code_3 USING utf8) = CONVERT( hkcur.currency_code USING utf8) LEFT JOIN `#__virtuemart_orderstates` AS vmos ON vmo.order_status = vmos.order_status_code LEFT JOIN `#__hikashop_category` AS hkc ON vmos.order_status_name = hkc.category_name AND hkc.category_type = 'status' LEFT JOIN `#__hikashop_user` AS hkusr ON vmo.virtuemart_user_id = hkusr.user_cms_id WHERE vmo.virtuemart_order_id > 0 GROUP BY vmo.virtuemart_order_id ORDER BY vmo.virtuemart_order_id ASC;

Thanks in advance.

Last edit: 7 years 10 months ago by Joomill.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
7 years 10 months ago #259072

Hi,

From what I could find online, this indicates that MySQL didn't had enough space available in order to run the MySQL:
stackoverflow.com/questions/10631387/103...-from-storage-engine
So I would recommend to look into that.

I suppose that VM must have a lot of orders, and the import query doing a JOIN across 6 tables in order to gather all the necessary data from VM must require quite a lot of memory for MySQL.

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

Time to create page: 0.058 seconds
Powered by Kunena Forum