Error during migration - Users and Orders not migrated

[jcrennan]

I am trying to migrate VM from 1.1.19 to 2.0 and have followed the migration process (unless I have missed something) exactly as they have listed, however when I run the process I find that I have errors when migrating the Users and Orders. I am working on a backup/test copy of my site and have run the migration a few times so products and everything else has migrated across just not the users and orders.

Below is the result of the migration in case that helps anyone.

Other factors that may impact
This is on Joomla 1.5.25 (have also tested after I did a migration to J25 but got same issue)
I am upgrading from VM 1.1.19 to VM 2.0
I do run JFUSION 1.6.0 (most updated vers)

Found prior migration process, resume migration maxScriptTime 23 maxMemoryLimit 33.6
        Synchronized 0 media for product in directory images/stories/virtuemart/product/
        Synchronized 0 media for category in directory images/stories/virtuemart/category/
        Synchronized 0 media for manufacturer in directory images/stories/virtuemart/manufacturer/
        Synchronized 0 media for vendor in directory images/stories/virtuemart/vendor/
        Processed 0 vm1 shoppergroups time: 2.59876251221E-5
        Looks everything worked correct, migrated 0 categories
        Looks everything worked correct, migrated 0 categories xref
        Looks everything worked correct, migrated 0 manufacturer categories
        Looks everything worked correct, migrated 0 manufacturers
        Found 104 vm1 products to import
        Worked on migration for 0.147070884705 seconds
        Migration finished

        vmError: port shoppers db error FUNCTION myurl_jtest.ISNULL does not exist SQL=SELECT `p`.*,`ui`.*,`svx`.*,`aug`.*,`ag`.*,`vmu`.virtuemart_user_id FROM jos_users AS `p` LEFT OUTER JOIN jos_vm_user_info AS `ui` ON `ui`.user_id = `p`.id LEFT OUTER JOIN jos_vm_shopper_vendor_xref AS `svx` ON `svx`.user_id = `p`.id LEFT OUTER JOIN jos_vm_auth_user_group AS `aug` ON `aug`.user_id = `p`.id LEFT OUTER JOIN jos_vm_auth_group AS `ag` ON `ag`.group_id = `aug`.group_id LEFT OUTER JOIN jos_virtuemart_vmusers AS `vmu` ON `vmu`.virtuemart_user_id = `p`.id WHERE ISNULL (`vmu`.virtuemart_user_id) LIMIT 0,2100
        vmError: port shoppers db error SELECT `p`.*,`ui`.*,`svx`.*,`aug`.*,`ag`.*,`vmu`.virtuemart_user_id FROM jos_users AS `p` LEFT OUTER JOIN jos_vm_user_info AS `ui` ON `ui`.user_id = `p`.id LEFT OUTER JOIN jos_vm_shopper_vendor_xref AS `svx` ON `svx`.user_id = `p`.id LEFT OUTER JOIN jos_vm_auth_user_group AS `aug` ON `aug`.user_id = `p`.id LEFT OUTER JOIN jos_vm_auth_group AS `ag` ON `ag`.group_id = `aug`.group_id LEFT OUTER JOIN jos_virtuemart_vmusers AS `vmu` ON `vmu`.virtuemart_user_id = `p`.id WHERE ISNULL (`vmu`.virtuemart_user_id) LIMIT 0,2100
        vmError: port ST addresses db error FUNCTION myurl_jtest.ISNULL does not exist SQL=SELECT `ui`.* FROM jos_vm_user_info as `ui` LEFT OUTER JOIN jos_virtuemart_userinfos as `vui` ON `vui`.`virtuemart_user_id` = `ui`.`user_id` WHERE `ui`.`address_type` = "ST" AND ISNULL (`vui`.`virtuemart_user_id`) LIMIT 0,2100
        vmError: port ST addresses db error SELECT `ui`.* FROM jos_vm_user_info as `ui` LEFT OUTER JOIN jos_virtuemart_userinfos as `vui` ON `vui`.`virtuemart_user_id` = `ui`.`user_id` WHERE `ui`.`address_type` = "ST" AND ISNULL (`vui`.`virtuemart_user_id`) LIMIT 0,2100
        vmError: port Orders db error FUNCTION myurl_jtest.ISNULL does not exist SQL=SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `jos_vm_orders` as `o` LEFT OUTER JOIN `jos_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `jos_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,1800
        vmError: port Orders db error SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `jos_vm_orders` as `o` LEFT OUTER JOIN `jos_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `jos_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,1800

info

        Info: Processed 0 vm1 users time: 2.86102294922E-6
        Info: Migration: 0 products processed
        Info: Migration: 0 orders processed

If you need any other info or data please let me know.

[Milbo]

You can do the migration at latest. It needs only the vm_ tables of your vm1.1 installation. In your case, I dont know, but sounds like a long running page, I would safe my vm1 tables, then I would uninstall vm1, then I would uninstall vm,.. then I would upgrade joomla, then install vm2.0.1 latest and to the migration with the old vm1 tables.

and you must update your mysq version. It seems to be too old, it does not know ifnull. Imho you need at least 5.0.4

[Joe Bourque]

I'm having the same problem I can migrate everything orders
        vmError: port Orders db error FUNCTION hcgjetdi_jom25.ISNULL does not exist SQL=SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `pdb8_vm_orders` as `o` LEFT OUTER JOIN `pdb8_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `pdb8_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,8400
        vmError: port Orders db error SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `pdb8_vm_orders` as `o` LEFT OUTER JOIN `pdb8_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `pdb8_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,8400

Server version is 5.0.92 Commmunity

[vazi]

Same error here, afther migrate vm1 for 2 only order dont go. have got same error above .

[grubosoft]

Please check your User-id's if they are the same as in Joomla 1.5.25.
jUpgrade stores them in your new tables with new ID's.
What I did is upgrade your site to 2.5.1. Check the userId's and changed them to the same ID's.
Install VM 2.0
After that I migrate VM1.1.9 tables to VM 2.0. Then the orders are fine for me.