0

When I disable MSI on Magento 2.4.5 I receive the following error when trying to open any product

Cardinality violation: 1242 Subquery returns more than 1 row, query was: SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`url_key`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`swatch_image`, `e`.`tax_class_id`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_flat_1` AS `e`\n INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'\n LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))\n LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (e.entity_id IN (2)) ORDER BY FIELD(e.entity_id,2)

The command I use to deactivate MSI was:

bin/magento module:disable -c -f Magento_Inventory Magento_InventoryAdminUi Magento_InventoryAdvancedCheckout Magento_InventoryApi Magento_InventoryBundleImportExport Magento_InventoryBundleProduct Magento_InventoryBundleProductAdminUi Magento_InventoryBundleProductIndexer Magento_InventoryCatalog Magento_InventorySales Magento_InventoryCatalogAdminUi Magento_InventoryCatalogApi Magento_InventoryCatalogSearch Magento_InventoryConfigurableProduct Magento_InventoryConfigurableProductAdminUi Magento_InventoryConfigurableProductIndexer Magento_InventoryConfiguration Magento_InventoryConfigurationApi Magento_InventoryDistanceBasedSourceSelection Magento_InventoryDistanceBasedSourceSelectionAdminUi Magento_InventoryDistanceBasedSourceSelectionApi Magento_InventoryElasticsearch Magento_InventoryExportStockApi Magento_InventoryIndexer Magento_InventorySalesApi Magento_InventoryGroupedProduct Magento_InventoryGroupedProductAdminUi Magento_InventoryGroupedProductIndexer Magento_InventoryImportExport Magento_InventoryInStorePickupApi Magento_InventoryInStorePickupAdminUi Magento_InventorySourceSelectionApi Magento_InventoryInStorePickup Magento_InventoryInStorePickupGraphQl Magento_InventoryInStorePickupShippingApi Magento_InventoryInStorePickupQuoteGraphQl Magento_InventoryInStorePickupSales Magento_InventoryInStorePickupSalesApi Magento_InventoryInStorePickupQuote Magento_InventoryInStorePickupShipping Magento_InventoryInStorePickupShippingAdminUi Magento_InventoryCache Magento_InventoryLowQuantityNotification Magento_InventoryLowQuantityNotificationApi Magento_InventoryMultiDimensionalIndexerApi Magento_InventoryProductAlert Magento_InventoryRequisitionList Magento_InventoryReservations Magento_InventoryReservationCli Magento_InventoryReservationsApi Magento_InventoryExportStock Magento_InventorySalesAdminUi Magento_InventorySalesFrontendUi Magento_InventorySetupFixtureGenerator Magento_InventoryShipping Magento_InventoryShippingAdminUi Magento_InventorySourceDeductionApi Magento_InventorySourceSelection Magento_InventoryInStorePickupFrontend Magento_InventoryLowQuantityNotificationAdminUi Magento_InventoryInStorePickupSalesAdminUi Magento_InventoryInStorePickupWebapiExtension

I've also disable some other modules, useless for me:

bin/magento module:disable -f Temando_ShippingRemover
bin/magento module:disable -f Magento_Ups
bin/magento module:disable -f Magento_Fedex
bin/magento module:disable -f Magento_Usps
bin/magento module:disable -f Magento_SampleData
bin/magento module:disable -f Magento_WeeeGraphQl
bin/magento module:disable -f Magento_Weee
bin/magento module:disable -f PayPal_Braintree
bin/magento module:disable -f PayPal_BraintreeGraphQl
bin/magento module:disable -f Magento_AdobeStockImage 
bin/magento module:disable -f Magento_AdobeStockImageAdminUi 
bin/magento module:disable -f Magento_AdobeStockImageApi
bin/magento module:disable -f Magento_AdobeStockAsset 
bin/magento module:disable -f Magento_AdobeStockAssetApi 
bin/magento module:disable -f Magento_AdobeStockAdminUi
bin/magento module:disable -f Magento_AdobeStockClient 
bin/magento module:disable -f Magento_AdobeStockClientApi 

Trying to debug the issue among all this modules I've found ( maybe I'm wrong) that the issue resides on Magento_InventoryCatalog module, then I enable it but it starts to ask for some dependencies on Magento_InventorySalesApi, and Magento_InventorySales, etc. Anyway, I feel insecure following this path and I would like to know if somebody know or can point me in the right direction to disable MSI on Magento 2.4.5 . Thanks in advance for your help.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.