Migrating to 2 Issues

[jstvnson]

I am migrating a large clothing store from 1.9 to 2.0.2 but I am getting the following errors.  Also, it says that my currency is not set and I have looked and I do not see where to change it.  I have the execution time set to 32 minutes and memory to 386M.         

Found prior migration process, resume migration maxScriptTime 287 maxMemoryLimit 373
        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: 1.9073486328125E-5
        Looks everything worked correct, migrated 0 categories
        Seems there was an error porting 24 of 105 categories xref
        Looks everything worked correct, migrated 0 manufacturer categories
        Looks everything worked correct, migrated 0 manufacturers
        Found 2060 vm1 products to import
        Worked on migration for 29.093529939651 seconds
        Migration finished

info

        Info: port shoppers found 0 vm1 entries for migration
        Info: Processed 0 vm1 users time: 2.8610229492188E-6
        Info: vendor 1 Stored
        Info: Migration: 0 products processed
        Info: port Orders found 0 vm1 entries for migration
        Info: Migration: 0 orders processed

        vmError: port ST addresses db error FUNCTION dkogbkpdb2.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,34000
        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,34000
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0
        vmError: Port Categories Xref unknow : ID 0


I need help.

Thanks,

John Stevenson
Atlanta, GA

[PRO]

Keep going,

You have to click the migrate until it works

It does bits at a time

[jstvnson]

How many times?  and how will I know when it is completed?  Also...what should I set the time on and the memory level?

[jenkinhill]

I have the execution time set to 32 minutes and memory to 386M.         

You set max_execution_time to 1920?   
On which version of PHP is this, as that should be more than enough time. Mine worked fine on 240secs and  memory_limit = 128M

[Milbo]

Please use the latest version. It has some corrections in it. (especially the isnull is removed and replaced against something more compatible)