Error creating product after 2.4.2-p1 to 2.4.3 upgrade

[GTLTD]

Hello.

I've upgraded Magento on my dev. site from 2.4.2-p1 to 2.4.3, which went smoothly, but if I click 'Add Product' I get the following error:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?))' at line 2, query was: SELECT `e`.`entity_id` FROM `mgxv_catalog_product_super_link` AS `l`
INNER JOIN `mgxv_catalog_product_entity` AS `e` ON e.entity_id = l.parent_id WHERE (l.product_id IN(?))

This is from exception.log:

[2021-08-26 08:57:50] 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 MariaDB server version for the right syntax to use near '?))' at line 2, query was: SELECT e.entity_id FROM mgxv_catalog_product_super_link AS l INNER JOIN mgxv_catalog_product_entity AS e ON e.entity_id = l.parent_id WHERE (l.product_id IN(?)) {"report_id":"ec517c5a03ebe3ba0494ab4d33408db992171b57923a4032be36c29afb2bddf6","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 MariaDB server version for the right syntax to use near '?))' at line 2, query was: SELECT e.entity_id FROM mgxv_catalog_product_super_link AS l INNER JOIN mgxv_catalog_product_entity AS e ON e.entity_id = l.parent_id WHERE (l.product_id IN(?)) at /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 MariaDB server version for the right syntax to use near '?))' at line 2 at /public_html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:91)"} []

Is anyone able to advise what might cause this please?

[Teodor Pavlovich]

I have the similar issue.

Any idea how to fix it?

[panchomuniz]

Hello I have the same issue, cant add new produts i can only update old products but not duplicate or add produts

[GTLTD · Accepted solution]

In my case, it was an Amasty extension that caused the issue, Product Attachments. I reported it to them and they have now fixed the issue for me.

[sundeep_kumar]

Any solution on this??

[elfling]

Yes,

Amasty/ProductAttachment/Model/Product/DataProvider/Modifiers/Meta.php

$isPartOfConfigurable = (bool)$this->configurableProduct->getParentIdsByChild(
    $this->locator->getProduct()->getId()
);

Really, you'd need to do a check that the productId actually exists first since you haven't created the product yet 

So you could change it to 

if(!$this->locator->getProduct()->getId()) return $meta;

    $isPartOfConfigurable = (bool)$this->configurableProduct->getParentIdsByChild(
        $this->locator->getProduct()->getId()
    );