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
1answer
33 views

Emoji is saving as (???????) in the database Magento 2

I added the Emojo library including JS and CSS files. Then it starts to display on the frontend. When I send the Emoji character via ajax. I am getting Emoji in the param request so while saving the ...
1
vote
0answers
39 views

ERROR: We couldn't change indexer(s)' mode because of an error

I'm facing this error when trying to change indexer mode from 'UPDATE ON SAVE' to 'SCHEDULED' Edit: We have already checked the logs, and seems to be nothing there.
0
votes
2answers
29 views

Magento 2 - Creating a new store view throws error - Integrity constraint violation

I need to create a new store view, but I get this error: Integrity constraint violation: 1062 Duplicate entry 'studioline-4' for key 'URL_REWRITE_REQUEST_PATH_STORE_ID' I checked the database, but ...
1
vote
1answer
20 views

Magento 1: MySQL failing on flat catalog / locked tables

I'm running quite an old Magento 1.9.2 instance, for a couple of weeks, it's going offline periodically because of MySQL load. MySQL server CPU usage is going over 1000% (one thousand), all cores are ...
-3
votes
1answer
46 views

Database user does not have enough privileges While running Setup Upgrade command in Magento 2.3

I have freshly installed Magento 2.3.5p2 on the XAMPP server on Windows OS. It was working fine but then suddenly it's showing below the message. Database user does not have enough privileges. Please ...
0
votes
1answer
17 views

Magento 2 Admin - Base table or view not found

I have 5 different domains for a Magento 2 installation - 4 websites and 1 admin side. I got a spontaneous exception when I'm trying to get access to an admin login form by admin URL(it was ok before, ...
0
votes
1answer
12 views

Is there any way to get enabled and disabled simple product of configurable product in Magenoto 2?

Is there any way to get enabled and disabled simple product of configurable product in Magento 2. I need to get all id of enable and disabled product by using SQL query or object manager approach. Can ...
-1
votes
1answer
41 views

Is there a way to save value in core config data using Magento 2 using object manager?

Is there a way to save the value in core config data using object manager like I will get the value by using I will get the value by $objectManager = \Magento\Framework\App\ObjectManager::getInstance()...
0
votes
0answers
39 views

Magento 2 GraphQL How to update custom row

Using Magento 2.4.3 Graphql Able to get, insert and delete a row from the custom table but unable to update(edit) custom row... custom endpoints - mutation { updateCustomMedia(id:7, input: { ...
0
votes
1answer
12 views

Error on setup:install step 4

I am installing magento in clean database but it throws an error In StoreRepository.php line 112: The store that was ...
0
votes
1answer
18 views

error when doing setup install on clean database magento2

Here is an error that occurs when I run setup:install command on clean database magento2 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'clean.core_confi g_data' doesn't exist I added ...
1
vote
2answers
39 views

Add INDEX to Magento 2 tables?

My Sysadmin says there's some space for optimization of DB by adding INDEX to some tables. Namely: catalog_product_entity catalog_product_entity_varchar Has anybody tried this before? Any guidance on ...
0
votes
1answer
26 views

Class Demo\Helloworld\Controller\Post\index\Interceptor does not exist

I am trying to get data from a database table, my code of Index.php <?php namespace Demo\Helloworld\Controller\Post; class Index extends \Magento\Framework\App\Action\Action { protected $...
0
votes
1answer
23 views

PHP Array Unique on exploded Keywords from MySQL problem

I'm trying to echo keywords from a MySQL database, separated by colon, and remove (don't show) duplicates. This is what I got. Keywords in DB Love:Sorrow:Death Happiness:Love:Excitement Excitement:...
0
votes
1answer
32 views

Magento 2.4 Error during upgrade: Schema binary is not declared

When I run the setup:upgrade command I get the following error: Cache cleared successfully Schema creation/updates: Types binary is not declared The front end seems to work fine. I also found binary ...
0
votes
1answer
22 views

Magento 2.4.2 - reporting_system_updates table contain large data

I want to optimize the reporting_system_updates table in my database it is already over 5GB of data. Can I safely truncate/delete this table? If so then anything will happen with my Magento setup? ...
0
votes
0answers
10 views

Missing Sequence in DB

We have a multistore setup and we just added 2 new stores store_13 and Store_Id 14. Store_Id 13 had some issues, we are not able to create an order in the system and when I had a look, it was missing ...
0
votes
2answers
25 views

M2.3.2 - Search not working

I am using Magento 2.3.2, but sometimes the default search bar does not work MySQL engine for the catalog search. For example, I have a product called "Test product for Toyota". When I ...
0
votes
0answers
10 views

Magento 2 How to create new order attribute which save value from input to DB

How to add custom input field and save btn in order viev tab and then save it in my custom row in sales_order->custom_order_attribute
0
votes
1answer
14 views

Magento Cloud space error

I have a Magento Cloud instance with 50GB of space, but my Magento is running out of DB space, how is that possible?
0
votes
3answers
39 views

How to Print Raw SQL query of Magento 2 format?

I am trying to print the raw SQL query of the below statement in Magento2 but am not able to do it. please find the statement $connection = $this->getConnection(); // I am getting the connection $...
0
votes
0answers
7 views

Getting access of records in db, SQL file size is 18+GB while export

I have exported my database in SQL file using the MySQLDump command from the SSH terminal. My store contains the data as below: No. of products below 40,000. No. of customer below 3000. No. of ...
0
votes
0answers
23 views

Magento 2: How do I get the tables that contains data of Categories, Products, Customers, Orders, Product Reviews Product Attributes and its values?

I want to export the tables that contain the data of Categories, Products, Customers, Orders, Product Attributes and its values (along with the custom attributes) Product Reviews from my Magento 2 ...
0
votes
1answer
16 views

Does Magento execute a query to get the review count of each single product on the category listing page?

Let's say that your category page shows 36 products at a time and shows the rating/review count underneath each product title. Does Magento perform 36 queries to get each of the product's review ...
1
vote
2answers
34 views

Delete all images in pub/media/catalog/product not linked to any product

I am facing a website wich media directory size is 88 GB, and that is getting problems with the server and some processes. After analyzing the product date, I determined that in this directory exists ...
1
vote
1answer
32 views

Magento 2: setup:upgrade error with customer_grid_flat index

I tried to run setup:upgrade command from Magento source but it's always get error: SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column 'created_in' used in key specification ...
0
votes
3answers
114 views

Price on product detail page changed to 0.00 magento 2.4.3-p1

I'm facing a weird issue with the product detail page on magento 2.4.3. The product price will be shown while loading the page and changed to 0.000 once the page is loaded completely. The price is ...
0
votes
0answers
8 views

db_schema.xml : (Insert value list does not match column list) How to 'ignore' destination table columns when migrating (upgrading) tables

Question How do I configure db_schema.xml to ignore columns inside the destination table when 'upgrading/renaming' a table? Information The module has been refactored and rebuilt with a few more ...
0
votes
1answer
20 views

Magento 2 - create a table with foreign key constraint

I try to add this database table. It has a foreign key constraint to the customer_entity table. I need to configure it so if the customer is getting deleted that record is also getting deleted. This ...
0
votes
1answer
17 views

Magento 2 - store bank payment data

We have a debit payment method where the user has to enter some data like his name, IBAN, BIC and the name of the bank. I need to store these pieces of information in our database and automatically ...
0
votes
0answers
18 views

SQL error on Database Import, while setting up staging site

I have been trying to import a database to clone a production site that is working and I am receiving this error when trying to import the database. Error Static analysis: 2 errors were found during ...
0
votes
0answers
23 views

Magento 2.1 - Unable to execute SSH commands

I want to upgrade my Magento 2.1 store but I can't lunch any SSH command, this is the output: php bin/magento cache:flush Array ( [name] => envBatchSize [value] => Magento\Framework\DB\...
0
votes
3answers
24 views

Magneto2: Base table or view not found table amasty_conf_group_attr doesn't exist

The changes made in products attributes doesn't show on the frontend. The part of the database won't update and shows the following message. "Base table or view not found table ...
0
votes
0answers
13 views

How to move my magento 2 aws lightsail db to aws rds db?

<?php return [ 'backend' => [ 'frontName' => 'admin' ], 'remote_storage' => [ 'driver' => 'file' ], 'queue' => [ '...
0
votes
0answers
10 views

How can I create a link which load another url?

I want to create link which load another url with filter without redirect. I added this records in url_rewrite table directly in MySQL entity_type : category entity_id : 4 request_path: computers-...
0
votes
0answers
23 views

Data truncation error 1406 - Data too long for column 'value'

Magento 2.4.3 - i want to save configuration in backend, in section Sales->Shipping Methods. But get an Error Something went wrong while saving this configuration: SQLSTATE[22001]: String data, ...
0
votes
1answer
19 views

How to setup password to Magento Cloud database?

My Magento Cloud doesn't have any passwords. I checked it in my app/etc/env.php file, and when I ran this command below. php -r 'print_r(json_decode(base64_decode($_ENV["...
0
votes
0answers
10 views

I get Unknown column 'e_attr.store_id' in 'field list' when trying to edit or create new product

I get this error when try to add or edit product from admin: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e_attr.store_id' in 'field list', query was: SELECT `e_attr`.`store_id` FROM `...
0
votes
1answer
26 views

Magento 2 : Can We Add Data From Custom Module to Core Database?

If I want to insert form data in to the "customer_entity" table How can we achieve that? I have mentioned all fields in the form as "create an account", and rather than creating a ...
0
votes
0answers
11 views

Magento 2 update inventory programmatically using cron

I want to update the product inventory. Get inventory from another platform using cron once got inventory need to update in Magento but what is the best way to update some time I will get more than ...
0
votes
3answers
40 views

Is possible to change the ID of an attribute?

I have these attributes: id 199 = size id 200 = color id 210 = number id 220 = measure Those are used to create configurable items in the product view. Color is showing above number and measure, ...
0
votes
1answer
30 views

How to create mysql database table in magento 2

whats wrong in my install file? InstallSchema.php public function install(\Magento\Framework\Setup\SchemaSetupInterface $setup, \Magento\Framework\Setup\ModuleContextInterface $context) { $...
0
votes
1answer
27 views

Magento 2: Get all bundle products

So I have to create a report (SQL Script) which has all the bundle products and all its customizable options. I can get list of all the bundle products using this query. select entity_id, type_id, sku,...
0
votes
1answer
66 views

Magento 2 : Admin URL Redirects to Search Results Page

When I try going to the admin panel of my local environment of Magento 2.4 (Enterprise) (admin URL is http://{unsecure_domain}/admin) It redirects me to a secure previous domain as if I was doing a ...
1
vote
1answer
29 views

Assign orders to customers where the emails are matching with a SQL query

I want to reassign existing orders to customers after deleting all customers and importing them into Magento 2 from a csv. The sales_order.customer_id values are not matching with the correct customer ...
0
votes
1answer
15 views

How is the CSV file in table rate shipping parsed

In Magento 2, I want to know how the CSV file that we upload to table rate shipping parsed in code. For example, is it directly opened as a text stream and searched using PHP, or is it loaded to a ...
0
votes
1answer
77 views

Magento 2 high MySQL usage. Same query running over and over

Our Magento 2.3.5 has started to continually use 100% CPU and I found that the below query gets executed over and over for an unknown reason. Any information to what is generating the query would be ...
0
votes
0answers
11 views

Salable Quantity

I have been looking for the salable quantities of items on Magento Commerce. I did see it on Catalog -> Inventory -> Products, but I want to export the data to use it in Magento Business ...
0
votes
2answers
23 views

How to remove pending reviews directly in database

How can I remove all pending reviews in certain store view directly from database? What should I use as SQL query?
0
votes
0answers
15 views

Is it possible to set up redash on the same hardware as a magento instance?

I am trying to help a friend figure out if it’s possible, and look for any tips, on getting a redash server up and running on a machine running magento 1 (going to be migrates to 2). We have read the ...

1
2 3 4 5
72