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
Keep going,
You have to click the migrate until it works
It does bits at a time
How many times? and how will I know when it is completed? Also...what should I set the time on and the memory level?
Quote from: jstvnson on March 17, 2012, 19:47:16 PM
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
Please use the latest version. It has some corrections in it. (especially the isnull is removed and replaced against something more compatible)