News:

Looking for documentation? Take a look on our wiki

Main Menu

User migration error

Started by Ralphy, July 14, 2013, 20:03:27 PM

Previous topic - Next topic

Ralphy

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