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

0
votes
1answer
14 views

Fetch all the students on the basis of ascending marks

This query fetches all the student name and there ids on basis of topics but i want to get these result on basis of ascending marks ... i.e select student_name and ids where student_topic = topic but ...
1
vote
0answers
18 views

Requested store is not found

I've migrated my database of my store when access store front or admin panel I get the following error 1 exception(s): Exception #0 (Magento\Framework\Exception\NoSuchEntityException): Requested ...
0
votes
0answers
18 views

How to Save Front-end Feedback Form Data in database table Magento 2

I want to save form data in a table, I searched a lot of stuff but unable to do it here i created a form in form.phtml file <form > <label for="fname">First Name</label> &...
0
votes
0answers
15 views

Error SQL[HY000] Error 1205 with import_products

I have a problem with a job which manage import products and customers every night. Randomly return an error when import products from SAP. If u see the picture u can see the material "SB-FHA125A-...
3
votes
1answer
35 views

Do bound parameters get escaped using the Core/Resource model?

Consider the following example: $connection = Mage::getSingleton('core/resource')->getConnection('core_read'); $email_address = $_GET['email']; $sql = 'SELECT * FROM `foo` WHERE `email_address` = ...
1
vote
0answers
12 views

How to save entered in particular shipping method in database in magento 2?

I am trying to create one shipping method module which has custom field named 'account no'. So far I Have done this. When user clicks on custom shipping, Input box is coming up.Now I am stuck in how ...
2
votes
1answer
29 views

How to drop a table in Declarative schema?

How to drop a table in Magento 2.3.0 using declarative schema ?
0
votes
1answer
27 views

where is cache_tag table used in magento2?

where is cache_tag table used in Magento2. IS it save CACHE_TAG constant value in magento2?
0
votes
1answer
36 views

Ubertheme error while Migrating date from Magento 1 to Magento 2

I am currently trying to Migrate datafrom our Magento 1 site to the Magento 2 site. We've installed the Ubertheme tool and set the details up in the extension. but every time I try to set up the ...
1
vote
1answer
26 views

sql query in cms_block table in magento 2

I have to write insert query for Magento 2 cms_block table, for ex:- cms_block table, what should i write for the column created_in , updated_in , creation_time , update_time row_id block_id ...
0
votes
0answers
6 views

Magento 2.2.5 Mysql add a coupon cart rule to customers account

I am looking to programmatically add a coupon code to a customers account so next time they come to the site and login to there account there will already be a cart price rule automatically applied to ...
0
votes
0answers
19 views

load data into dynamic rows from database on edit action

I want to load the data from database table to dynamic rows(multiple record) when edit action is called . I am using one to many relation on table Student and Courses i.e Student registering multiple ...
0
votes
0answers
9 views

Is it possible to Extract Attributes with its all Values and their value Id's using My SQL in Magento 2

Is it possible to Extract Attributes with it's all Values and their value Id's using My SQL in Magento 2?
0
votes
1answer
25 views

What new tables need to be created when building module for custom attributes?

Magento 2.2 -- I am trying to build a module that would allow for custom attributes to be created in the admin panel. At this point, I'm stuck on what tables need to be created to allow for that ...
0
votes
1answer
26 views

Deleted ShipperHQ module causing error in “All Customers” section of Magento 2

I'm currently trying to build a Magento 2 site to replace an existing Magento 1 site. As we currently use the MatrixRates Module we decided to give ShipperHQ a try but ultimately decided against using ...
0
votes
0answers
30 views

Invalid Form Key Error

I'm getting this error on my magento website when I try to create new user account.Can anyone kindly assist? https://i.stack.imgur.com/caIKp.png
0
votes
2answers
34 views

Magento 2 module error after version upgrade

I was recently trying to upgrade our Magento from 2.2.5 to Magento 2.2.7. I thought I succeeded but we're currently getting the following error: There has been an error processing your request ...
0
votes
1answer
22 views

Element 'block', attribute 'remove': The attribute 'remove' is not allowed. Line: 745

I'm getting this error when I hit the front end. Couldn't able to find any solution regarding this. 1 exception(s): Exception #0 (Magento\Framework\Config\Dom\ValidationException): Element 'block'...
0
votes
0answers
5 views

How/when are flat tables & grid table generated?

I'm going through the Magento 2 database and I see a few tables names with a _flat, _grid or _grid_archive suffix. By the looks of it, these seem to be a collection of data compiled from other tables....
0
votes
1answer
14 views

Could a hybrid data model, like using JSON in fields, allow us to eliminate the need for EAV within something like magento 2?

I was reading about EAV, and what options are available to avoid the pain caused by it, and stumbled upon using JSON in fields. This mariadb feature page shows an example like, SELECT name, ...
0
votes
0answers
21 views

Magento 2 I want to get order increment id and update all item of sales_order_item table order wise in below observer. How can i do that

I want to get order increment id and update all item of sales_order_item table order wise in below observer. How can i do that namespace Namespace\Moduename\Observer; use Magento\Framework\Event\...
0
votes
0answers
28 views

How can I convert this raw sql segment into a function to use in magento 2?

This sql segment works fine but meqp validator reports the possible raw sql error 'select `review_id foreach ($post['cons'] as $key => $value) { $array[] = $key; } $inCond = $...
0
votes
1answer
33 views

How to import Configurable product from csv with custom attributes using php script

I am trying to import a configurable products in magento 2 with custom attributes using a php script. How far I got the php script to create simple product without custom attributes as a newbie i don'...
1
vote
1answer
20 views

Calculating average price of specific products over time

I'm trying to create a graph that will show the average price of specific products on my site over a period of time. What I'm struggling with is coming up with the most efficient query to use, in ...
1
vote
0answers
25 views

How to rebuild Magento 1.3.2.4 corrupted database ready for migration to Magento 2.3.0

We have an existing old live Magento 1.3.2.4 website (which is completely backed up). We have built a new Magento 2.3.0 website which is ready to go live, but just needs the old Magento 1.3.2.4 data ...
1
vote
2answers
42 views

/app/etc/local.xml not working for me?

I have a client's website in magento 1.9.2.0. Am trying to edit database details and admin custom url in app/etc/local.xml but no changes reflecting. when I do research for this, they asking for ...
1
vote
1answer
19 views

magento 2 - Access denied for user - cache problem

1 exception(s): Exception #0 (Exception): Warning: mysqli_connect(): (HY000/1045): Access denied for user 'aromacak_db30'@'localhost' (using password: YES) in /home/aromacakes/test.aromacakes.online/...
0
votes
1answer
12 views

core_url_rewrite missing

So I just started to manage, not really develop, a Magento 1.9 for a new employer. With my previous employer we made certain anyone creating new products, via duplicating existing, wiped out the url ...
0
votes
0answers
14 views

magento2 creating a lot of catalogrule_product_temp tables

Magento2.2.5 based multisite (multi store view)seems to be creating a lot of temporary tables such as catalogrule_product__temp9a310576 catalogrule_product__temp998786f4 etc... However I am not sure ...
0
votes
1answer
12 views

Tax_class_id per product (through SQL)

hoping you are well, I need your help with the following topic: I want to make a report that extracts all the products in MAGENTO that does NOT have tax_class_id = '2' (taxable goods) and although I ...
0
votes
0answers
18 views

Can't get SQL script to create columns

Magento 1.9, customized sales module, I am trying to add 4 columns. 'liftgate' and 'liftgate_fee' to the sales_flat_order and sales_flat_order_address So here's my script: It's called: mysql4-...
0
votes
1answer
29 views

How to sync database between local or staging and the live store

I am coming from Wordpress and the way I sync my database there is by using a plugin to pull and push databases between too environments, and I was wondering if there is a similar approach with ...
0
votes
1answer
26 views

core_config_data table keeps on reloading in Magento 2

To make a change, I opened core_config_data table in Magento 2 DB, but it keeps on reloading even after I disabled the new module. What should I do ? Now all the tables have the same issue.
0
votes
0answers
10 views

how can i change the value of state column in code(sales_order) table from new to processing ?

Hi i have made a relation between two order statuses in my magento 2.2 system , the first status of the order is "pending" and the second is "processing" , i goto (stores->settings->order statuses) ...
0
votes
0answers
20 views

How to Include Child products id in same column using select query

I am trying to fetch all products entity_id from catalog_product_entity table and appending all of the child product ids (if entity_id is a parent item) to resulted column but unable to get my head ...
0
votes
0answers
14 views

Magento 2 : connect remote database over ssh tunnel

I have a database setup on remote server that is accessible via SSH. I need to connect magento 2 on my localhost to this mysql database via ssh tunnel. is this possible? if yes how?
0
votes
0answers
30 views

Magento 1.9.4 add custom dropdown field to inventory tab

Currently in magento when you manually change the quantity of a stock managed product in the admin there is no reason assigned to this. So, what I would like to do is add a dropdown field below the ...
0
votes
0answers
16 views

Magento 2.1.6 website is working fine but suddenly in one subcategory I'm getting the error bellow

Magento 2.1.6 website is working fine but suddenly in one subcategory, I'm getting the error below. website link - https://buddsbuddy.com/toys-for-toddlers/toys.html 2 exception(s): Exception #0 (...
0
votes
0answers
20 views

Restoring database triggers

There's been a known issue with Magento's backup/rollback process for a while, which was marked as resolved in 2.2.x & 2.3.x where taking a backup removed the mysql triggers: (see: https://github....
-1
votes
0answers
61 views

Error in log in Magento 2.2.6

Receiving these errors which are causing me problems with store. exception.log: [2018-12-10 06:45:03] main.CRITICAL: Invalid method Magento\Eav\Model\Entity\Attribute::isAllowedForRuleCondition {"...
1
vote
1answer
12 views

Are the file paths inside a db table?

Does someone know if some file paths are stored in the database? I created 2 environments and exported one database to another but on the second environment I get the following error: exception(s): ...
0
votes
0answers
23 views

Magento2: How to add customer via SQL query?

i want to add a customer in database using insert query. Different table insert query for customers , which create a new customer after will login successfully
0
votes
1answer
17 views

Magento showing default images after moving to a new server

I have a magento store with version 1.9 hosted on http://bandsawblades.co.uk which I move to 1and1 server on a subdomain called http://test.bandsawbladedirect.co.uk The images are not showing on ...
-1
votes
0answers
84 views

Can't upgrade database from 2.2.7 to 2.3. Cannot process definition to array for type enum

Magento 2.2.7 to 2.3 Started at 2.2.3 and upgraded incrementally via command line. Php 7.2 is enabled. Did not enable until ready to upgrade to 2.3 b/c 7.1 support ended on M2.3 SQL Version: 10.1....
0
votes
1answer
49 views

How to manually import/migrate orders & customers from Magento1 to Magento 2 database tables?

What is the best way to manually move the orders and customers to Magento 2.2.6 from Magento 1.8.1 without any third part extensions? there are around 100 records only. I was able to migrated all ...
0
votes
2answers
29 views

Problem Sessions Database - Magento 2

today I saw my Magento database and in a few months it went from a weight of 300MB to 2GB. I saw which of the tables was heavier and I saw that there is a 2GB SESSION table. Why do the sessions are ...
-1
votes
0answers
35 views

Magento 2: How to truncate customers and order tables - Error#1701 cannot truncate a table referenced in a foreign key contstraint

I tried to follow this solution Magento 2: How to truncate customers, products, reviews and orders table to truncate the customer tables and order tables using the following commands, but i'm getting ...
1
vote
1answer
44 views

Sync Staging and Production Database

How to sync staging and production database? I have staging database and i want to sync it with production database. Production database contains new customers and sales order. I dont want to replace ...
0
votes
0answers
31 views

Magento 2 lifetime sales not refreshing after migration

I migrated products from PrestaShop to Magento 2. The migration went smoothly and all the information has been migrated. However when refresh lifetime sales on the Magento backend they do not get ...
0
votes
1answer
13 views

Magento 1.x addFieldToFilter using AND instead of OR (how can I join search using AND)

I am trying to use AND and OR based on user input. OR = success But I an unable to setup AND queries for addFieldToFilter question: how can I add the second (looped filter) using AND to join $...