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
0
votes
0answers
12 views

What is the most popular database choice for Magento 2?

this question sounds more like a poll because I'm just curious as to what database is the most commonly used for Magento2. I currently use MariaDB 10 from following an installation tutorial online, ...
0
votes
0answers
8 views

Magento2 - Mysql to duplicate product attribute

Is it possible to via sql duplicate a product attribute and give the newly created one a different attribute code and label? Otherwise have it be a 100% duplicate . I have a ton of attributes I need ...
0
votes
1answer
17 views

How to properly replace database in Magento 2?

I want to connect my Magento 2 to a new database, I've updated the /app/etc/env.php What other steps do I need to take
0
votes
0answers
8 views

Why is admin user's password stored in two tables?

The password of an admin user is stored in table admin_user (column password) and admin_password (column password_hash). What is the reason for storing it twice? I don't understand why it is ...
0
votes
1answer
24 views

InstallScripts vs db_schema for new EAV attribute

I'm in the process of adding new fields to my registration page. I know that we're now supposed to use db_schema instead of InstallScripts, but how can I make sure that they're seen as customer ...
1
vote
0answers
12 views

How to change driver between amqp and db

We have an extension that can make use of either MySQL driver db or RabbitMQ amqp. The drive is mentioned on these files: etc/queue_consumer.xml etc/queue_publisher.xml etc/queue_topology.xml https:...
0
votes
1answer
13 views

Disabling Magento_CatalogStaging creates a staging duplicate query issue for a record that doesn't exist

I am attempting to disable Catalog Staging without starting over. I ran this command bin/magento mo:d Magento_CatalogStaging Magento_CatalogImportExportStaging Magento_BundleStaging ...
0
votes
1answer
9 views

Integration tests - error when connecting to the database

I'm having trouble running the magento2 integration tests. I followed the documentation and set up the database parameters in install-config-mysql.php : 'db-host' => 'mysql:3306', 'db-user' => ...
0
votes
0answers
8 views

Import Stock QTY from onsite Point of Sale - Method Question

I have a production online site that is running smoothly. I want to update stock QTY from my onsite store on a daily bases, around 10k SKUs. Now I am using shared hosting currently, that does not ...
0
votes
0answers
14 views

Database not creating tables for new extensions on bin/magento setup:upgrade. Declarative Schema is not up to date

I installed Magento 2.3 successfully, with custom style sheet and Mageplaza Blog ext which all works fine. I wanted to install a slider module and I have done this through ssh. Composer installs the ...
1
vote
0answers
22 views

How to save data in custom table onclick custom button from Customer Edit page Adminhtml? magento 2

Basically so far I have added a custom button(highlighted in image) on admin/customer/edit page. In order to add the custom button I have overridden \vendor\magento\module-customer\view\base\...
0
votes
3answers
71 views

Magento 2.2.6 disk space utilization - /var/lib/mysql/ folder is taking 43 gb

Due to some reason my magento 2 website (Magento ver. 2.2.6) taking too much space from the server . Yesterday there is 1.2 gb available now only 240mb available . Please help on this . Please see ...
0
votes
2answers
23 views

Can I keep my database and data from installation of Magento?

I know tables will be created during the installation of a new Magento application. But what if my database is not empty, will it skip this process during the installation? I want to use old database ...
0
votes
1answer
10 views

How to export multistore product data from DB?

My client wants to have a CSV file containing three columns, the product SKU, website ID (1 = CA, 2 = US) and the final price. How could I do it?
1
vote
1answer
23 views

cataloginventory_stock_item - errno: 150 Foreign key constrain is incorrectly formed

I'm tranfering my magento2 website locally. Importing website database gives me the following error: ERROR 1005 (HY000) at line 636351: Can't create table 'cataloginventory_stock_item' (errno: 150 "...
0
votes
0answers
20 views

Wishlist page layout Magento 2

How would I change the customer wishlist page layout? It's currently in grid, how would I make it a list? Thanks in advance.
0
votes
1answer
23 views

solution to invalidate private content?

Please help me, I want to know exactly how the Invalidate private content works? the solution to invalidate private content? example: when I add to cart in Magento 2, how to identify change data and ...
0
votes
1answer
29 views

Magento2 setup:upgrade Undefined index notice

Using the latest version of Magent2; 2.3.5 currently. When running the setup:upgrade query, we are hitting the below error: Notice: Undefined index: store in /siteurl/public/vendor/magento/framework/...
0
votes
0answers
5 views

Emojis in mail subject line without affecting the database

I'm using emojis in unicode format in my transaccional emails, this like #128588 (🙌) Everything looks good in Magento's backoffice, but the emojis are not being shown the right way in the ...
0
votes
0answers
12 views

Exporting database from local to server after data migration

I couldn't install the data migration tool on my server, so I decided to do it on the localhost. Everything works after migration, I got all the data I needed. My question is do I have to re-upload ...
0
votes
1answer
11 views

store logo not showing in transnational order email in magento 2

the store logo is not showing in order email which was showing and uploaded in the configuration -> design ->transnational email section
0
votes
0answers
17 views

MySQL - Magento categories export the right way - bottom level category path split and category ID value lookup

After some research I found that it's best to approach it like this: find the bottom level category for each product and return its path delimit the path into individual categories. That gives you ...
0
votes
0answers
24 views

Is there any solution to transfer a partitular category and there sub category from magento 2 to another magento 2

I need to transfer a particular categories of products to another Magento 2 site with all the attributes image and all
0
votes
0answers
25 views

Magento 2: Database Instllation Error

While installing database from cmd I am getting below error. Unable to apply data patch Magento\Msrp\Setup\Patch\Data\ChangeMsrpAttributeLabel for module Magento_Msrp. Original exception ...
0
votes
1answer
17 views

Magento Product Save Issues - Asymmetric Transaction Rollback

We have a Magento 2.3.2 CE instance running and it has been working for us for a while without issue. Recently our products stopped saving and instead starting throwing the Asymmetric transaction ...
0
votes
0answers
16 views

Magento 2 Missing Wishlist Tables

I am working with a Magento 2 database that is missing the 3 wishlist tables. wishlist wishlist_item wishlist_item_option Is there a mysql script I can run to create these tables? Thanks
0
votes
1answer
25 views

Error running setup:upgrade : Base table or view not found: 1146 Table 'db.inventory_low_stock_notification_configuration' doesn't exist

I'm using Magento 2.3.4 and i disabled all Magento 2 inventory extensions, when running php bin/magento setup:upgrade, i encountered this error: Schema creation/updates: SQLSTATE[42S02]: Base table ...
0
votes
0answers
21 views

Can I import customer data from another shopping cart to Magento

I have a client that has their site on Interspire (now BigCommerce) and Interspire Shopping cart has since then be deprecated. Is there any way I can set up a Magento site for them and import the ...
0
votes
0answers
22 views

Fails product import on Magento 2.3.x

I am creating new import module and I have issue with new created Product. Product doesn't want to create: In StockRegistry.php line 194: The Product with the "13.111.116" SKU doesn't exist. My ...
0
votes
0answers
9 views

Edit Review Section Not working in Admin Side Magento 2.3

I am facing issues in admin side Magento 2.3, when I click on edit review then showing completely blank screen even when I update status from pending to approved then I got (status update successfully)...
0
votes
0answers
5 views

Search on sales data rather than attributes using layered navigation

I am looking for a solution which will allow my users to search for skus based on sales data rather than product attributes using layered navigation (or something which looks similar). I sell ...
0
votes
1answer
37 views

Magento 2 function insertOnDuplicate()

How can we implement insert on duplicate update using non-primary key or non-key field using Magento's function insertOnDuplicate? Or is there any other way then please suggest.
0
votes
0answers
22 views

Magento 2 don't create Data base tables

I have 3 weeks trying to install by composer some modules but when i see the data base i cant found any data table of the module. I recibe different issues but always persist this kind of issue: 2 ...
0
votes
1answer
23 views

Magento 1.9: Get last row in getModel

So, most of the time I saw using getFirstItem and getLastItem used in case of collection. But I can't see any possible method to get the last item for ::getModel()) So, is there a possible way to ...
0
votes
0answers
13 views

private sql connection database

I'm using magento 2, I want to use a private sql connection with port when I try to add this code to my env.php, it does not work 'db' => [ 'table_prefix' => '', 'connection' => [ ...
0
votes
1answer
31 views

Moving from Hostgator Magento 1.9.3.3 to Digital Ocean Magento 1.9.4.4

I am trying to move away from a HostGator VPS to a Digital Ocean VPS and also upgrade my Magento version in the meantime. I have a very basic knowledge of VPS and the LAMP stack. So on Hostgator, I ...
0
votes
1answer
18 views

magneto sql unknown query

we are seeing this sql query in our DB and are unsure what is genereting this, we have flat catalog index enabled so it should not be asking for this sql query select `e`.*, if(at_visibility.value_id ...
0
votes
1answer
29 views

Triyng to filter products with value_id

Tried filtering with option_id and value_id but it is looking for value and when I change it to catalog_product_entity_int.value_id or at_manufacturer.value_id it returns syntax error. Trying to ...
0
votes
0answers
13 views

how to increase sku 64 symbols to be 255 symbols at magento 2.3.2

how to increase sku 64 symbols to be 255 symbols at magento 2.3.2 the below image https://i.imgur.com/MaWo0Qo.jpg i did this solution but still same issue any advice set "const SKU_MAX_LENGTH = ...
0
votes
1answer
14 views

Magento deployment process - DB Sync

I'm developing a Magento Store, I bought a custom theme and a lot of the theme content goes into the DB (eg. the content of the footer or menus). How should I proceed to deploy changes that I made ...
0
votes
0answers
36 views

Magento 2.3.4 cannot cancel order with coupon

I am having this issue in magento 2.3.4 instance. When a customer who has an account creates an order and a discount coupon is used you cannot cancel it if needed from admin. Error in exception: [...
0
votes
0answers
18 views

m2_cl tables are empty after migration

We just performed a migration from m1 to m2 and noticed the creation of m2_cl_* tables in the m1 database. From what I can gather, it seems thes tables are useful for delta migration. But our m2_cl_* ...
0
votes
2answers
21 views

delete export record from which table?

for some reason, I have to delete this record from the table, (it is stuck, cannot download or delete) anyone know this record belongs to which table? so I can delete it by sql query Thanks
0
votes
1answer
21 views

How set value for attribute?

I have this code: foreach ($skuScope as $sku) { $object = Mage::getModel('catalog/product'); $product = $object->loadByAttribute('sku', $sku); $attributes = $product->getAttributes(...
0
votes
0answers
23 views

Can't access phpmyadmin with credentials provided in /app/etc/local.xml

I can't access phpmyadmin on staging with the credentials provided in /app/etc/local.xml. Unauthorized This server could not verify that you are authorized to access the >document requested. ...
0
votes
0answers
19 views

Upgrade Magento 2.1 to Magento 2.3 on a new server import new orders from production

what is the list of data i need to manually export from my production site? after upgrading to magento 2.3 on new server and changing DNS info to go live on new server- the easiest solution i see is ...
0
votes
0answers
9 views

How to compare products metadata in database [Magento 2]

I'm creating configurable product by API. All is working fine and the simple/configurable products appears in the backend. However when I look at the frontend, only simple product are shown, not ...
0
votes
2answers
30 views

How to access Magento DB phpmyadmin

how can I access the Magento DB with phpMyAdmin? I'm learning programming and wrote everything on a local version of Magento 1.9.2.4, on the local version I entered localhost and could see the DB in ...
0
votes
2answers
23 views

Create an SQL script to find a simple product name with its configurable product SKU In Magento 2 [Magento 2]

Create an SQL script to find a simple product name with its configurable product SKU In Magento 2 [Magento 2] Anyone with a better solution than my one are appreciated. Please share your answer.
0
votes
1answer
15 views

Possible raw SQL statement detected. delete from $tableName WHERE sku = $productSku

the code is working well and doing it's job but pipeline on bitbuckets drops an error Possible raw SQL statement "delete from $tableName WHERE sku = $productSku " detected. my function where this ...

1
2 3 4 5
68