Skip to content

Only few product is not saving during update in Magento 2

In Magento ver 2.4.3 some of the products are not saved from admin.Showing error :

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 main_table.*, cp_table.type_id FROM
cataloginventory_stock_item AS main_table INNER JOIN
catalog_product_entity AS cp_table ON main_table.product_id =
cp_table.entity_id WHERE (main_table.website_id = ‘0’) AND
(main_table.product_id IN())