-- 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.