Questions tagged [database]
Questions related to Magento's MySQL database, for example, the table schema, plain SQL queries or database configuration. For questions about the Magento database access layer, use other tags, like: eav, model, resource-model, collections, install-script. For questions about SQL queries in particular, the SQL tag is appropriate too.
3,543
questions
2
votes
1answer
26 views
In which situation the entity_id and row_id are different in “catalog_product_entity” table?
The row_at represents "Version ID" & also its "auto_increment" of type for the entity.
That concludes that one record/entity can have multiple rows with the same value for ...
0
votes
0answers
10 views
In my Magento store have 400000 above product. It is taking time to reindexing any solution
I have Magento 2.4.2-p1 store. where have 400,000 above products it uploaded by Magmi extension.
Reindexing taking too much time. Have any solution for fast reindexing. can i increase the values of ...
0
votes
0answers
11 views
update magento quantities from mysql
I'm drawing a draft for a script to update several products at once using mysql.
I've got my own table myinventory which has two columns: sku and qty
UPDATE cataloginventory_stock_item
INNER JOIN ...
0
votes
0answers
3 views
How to edit the admin grid row data with the edit link in the action column?
I am trying to perform edit row option in the admin grid please suggest links for it
0
votes
1answer
16 views
Rows are not deleting in the admin grid
class Delete extends \Magento\Backend\App\Action
{
/**
* @var \Webkul\Grid\Model\GridFactory
*/
var $postFactory;
/**
* @param \Magento\Backend\App\Action\Context $context
* @param \Webkul\Grid\...
0
votes
0answers
12 views
After saving the custom form it should direct to custom admin grid but directing to dashboard with the invalid key message and saving the data too
How to solve invalid security and form key issue?
0
votes
1answer
11 views
Magento 2.3.6 - Img and SKU or product ID SQL dump
I need a SQL dump in CSV where I get these values:
IMG name
SKU or product ID
I use PHPAdmin and looking through the tables but can't find any values where I can link the tables to get the info I need....
0
votes
0answers
9 views
Magento 2.3 - Image with SKU database dump
I need to export a CSV file with the following info:
IMG name
SKU
I found the SKU in catalog_product_entity
And I also found the IMG names in catalog_product_entity
However I do not have any value ...
0
votes
0answers
14 views
Content staging for different magento installations
We currently have an integration and a production stage for our magento shop. The goal is that we configure and create content (products, cms, ...) on the integration stage and deploy them on the ...
0
votes
1answer
32 views
Importing existing products: Integrity constraint violation: 1062 Duplicate Entry
I have been importing existing products to a local environment through the admin dashboard. I realized that many of the products I imported didn't include their attributes, so I went back to make sure ...
0
votes
0answers
8 views
Constraints for table `catalog_product_entity_media_gallery_value
When I import I get this error my store working fine but I think it may cause some issues if did not fix the issue any help will be appreciated!
ALTER TABLE catalog_product_entity_media_gallery_value
...
0
votes
1answer
15 views
Is Magento 2.1.13 version support MySQL 5.7 version?
Currently, my magneto project (2.1.13) connect with the 5.6 MySQL version in the AWS server.AWS server automatically will update MySQL version from 5.6 to 5.7 because MySQL 5.6 is deprecating in ...
0
votes
1answer
26 views
How to optimize MySQL for best Magento 2 performance and Increase indexing speed?
How to optimize MySQL for best Magento 2 performance and Increase indexing speed?
1
vote
2answers
31 views
How to find Magento Cloud DB credentials?
I've one integration environment it was working well but one of my developers deleted the env.php, now I can't make it work again.
How could I find my database credentials to my integration env in my ...
0
votes
1answer
34 views
How to get column name cms_page table in Magento 2?
I am trying to create a field in system config to display a list of column names of the cms_page table. How to achieve this. please help me
0
votes
1answer
28 views
magento 2 - remove Customizable Options for all products?
how I can delete / remove Customizable Options for all products?
Thank you
0
votes
1answer
21 views
How to check reindex triggers from Magento 2.4 database?
I would like to check my database triggers related to stock updates in my Magento 2.4.
I need to know what are the triggers to stock updates specifically.
How could I check it?
4
votes
1answer
49 views
How “cms_block_store” and “cms_page_store” tables are working with Primary keys in Magento?
I have a general doubt in MySql foreign key constraints and Magento.
As per MySql, a table should have only one primary key for a table and a Primary key should contain unique values.
I checked in &...
0
votes
1answer
10 views
Where are media attributes/roles stored?
I was browsing through the DB, trying to find out where the media attributes of product-media-gallery-items are stored.
For clarification: They are called "Roles" in the Admin-Frontend and &...
0
votes
0answers
16 views
How to save Image data using Magento 2.4.2?
I have created an input type image using Magento 2 Extension and want to save Image data.
Now I want to save Image data in Magento 2 Database Custom table.
I have created custom table and run Ajax ...
0
votes
1answer
16 views
Magento 2 (ver. 2.3.6) reindex not working
I have a single view Magento 2, with about 5000 products on it, running on a cloud hosting with 4GB RAM.
What happens is that every time the reindex process is triggered (by the cron job or by hand) ...
0
votes
0answers
17 views
Need to manually write in the DB in patch_list table a particular CMS block
I have just been asked to do this, and me and my colleagues have no idea, any help would be greatly appreciated!
0
votes
1answer
23 views
How to overwrite existing DB value with NULL value?
On an admin grid form I have a checkbox. If the checkbox is checked the form shows additional data fields. If it is not checked the additional fields are hidden. When the form is saved, the data from ...
0
votes
1answer
50 views
Integration ID is not specified or invalid when authorising
On a Magento v2.4.1 site, when trying to authorise an existing integration record, I'm receiving the error "Integration ID is not specified or is invalid".
I verified that the record does ...
0
votes
1answer
26 views
magento 2- showing special price products on the product list page not working with flat catalog tables
I have created functionality to show all the special price products on the product list page by extending the core class \Magento\Catalog\Model\Layer.
This functionality is working fine with default ...
0
votes
2answers
25 views
Magento 1 Sql query for product name, sku and quantity
I am using Magento 1. I want to fetch product names, SKUs, and stock quantity with SQL queries. If anyone knows please let me know. Thanks in advance.
1
vote
1answer
67 views
Magento 2 | Reindex very slow in local server
On my server with:
MariaDB 10.4
PHP 7.4
Elasticsearch 7.9.1
Elasticsuite 2.10.0
I am trying to relaunch the full reindex for Magento2 but I have seen that catalog_category_product is very slow, its ...
0
votes
1answer
28 views
Get specific columns from Left Join
I am trying to join two tables like below
$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$collection = $objectManager->get('Advance\Module\Model\Method')
->...
0
votes
0answers
19 views
How to create a website, store and storeview using data patch in magento2.4.2
I want to create a website, store and storeview using data patch in magento2.4.2.
How to do that.
Thanks
1
vote
0answers
17 views
SQL maxium innodb size issue
I am installing smtp extension suddenly I am facing with below Mysql error message
https://prnt.sc/127cedv
SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row ...
0
votes
1answer
8 views
MySQL Query of catalog_product_super_link filtered by attribute_set_id
I want to export all fields from the catalog_product_super_link table, but filtered to exclude any products that have have a certain attribute_set (31 in this case).
This post (MySQL Query filtered by ...
0
votes
1answer
11 views
magento 2: how to checked use default value for product status programmtically?
I have to update and checked checkbox for use default field for product status. But I do not know how to update and checked that checkbox ?
here is my code
$objectManager = \Magento\Framework\App\...
0
votes
1answer
12 views
upload porto theme with existing database in Magento 2.3.5
can I upload the porto theme and use my old products hence the dummy data will be removed and my old data will be shown... is this possiable
furthermore will my old categories appear in the theme or ...
0
votes
1answer
18 views
Is it right or wrong to create tables in the magento 2 database?
Guys I'm new to magento development and I'm trying to learn how to create basic modules and I'm trying to create a module that registers some customer information and then returns it to the ...
0
votes
1answer
126 views
problem in facebook pixel module for magento2.4
we installed the facebook pixel module for magento2.4. so far everything perfect. But when I enter the product registration and saved, the error below occurs
Error: Call to undefined method Facebook\...
0
votes
1answer
23 views
Magento 2 Change custom option name with mySql
I have this line which I can use to update the price of a custom product option.
UPDATE `catalog_product_option_type_title` a JOIN `catalog_product_option_type_price` b ON a.option_type_id = b....
0
votes
1answer
34 views
How to import 3 tables dump into database using script?
I want to include 3 tables SQL dump into that database, how to add it by using a custom module or script or any best practice.
0
votes
0answers
18 views
Magento 2.4.1 EE | Customer custom attribute created from admin but not saving value in DB
I am facing an issue with Magento2 EE website (Magento ver. 2.4.1) for customer custom attribute.
Found similar question here as well but not with any solutions.
When I create a new customer attribute ...
0
votes
0answers
26 views
Serialization failure: 1213 Deadlock found when trying to get lock
We are using https://github.com/firegento/FireGento_FastSimpleImport2 to import product using CSV and we end up in getting this exception.
["SQLSTATE[40001]: Serialization failure: 1213 Deadlock ...
0
votes
0answers
49 views
MariaDB crashing every few days
I'm using Magento2 with MariaDB 10.3.27 on Debian 10.8 and i'm experiencing MariaDB crash every few days. I have no idea what can cause those unexpected crashes. I'm sending my config and crash logs. ...
0
votes
0answers
12 views
Error on mysql only on front page
I'm using Magento 2.3.6-p1
In Cli commands everything works fine.
I can ran setup:upgrade, compilation, content:deploy, etc.
But, when I go to www.mystore.com I get the following:
2 exception(s):
...
0
votes
1answer
51 views
Magento 2 - Is it safe to remove the DEFINER=.. statement from sqldump?
I have a web server that serves Magento2 and a MySQL Server that hosts the database and both of these servers are in a single ubuntu instance.
I would like to move the MySQL server to a separate RDS ...
1
vote
2answers
24 views
Add collection filter from json field
I want to filter custom collections with JSON field filters. In the below image, there are 2 fields category and product. They have JSON value.
I am able to get collection by Direct SQL query by ...
0
votes
1answer
29 views
Magento 2 get categories by store Query
I want to get all enable categories for specific store from query in Magento 2 database. As I tried from database query from table catalog_category_entity_int
SELECT * FROM `...
0
votes
3answers
40 views
How to Fetch/Insert in Database without Sql Query
I am trying to get customers from the database whose order was cancelled, and I am able to do this via Query. But I think the standard way should be without using Queries. So is there a way I can ...
0
votes
1answer
41 views
php bin/magento setup:db-declaration:generate-whitelist
I had some issues when updating an module, I revived an error and after looking it up It was recomaneded to do php bin/magento setup:db-declaration:generate-whitelist. AFter i did this I was able to ...
0
votes
0answers
29 views
Magento Cloud Too many mysql connection error
I'm getting error on the Magento Cloud,
ERROR 1040 (HY000): Too many connections
Doesn any one now how i can restart the mysql or just know the reason of that, like where i can find the mysql logs ...
0
votes
1answer
22 views
How to confirm and approve a customer account via Database in bulk Magento 2
How can we change a customer account confirm and approve a customer account via Database in magento 2
0
votes
0answers
26 views
Magento 2.3.6 Commerce : Missing field used into WHERE clause on catalog_product_entity_media_gallery_value_to_entity (entity_id)
On the category page I have this error :
2 exception(s):
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity.entity_id' in 'where clause', query ...
1
vote
1answer
41 views
Magento 2 Best way to merge specific DB tables and data from one database to another
We have two enviroments Staging and Production, for Magento 2.3.5. At the moment these two enviroments have different database structure, meaning that we can't just dump the entire DB and restore it ...
