Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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
12 views

Syntax error or access violation: 1118 Row size too large Reindexing

I am facing : SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, ...
0
votes
0answers
16 views

problem with 'ABSOLUTE_MIN_PASSWORD_LENGTH' - Magento 1.9.4.3

After upgrading Magento to 1.9.4, I have this issue when logging in the website (as a customer). Fatal error: Undefined class constant 'ABSOLUTE_MIN_PASSWORD_LENGTH' in /home/..../public_html/...
0
votes
0answers
13 views

Category not being updates for products

I currently have a cronjob plugin running in the background of my magento 2 installation which imports products from an XML file to the db. The code checks if the product exists, and if it does it ...
0
votes
1answer
29 views

Magento 1.9: Get Product details for a Customer Order

I am trying to get the product_id of each orders that the customer has ordered. One simple way is to fetch all the orders, and for each order have a loop to get all items for each order. Which will ...
0
votes
2answers
29 views

Magento 2 : Automatically rating for product has image

Automatically add four stars on the results page, products page, for all products that do have an image. (Use the database direct to update the stars for the SKUs that have image_count = true) Use ...
0
votes
0answers
13 views

How to fix 'Magento_Store' data-version not available and duplicated entry?

I'm receiving some error messages related to the Magento_Store module when I try to run the downgrade version via Magerun and when I try to change it too, as you can see in these images below. I ...
3
votes
1answer
48 views

How to rename an existing custom table in Magento 2?

I created a table with name "Redeem_blanace" using InstallSchema.php as: class InstallSchema implements InstallSchemaInterface { /** * {@inheritdoc} * @SuppressWarnings(PHPMD....
0
votes
2answers
32 views

Unique constraint violation found after upgrading to Magento 2.3.3

I just recently upgraded from Magento 2.3 to Magento 2.3.3 and whenever I'm trying to run php bin/magento setup:upgrade SSH command it just stick on Unique constraint violation found. Any idea how do ...
1
vote
0answers
18 views

get checkout value for new field Magento 2

I have created a field in Frontend which is a datepicker. I have used a plugin <type name="Magento\Checkout\Block\Checkout\LayoutProcessor"> <plugin name="date_picker" type="Module_Name\...
0
votes
0answers
37 views

Empty additional_attributes Table Magento 2

Please, can someone let me know how I can empty the additional_attributes for all of the products on my site? Due to some import issue, wrong information has been imported and when I exported CSV it ...
0
votes
0answers
12 views

DB script for search and replace a word from entire database

I want to make a DB script for my Magento 2 site. I want it to search a specific word and replace it from another.I have seen other links that show how to replace but those are the queries. I need a ...
0
votes
0answers
10 views

Magento 2 : What tables should be created to make product price Store-view wise? [ Multi Storeview Pricing ]

I want to create functionality like product prices can be set at the store-view level for that I've added one more option as Storeview in a configuration for Stores > Config > Catalog > Catalog > ...
1
vote
1answer
23 views

Sales order vs sales order grid

What is the difference between these two dB tables? I can see for the data, the sales_order_grid appears to be a subset of sales_order. Is this true? What is the purpose of having duplicate tables (I ...
1
vote
0answers
12 views

Unable to create duplicate product in Magento 1.9

I have tried to create a product using the duplicate product in Magento 1.9.3.1. It gives an error as follow
0
votes
2answers
20 views

How to update product name for main website and all store

I am updating the product name and it only affects the En store view I want to update product name for all store views and main website as well. see the sample code below $sku = 'E20630'; $...
1
vote
0answers
50 views

How to set the value of checkbox in gift_message to the database

I have added a custom checkbox to my magneto cart page for gift message. I want to add value 1 to the gift_message table's "remove_tag" column (which i added) if the checkbox is checked. How can i ...
0
votes
1answer
22 views

How does sales_quote and sales_quote_adress table relate?

In the sales_flat_quote table, there is a store_id column. In my perspective the customer order in the front-end (website) and in the back-end, Magento creates each quote for different stores, if my ...
0
votes
0answers
16 views

Magento 2 : How connect Magento with Neo4j Graphical Database

Does any one know how to connect Magento 2 with Neo4j Graphical Database ? There is a PHP client library (composer require graphaware/neo4j-php-client:^4.0) which i have updated in Magento project, ...
0
votes
0answers
8 views

Magento 2.3 mysql version from 5.6 to 5.5 [duplicate]

I know this is an old question but I couldn't find any solution to it. Currently i am having issues with mysql version on my server. i have mysql 5.5 but magento 2.3 requires 5.6. Is there a way to ...
0
votes
1answer
27 views

Unable to find Multi Store Links in magento 2.3

I am new to Magento. I have installed FreeGo theme in my Magento 2.3.x and I've created Multi Stores in Admin Panel but how can I view them? I am unable to find links to view them. Not in the footer, ...
1
vote
1answer
29 views

Magento 2: MySQL Issues

When using Magento2 backend, I’m running into a lot of timeout errors (from cloudflare and from nginx (when cloudflare is disabled) ). These timeout errors happen when i'm trying to insert / update a ...
0
votes
1answer
26 views

Magento 2.3 Mysql Showing Upgrade Compilation Error

When i run php bin/magento setup:upgrade in cmd, then i'm getting this error. anyone can help me, why this error is showing ? website is working fine but i want to fix this error. Plz help if someone ...
0
votes
0answers
26 views

Upgrading Magento 2.2.9 to 2.3.2 missing email_abandoned_cart mysql table

I recently installed a new Magento that was originally 2.2.2 . However the theme i am using then just came out with a updated theme for 2.3.2 so I uploaded that one and upgraded my Magento to 2.3.2 ...
0
votes
0answers
8 views

BSS MultipleStoreViewPricing enbled error

we have a problem after install BSS MultipleStoreViewPricing module ,we trying to enable the extension Stores then Configuration then Catalog.Store View to enable the module. Save Config the problem ...
0
votes
0answers
13 views

BSS MultipleStoreViewPricing error [duplicate]

Dears, I have a problem in Magento 2.3.2 . - BSS MultipleStoreViewPricing Module It shows error I run the below command php bin/magento setup:upgrade Please check attached screenshot of error enter ...
0
votes
0answers
6 views

Constraint “quote_to_store” references exception table in magento 2

After importing database I am getting Exception #0 (Magento\Framework\Exception\InputException): Constraint "quote_to_store" references table that does not exist. unfortunately, no answer found ...
0
votes
1answer
17 views

How to list unused attributes options by sql query

I would like to list all attributes options that our products don't uses. I prefer to use SQL to do that to learn how to work with. Right now i use this query to get the ID of my attributs select * ...
0
votes
0answers
39 views

Magento 2 : How to retrieve 'custom quote params' from quote object after order placed

I want to retrieve custom params saved in the table: "quote_item_option" I have built an observer to capture the purchase event and also to retrieve the quote object i.e public function execute(\...
0
votes
1answer
29 views

How to get data from custom table without using object manager

I want to insert data in custom table "outofstockproductnotification". But before insert data, I want to check if some data like email id and product id is already exist or not in my custom table. I ...
0
votes
0answers
24 views

Assoicated Products relation with Main Products, SQL Query

Our magento store products have three drop downs like color, size & weight. The price of main product changes when we select from size or weight etc. Stuck to run a query to get assoicated ...
2
votes
7answers
96 views

Magento 2.1.3 Extremely High MySQL CPU Usage

We recently started having big issues with our website slowing down quite often due to maxed out CPU usage (MySQL process using 200% CPU). The CPU usage is constantly at 60-85% and maxes out multiple ...
0
votes
1answer
24 views

Certs-Buzz and Magento Certified Developer Exam Training Material

I'm attempting to take the test for the Magento Certified Developer. I wonder if the appropriate responses given to each address are dependable? Since when I resulted in these present ...
1
vote
1answer
17 views

How to programmatically set description in simple associated products?

I need set description in all associated products of specific configurable product and with this code all it's ok except part of code where I insert description in associated products on database. ...
0
votes
2answers
33 views

Why product collection model don't show real Sql query?

I want to understand how M2 loads products EAV attributes, so I wrote the following code: $productCollection = $this->productCollection->addFilter('entity_id', 7) ->...
0
votes
1answer
32 views

Magento 2.2 - MySql slow Queries issue

I am new in Magento 2.2 and facing MySql slow queries issue.I want to know how to use/install MySqltuner in Magento 2. And where is the location of my.cnf file? Need help to fix this issue. Thanks
2
votes
0answers
30 views

Magento 2 Catalog search results are not correct?

I have migrated data from magento 1 to magento 2. I am searching product name: 4.0ct Round Morganite Diamond Engagement Ring Bridal Set 14k White Gold then it is showing lots of products on result ...
2
votes
0answers
37 views

Magento 2.3.2 : How to clear magento database after testing

I am currently doing a lot of tests in Magento so I can get familiar with it. Unfortunately the database is extremely cluttered with my tests. I wish to clear up the database so I can start over again....
1
vote
0answers
25 views

Magento 2.3.1 Frontend stock not correct after sql update

I'm updating stock via SQL update along the lines of below website https://www.danjoseph.me/2017/01/12/magento-2-database-level-inventory-management/ The price and qty is updated and visible in ...
0
votes
1answer
21 views

Magento 1 sub domain Redirect issue

Just copy original domain files and DATABASE to Sub-domain and change Base-URL every links is working prefect but only few products, category, and images slide show links redirect to original main ...
2
votes
1answer
56 views

Magento 1.9 Mysql Query to pull out data

I am kind of stuck getting data from magento 1.9. The solution i needed is mysql query so that I can collect all data in one table. The values in table i needed from different table are product id, ...
1
vote
0answers
49 views

Using Magento 2.3.2 with MySQL 8.0: Which problems could arise?

According to the DevDocs only MySQL 5.6 and 5.7 is supported. I have set up a shop now with MySQL 8.0 and it seems to work so far. However, it is not a fresh installation, instead I dumped the ...
1
vote
1answer
67 views

Bulk updating product prices : Magento 2

In my M2 store I have over 200k products. They were added manually through API (https://domain.com/rest/all/V1/products call). Nowadays prices of my products are changing frequently and I need to ...
0
votes
1answer
98 views

Magento 2.3: Delete Product Attribute SET and Delete all categories through Database Query

I want to delete all custom attribute sets, I'm facing an issue when I'm deleting attribute set manually then 404 error is showing in Magento 2.3 and can i delete all categories with 1 database query ...
0
votes
0answers
34 views

Magento 2 : Create a module for hiding custom options of a product when checked using checkbox

To create a module for magento that adds a checkbox for the values rows in the “Customizable Options” section on the product page in magento backend. This checkbox will hide the customizable option ...
1
vote
0answers
20 views

Database Resources setup in local.xml + magento1.9

I want to setup default_setup and default_read as different databases for both in Magento 1.9. Now the thing is there is something wrong with default_setup DB but default_read DB is proper so homepage ...
1
vote
1answer
41 views

Magento 2.2.2 to Magento 2.3.2 - setup:upgrade error

After being able to update magento to 2.3.2 Which is in current state when I try to run the command bin/magento setup:upgrade: get the below error root@---:/var/www/html# bin/magento setup:upgrade ...
0
votes
2answers
40 views

Magento 2.3: get latest post from table

I have a simple post table, how can I get lasted post in the phtml file.
0
votes
0answers
29 views

Products with tier prices cannot be updated

I run magento 2.3.0 and have the following problem. I have several configurable products in magento store. Under the configurable products i have created simple products with tier prices. When i ...
1
vote
1answer
37 views

Magento 2 load dynamic values to select field in XML

i am new in Magento development. I am trying to create a new module for adding dynamic fields for product edit page. Now I was able to add the fields in admin's product edit page. now I want to show ...
0
votes
0answers
12 views

How to restore images of deleted products via sql?

I am using magento 2.2 version , I was deleting few products from admin dashboard , at the time of deleting my site crashed due to server issue and because of that when site goes up I see that 8 ...