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,158
questions
0
votes
1answer
24 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
12 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
41 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
29 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 ...
0
votes
0answers
17 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
9 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
22 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
47 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
15 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
23 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
2answers
28 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
92 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
29 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
29 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
24 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
54 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
42 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
91 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
33 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 ...
0
votes
0answers
19 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
40 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
36 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 ...
0
votes
1answer
23 views
Auto Cron is Not Working When I want to add Data into DataBase
Here Data Was Successfully Addded Into Database When i Run php bin\magento cron:run Command But AutoMatically Data Wasn't Added.
vendor\module_name\Cron\Test.php
use Psr\Log\LoggerInterface;
class ...
0
votes
1answer
49 views
InstallSchema not running even though module is not installed
I searched all over and don't see anyone with the same issue.
Below are steps I tried to solve this with no success
I deleted the module from setup_module table.
I don't see any errors in var/log/...
1
vote
0answers
26 views
EAV load collection issue (High Load Time)
We have an eCommerce platform. The issue is that when we increased the products to ~3000, the EAV:load_collection is taking a lot of time(~20 sec) and eventually slowing the site. If I remove the ...
0
votes
0answers
23 views
DB Error SQLSTATE[42S02]
SQLSTATE[42S02]: Base table or view not found: 1146 Table
'mavikmarine_l2li.m_catalog_product_flat_1_tmp_indexer' doesn't exist,
query was: UPDATE m_catalog_product_flat_1_tmp_indexer AS et
...
