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"

Filter by
Sorted by
Tagged with
0
votes
0answers
8 views

I'm looking for a specific Magento 1 extension for 'custom options' including dependencies (children), images & price/delivery time table

I am looking for a very specific Magento 1 extension for 'custom options', including dependencies (children), images & price/delivery time table. As of now I have 2 individual extensions which ...
0
votes
0answers
17 views

data-migration-tool SQLSTATE[42S02]: Base table or view not found

I am using data-migration-tool version 2.3.5 and my Magento version 2.3.5-p1, when I have to run data migrate command php bin/magento -r migrate:data app/code/Vendor/ModuleName/etc/opensource-to-...
2
votes
1answer
25 views

Can not save in db custom json value on block

In my plugin I created a new table 'myapp_staging' made of three columns: 'id', 'id_api_call' and 'f24_options_value'. In the last field I would like to save a response to my Api call in json format. ...
0
votes
1answer
10 views

How to create table in widget.xml

I wanna add a html table in widget.xml. I mean this: instead of this: Is this possible? Thanks.
0
votes
1answer
33 views

Megnto 2 - table 'magento.store_website' doesn't exist

I am a newbie to Magento. My friend requested me to make some changes to his existing Magento 2 website and gave a Full CPanel backup. When I executed the Database dump, I noticed that only a few ...
0
votes
0answers
11 views

Magento2 store table the store_id needs changed from 2 to 0 to be reset

Not sure how it has occurred, but in our store table, the store_id has changed to 2, but should be 0 I believe for admin. What is the query to run to reset it? We have backups with the correct values,...
0
votes
1answer
26 views

Help to create grid for a table

I need to create a simple adminhtml grid to a table. I went through several tutorials on the internet and none worked. It's a simple table with an ID, text1, text2, created_at and updated_at columns. ...
0
votes
1answer
15 views

jquery in how to get the children without tag id using?

j query in how to get the children without tag id using ? i have using table structure to get the children but last children not getting. I have try this Code $(document).ajaxComplete(function (...
1
vote
1answer
162 views

Magento 1.9 - How to write script for bulk update values in table using csv?

Try to bulk update label name in catalog_product_entity_media_gallery_value, CSV formate : Workout: <?php require_once 'app/Mage.php'; umask("0"); Mage::app(); ini_set('display_errors',"1"); ...
1
vote
2answers
78 views

Magento 2.3 InstallSchema.php does not create any table

I have an InstallSchema.php that does not create the table in the database. Here is the code of the schema php: <?php namespace MyVendor\News\Setup; use Magento\Framework\Setup\...
0
votes
0answers
30 views

How can I get data from table using repositories? | Magento 2.x

How can I create repository in magento 2 and than get data from me custom table using this repository? Model of this tables is created.
0
votes
1answer
230 views

Missing setup_module table in Magento 2.3.2 database

i am missing a table setup_module in magent 2.3.2 database, the site is working, however i cannot install any extensions as the new tables are not being created due to missing setup_module. i could ...
1
vote
2answers
95 views

Magento 2: New field in checkout page, find its input value store in which table of database

I created a new field example in the checkout shipping. label example I can check in the table eav_attribte like the below images. But in which table I can check it's Input value if I put a value ...
0
votes
1answer
42 views

difference tables 'quote' and 'quote_adress"

What is the 'quote' table for? And what is the difference between 'quote' and 'quote_adress' table ? Does anyone know what is the difference ? Thanks in advance.
0
votes
0answers
16 views

Problem with Table rates Magento 2

I have problem with table rates in Magento 2.3.2 when I export the table and make a test int the store the price of shipping is always zero unlike what I make in the table please see the screenshot :...
3
votes
1answer
179 views

How to rename an existing custom table in Magento 2?

I created a table with name "Redeem_blanace" using InstallSchema.php as: class InstallSchema implements InstallSchemaInterface { /** * {@inheritdoc} * @SuppressWarnings(PHPMD....
0
votes
0answers
74 views

Magento 2 : How to retrieve 'custom quote params' from quote object after order placed

I want to retrieve custom params saved in the table: "quote_item_option" I have built an observer to capture the purchase event and also to retrieve the quote object i.e public function execute(\...
1
vote
4answers
201 views

Magento 2 data migration triggers table missing in M1

We have successfully migrated data from M1 to M2 using the data migration tool. We have a custom table called md_cybersource which is mapped to magedelight_cybersource in map.xml When we run delta ...
0
votes
0answers
35 views

Magento 2 - Problem inserting Data in the Database using objectManager

I want to insert data in the table directly using object Manager from Model file. I am providing the code snippet but this isn't inserting the data. I want to know the correct syntax to perform the ...
0
votes
2answers
108 views

product view count table in database magento 2?

I have to write code for getting product count.it is working fine but i want to know where the count record comes? public function getProductCount($id) { $prodData = $this->_prodCollection-&...
1
vote
1answer
103 views

Magento 2 EE | How to create/update new record in magento_customerbalance_history table?

I am trying it as: Using the collection \Magento\CustomerBalance\Model\Balance\HistoryFactory $historyFactory As $model = $this->_historyFactory->create(); //$model->setId(2); $...
0
votes
0answers
27 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
532 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
62 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
37 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
270 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
187 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
161 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
110 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
394 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
5answers
4k 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
359 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 ...
1
vote
0answers
36 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
16 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
3answers
1k 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
1answer
310 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
33 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
1answer
172 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
2answers
124 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
244 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?...
6
votes
5answers
13k 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 ...
6
votes
1answer
395 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
482 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
836 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 ...
2
votes
1answer
864 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
69 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
429 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
777 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
1k 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
3k views

Magento2: Store Configuration Table with multiple fields

How can I get in the Store -> Configuration a multi-field tables whose values are serialized?