Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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 ...

0
votes
0answers
3 views

UpgradeData.php Insert and Delete not working on Magento Cloud

I wrote a section in UpgradeData.php to insert and delete some values in tables directory_country_region_name and directory_country_region. Code below, if (version_compare($context->getVersion(), ...
0
votes
0answers
13 views

Magento 2 Unique constraint violation found when changing order status

After placing an order successfully in the backend we receive a "Unique constraint violation found" error when trying to change its status or cancelling it. I already looked into the system.log and ...
0
votes
0answers
15 views

error after moving magento mysql

I moved a magento1.9 mysql database to a AWS RDS and now when I go to the site it throws an error that says #4 /var/www/html/usa.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): ...
1
vote
0answers
20 views

Magento 2.2.5 - Categories and not getting saved in the database.

In my Magento 2.2.5 Store, When I try to edit the existing categories content and press the save button, the categories content stays the same, there is no change being reflected in the admin panel,...
2
votes
3answers
35 views

New table doesn't created

My install InstallSchema.php: app/code/Aty/TestTask/Setup/InstallSchema.php <?php namespace Aty\TestTask\Setup; use Magento\Framework\Setup\SchemaSetupInterface; use Magento\Framework\Setup\...
2
votes
3answers
117 views

Magento Development environment database setup

Our company is new at Magento development so we are still figuring out a good dev cycle. I read the guide that Magento provided. But still not sure on how to develop with a team (5-10 people). Our ...
0
votes
2answers
33 views

Moving Live database to a staging Server (M1)

I am moving my live database to a staging server in order to setup a development environment. I took two dumps of my live database structure without data dump data dump excluding the log tables ...
0
votes
1answer
25 views

Magento 2 - Admin module - how to SELECT data from database to display in Admin page

I'm building out an Admin module that's intended to SELECT data from a specific table in magento database and display that data on page, it's a custom table called "commission_sales". At this point I ...
0
votes
0answers
19 views

Product changes not appear in frontend

I have problem with my products in magento 1.9. I successfully imported products to shop, but when I made changes in backend, changes not appear in frontend. For example I change Base image or page ...
0
votes
1answer
22 views

AddIndex in magento2

What is the use of index in table creation in magento2 ->addIndex($installer->getIdxName('blog_comment', ['parent_id']), ['parent_id']) Thanks
1
vote
1answer
30 views

Magento 2 Order number increment

By default, in Magento 2 the order number starts from 100000001. But if I want to increase it by 55555. So it would look like 100055555, what would be the SQL query to directly modify the table ...
0
votes
0answers
15 views

Magento why getting a wrong downloadable product link

Can someone explain me why when I purchasing a download product I am receiving different download product ? Magento 2.2.6
0
votes
2answers
41 views

Magento 2 get database prefix on install data

How to get database table prefix on install data? It is showing "table or view not found". <?php namespace ...; use Magento\Eav\Setup\EavSetupFactory; use Magento\Framework\Setup\...
0
votes
1answer
19 views

Magento databse table copy gives error

I have an old and a new magento installation(same version). Both are using the same mysql user and password. I'm trying to copy a few tables from the old one to the new one(trough SSH - using Putty): ...
0
votes
1answer
19 views

Magento 1 and 2 SQL Select Count of picture of all SKUs?

We are in the final steps to migrate from 1 to 2. Now we found that some picture got lost. Is there a way to select all SKUs and their picture counts like: SKU Count 123 2 234 6 345 2 ...
2
votes
1answer
33 views

Magento 2.2.5 - Connect register.phtml to the database

At the moment I'm struggling with sending data through my register.phtml. The situation right now is, I've created a module that allows me to override the core register.phtml with my own custom ...
0
votes
1answer
14 views

Magento 1.9 Catalog Search result redirect the live website

I am trying to find where I did mistake when I search abc in catalog search tab. the link local.xyz.com/abc.html Redirect to www.xyz.com/abc.html. Don't know where I did mistake, I already changed the ...
1
vote
1answer
14 views

magento2 : copy sales_order table custom data to sales_order_grid

i want to add custome data when data adds in sales_order automatically it copied into sales_order_grid i have same name column in both table
1
vote
0answers
27 views

Admin_User_Session User_ID NULL

1,400 products were deleted fro my PROD Magento 2.2.1 community store. Looking at the admin_user_session table there is an entry at the time I suspect the mass deletion was executed. Is there an ...
0
votes
0answers
15 views

Magento Database Timestamp

my problem is as follows: A range of products were deleted from my PROD store (approximately 1,400). Original store approximately = 6,700 products Store after mass deletion approximately = 5,400 ...
0
votes
1answer
15 views

[Magento2.2.6]What is the purpose of tables which have tmp/replica/idx as a postfix?

I'm trying to insert queries in order to add products to our Magento website. I have no idea about these tables i mentioned at title like catalog_category_product_index_replica, ...
0
votes
0answers
18 views

Fresh Magento 2 vs my magento 2 website what can be the issue

Where can I start to find a issue I have on my magento 2 ver 2.2.6. Because when I installed a vanilla magento 2 2.2.6 no issue. So the issue is on my website and I can't find the problem. Where ...
1
vote
4answers
25 views

InstallSchema.php not working in magento2

I have been trying to create a table from InstallSchema.php, but some reason the table is getting created. I haved created a bare minimum module with the following files. 1. registration.php <...
2
votes
0answers
19 views

Magento 2 - Can I have to create API, Interface & Resource Model for relational table

I am creating a module which have three tables let's say for example table1 -------- id int(13) PRIMARY_KEY title varchar(50) table2 -------- id int(13) PRIMARY_KEY title varchar(255) table3 `...
3
votes
1answer
42 views

What Database Tables Contain Credit Card Information?

I have a Magento 1 database that I want to remove sensitive data from before I allow a consultant to connect to. What tables/rows would I need to fill with dummy data? I have looked at my tables ...
0
votes
0answers
6 views

Indexing the Core Magento 2 table columns without effecting the update query performance

my doubt is regarding the indexing in database tables columns of Magento 2 instance. I want to put index on few of the columns in my heavy database tables columns of my core Magento 2 tables. Can ...
0
votes
0answers
8 views

Product custom brand attribute doesn't updated automatically after assigning product from brand extesnions

Please visit here to see my problem:- http://nimb.ws/JkrGdY http://nimb.ws/Qi6rBn http://nimb.ws/sb3M8p I've approximately 5k products so it's not possible to save individually, from the grid I ...
0
votes
1answer
20 views

Is FireBear Improved Import Export Extension/Support Safe?

I purchased the FireBear Improved Import Export Extension with support so that I can merge two stores into one and upgrade from Magento 1 to Magento 2. After downloading the plugins and contacting ...
0
votes
2answers
53 views

Parse error: syntax error, unexpected '$servername' (T_VARIABLE), expecting function (T_FUNCTION) or const (T_CONST) php

I am trying to connect to a MySQL database usign PHP but am currently facing this error : Parse error: syntax error, unexpected '$servername' (T_VARIABLE), expecting function (T_FUNCTION) or const (...
0
votes
1answer
32 views

request sql bad with invalid quote

We are trying to migrate our code from magento 1.7 to 1.9 and I have an issue when i build a request with magento 1.9. I wrote this for a column on the order grid : $this->addColumn('id_po', ...
1
vote
0answers
41 views

Magento 2 Down: replica Tales not found when reindexing!

My server went down because the disk was full, after fixing it, I noticed that the magento 2 website never came back: (Magento 2.2.4, PHP 7.0.30) When re-indexing, i get the following error: ...
0
votes
0answers
17 views

Import Non-Magento database to Magento 2

I'm new to Magento and very much still trying to learn the ropes, so to speak. I'm researching the possibility of migrating a database from a non-Magento ecommerce website over to Magento - this ...
1
vote
1answer
23 views

Is too much cron jobs schedule cause server time out of website ?

Hi i have a website in magento2 , in my database we have 467500 rows in cron_schedule table , my site is lacking alot and most of the time it goes down displaying server timeout issue . The ...
0
votes
0answers
35 views

Join tables from different collection to get phone number on Grid?

I need to get the customer's phone through a custom extension that I have four reports. Here is what I have done so far based on a part of the code I found on another post. function ...
3
votes
1answer
53 views

How to get All Column names of table in magento 2

I created a custom form in admin using block(without UI component). So i want to get all columns of my custom table in form block file. Please suggest me.
0
votes
3answers
39 views

Magento 2 from which database table data comes to credit memo grid.

I need to add custom diiscount to credit memo grid, I added to invoice grid as data populated from sales_invoice table but unable to find table to credit memo.
2
votes
1answer
30 views

Magento 2.2.5: How to join a table with a repository

I am trying to join table 'cataloginventory_stock_status' with order item table using OrderItemRepositoryInterface and searchCriteriaBuilder. $searchCriteria = $this->searchCriteriaBuilder ...
0
votes
2answers
25 views

Magento 1.13.1.0 with Mysql 5.6.41

I would like to know if Magento EE 1.13.1 works with MYSQL 5.6.41. Thank you!
0
votes
1answer
22 views

How to find out If Magento MySQL is hosted on AWS RDS

How do I find out if my Magento Instance's Database is being hosted on RDS? I see a RDS instance on AWS, but am not sure how I test without actually stopping the RDS. Wondering if there's a more ...
0
votes
1answer
14 views

Magento 2.1.11 - adminhtml - Saving model to database with boolean field does not match value

I am trying to save data from a model to the database. Most of the data is being saved correctly, but I am having issues with boolean fields. The database has several boolean fields something like ...
1
vote
0answers
20 views

Magento 2.2.4 enterprise edition in `catalog_product_entity_int` table they use 'row_id` instead of `entity_id

I am afraid, i just want to know in catalog_product_entity_int table they use row_id instead of entity_id. and also other table use row_id I don't understand difference why they use row_id instead of ...
0
votes
1answer
27 views

How to delete table from mysql when uninstall extension frommagento 2.2.6?

I have created an extension with the schema. It is installed correctly and tables are created correctly in the database. But, now I want to uninstall that extension. But with uninstall, I also want ...
0
votes
0answers
17 views

M2: SQLSATE[42S02]: Base table or view not found

I have script which is responsible auto import products to our store. Today I get issue, anyone know how to solve? [2018-10-03 11:15:53] main.CRITICAL: SQLSTATE[42S02]: Base table or view not found: ...
1
vote
0answers
42 views

How Do I Merge Two Separate Magento Databases

Problem I am trying to combine two Magento version 1 stores from separate domains. My goal is to combine the two existing sites into one so that it can be hosted on a new domain and after all the ...
0
votes
1answer
30 views

facing this issue contains 1 abstract method and must therefore be declared abstract or implement the remaining method

Facing fatal error given as below. Fatal error: Class Sugarcode\Test\Model\Total\Fee contains 1 abstract method and must therefore be declared abstract or implement the remaining methods (...
0
votes
1answer
29 views

custom table data fetch and show in cart page

I want to fetch custom table data and show on cart page. Don't need to do from customer id (session). Please review my code and give me a solution. Here's my code: /home1/dukaania/public_html/...
0
votes
1answer
19 views

Data is not fetching, return 0

Data is not fetching get customer id null.? Please review my code. Here's my code: /** * Collect grand total address amount * * @param \Magento\Quote\Model\Quote $quote * @param \Magento\Quote\...
0
votes
1answer
25 views

Shoping cart page fee value return 0

I want to retrieve database value in cart page but it shows 0. Please review my code. app/code/Sugarcode/Test/Model/Total/Fee.php /** * Collect grand total address amount * * @param \Magento\...
2
votes
1answer
33 views

I am trying to override core interface in Vendor\magento\sales\Api\Data\OrderItemInterface.php

My di.xml code is here, is there any alternative way to override an interface for core file. <preference for="Magento\Sales\Api\Data\OrderItemInterface" type="Vendor\Name\Api\Data\...
3
votes
1answer
39 views

Found this error does not extend \Magento\Framework\DataObject

Facing this error Exception #0 (InvalidArgumentException): Sugarcode\Test\Model\Fee does not extend \Magento\Framework\DataObject Here's my code /home1/dukaania/public_html/testing2/app/code/...