Migration not working pulling my hair

[aromasense]

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

[Maxim Pishnyak]

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

[aromasense]

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

[Maxim Pishnyak]

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