Whenwe wtry to migrate product data we are getting the following error.
https://drive.google.com/a/mdlonline.nl/uc?id=18YmSAhnwxOV1m2Ri335MZMittRiJFfq-
What can i do to fix this?
The query is SELECT * FROM `catalog_product_entity_int` `t` WHERE attribute_id = 167 AND value = AND entity_id = 19099 LIMIT 1
That is obviously not correct.
-
I found the solution in this forum, i needed to run this query:DELETE FROM catalog_product_super_attribute_pricing WHERE value_index IS NULL OR value_index = '' OR value_index NOT IN (SELECT option_id FROM eav_attribute_option);on the old database to delete wrong records.