FACEBOOK SHOP PRODUCT SYNC NOT WORK

[dukpionstore]

Contact Details

[email protected]

What happened?

Upload to Facebook  Finished (response) ({"success":false,"message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'vjnrpwwnfw.catalog_product_super_link' doesn't exist, query was: SELECT e., IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS status, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS visibility, l. FROM mgdc_catalog_product_entity AS e\n INNER JOIN mgdc_catalog_product_entity_int AS at_status_default ON (at_status_default.entity_id = e.entity_id) AND (at_status_default.attribute_id = '97') AND at_status_default.store_id = 0\n LEFT JOIN mgdc_catalog_product_entity_int AS at_status ON (at_status.entity_id = e.entity_id) AND (at_status.attribute_id = '97') AND (at_status.store_id = 1)\n INNER JOIN mgdc_catalog_product_entity_int AS at_visibility_default ON (at_visibility_default.entity_id = e.entity_id) AND (at_visibility_default.attribute_id = '99') AND at_visibility_default.store_id = 0\n LEFT JOIN mgdc_catalog_product_entity_int AS at_visibility ON (at_visibility.entity_id = e.entity_id) AND (at_visibility.attribute_id = '99') AND (at_visibility.store_id = 1)\n LEFT JOIN catalog_product_super_link AS l ON e.entity_id = l.product_id WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) != 1) AND (e.type_id = 'simple') AND (l.product_id IS NULL) ORDER BY e.updated_at desc\n LIMIT 2000"})

Magento Version

2.3.4

Plugin Version

1.4.4

Relevant log output

Upload to Facebook Finished Finished (response) ({"success":false,"message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'vjnrpwwnfw.catalog_product_super_link' doesn't exist, query was: SELECT `e`.*, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, `l`.* FROM `mgdc_catalog_product_entity` AS `e`\n INNER JOIN `mgdc_catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '97') AND `at_status_default`.`store_id` = 0\n LEFT JOIN `mgdc_catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 1)\n INNER JOIN `mgdc_catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '99') AND `at_visibility_default`.`store_id` = 0\n LEFT JOIN `mgdc_catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '99') AND (`at_visibility`.`store_id` = 1)\n LEFT JOIN `catalog_product_super_link` AS `l` ON e.entity_id = l.product_id WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) != 1) AND (`e`.`type_id` = 'simple') AND (l.product_id IS NULL) ORDER BY e.updated_at desc\n LIMIT 2000"})

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[magefan]

@dukpionstore , please try this fix https://github.com/facebookincubator/facebook-for-magento2/pull/111/files