VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: Ralphy on July 14, 2013, 20:03:27 PM

Title: User migration error
Post by: Ralphy on July 14, 2013, 20:03:27 PM
Hello everybody.

I am trying to update my virtuemart 1.1.9 site to virtuemart 2.0.
But when migrating the users I receive an error and none of the users are migrated.
this is the error:
vmError: port ST addresses db error Unknown column 'ui.address_type' in 'where clause' 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,71100
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,71100

Is there a solution for this problem or is there a workaround to migrate the users?

Thanks in advanced.

Ralph