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
4k views

Facing this issue, It 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 (Magento\...
0
votes
1answer
24 views

Get specific columns from Left Join

I am trying to join two tables like below $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $collection = $objectManager->get('Advance\Module\Model\Method') ->...
0
votes
0answers
14 views

When i want to checkout sometimes then error will be show i am using (Elavon Payment Method)

[2020-08-18 09:43:25] main.CRITICAL: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'eshoppy_porto.installments' doesn't exist, query was: SELECT main_table.* FROM installments AS ...
0
votes
1answer
1k 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, ...
1
vote
0answers
10 views

SQL maxium innodb size issue

I am installing smtp extension suddenly I am facing with below -- Mysql -- error message https://prnt.sc/127cedv SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum ...
2
votes
1answer
1k views

Magento 2 Migration : SQLSTATE[23000]: Integrity constraint violation: 1062

I followed http://devdocs.magento.com/guides/v2.0/migration/bk-migration-guide.html for migration. I am facing issue - SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'customer-...
5
votes
2answers
1k views

Magento MySQL Engine choice

Some of the tables in the Magento 2.1 DB have "MEMORY" as their engine. This is a problem for the DB cluster we are using (Percona-XtraDB-Cluster with pxc_strict_mode = ENFORCING). Can I change the ...
1
vote
2answers
1k views

Magento 2 PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections

When I run a script for upload products more than 5000. after 152 products upload showing below error. How can I upload thousand of products from csv without error? Error: PHP Fatal error: ...
0
votes
1answer
616 views

Magento 2 custom catalog condition rule not saving in custom module

I have added custom catalog conditions to my custom module admin form. a condition drop-down is displayed fine and in post data, condition value is also getting. but I am unable to save condition ...
0
votes
0answers
15 views

How to create a website, store and storeview using data patch in magento2.4.2

I want to create a website, store and storeview using data patch in magento2.4.2. How to do that. Thanks
0
votes
0answers
21 views

How to export products with tier prices directly via database using SQL?

I want to export these data from my Magento 2.4: Status Product Name SKU Price Advanced Pricing Quantity How could I do it via SQL?
2
votes
2answers
2k views

Column not found: 1054 Unknown column 'at_status_default.value'

I'm actually kind of desperate.I tried many times to update my Community Edition from 2.2.1 to 2.2.5, always failing due to what I guess is a database inconsistency.After the update procedure - done ...
0
votes
1answer
7 views

MySQL Query of catalog_product_super_link filtered by attribute_set_id

I want to export all fields from the catalog_product_super_link table, but filtered to exclude any products that have have a certain attribute_set (31 in this case). This post (MySQL Query filtered by ...
2
votes
1answer
4k views

Magento 2 Add extra data to an order

I'm brand new to Magento 2 programming, although I have a number of years of PHP behind me. I need to store an id from an external system alongside an order that that system creates. I've got the ...
2
votes
1answer
1k views

Magento 2 - read and write connection for custom query

I am using Magento 2.2.5 EE. I need to write some custom queries Select and Insert I know how to write custom query, its simple: Create new connection: $objectManager = \Magento\Framework\App\...
0
votes
1answer
10 views

magento 2: how to checked use default value for product status programmtically?

I have to update and checked checkbox for use default field for product status. But I do not know how to update and checked that checkbox ? here is my code $objectManager = \Magento\Framework\App\...
0
votes
1answer
11 views

upload porto theme with existing database in Magento 2.3.5

can I upload the porto theme and use my old products hence the dummy data will be removed and my old data will be shown... is this possiable furthermore will my old categories appear in the theme or ...
0
votes
1answer
105 views

I want to develop IP restriction on Login [closed]

In this I want to develop the following things: I want to develop IP restriction over customers login in which if I want to develop one filed in admin which you can specify anyone's IP address(text-...
0
votes
1answer
17 views

Is it right or wrong to create tables in the magento 2 database?

Guys I'm new to magento development and I'm trying to learn how to create basic modules and I'm trying to create a module that registers some customer information and then returns it to the ...
0
votes
1answer
30 views

problem in facebook pixel module for magento2.4

we installed the facebook pixel module for magento2.4. so far everything perfect. But when I enter the product registration and saved, the error below occurs Error: Call to undefined method Facebook\...
1
vote
1answer
2k views

How to get visitor data & store detail in database in magento2

I want to get visitor data when any visitor visit magento website. In visitor detail, I want to get IP address, browser name , Operating System Name , First Visit Time, & Last Visit time. How is ...
3
votes
1answer
2k views

Magento 2 call table stock_item from database

I working to Magento 2.0.2 and i trying to call the table stock_item of the product. When i worked in Magento 1.9 i used this code: loadByProduct($_product)->getQty();?> But now the class Mage is ...
2
votes
2answers
1k views

How does the number of products affect magento/server performance?

How does the number of products affect magento/server performance? I am considering deleting unused products in a magento multistore setup as I am only using 1 of the stores. I have over 25K skus but ...
0
votes
1answer
13 views

Magento 2 Change custom option name with mySql

I have this line which I can use to update the price of a custom product option. UPDATE `catalog_product_option_type_title` a JOIN `catalog_product_option_type_price` b ON a.option_type_id = b....
2
votes
1answer
61 views

How to create stored procedure with Magento 2.3.x setup script.?

I'm trying to create MySQL stored procedure using Magento 2.3.x for one of my requirements. I found that that there is no way in Magento 2.3 declarative schema by which I can create that. But if the ...
1
vote
2answers
1k views

SQLSTATE[42000]: Syntax error or access violation: 1064 in magento 2.2.5

I have deleted old theme column in database table "theme". after that i am getting error on catalog view page and product view like this exception(s): Exception #0 (Zend_Db_Statement_Exception): ...
1
vote
1answer
50 views

Magento 2: What is the purpose of “_replica” tables?

I'm newbie in Magento but I have a store that started in 2.2 and is now updated to 2.4.1. What is the exact purpose or _replica tables? The only mentioning is that they help prevent deadlock but how ...
0
votes
1answer
33 views

How to import 3 tables dump into database using script?

I want to include 3 tables SQL dump into that database, how to add it by using a custom module or script or any best practice.
0
votes
2answers
4k views

Get the special price of the product using query in Magento

I want to create a view of Magento products. The following query will do that: Note: Magento's default records used to create it. SELECT P.entity_id as uid, P.created_at as cdate, # Created to ...
0
votes
1answer
63 views

Port must be configured within host parameter in Magento 2

I received the following error, "Port must be configured within host parameter. like localhost:3306 in /var/www/html/dbm2/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php" when trying to go ...
0
votes
0answers
18 views

Magento 2.4.1 EE | Customer custom attribute created from admin but not saving value in DB

I am facing an issue with Magento2 EE website (Magento ver. 2.4.1) for customer custom attribute. Found similar question here as well but not with any solutions. When I create a new customer attribute ...
0
votes
2answers
2k views

How to remove city as a required field at checkout page in magento 1.9.3.6?

I want to remove required field from city and make it non required field at checkout page. how can i implement this?
0
votes
1answer
1k views

Call to a member function extend() issue

I tried to import my Magento project into my local machine (wamp server), But I was not able to access it, i got the following error: Fatal error: Call to a member function extend() on a non-object ...
0
votes
1answer
1k views

Database connectivity issue in Magento 2.1

I am trying to connect to magento database of another system with the following configuration in app/etc/env.php array ( 'host' => '192.168.1.172', 'dbname' => 'datacenter', '...
10
votes
2answers
9k views

Magento 2: how to delete orders from the database

How can I delete the test orders created in my store? I have opened the database but I couldn't find the order table. Please help me to delete the orders. I'm using the later version of Magento 2.
0
votes
1answer
59 views

How to fix skip to content option in magento 2

I have issue with the magento2. When we open a website the skip to content appear before loading the complete website . How i remove this option. Image is atatched.
0
votes
0answers
16 views

Serialization failure: 1213 Deadlock found when trying to get lock

We are using https://github.com/firegento/FireGento_FastSimpleImport2 to import product using CSV and we end up in getting this exception. ["SQLSTATE[40001]: Serialization failure: 1213 Deadlock ...
0
votes
1answer
1k views

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'store_id' in where clause is ambiguous

After searching around I still haven't found a solution so I thought I would post it here. Any help would be greatly appreciated. When I go to filter one of the columns it redirects me to dashboard ...
8
votes
8answers
35k views

Magento 2 : URL key For Specified Store Already Exists

We have a Magento 2 multisite setup, with categories set up. When editing some (but not all) of these categories, in different store views, Magento throws following error and does not save data: In ...
0
votes
0answers
26 views

MariaDB crashing every few days

I'm using Magento2 with MariaDB 10.3.27 on Debian 10.8 and i'm experiencing MariaDB crash every few days. I have no idea what can cause those unexpected crashes. I'm sending my config and crash logs. ...
0
votes
2answers
66 views

Truncate media_storage_file_storage table

The table 'media_storage_file_storage' is very big. Can I truncate this table if I use "File System" as "Media Storage"?
0
votes
1answer
1k views

Magento 2: Change DB Name Without affecting core files

I'm running custom script on my Linux Server. I don't want that script to affect my current database. Username/Password/Host will be same. Only DB name is changed. How can I do that without changing ...
0
votes
0answers
373 views

How to add another model collection data to an array. [Magento 1.9]

I have response collection $customerData, I have to add referral code of selected customers in the same array, Model and field of referral code is : $referCustomer = Mage::getModel('...
1
vote
1answer
1k views

Magento 2 invoice email not sending

My customer complaint they do not receive the email order. So I have to manually send them the invoice from the admin account. What cloud be the issue?
1
vote
1answer
1k views

Magento 1 can't connect to database

Please Helpme on this,I have copied a live site to a development environment so I can do some testing. I've followed this tutorial to get everything up and running. When I go to the site is says ...
4
votes
8answers
1k views

How to improve magento site performance

I have setup multi-store magento website, also added full page caching plugin to speedup performance in front-end but still front-end is very slow. Some reason I figured out from my analysis : 1) ...
1
vote
2answers
21 views

Add collection filter from json field

I want to filter custom collections with JSON field filters. In the below image, there are 2 fields category and product. They have JSON value. I am able to get collection by Direct SQL query by ...
5
votes
2answers
7k views

Update a field in database via model

I'm trying to update a field in the database via my database model. All tutorials online about CRUD models seem to just show how to 'CR' and not showing examples of the 'UD'. My code so far: ...
0
votes
0answers
12 views

Error on mysql only on front page

I'm using  Magento 2.3.6-p1 In Cli commands everything  works fine. I can ran setup:upgrade, compilation, content:deploy, etc. But, when I go to www.mystore.com I get the following: 2 exception(s): ...
0
votes
1answer
29 views

Magento 2 - Is it safe to remove the DEFINER=.. statement from sqldump?

I have a web server that serves Magento2 and a MySQL Server that hosts the database and both of these servers are in a single ubuntu instance. I would like to move the MySQL server to a separate RDS ...

1
2 3 4 5
71