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
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

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

Magento Database Repair Tool error mysql_fetch_row

We want to run the Magento 1 Database Repair Tool, but we fetch some errors. What am I missing? Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /magento-db-repair-...
0
votes
1answer
4 views

Could not save product - TRIGGER command denied to user

Could not save product in Magento 2.1.9 after copying the database from another Magento 2.1.9 shop and changing the mysql user (f.e. if you copy your develop database to production server, the ...
2
votes
2answers
20 views

Magento 1 catalog_product_flat_1 corrupt

We have disabled the option to use catalog flat product. Not we have a corrupt DB message: magento.catalog_product_flat_1 Error : Incorrect information in file: './magento/catalog_product_flat_1....
0
votes
0answers
12 views

Magento : Attributes For Product Not Saving

I am using Magento 1.9.x. I have created some attributes for products, When I save, this attribute not working. Pls help me https://ibb.co/hUmVY9 Thanks
0
votes
0answers
15 views

How to integrate excel formulas which are in multiple sheet integrated in magento 1.9? [on hold]

I have 4-5 sheets which formulas are interconnected with each others.how i can integrate with magento panel ?is there any plugin / option available ?
1
vote
1answer
11 views

How to add new column in custom table and also in admin listing page?

I want to add a new column in my existing custom admin grid: My columns in admin grid are: also I want this column to appear in edit listing page.
0
votes
1answer
13 views

Query Magento2 database to find all SKUs without managed stock set to yes

Is there a database query that I can run against my Magento 2.1.6 database to find all SKUs that have Manage Stock set to No. I need to have ALL products set to Yes and Use Default checkbox ticked. ...
0
votes
0answers
14 views

Run magento2.2.3 on Local Machine - MAMP

I downloaded my live magento 2.2.3 based website into my local desktop Mamp directory. I imported the database into the local phpmyadmin. I edited the app/etc/env.php file to have the correct ...
0
votes
0answers
6 views

How can i display the subcategories listing page on click of root categories instead of product lisitng in magento2

I need to display the subcategories in the categories,when clicked from menu it should redirect them to a subcategory page,again onclick of that it should breakdown to level3 category and so on until ...
0
votes
0answers
19 views

Magento 1.9.1.0 ce to 2.2.5 ce Migration Transform Data Type From TinyInt to SmallInt

I am working through a data migration profile for a large site. I'm currently mapping fields from modules and converting eav attributes. I have come across the error: [WARNING]: Mismatch of data ...
0
votes
0answers
18 views

Custom module created is not working in server,works good in local environment

We have created a custom module inside app/code and in upgrade schema script we have increased the module.xml version to add a new column to the existing table.Will it cause any issues?I am not able ...
1
vote
0answers
20 views

Delete Session Files and Prevent Returning

I've already attempted to delete session files, but they come back one at a time and slowly... Huh? Can someone explain why please and help me permanently delete them please? I can not locate them in ...
0
votes
1answer
14 views

Magento 1.9 Product View Count on product detail page

I am displaying product view count on detail page using ajax call on page load but it is taking a lot of time. I am sharing my code below. $jsonArray = array(); //Views count $count = 0; ...
0
votes
0answers
4 views

Adding an index to a Magento2 MySQL Core Table - recommended best practice?

I need an index on the updated_at field of the Magento2 core table customer_entity. What would be the best practices in that case? Should I just add it to the core table? Or better create a second ...
2
votes
3answers
38 views

How to add new table in existing module using UpgradeSchema in Magento 2

class UpgradeSchema implements UpgradeSchemaInterface { public function upgrade(SchemaSetupInterface $setup,ModuleContextInterface $context){ $setup->startSetup(); if (...
0
votes
0answers
4 views

How can i make route as noindex in category page if more than one filters are slelected from layered navigation?

How can i make route as noindex in category page if more than one filters are slelected from layered navigation..
1
vote
0answers
9 views

PDO MYSQL error after moving database from remote server to same server magento is on

I am having an issue where when I go to my Magento site I get a 500 error and looking at the servers error log I see the blow Unable to load dynamic library '/usr/lib/php/20151012/pdo_mysql.so' I am ...
1
vote
0answers
8 views

Mysql state “Creating sort index” slow magento2

how to disable "Creating sort index" state on mysql, this is cause high CPU(>400%) & slowing magento how to prevent this? thanks
1
vote
1answer
20 views

Could someone please explain Declarative Database Schema

So, I read that Magento 2.3 will be introducing Declarative Database Schema. Today, when you want to alter the schema of a Magento database, the pattern used to accomplish this is to use the ...
0
votes
1answer
20 views

What are cons to accessing magento database directly to pull out product data

I am working on a custom app where customers will be able to virtually try on and potentially even buy my products via an iphone/android app. I am currently working on mastering using the Magento2 ...
0
votes
1answer
34 views

Magento 1.9 - issue creating coupon rule. An error occurred while saving the rule data

I can create a new Shopping Cart Price Rule, but when using Actions or Conditions it won't save, resulting in a red error: An error occurred while saving the rule data. Please review the log ...
1
vote
1answer
27 views

magmi : I need to import (and assign) 7000+ attribute_code Values through csv

magmi : I need to import (and assign) 7000+ attribute_code Values through csv. My issue is that the format of magmi csv is Attribute names should be horizontaly column wise(7000+ cols) and values ...
3
votes
1answer
39 views

Magento 2 - Maximum execution time of 300 seconds exceeded

I am upgrading a website from Magento 2.2 to 2.5 and running into an error. I read through a lot of threads and forums but nothing is working. This includes adding max_execution_time 60000, ...
0
votes
0answers
22 views

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.color'

When i go to the order page in the backend of Magento 2 i am getting column not found. How can i solved this error? SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.color' in 'field ...
0
votes
0answers
10 views

How can we store value to database custom table from custom module in magento 2 from phtml files?Apart from install and ugrade schema scripts?

Can you please suggest us how can we store a custom value entered in screen using form ,upon click of the submit should store value in our custom table created.
2
votes
1answer
30 views

Is it possible to make magento use another user database?

If a website has an thousands of users registered and the credentia is stored one user database (one account) and we are installing a new store (magento). Is it possible to make magento use the ...
1
vote
0answers
40 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
2answers
26 views

Delete Magento 1.9 Core URL Rewrites

I need to delete/truncate the Magento 1.9 core URL rewrites which are older than 3 months of core_url_rewrite table in Database. What's the exact SQL query to achieve this?
1
vote
1answer
32 views

Install fails: “Storage engine MEMORY is disabled (Table creation is disallowed)”

When installing Magento 2 (with `magento setup:install), I receive the following error: ... [Progress: 16 / 557] Module 'Magento_Catalog': Installing schema... [Zend_Db_Statement_Exception] ...
0
votes
1answer
26 views

Production Mode app:config:import issue

after a new deployment I get the following error: {"0":"The configuration file has changed. Run app:config:import or setup:upgrade command to synchronize configuration.","1":"#0 \/var\/www\/dev.xxx....
1
vote
0answers
21 views

Issues with Database

If I update the prices, SKU's etc.. in admin they will reflect on the front end but the grid inside admin still shows the old data. I have tried re-indexing and optimising the database but this ...
1
vote
0answers
23 views

Magento 2.1.7 URGET Order saving error: SQLSTATE[42S02]:

i have just tried to add a custom order for testing purposes but i get this error: Order saving error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_.sequence_order_1' doesn't ...
1
vote
0answers
8 views

Magento 2: How to get the image from salerule?

I am showing the data of the salerule in the product view and is necessary for me to also show the image and description of the rule. All the information I need is in Top Banner: Is possible get it ...
0
votes
1answer
42 views

Fetch data from database custom table

Magento version: 2.2.5 EE I have created a new table 'custom_table' i need to render the values in a custom template. How to get the values of that table Regards, Rajesh
0
votes
1answer
22 views

Magento 1.9 database insert file

I try to add a new field to the customer form , on the create account page. What I don't understand is where can I find the file which holds the script with the database insert values. Like the "...
0
votes
0answers
17 views

Magento 2.2.5 : Save Catalog Rule Conditions

I am trying to save catalog rule condtions from my custom module, below is the array I get in my controller save.php [rule] => Array ( [conditions] => Array ( ...
0
votes
0answers
15 views

Tables related to product and pricing in Magento 2

I just wish to know that, what are all the tables related to product and pricing in Magento 2.
0
votes
0answers
12 views

Exception after InsertOnDuplicate magento 1.9

$result = array(); $adapter->insertOnDuplicate(array('main' => $this->getMainTable()),$result); > SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry > '0' for ...
0
votes
0answers
22 views

Magento 2: sales_order_tax and sales_order_tax_item table deleted, how to restore data?

Accidentally deleted my sales_order_tax and sales_order_tax_item table. Now I have repaired it with the Magento installer, but I lost all the data in the tables. Is there a way to restore the data ...
0
votes
1answer
13 views

Remove all password salts from customer table Magento 2

I recently did a Cart2Cart migration for customers and customer passwords, but since we have launched, our customers have been having huge trouble logging in! I've done some research but couldn't ...
0
votes
1answer
16 views

How does magento2 associates an entity with it's table?

How does magento2 connects an entity with it's table ? For example if in \Magento\Customer\Model\ResourceModel\Customer we do $this->getEntityTable(). We get the table name customer_entity. Where ...
0
votes
1answer
27 views

How to get data after adding attributes

So, I created adapter: $adapter = $this->_getWriteAdapter(); After that I added some attributes for select: $select = $adapter->select(); $select->from(array('o' => $this->getT... $...
0
votes
0answers
18 views

Error 1146 table doesn't exist and I cannot delete the table

In phpmyadmin there's a list of tables in my database which show up on the left hand side but they don't all show up on the right hand side. When I click spme of these tables on the left hand side I ...
0
votes
1answer
68 views

Magento 2 Unable to find a physical ancestor for a theme

I've delete Magento 2 theme folder and upload it again but when upgrade it via command line i've got an error say Unable to find a physical ancestor for a theme so any suggestion about that?
0
votes
0answers
22 views

Error Magento 2 when edit product in adminpanel

Magento version 2.2.5, everything was good, then probably I did something (maybe switching to production mode or some url_rewrite manipulations) but now this strange error, I've never met before. ...
0
votes
0answers
19 views

I have 10,271 attributes in a database I want to add them to magento 1

I have 10,271 attributes in a database I want to add them to magento 1 (inside an attribute group name "specification"), then import all the attribute values in each of the previous attribute fields. (...
0
votes
4answers
46 views

How to know magento 1.9 version Using MySql?

I am having Magento1 Database details. Using that can we get the version of magento? I found it can be get with files or with some custom code. I am looking for to get from Database.In which table ...
0
votes
1answer
29 views

Magento2: How to use flat table instead of EAV?

I have a Magento 2 project, in which the customer will have only a very few attributes. So instead of EAV a want to use Flat tables. i.e I want all the attributes to be columns. Customer Address will ...
1
vote
2answers
71 views

Magento ver. 1.9.3.9 After update catalog url rewrite stuck on processing

I am faced with an issue, whereby after updating magento to 1.9.3.9 from 1.9.3.8 my catalog_url_rewrite index is stuck on processing. Checking process list I cannot see anything untoward. Also, ...
1
vote
0answers
50 views

Problem with SQLSTATE[42S22]: Column not found

This happened. Just new installation on an old(worked) database. Could somebody help me please? {"0":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at_status_default.value' in 'where ...