Hi,
So have been busy now for a few days and upgrading jm1.5 vm 1.1.4 didn't work as it should so decided to take a new template with jm2.5 and VM2.0.22a took the old tables from the 1.1.4 and ticked the box enable database update tools.
Hit start migration and get the below:
vmError: VmTable #__virtuemart_vendors_en_gb Check not passed. Neither slug nor obligatory value at vendor_store_name for auto slug creation is given
vmError: port Products db error Table 'testone.d3ne6_vm_product' doesn't exist SQL=SELECT *,`p`.product_id as product_id FROM `d3ne6_vm_product` AS `p` LEFT JOIN `d3ne6_vm_product_mf_xref` ON `d3ne6_vm_product_mf_xref`.`product_id` = `p`.`product_id` WHERE (`p`.product_id) IS NOT NULL GROUP BY `p`.product_id ORDER BY `p`.product_parent_id LIMIT 0,1000
vmError: port Products db error SELECT *,`p`.product_id as product_id FROM `#__vm_product` AS `p` LEFT JOIN `#__vm_product_mf_xref` ON `#__vm_product_mf_xref`.`product_id` = `p`.`product_id` WHERE (`p`.product_id) IS NOT NULL GROUP BY `p`.product_id ORDER BY `p`.product_parent_id LIMIT 0,1000
vmError: port Orders db error Table 'testone.d3ne6_vm_orders' doesn't exist SQL=SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2`,`o`.order_id FROM `d3ne6_vm_orders` as `o` LEFT OUTER JOIN `d3ne6_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `d3ne6_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE (o2.order_number) IS NULL ORDER BY o.order_id LIMIT 0,1000
vmError: port Orders db error SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2`,`o`.order_id FROM `#__vm_orders` as `o` LEFT OUTER JOIN `#__vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `#__virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE (o2.order_number) IS NULL ORDER BY o.order_id LIMIT 0,1000
Non of the products are imported and I am still stuck.
Doing this on xampp.
After 2 days struggling thought I see if some one here can help?
thanks in advance
cheers
Marco
Did you use sticked thread in that forum section that explains how migrating could be done?
Probably it's necessary to update your VM 1 from 1.1.4 to the 1.1.9 or so subversion (before migration to VM 2).
I tried quite a lot of variations for migration but it just wouldn't do as I wanted it to.
Anywhoo(had some sleep) I loaded my backup again on localhost and tried the migration tool again and same result, read the error a bit more careful and hit the set store owner again and it got set to 187.
Then I renamed all my old jos_ to new d3ne6_ and hit start migration and lord and behold it worked.
Now I have to sort out how I can get the prices and selection options for child products right but that I suspect will be another topic :s
cheers
Marco
Quote from: Maxim Pishnyak on August 16, 2013, 22:33:23 PM
Did you use sticked thread in that forum section that explains how migrating could be done?
Probably it's necessary to update your VM 1 from 1.1.4 to the 1.1.9 or so subversion (before migration to VM 2).
As far as you use not this mentioned by me method I couldn't help you much. And I doubt that migrating child products need special attention (of course if right migration method is used).