Skip to main content
We’ve updated our Terms of Service. A new AI Addendum clarifies how Stack Overflow utilizes AI interactions.
Magento

Questions tagged [database]

Ask Question

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,729 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
64 views

Create a data patch to add a new attribute to the customer, for example when registering a new customer, in the admin panel it must be possible to view the new field (e.g.: Customer Code) and make the ...
frANCO's user avatar
  • 1
0 votes
0 answers
55 views

We are using magento 2.4.4 version for our website yesterday we observe that all tables related with magento got automatically deleted, what will be the possibel reason and how we find the RCA
user122933's user avatar
  • 1
0 votes
1 answer
73 views

Magento 2 extremely slow reindexing after server migration (21 hours for 200k products) After migrating our Magento 2 store to a new dedicated server, we noticed that full reindexing now takes around ...
Vladyslav Ollinyk's user avatar
  • 1
0 votes
0 answers
30 views

After running the cmd php bin/magento setup:upgrade I am getting following error. [2025-03-07T07:07:05.311272+00:00] main.ERROR: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'magento2....
zus's user avatar
  • 43
0 votes
0 answers
23 views

Instead of close i did exit in xampp, whenever i exit xampp i am facing MySql start issue. Again and again i am reinstalling the xampp. How to solve the issue, how star my MySql. MySql Error: 2025-03-...
zus's user avatar
  • 43
0 votes
1 answer
75 views

We're using Magento CE 2.4.6, and we're looking for implementing slave-master scheme to make our infrastructure more robust and faster. I know this implementation exists on the Magento 2 Entreprise ...
Thomsath's user avatar
  • 150
0 votes
1 answer
434 views

Hi everyone and happy new year I'm not able to complete indexing and get some errors. Any clue? Design Config Grid index has been rebuilt successfully in 00:00:00 Customer Grid index has been rebuilt ...
universitas srl's user avatar
  • 1
0 votes
0 answers
51 views

Do you know of any extension for Magento Open Source that functions similarly to Adobe Commerce's Magento_ResourceConnections for managing master-slave database connections? In Adobe Commerce, these ...
MagePsycho's user avatar
  • 4,672
2 votes
1 answer
342 views

What would be the steps to safely downgrade the database of an Adobe Commerce project to Open Source?
Raul Sanchez's user avatar
  • 2,664
0 votes
0 answers
45 views

We are Saving Configurable Products using Pim(pimcore) through a custom Module in Magento, while saving configurable Products,we are getting this below Foreign key constraint Erorr, SQLSTATE[23000]: ...
Chandra Sekhar's user avatar
  • 1
0 votes
1 answer
83 views

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 '...
ne0nlight's user avatar
  • 61
0 votes
1 answer
165 views

(function anonymous( ) { debugger }) I am getting this in source tab and whole website is freezing because of it. I have not added this code anywhere. How to find out what is the exact issue. Also ...
Tisha Jhanwar's user avatar
  • 103
0 votes
1 answer
166 views

We are working with Magento version 2.4.5 and want a clean (new) installation of the latest version 2.4.7 while retaining our current database with 2.4.5, of course. What is the most sensible sequence:...
Koos's user avatar
  • 21
0 votes
2 answers
118 views

I have 600000 products, 6000 categories and multiple attributes set and attributes 10 stores and 20 store views This will create large set of data in Magento 2 open source in eav and creates indexing ...
Yogita's user avatar
  • 784
0 votes
1 answer
40 views

I am getting this error when trying to setup Magento from the terminal on Mac OS localhost. SQLSTATE[HY000] [1045] Access denied for user 'magento'@'localhost' (using password: YES) In InstallCommand....
Justin Collins's user avatar
  • 363
0 votes
1 answer
254 views

Could not validate a connection to Elasticsearch. Unknown 401 error from Elasticsearch null curl -X GET 'http://localhost:9200' {"error":{"root_cause":[{"type":"...
Ravindrasinh Zala's user avatar
  • 2,157
0 votes
2 answers
150 views

I am in the process of migrating a Magento2 website from a single dedicated server to a split setup with Magento on one server and the Database on it's own dedicated server. What is the recommended ...
UrbanwarfareStudios's user avatar
  • 223
0 votes
1 answer
72 views

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 ...
Timothy Fisher's user avatar
  • 131
0 votes
2 answers
34 views

save some records to DB and after throw LocalizedException, the saved data does not show in the table. auto increment ID is assigned $data = [ 'sku' => $f_sku, 'user' => $...
kanishka maduranga's user avatar
  • 65
1 vote
0 answers
158 views

I have a column name in my db_schema.xml, I want it to have the unique property and also fulltext, when I add these two fields it returns an error that said Index Name already exists, this is because ...
Roberto's user avatar
  • 66
0 votes
2 answers
138 views

Where is the folder that contains the information of registered customers? I need to extract the 'last login date" with e-mail/name/id Thanks!
Flavio's user avatar
  • 1
0 votes
1 answer
59 views

I have question on how do you guys save post_category relationship, when i debug save action, i just saw Post to be saved , how magic underneath the hood https://github.com/magefan/module-blog
ducanh's user avatar
  • 11
0 votes
0 answers
43 views

I have noticed that certain categories in the database don't have entries. Once they are saved manually, the entries appear, but there are much too many of them to save them all manually. This is ...
Jack's user avatar
  • 5
0 votes
1 answer
106 views

I am working on an integration extension for Magento 2. I would like to create API endpoints for core_config_data table, because I would like to insert a html script to header of each specific store ...
Krumpel's user avatar
  • 3
0 votes
1 answer
179 views

I'm trying to create a module which adds 2 fields in bundle option. I've already managed to add 2 field: However, it doesn't save the values in my database. The columns are created, but they are not ...
Petacchi's user avatar
  • 17
0 votes
2 answers
411 views

I get the errors while customers add. err: Something went wrong with processing the default view and we have restored the filter to its original state solution: TRUNCATE ui_bookmark; ? is the right ...
hariprabhu rajan's user avatar
  • 5
0 votes
0 answers
45 views

I am facing an issue with my SQL database which take 500% of the CPU. I have taken a screenshot of the process list. Error: [2024-06-02T06:00:17.313192+00:00] main.ERROR: SQLSTATE[HY000] [2002] ...
Bbaodenx3's user avatar
  • 1
0 votes
1 answer
112 views

I'm new in Magento. So I want to understand Magento from basic to advanced so I can work on projects as an individual without taking any help. Please guide me on how to start learning and source ...
BOBY GUPTA's user avatar
  • 9
0 votes
2 answers
156 views

I'm a new Magento developer. I have a question, can I integrate bootstrap5 or tailwind css into my module without affecting the class of other modules and can I integrate angular into magento and how? ...
Abu Shino's user avatar
  • 1
0 votes
2 answers
56 views

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 ...
Dramorian's user avatar
  • 33
0 votes
0 answers
154 views

We are facing huge MYSQL CPU usage. While investigating we found that there are MySQL sleep connections during the CRON run. Is there any way to reduce the CPU usage and the sleep connections. Please ...
Jasvir Singh's user avatar
  • 363
0 votes
2 answers
267 views

I want to install magento and I run the command below, php bin/magento setup:install --cleanup-database --base-url=“http://**.***.**.*/var/www/html/magento/“ --db-host=“database-1.************.*****...
Meow's user avatar
  • 1
0 votes
1 answer
53 views

I am using magento 2.4.4.p1 upgrade from 2.3 to 2.4.4-p1 i have some products in my site in that few are disabled few are enabled after upgradation i am trying to enable one product it enable but not ...
pavan kumarexinent's user avatar
  • 1
0 votes
2 answers
52 views

There is data in my table as you can see in below image when i disable the extension from command line & reenable it the data is getting remove from database as i attached the picture below here ...
syed zaviar hasan's user avatar
  • 1
0 votes
2 answers
326 views

How to create data patch to insert data into the database for dynamic blocks?
Vinod Kumar's user avatar
  • 2,095
0 votes
0 answers
91 views

SET timestamp=1708087305; UPDATE `theme` SET `parent_id` = NULL, `theme_path` = 'Magento/blank', `theme_title` = 'Magento Blank', `preview_image` = 'preview_image_5d490e5c15226.jpeg', `is_featured` = '...
Magecomp Product Team's user avatar
  • 127
0 votes
1 answer
176 views

I have enough space in my instance's HD. However, the space allocated to my MySQL database shows 108% usage by using the command below. magento-cloud db:size How could I increase my MySQL HD's ...
Rafael Corrêa Gomes's user avatar
  • 14k
0 votes
0 answers
95 views

I really need you guys’ help. I just can't get my head around how magento saves relational data. For instance, the catalogue-rule module has three tables, "catalogrule", "customer_group&...
Joseph Haan's user avatar
  • 13
0 votes
1 answer
143 views

We have an issue where we get data from a client. They are copying and pasting from websites so things are a mess atm. So we have attributes with sku values in them. I did try and delete them manually ...
Jan-petter Havna's user avatar
  • 59
0 votes
1 answer
912 views

I am having issues installing Magento2 on my local machine. I have been following this tutorial but I run into the same issue where my localhost/magento2/pub/ page doesn't display content. I have been ...
Kage Dev's user avatar
  • 5
0 votes
1 answer
416 views

Good Afternoon, I am looking at a data scoping issue around category content fields for Magento 2 (2.4.5-p2). I have a list of fields that we typically fill in (please see below for category content ...
Baber's user avatar
  • 302
0 votes
0 answers
170 views

Broken reference: the 'product.reviews' element cannot be added as child to 'product_tabs', because the latter doesn't exist
Alan Biju's user avatar
  • 11
0 votes
2 answers
172 views

I have created a custom admin form using a UI component and added a multi-select shipping method field. I've successfully retrieved the selected values in an array and stored them as a string in my ...
IntraPersonalLearner's user avatar
  • 580
0 votes
3 answers
131 views

As we anticipate the upcoming Magento versions in 2024, several exciting features and enhancements are expected to shape the platform's evolution. While specific details may depend on official ...
Roshan Choudhary's user avatar
  • 1
0 votes
2 answers
142 views

I have tried all of my thinking, I don't understand why the grid displays a blank Controller namespace StateDrives\RequestQuote\Controller\Adminhtml\Bulkquote; use Magento\Backend\App\Action; use ...
abbas fakhruddin's user avatar
  • 3
2 votes
0 answers
58 views

I have two custom columns in UI grid (let's call them subscribed_customers" and "unique_purchases") created in particular listings that retrieve value from the database with logic. ...
Dramorian's user avatar
  • 33
1 vote
0 answers
423 views

I'm quite new to the Docker and DDEV material. I've setup a local instance of our Magento repository, using Docker and DDEV. Imported the database and changed the env.php using the following settings ...
MaxiKloas's user avatar
  • 11
1 vote
1 answer
42 views

ref.like this >> from this to this
Bu By's user avatar
  • 23
1 vote
2 answers
72 views

Recently I've been unable to reindex Product Price (catalog_product_price) on Magento 2.4.6. When I run 'php bin/magento indexer:reindex catalog_product_price' from the CLI, I get the following output:...
mcpacific's user avatar
  • 41
0 votes
0 answers
56 views

Using Magento 2.4 MaySql 8 I am investing now a lot of time to try finding the option_id (red marked) of the connected simple product to the configurable products. I ended up in the following tables: ...
Samuel Demir's user avatar
  • 217

1
2 3 4 5
…
75