List of tables to safely truncate in Magento 2?
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?
sql
Auto Added by WPeMatico
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: After Updating a Module
On My site i am running old version of Advanced Product Options Suite Extension for Magento 2 by mageworx. I just updated the Advanced Product Options Suite Extension into latest version. I tired updation with upload Extension files manually also… Read More »SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: After Updating a Module
Magento 2 Website Id 0 Not Found Even though it IS in the Database SQL Tables
Running php bin/magento setup:upgrade returns this error ‘The website with id 0 that was requested wasn’t found. Verify the website and try again.’ Running php bin/magento setup:db-data:upgrade will return the same error. Running php bin/magento store:list will reveal that the… Read More »Magento 2 Website Id 0 Not Found Even though it IS in the Database SQL Tables
Setup Production Database on Staging server in Magento 2.4
I downloaded the production database. Now I want to setup the database on the staging server. So what sanitize process I have to apply on the database before uploading to the staging server.
How to Solve 404 error on frontend?
Getting 404 error on frontend page backend Admin panel is perfectly working frontend page only through error what is the reason behind that
Unexplained ‘EXPLAIN’ SQL Queries in Magento 2 Production Database
Greetings forum members, I hope this message finds you well. I am currently facing an issue with my Magento 2 production database and would greatly appreciate any insights or assistance from the community. Specifically, I am curious to know if… Read More »Unexplained ‘EXPLAIN’ SQL Queries in Magento 2 Production Database
Custom sql to get Magento2 EE reward point data
I am trying to write a custom sql that will provide to me data related to the Magento2 EE reward points. My issue is that my queries seem to be showing 0 as the result which can not be because… Read More »Custom sql to get Magento2 EE reward point data
Magento 2 – Query to know the user who update the price of the product
I am very new to magento. What is the query to to know who was the user who updated the price of a product? I just want to know the query, not the code. Thanks in advance.
Convert SQL Select Query to Magento Collection
I have a complex sql select query which actually returns sales report against specified categories. I want to load data as a collection to display but I’m not able to convert the query into Magento’s equivalent getCollection statement. my query… Read More »Convert SQL Select Query to Magento Collection
Category name from store view, only when it exist else default value – Magento2.4
We use the following code, to get the category name of a specific product. This works fine, but we face the issue with the store views. It only works well if the specific store view does have a unique value… Read More »Category name from store view, only when it exist else default value – Magento2.4
- « Previous
- 1
- 2
- 3
- 4
- Next »