Stack Exchange Network

Stack Exchange network consists of 175 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 [table]

This tag is ambiguous. For database tables, use "database", for html tables use "template" or "html", for shipping table rates use "table-rates"

0
votes
0answers
22 views

How to display numbers of row in table to section in configuration system

I want to count the rows of table and display it to field in section system, can someone help me how to resolve this. Thanks!
0
votes
1answer
15 views

Magento 2 display certain rows from custom table in admin grid

I have a custom table(id,product_id,company_code) that is displayed on the backend as a grid. To create the grid, I followed this link. This displays all the records from the table. I need to show ...
3
votes
1answer
25 views

Magento 2. Declarative schema. What is the use of the memory engine?

When creating tables using the Declarative Schema one can set the engine="" attribute value as memory. I can't seem to find an example in the core. What is a use-case for this configuration, how does ...
0
votes
1answer
35 views

Table where global names is stored

I have an issue in Magento where few of my tables and reports are showing the product names/Category in French language.We do have a store at France and in other countries, but the requirement is to ...
2
votes
2answers
42 views

How to create a table in configuration system.xml file in Magento 2?

How can i create table in system.xml file is there any way? I had searched around but can't find any solution want to create like this
0
votes
0answers
38 views

Magento 2 : Create and Handle Many to Many Relationship Between Two Table

I have two custom table that is related by many to many relationships. So how to create these two tables: is there a specific syntax? and how to handle this type of relation thanks in advance
2
votes
1answer
62 views

Suddenly customer_grid_flat table delete in magento 2

I am using Magento 2.2.6. My site is working fine. But today morning I show customer_grid_flat table delete in my database. Please, someone, let me know why it's doing. Also in Admin side customer ...
2
votes
0answers
25 views

What is the difference Between cataloginventory_stock_status & cataloginventory_stock_status_idx

If I use cataloginventory_stock_status and cataloginventory_stock_status_idx return different values, what is the main difference between these two tables?
0
votes
1answer
60 views

How to create custom table programmatically(using code) without using installschema.php magento 2?

Actually I have created a custom grid in back-end for creating custom table there I am providing some fields like- table name, Assigned to Module Name, Number of Input text boxes. Now I want to ...
0
votes
3answers
42 views

Magento2: How can i get all orders from database tables

I want to get all orders record from database. How many tables i have to dump for . Kindly enlist the tables names here
2
votes
2answers
63 views

How to get column value by another column value?

I have table called my_table. In my_table I have got 4 columns: ID which is primary and auto increment, name, some_text, serial_number(int). I want to get only those some_text fields which match ...
0
votes
0answers
9 views

Magento 1.9.0.1 Unable to read version 17996 table error

a current (maybe the only one nowadays!) user of magento 1.9.0.1 here. I've just run into a problem where I'm trying to print an invoice of a customer, but I keep running into this error. I first got ...
1
vote
0answers
28 views

Magento 2 How to Create Custom Checkout Step and Save its Value In Order [closed]

How to Create a custom checkout step with input field and save its value into the order table i want to only textbox field into the checkout. Thanks in Advance
2
votes
0answers
15 views

Increasing character limit for database tables

I have recently upgraded a copy of my site from 2.2.5 to version 2.3. All appeared to work correctly however I have encountered issues with a third party extension for a payment gateway. The ...
0
votes
0answers
20 views

Magento 1.9 Pull in Attribute Labels of Configurable products

Got a table which currently pulls the data of the Attributes of the config products. Im trying to add a the Attribute titles. Currently got this but can not seem to spit the Label out. Any ideas? <...
0
votes
2answers
138 views

onclick="document.getElementById('showme')

I am trying to make this work in Magento, but Magento changes the html and my boss hates it when I want to change anything using cPanel. So I need an option using the dashboard in Magento <table ...
0
votes
0answers
50 views

Magento 2: Set table structure in order invoice pdf

I have need to set order invoice PDF in table structure. I have tried in Magento 2 below core files for same but not done. magento\vendor\magento\module-sales\Model\Order\Pdf\Invoice.php ...
0
votes
1answer
129 views

Magento 2 find observe that fill the table sales_order_item

I want to add data in the table sales_order_item, but for that i need to know what Observer fill this table. If someone know ?
0
votes
1answer
27 views

Display Catalog Info on page

Is it possible to display the Magento product catalog (just a select few columns) on a page on my company site? My company's Magento install is integrated with our ERP system so it shows real-time ...
0
votes
0answers
33 views

Magento 1.9.2. - Join eav customer attributes table with all its values

I have joined the eav / config table to pick up a specific attribute (created with Attribute Manager) connected to the customer id. But now I would like to be able to get all the attributes from that ...
0
votes
1answer
58 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
21 views

how to fetch data from custom table and show in cart page

i want to fetch data from custom table and show in cart page. Please give me a code or any reference or any extension need serious help. I just create a module for show data in cart page but data is ...
0
votes
2answers
67 views

How to know the database name from InstallData.php file

Could anyone please help me how to know the table name from InstallData.php file in this question. there is no InstallSchema.php file
0
votes
1answer
101 views

Retrieve custom fields from customer table using SQL

I have two custom fields in my customer table, namely nickname and sponsor. I would like to create an sql query to select the two custom fields that I have in the table. What kind of query should I do?...
0
votes
0answers
24 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.
3
votes
4answers
4k views

Get database connection in magento 2

I wish to have code equivalent in Magento 2. The below one is Magento 1 $resource = Mage::getSingleton('core/resource'); $connection = $resource->getConnection('core_read'); I need the above ...
5
votes
1answer
148 views

reporting_system_updates table is getting large

On our webshop (running community 2.1.9) we have a table called reporting_system_updates and it is allready over 300Mb in size. Can I safely truncate this table?
0
votes
1answer
120 views

Magento 2 - Save data to multiple tables not working

I have created a custom module having two tables named helloworld_post and helloworld_tag and from front-end side I want to save fields values to these 2 tables. However I have created two respective ...
5
votes
1answer
652 views

Magento 2: Is there a way to lock indexer programmatically?

When I run my custom import script, and during it's execution starts reindex, it causes the error : SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try ...
0
votes
1answer
545 views

Magento 2 Get table name with prefix

I'm trying to get a table name with prefix. I currently try to use getConnection()->getTableName() but that doesn't work. I've seen people suggesting to use $this->_resource->getTableName() ...
0
votes
1answer
26 views

How does magento know the table name

I am confused about magento table name defenation. Here in magento 1 we was define in entity tag in which table name and entity was defined. But in magento2 nothing like that . So my question is ...
0
votes
1answer
343 views

How to properly load config table data into Admin Panel?

I'm trying to create a config table using ArraySerialized and I'm able to save it to database and retrieve it via code, the problem is everytime I load my backend panel, my custom select field from ...
1
vote
1answer
489 views

Magento 2. In which database table is catalogsearch_fulltext index saved?

In which table is information produced by catalogsearch_fulltext index saved when SQL is set as a search engine?
1
vote
1answer
803 views

How to get table prefix?

I have the following code in my install to create a table: $installer->run( "CREATE TABLE IF NOT EXISTS `npcallnations_orders` ( `id` INT AUTO_INCREMENT, `order` int, `...
5
votes
1answer
2k views

Magento2: Store Configuration Table with multiple fields

How can I get in the Store -> Configuration a multi-field tables whose values are serialized?
0
votes
0answers
126 views

How can i get Attributes Values on sales_flat_order_grid after insert new custom column

I have insert column: warehouse in sales_flat_order_grid.[And also created attributes with values] After added how can i get the attributes values, //workout $this->addColumn('warehouse', array( ...
0
votes
1answer
896 views

Custom Table is not getting created in Magento 1.9

I am unable to find why the table is not getting created. I have cleared the cache and everything and checked for the solutions but everything seems good. Here is my config.xml <?xml version="1....
0
votes
1answer
515 views

How can i add custom multi option Attribute in sales order grid like select warehouse and able to edit on the grid itself

I need to add custom multi selection option for admin purpose, like the ordered products currently available in which location warehouse. Its display like both inside of the order page and Sales->...
1
vote
1answer
23 views

Just want to know 2 simple question?

When the table with name sales_flat_order first introduced in Magento & in which version ? When the table with name log_visitor first introduced in Magento & in which version ?
6
votes
2answers
5k views

Magento 2 How to add foreign key in update schema

I try to add foreign key constrain for magento 2 existing table. I have update schema script but it's not working. <?php namespace Retailers\Customer\Setup; use Magento\Framework\Setup\...
3
votes
1answer
227 views

How do i get to Magento Table value using API

I am using the WebShopApps MatrixRate – #1 Multiple Table Rates Extension for User Selection of courier service. I need to get this table Values by API. how do I get to Magento table value using API? ...
0
votes
1answer
217 views

phtml file for checkout table

where do i find the phtml file for the picture above. i want to adjust the table itself. i actually know where the css is. i searched in already in /vendor/magento/module-costumer/view/frontend/ /app/...
1
vote
1answer
2k views

Magento 1.x Database tables with product data

Which tables are the ones in the database that have all the product data in a Magento 1.x system?
3
votes
3answers
200 views

How to save two entries in one table row in Magento 1.9?

I have to save In and Out timing of customer and their In and Out location, I want to save all the data in one row. I am getting status 1/0 1== In DATA, 0== Out DATA, but how to save it in the same ...
1
vote
0answers
121 views

New module doesn't create table

My new module cant create a table while i clean core_resource table. Here is my config.xml file: <?xml version="1.0"?> <config> <modules> <Alkos_Flexibleimport>...
1
vote
0answers
17 views

data grid table title error magento 2.1x

there is error on admin title grid products =>catalog customer =>all customer content =>pages and more on the top of the list Is any one have some idea to fix this issue..
3
votes
3answers
214 views

SQl is not working?

I am upgrading my table with new version and changed config version too, getting error :PDOException Object ( [message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1064 You ...
4
votes
2answers
794 views

TAblerates upload: something went wrong with importing tablerates

When importing the tablerates i get the message: something went wrong when importing the tablerates. I can't find the reason why, could you give me a hint? On the internet i could not find ...
4
votes
1answer
5k views

Magento 2 : How To Create UNIQUE KEY Field in Custom Tabel

I want to create custom filed say myname with constraints UNIQUE KEY in custom extension table. In Magento1 we can define like this : UNIQUE KEY `myname` (`myname`) How can I do this in Magento2?
0
votes
0answers
48 views

Magento 2: create table dependent on configuration

I have a requirement where I need to create a custom table in database but these should be dependent on some configuration of module. Lets say I have enable disable configuration in my module, if any ...