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,729 questions
0
votes
1
answer
50
views
Magento 2.4.6 – Fastest way to create configurable products via API? Is a MAGMI-style DB importer safe?
I’m working on a Magento 2.4.6 project where the ERP sends product data to Magento through a custom REST API endpoint.
Our current workflow is slow because Magento’s product creation API (/rest/V1/...
0
votes
1
answer
64
views
I can't get the data patch to show a new attribute in admin panel
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 ...
- 1
0
votes
0
answers
55
views
Magento tables deleted automatically
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
0
votes
1
answer
74
views
Magento 2 extremely slow reindexing after server migration (21 hours for 200k products)
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 ...
0
votes
0
answers
30
views
After running setup:upgrade cmd 'magento2.core_config_data' doesn't exist in engine
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....
- 43
0
votes
0
answers
23
views
In windows Xampp MySql Start issue
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-...
- 43
0
votes
1
answer
76
views
Is slave - master model dangerous through Magento 2 CE?
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 ...
- 150
0
votes
1
answer
437
views
Magento 2.4.7-p3 indexation problem
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 ...
0
votes
0
answers
51
views
Magento Open Source Extension for handling Master-Slave DB connections
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 ...
- 4,672
2
votes
1
answer
347
views
Downgrading Adobe Commerce to Open Source
What would be the steps to safely downgrade the database of an Adobe Commerce project to Open Source?
- 2,664
0
votes
1
answer
85
views
SQL Foreign Key issue preventing setup:upgrade from completing
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 '...
- 61
0
votes
1
answer
165
views
My magento 2 website is freezing and stuck due to debugger
(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 ...
- 103
0
votes
1
answer
166
views
install Magento 2.4.7 with a database 2.4.5
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:...
- 21
0
votes
2
answers
118
views
Magento 2.4 open source reindexing issue
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 ...
- 784
0
votes
1
answer
40
views
Trouble installing magento on Mac OS, issue with MySQL
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....
- 363