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.

Filter by
Sorted by
Tagged with
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
12 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
17 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
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
1answer
15 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
33 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
27 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
18 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
128 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
50 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
30 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 ...

1
2 3 4 5
71