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.

1
vote
1answer
428 views

Magento 2 MySQL server has gone away

I managed to migrate magento 1 to new magento 2.2.5 When I reindex for the first time I get in indexer Category Products [2019-02-07 21:58:57] main.CRITICAL: Warning: PDOStatement::execute(): ...
1
vote
1answer
37 views

Generate Magento 2 Product Feed with MySQL Query

I hope you all having a nice day. I am wondering is it possible to generate below feed with SQL on Magento 2 Database? I want to run this query from Google Apps scripts using jdbc:mysql. Expected ...
0
votes
1answer
16 views

Can a product's attribute store several values for the same product or do I have to do something else (Magento 1.9)?

I will explain with general terms the situation: I have some products which should have 1-8 values for the same attribute and in the same product. For example: SKU 55720, Name of Attribute: Norm, ...
0
votes
2answers
102 views

cannot connect to mysql on remote server

I am trying to migrate data from magento 1 to maganto 2. Both sites are on different server. So when I try to migrate by below command : sudo php /var/www/m2.gocleaning.nl/bin/magento migrate:...
0
votes
2answers
236 views

magento 2.2 trying to save multi select value in database

I am trying to save multi select value in DB. But getting error Array to string conversion in /var/www/html/devstore/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php on line 2999 Template file ...
0
votes
0answers
10 views

UPS Zip Code is not being instered into databse after checkout in magento 1.9

I am newer in Magento version 1.9. When I do "Proceed to checkout" then I insert UPS account number and UPS billing zip code, after placing order the value of UPS account is being stored into DB(table:...
0
votes
1answer
130 views

Problems with Elasticsearch install Ubuntu

I have installed on my Magento 2.3 server and an annotation has arrived for me to install Elasticsearch. This is my system: Ubuntu 18.04 Nginx 1.14.0 MySQL 5.7.25 I have followed these instructions: ...
2
votes
1answer
1k views

Deprecation Notice - Elasticsearch - Magento 2.3.0

I have installed version 2.3.0 of Magento and I have received this notification: Deprecation Notice Catalog Search is currently configured to use the MySQL engine, which has been deprecated. ...
0
votes
0answers
36 views

SQLSTATE[42000]: Syntax error or access violation: 1064. SQL Review Error

This error keeps appearing whenever I try to view a product. Everything else works, only problem occurs when trying to open a product page. Anyone have some sort of idea of how this can be fixed as ...
0
votes
1answer
47 views

Data Migration Error related to CREATE TRIGGER

i'm getting the error when i try to run data step for the data migration tool. The extension "codisto" has been uninstalled while ago. Please advise [Zend_Db_Statement_Exception] SQLSTATE[42000]: ...
0
votes
1answer
252 views

Magento 2: foreign key for catalog_product_entity

Good evening. I am trying to create new table (product_store): <?php /** * @author Convert Team * @copyright Copyright (c) Convert (http://www.convert.no/) */ namespace Convert\...
0
votes
0answers
28 views

Merge 2 magento stores databases

I have a running store on magento 1.9x and we want to do a redesign, so we bought a theme without reading the comments about the issues https://themeforest.net/item/printshop-responsive-magento-...
1
vote
1answer
23 views

Stock status is not changing on backend/frontend after I change it directly in the database

I made a script that updates the stock status in database. I change them in the table named "cataloginventory_stock_status", but the changes doesn't appear on backend when I search for products by id. ...
0
votes
1answer
36 views

In Magento 2 will new sales overwrite migrated sales orders?

I'm currently migrating an existing Magento 1 site to Magento 2 and I wondered how the sales number would behave after migrating data. We’ve migrated all of our existing sales data from our Magento 1 ...
0
votes
1answer
299 views

Database Storage and catalog:images:resize

Newly uploaded images are not appearing on the Magento Front End when using Database as the media storage mechanism, in Magento CE 2.3. I have tried almost everything, including cache clean, flush, ...
1
vote
1answer
110 views

Change attribute from text to dropdown

How can I convert a product attribute type from Text to Dropdown in Magento? I already have attribute values assigned to many products, so don't want to lose these in the process.
0
votes
0answers
39 views

I am not getting all the products after executing my query

After executing my query i got several products (SKUs) but it is not displaying all the products that are stored in the database. Take a look at this picture: How do i know that? Well, I put a ...
0
votes
0answers
35 views

Bundle items are missing from sales_flat_order_item table. Magento 1.9

I wonder if somebody faced the same issue or knows what can cause this. For some reason, all bundle items are missing from sales_flat_order_item table, so I can't get the parent item. From old db ...
0
votes
1answer
31 views

Trying to obtain the “real” value (not the id) MAGENTO database -sql

I dont know why i am not getting what i want after executing my query AND i was not able to find an attribute. Let me explain everything: First off, i wanted to get all the products that had these ...
0
votes
1answer
132 views

Delete Multiple Tax Rates in Magento 2

I have a number of redundant Tax rates (539 when I only need 269) in Magento 2.2.7 and I'd like to remove them. Is there a way to do this that doesn't involve going into each one and clicking the "...
0
votes
1answer
56 views

Magento 2 - Add a new product attribute with values from DB

I'm looking for creating a custom attribute for products, already have a CRUD module, with name and descriptions fields, so the names from my DB should be options of that attribute. How do I need to ...
0
votes
0answers
54 views

Can we delete stores and orders before delta migration

We have a multistore site for which data is migrated from Magento 1 to Magento 2. We need to clean the database for some stores which are not active now. As the stores that we want to delete are not ...
0
votes
1answer
232 views

How to clean up magento2 database programatically?

How can I delete all test data from magento2 database programatically. Is there is any way to run an API and delete all test data?
0
votes
1answer
42 views

How to load database table records into the Magento CMS page

We have created a form using Magento CMS page. As you know, Form has many fields like Name, Email, etc. In our form, we have an input field called School. We have a list of schools in the database. ...
0
votes
1answer
23 views

Can't add items to cart in Magento 1.7

I'm working on migrating my site over to a new server and everything is up and running, except when I go to add an item into stock it doesn't work. I am not getting a Magento error nor is it ...
0
votes
1answer
155 views

Magento 2.2.2 error: The configuration file has changed. Run app:config:import or setup:upgrade command to synchronize configuration

I am getting this error when attempting to install Magento locally: The configuration file has changed. Run app:config:import or setup:upgrade command to synchronize configuration. When running "...
0
votes
1answer
151 views

Migration tool causing url_rewrite duplicates in Magento 2 leading to missing categories in Navigation

I am currently attempting to Migrate data from Magento 1 to Magento 2. I ran the Ubertheme Magento "Data Migration Pro" tool several times in the course of trying to Migrate our information over from ...
0
votes
0answers
12 views

Magento 2 how to create html with database conditions if else app\code\Emipro\Custompayment\view\frontend\web\template\payment\custompayment.html file

I get system config value on custompayment.html. Now i want to create html radio box according config value status . For example payment_first==1 then radio box show otherwise not show. this ...
1
vote
2answers
234 views

error on running raw sql query in upgradeData.php magento 2

I have created my own module and in UpgradeData.php script I am writing my own, mysql query but it gives me an error when I run bin/magento setup:upgrade to run the setup script files Recoverable ...
0
votes
0answers
130 views

Serialization failure: 1213 Deadlock found when trying to get lock; Try restarting transaction

I am using Magento 2.2.7 , and I am trying to add product by using API. After running process, I got error like: And whatever product was added it is also delete automatically. I tried with ...
1
vote
0answers
37 views

Modifying a query (get products using SQL only)

I am trying without success to obtain all products from MAGENTO database. (SQL only) After a few attempts i got this query (it is not working properly because it shows empty rows after executing it): ...
0
votes
1answer
20 views

Magento2 count # of customers purchasing for first time

I have a magento 2.2.5 based website and what I want to do is for the current month count the number of people who were logged in as a customer and made a purchase for the first time (first time ...
0
votes
0answers
125 views

Column not found: 1054 Unknown column 'tier_price_1.percentage_value' error before magento migration

I am done my magento migration but then I show one error while indexing : unknow collum percentage_value And error is Column not found: 1054 Unknown column 'tier_price_1.percentage_value' in '...
0
votes
0answers
16 views

Orders are not inserted in the sales_flat_order and sales_flat_invoice tables Magento 1.9

My website is already in production mode and worked fine for many days. Till last week everything is working fine. Suddenly, from 5 days orders are not showing up in the backend. When I checked the ...
0
votes
1answer
114 views

Magento 2 Reindex overwriting database Tier_Price changes

Could someone explain to me why whenever I perform a reindex on my magento website any changes I have made within the catalog_product_index_price table get overwritten. I have created a module that ...
0
votes
1answer
36 views

how to enable disabled products via query?

Hi I want to enable all products I have in my Magento 2 store, is there any query to enable all products we have using a single sql query ? Thanks
0
votes
0answers
23 views

Changed order number, but storeview gets wrong number

I changed my order number with a prefix for all my store views. For example, i have the following construction: Web Site 1 > Store 1 > Store view 1 Web Site 1 > Store 1 > Store view 2 Web Site 2 > ...
0
votes
0answers
36 views

Magento 2 Checkout onepage how to create a custom step and save its value

In Magento 2.2.6 I am created the custom checkout step but its value is not saved in the order (database) I am take a reference into the following link: https://packagist.org/packages/sbodak/...
0
votes
1answer
45 views

Magento Open Source 2.3 / 2.2 - How many orders / inventary and SKU it can handle?

I'm about to start a project, But my concerned is on the data, the magento 2.2/2.3 can handle. The traffic figures are in 1 Million to 5 million and we are not interested in Enterprise model as of ...
0
votes
0answers
27 views

Magento 2.1 File system code Backup Not Working

database and media file backup is working with my store. But when I try to get system backup following error occurs. Both in terminal and Admin panel. I have run the following command to get the code ...
0
votes
0answers
35 views

M2: Should I make a generic “My Company” module?

My question is a process question. I want to use Magento 2 best practices and I haven't seen any guidance in this regard. A lot of what I read is "how" to do something and not whether it's a good idea....
0
votes
1answer
61 views

Import Magento1 admin users to Magento2

I have done data migration using data migration tool from magento 1.9.x to 2.2.4, but it doesn't import admin users as mentioned in the docs, and we need to manually copy the admin users. What I have ...
0
votes
1answer
39 views

Increase Product Price by specific amount for all Products - Magento 1.9

I am running Magento version 1.9.3.4 with PHP 5.6.40 for my store and it has around 5000 products. So I need to increase the product price by Rs.1000 for all products. I just added below custom code ...
0
votes
2answers
254 views

Where is “status” located in the database from Magento 2 order grid

I want to change all the orders that are in the status of "Processing" to "Complete" state. I managed to find this in the sales_order table and set the state and status to complete. This worked fine ...
0
votes
0answers
73 views

How to resolve “Incorrect table definition” on Magento?

I want to restore my Magento database back up, but I get below error message: ERROR 1293 (HY000) at line 68: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP ...
0
votes
0answers
18 views

Magento 2: What is the best practice of storing and retrieving custom data

Looking for some input on what the best practice would be to store and retrieve custom data. As an example, I need to store, retrieve and update a couple of custom variables: access_token and ...
0
votes
0answers
36 views

How to perform a database rollback in Magento 1?

I added an install script to my extension which added a attribute to some tables. wr_epo\app\code\local\WR\EPO\sql\wr_epo_sales_setup\upgrade-1.0.0.12-1.0.0.13.php <?php /** * @var ...
1
vote
1answer
147 views

Magento 2 : Please upgrade your database while database is newer than required

I am getting this error when moving Magento 2 website to Google Cloud (Click to Deploy). I have merged theme files and media files and it worked fine. When I have connected to my old database it ...
0
votes
1answer
225 views

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row

After created a shopping cart rule for grouped product I got that catalog_product_attribute indexer needs reindex. When I tried to reindex from console I got: Product Attributes index process ...
0
votes
1answer
71 views

Magento 2 - Enabling Flat Catalog causes SQL error. Reading from “report” tables

When I enable the flat catalog in my Magento 2.2.5 installation, I get an error. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.name' in 'field list', query was: SELECT COUNT(...