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,511
questions
0
votes
1answer
8 views
How to export all URL rewrites in a CSV?
I would like to export all my URL rewrites in a CSV, via Magento 2 admin panel I can't do it. I followed this guide below but I didn't find anything native.
https://docs.magento.com/user-guide/...
0
votes
0answers
24 views
Magento2 - Integrity constraint violation 1062 ALTER TABLE on setup:upgrade
Magento 2.3.5 Mariadb 10.2 PHP 7.2
We are hitting the constraint violation error below when running: php bin/magento setup:upgrade
catalog_product_entity_varchar ran out of space at 2147483647 so we ...
0
votes
2answers
26 views
Magento 2 - how to re-install missing foreign-key constraints?
I am using a third party extension.
I noticed that a constraint is missing by comparing with a fresh installation. This causes a bug when deleting an item of the extension.
Is there a command which is ...
0
votes
1answer
16 views
Magento 2 - Foreign Key Constraint does not delete record
I am using the extension Amasty Product Attachments.
If I add an attachment to a product and then delete that attachment from Amasty -> Product Attachments -> Attachments Management, then I can'...
0
votes
3answers
35 views
How to check installed extensions on database magento 2
I need to check installed module on database table
I hope your help
Thanks
Thomas
4
votes
3answers
71 views
How to manage Magento store with 60 Million Products
I have completed the product import process of 60 Million products in Magento 2. But products are not visible on the front-end, while debugging this I found that re-indexing of products is still in ...
0
votes
0answers
12 views
Class does not exist error after Mysql upgradation in Magento 2.2.4
Recently we have done Mysql upgradation from 5.6 to 5.7.31 in Magento EE 2.2.4, we have Android application, when logging in to new installed application it is giving error(given below) for first time ...
0
votes
0answers
5 views
Magento 1.7 - SEO URLs - Rewrite URL in Sitemap for Products
we have Magento 1.7 in use.
We would like to read our SEO URL for the products from the database. We have found that the attributes for "url_key" do not match the URL from the sitemap of ...
0
votes
1answer
24 views
ResourceModel->delete() not deleting row in custom table
I am writing a module which imports additional product information into a custom table with SKU as the PK.
If there is already a row in the custom table regarding the SKU, i have to delete the old row ...
0
votes
0answers
8 views
magento 2 set quote_item custom column in controller
I want to update my custom column name order_item_note in a quote_item table.
I have the below data.
Product Id, and Text to insert.
How to update the column order_item_note without raw sql
I have ...
0
votes
1answer
28 views
Magento 2 SSH reindexing not working? [duplicate]
I just installed a Magento 2.3.6 version. and I tried to run the Command Reindexing but it's not working. I tried with diff commands like cache clear and flush none of the commands are not working ...
0
votes
1answer
30 views
Magento 2 SSH CLI reindexing not working
I just installed a Magento 2.3.6 version. and I tried to run the Command Reindexing but it's not working. I tried with diff commands like cache clear and flush none of the commands are not working ...
0
votes
0answers
11 views
Which DBMS versions Magento 2.1.18 supports?
I am unable to find on Magento website or elsewhere, up to which versions of MariaDB and MySQL Magento 2.1.18 supports. I know it's old, but that's another topic.
I've found MySQL 5.6.x, I wonder if 5....
0
votes
0answers
33 views
Magento migration 1.9.3.1 to 2.3.5 p2
When i doing migration from magento 1.9.3.1 to magento 2.3.5 p2 getting this error. And after search this related issue i deleted some database tables but again and again i getting this issue on ...
0
votes
1answer
10 views
how to migrate order , customer data mysql from one environment to another
need table detail which we need export order , customer attribute from same version of magneto but different server
need table name .
any admin import /export method.
1
vote
1answer
21 views
Remigrate data to new M2 database
How can i remigrate data to new database after one migration?
Workflow:
Migrate data from M1 => M2. In M1 database new m2_cl tables created.
Delete M2 table and try to migrate data from M1 one ...
0
votes
0answers
6 views
Magento 2 getSelect with columns only showing one record in admin grid
I have a collection like below.
protected function _initSelect() {
$this->addFilterToMap('entity_id', 'main_table.entity_id');
$this->addFilterToMap('increment_id', 'main_table....
0
votes
0answers
19 views
Magento 2: Adding Custom Field to Checkout and Having a Database issue
So I'm trying to add a custom 'checkbox-set' to the checkout page of a vanilla install of Magento 2.3.2, I have it working on the frontend view, though after changing some values in the InstallSchema....
1
vote
1answer
27 views
How to fix Magento 2 MSI inventory reservation inconsistencies directly via DB?
I see orders that are closed, canceled or completed that were created in the reservation table but never removed and they won't be removed since it's triggered when the order changes the status.
I ...
0
votes
0answers
17 views
Declarative schema uses padding in 2.3, gone in 2.4, do we have to use it?
In a module we're developing we declare a new database table with a foreign key relationship to the sales_order table. We want to support Magento 2.3 and 2.4, so we use the declarative schema (...
0
votes
0answers
11 views
Checkout Payment Method Error - M2
I am facing this issue when placing order in magento 2.4.0. I am using multi store website. How to i can fix this issue ?
0
votes
0answers
21 views
Slow Catalog pages Magento 2.4 - Large database - 30+seconds first page load
We have been working on a Magento 2.4 multi store.
On Dedicated server, 24 Cores, 192GB RAM, MySQL 5.7, PHP 7.4
One of the stores has 300k SKU.
When loading the homepage and product pages, the speed ...
0
votes
1answer
23 views
Re-indexed procedure in Magento 2
If i update 10K products and re-indexed it first time it will re-indexed all.
But if i update 10 more product so it will require re-index so my question is is it re-index all the products from ...
0
votes
0answers
18 views
Import orders from Magento 2.1 to 2.4
We have a live Magento 2.19 site. Recently we've duplicated the website as a development site, upgraded it to 2.4.1 and added a new customised theme and added various new modules. We are about to go ...
1
vote
4answers
33 views
Where is URL Key information stored in database?
I'm using a mass import extension to import product URL Keys for a Magento 2.3.0 site which recently went live. The URL key information in the backend product detail is correctly updated but Magento ...
0
votes
0answers
12 views
DOB of customer changed in database for one store in magento 1
customer signup during checkout in magento 1.I have using 2 stores in it, when I register a user for thai store and check DOB. It save wrong DOB in database but log file shows correct DOB.
1
vote
3answers
40 views
I want to fetch Product Names on behalf of comma separated SKU's
I want to fetch Product Names on behalf of comma separated SKU's i.e. sku1,sku2,sku3 and the expected result is Name1,Name2,Name3
0
votes
0answers
10 views
How to export products with tier prices directly via database using SQL?
I want to export these data from my Magento 2.3:
Status
Product Name
SKU
Price
Advanced Pricing
Quantity
How could I do it via SQL?
0
votes
1answer
15 views
'TABLE 607 WHERE `Non_unique` = 1' - Setup Upgrade Error
When i run this command (setup:upgrade) in Magento 2. Then i am getting this error.
Please tell me how to i can fix this issue. which table is 607 ?
Syntax error or access violation: 1064 You have an ...
0
votes
0answers
7 views
How does catalog_category_product ( Category Products ) reindexer works according to mysql in Magento 2
I want to know about catalog_category_product ( Category Products ) indexer in Magento 2 like how it will work according to mysql.
Like in which table's it will enter the data then further which table ...
1
vote
1answer
33 views
Table in MySQL to show product data in Magento 2 after reindexing process
I want to know about those MYSQL tables which is used to fetch data for Front-end Products in Magento 2 after re-indexing process.
Like which table will be used after re-indexing process to show ...
1
vote
1answer
32 views
Magento 2: What is the purpose of “_replica” tables?
I'm newbie in Magento but I have a store that started in 2.2 and is now updated to 2.4.1.
What is the exact purpose or _replica tables? The only mentioning is that they help prevent deadlock but how ...
0
votes
0answers
262 views
magento 2.4 Impossible to process constructor argument Parameter #0 [ <required> Magento\Framework\Search\Adapter\Mysql\Mapper $mapper ]
I am getting below error
Impossible to process constructor argument Parameter #0 [ Magento\Framework\Search\Adapter\Mysql\Mapper $mapper ] of Amasty\Shopby\Model\Search\Adapter\Mysql\...
0
votes
0answers
27 views
Catalog product and Stock index Error
I am getting this strange error while reindex, and I cannot find any solution on google or on stackoverflow.
Stock index exception: SQLSTATE[42S01]: Base table or view already
exists: 1050 Table './...
0
votes
0answers
15 views
How to check the result of temp and replica table in Magento 2 indexing
I have running indexer index command in Magento 2 for 60 million products.
But when i check in back end after 2 days it will show processing catalog_category_product and when i have go to error log ...
0
votes
2answers
30 views
Address Options > Number of Lines in a Street Address
I am experiencing a problem in my magento 2 store.
I cannot set the line quantity in Settings> Client Configuration> Name and Address Options> Number of Lines in Address
I can put any value 1,...
0
votes
0answers
13 views
Search for a deleted table's reference id in all tables, rows and columns of a DB
I had copied the table structure of table 'url_rewrite' and created a new table named 'url_rewrite_new' with empty data in my Magento 2 store DB, also renamed the 'url_rewrite' table. Then I ran ...
0
votes
0answers
14 views
Save config.xml value on install/upgrade
I have just created system.xml and config.xml for my project - they work ok after implementation:
The values don't get written to the database unless I press save in admin though - ran setup:upgrade ...
0
votes
0answers
14 views
Magento database optimization slow query
my website was getting internal 500 error intermediately, my hosting provider(siteground) told me that the magento database was running slow queries ( 80 in the past 24 hours), which cause spikes on ...
0
votes
2answers
21 views
How can we import db in magento2 cloud project
I want to import SQL file in cloud project magento2.
by ssh i login and import db then i am getting mysql server gone away after little time later.
0
votes
3answers
43 views
Get reviews by SKU and id using SQL query in Magento 2?
I want a SQL query to get product reviews by SKU using Magento2 for example,
It should contain,
SKU,id,title,discription,name
Please help me someone for the same.
since I am new to Magento 2.
0
votes
1answer
25 views
Setup:upgrade error. Base table or view not found
Any ideas how to resolve below error please?
Installing schema... Upgrading schema... SQLSTATE[42S02]: Base table or view not found: 1146 Table 'm2.email_template' doesn't exist, query was: SELECT ...
0
votes
0answers
17 views
Magento Cloud DB Backup Related query
I know this is not right question to ask here but still want to discuss here.
Anyone know how to request DB backup of olddays from magento cloud support team. They are saying that magento cloud ...
0
votes
1answer
36 views
When I am trying to run setup:upgrade its always gives below error,
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE 446 ...
1
vote
1answer
34 views
How to create table database and data saving into the table in Magento 2 [closed]
I want to add a table into the database and get input from a custom form
0
votes
1answer
23 views
Possible to using SQL query to get last 30 minutes created account from Magento?
Possible using SQL query to get last 30 minutes created customer account from Magento? I want to run a cron job that it can get the last 30 minutes created customer account id. so base on ID, I can ...
0
votes
1answer
15 views
Data Migration Tool with splitted database
I would like to migrate data from my Magento 1 website to the new Magento 2 one.
In the Magento 2 instance, I've splitted the database for performance reasons (https://devdocs.magento.com/guides/v2.4/...
0
votes
1answer
54 views
Failed to read auto-increment value from storage engine catalog_product_entity_varchar
Can't add a new product and get an error.
SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine, query was: INSERT IGNORE INTO catalog_product_entity_varchar (...
0
votes
0answers
14 views
SQLSTATE[42S02] at Admin Login
Using Magento 2.3.3. happy_mage300 database in phpmyadmin
There has been an error processing your request
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'happy_mage300....
0
votes
1answer
11 views
Fetch data and arrange sequence in given format
This is my array:
<?php
$sku = ['HH017','HH018','HH005','HH010','20OZHHTUMBLER',
'30OZTUMBLER2','HH006','HH-05'];
$sequence = ['HH005','HH010','HH006','20OZHHTUMBLER',...];
print_r(sort($...
