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
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
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
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
434
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 ...
2
votes
1
answer
345
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
84
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
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
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
0
votes
2
answers
151
views
Magento2 - Migrating the database from one server to another
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 ...
0
votes
2
answers
34
views
Magento 2 : Saved data not in DB after throw new LocalizedException
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' => $...
0
votes
2
answers
140
views
Where is the file with all customers details (last log-in date)
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!
- 1
0
votes
0
answers
43
views
Certain Categories Missing Database Entries
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 ...
- 5
0
votes
1
answer
179
views
Magento 2 - Add 2 New fields in bundle item option Selection
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 ...
- 17
0
votes
0
answers
45
views
My Magento SQL is taking 500% of the CPU
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] ...
0
votes
2
answers
156
views
How to add bootstrap and angular in magento2.4.5
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? ...
0
votes
0
answers
154
views
MySql Sleep Connections
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 ...
- 363
0
votes
1
answer
53
views
magento 2 new categroy product missing in category page
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 ...
0
votes
2
answers
327
views
How to create data patch to insert data in dynamic blocks in Magento 2.4?
How to create data patch to insert data into the database for dynamic blocks?
- 2,095
0
votes
1
answer
176
views
Increase database size on Adobe Commerce Cloud
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 ...
0
votes
1
answer
143
views
Where to delete attribute values - Magento 2.4.6
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 ...
0
votes
1
answer
419
views
Magento 2 Category field data scope issues
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 ...
- 302
0
votes
2
answers
172
views
Magento 2 :: Admin Custom Form values stored with double quotes issue
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 ...
0
votes
2
answers
143
views
i am fetching the data from database and display in magento admin grid, and the grid display blank
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 ...
1
vote
0
answers
424
views
Docker DDEV / DB error | php_network_getaddresses: getaddrinfo for mysql failed: Temporary failure in name resolution
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 ...
- 11
1
vote
2
answers
72
views
Attempts to reindex catalog_product_price throws SQLSTATE[42000]: Syntax error or access violation: 1064 on Magento 2
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:...
- 41