i am running the tool and getting this error on step5 product migration
[error] [ub_data_migration] Mage2CatalogProductOptionTypePrice: Price Type is too long (maximum is 7 characters).
1 answer
Hi there,
[error] [ub_data_migration] Mage2CatalogProductOptionTypePrice: Price Type is too long (maximum is 7 characters).
That issue occurred because your M1 database had at least one data record which had bad value on the ‘catalog_product_option_type_price.price_type‘ field.
You can run the following SQL query in your M1 database to look for that data record:
SELECT * FROM `catalog_product_option_type_price` WHERE LENGTH(`price_type`) > 7;
and then, you have to re-update the value (reduce the length of string value. Max length allowed is 7 characters) of the price_type field on all found data records.
+ Once done, you can continue with the data migration in step #5 as normal.
Regards,
Mall.