Auto Added by WPeMatico
I am running into an issue when trying to run setup:upgrade, to where it fails with saying; SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID’; check that column/key exists, query was: ALTER TABLE review DROP FOREIGN KEY REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID… Read More »SQL Foreign Key issue preventing setup:upgrade from completing
We are using Magento 2.4.2-p2 version with SimiCart – Magento 2 Mobile App Builder We are struggling from where category_id is coming File name – app/code/Simi/Simiconnector/Model/ResourceModel/Productlist/ProductlistCollection.php File function – $collection = $simiObjectManager->create(‘MagentoCatalogModelProduct’)->getCollection() ->addAttributeToSelect($simiObjectManager->get(‘MagentoCatalogModelConfig’) ->getProductAttributes()) ->addMinimalPrice() ->addFinalPrice() ->addTaxPercents() ->addUrlRewrite(); when we… Read More »Magento 2 SimiCart – Magento 2 Mobile App Builder
I noticed my DB CPU creeping up and hitting 100% this week. Looking into the MySQL process list I saw 4 instances of the same query running. These queries never finish though, one has been running for 50+ hours, and… Read More »Where is this query coming from?
i am trying to get order collection group by sku using sql query. this query is working in my local system but not in my live site. it returns – Uncaught TypeError: Cannot read properties of undefined (reading ‘select’) Following… Read More »Magento 2 Get order collection using mysql query group by sku
Any idea how to disable products without images via SQL ? Magento ver. 2.4.3-p1 Thank you
I’m on OpenMage LTS 20.0.6 installation and while the site doesn’t have much data, it keeps getting a lot of high execution queries that seem related to Layered Navigation +—————————-+—————————————————————————————————————————————————————+ | name | value | +—————————-+—————————————————————————————————————————————————————+ | Version | OpenMage… Read More »Constant slow queries from OpenMage / Magento 1.9 probably from Layered Navigation
I have a SQL query that does what I need SELECT ipi.*, COALESCE(unique_purchases, 0) AS unique_purchases FROM mst_inventory_planner_inventory AS ipi LEFT JOIN ( SELECT product_id, COUNT(DISTINCT order_id) AS unique_purchases FROM sales_order_item GROUP BY product_id ) AS soi ON ipi.product_id =… Read More »Issue with implementing unique_purchases column in main table using leftJoin in Grid ResourceModel
I require an SQL query to retrieve information about the promotions applied to an order from the sales order table. The field “applied_rule_ids” is utilized to obtain all rule IDs. However, a challenge arises when a rule, such as “buy… Read More »SQL for getting promos applied to an order
What i am doing ->addFieldToFilter(‘value’, array([‘eq’ => ”, array(‘isnull’ => true)])) What i want in the query – ‘((value = ” )is NULL)` Can anyone help me on this Thanks.
For Magento 1, here is a list of tables which can be safely truncated. Is there a similar list of tables for Magento 2, which can be truncated/deleted without deleting base data?