Fix Magento 2.4.3 adding product error
Budget: $10 – $30 USD
Hi,
since yesterday I have an error with M2.4.3 when I press ADD A PRODUCT button:
main.CRITICAL: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?))' at line 2, query was: SELECT `e`.`entity_id` FROM `catalog_product_super_link` AS `l`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.parent_id WHERE (l.product_id IN(?)) {"report_id":"0c0695782f9305f63234b2cdcd0e83c28ba740a07e446978f3927685014e1ad8","exception":"[object] (Zend_Db_Statement_Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?))' at line 2, query was: SELECT `e`.`entity_id` FROM `catalog_product_super_link` AS `l`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.parent_id WHERE (l.product_id IN(?)) at /home/myshop/public_html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:110, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?))' at line 2 at /home/myshop/public_html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:91)"} []
I'm looking for someone to fix this.
Thank you
since yesterday I have an error with M2.4.3 when I press ADD A PRODUCT button:
main.CRITICAL: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?))' at line 2, query was: SELECT `e`.`entity_id` FROM `catalog_product_super_link` AS `l`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.parent_id WHERE (l.product_id IN(?)) {"report_id":"0c0695782f9305f63234b2cdcd0e83c28ba740a07e446978f3927685014e1ad8","exception":"[object] (Zend_Db_Statement_Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?))' at line 2, query was: SELECT `e`.`entity_id` FROM `catalog_product_super_link` AS `l`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.parent_id WHERE (l.product_id IN(?)) at /home/myshop/public_html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:110, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?))' at line 2 at /home/myshop/public_html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:91)"} []
I'm looking for someone to fix this.
Thank you