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
0 answers
103 views

Magento 2 How to update quote totals information from admin

Magento 2.4.5-p1 version using. We want to give custom discount via our custom module Using this code - <?php namespace Namespce\Modulename\Controller\Adminhtml\Quote; use Magento\Backend\App\...
sumeet bajaj's user avatar
  • 1,266
0 votes
1 answer
31 views

how do i make an admin grid based on sales_order table (some columns but not all) using best practice?

Let's say I need an admin grid where not all columns of the sales_order table will be, but only some of them. For example: customer_id customer_name nickname How best to solve such a problem?
esca7a's user avatar
  • 11
0 votes
1 answer
90 views

db_schema can't set foreign key - Table [prefix]_sales_order do not have column with name "name"

I must add column1 to sales_order_grid and create foreign key to table sales_grid.column1 When i try use bin/magento setup:upgrade i get next message Table [myPrefix]_sales_order do not have column ...
esca7a's user avatar
  • 11
0 votes
1 answer
34 views

is it safe to delete magento 2 table:fl32_csp_report?

I have the following table, named fl32_csp_report, size: 2.5GB. it's very huge table, and it affected the visiting speed when customers comes to my website. My store has been just updated from ...
li haihua's user avatar
2 votes
2 answers
4k views

Insert data into custom table in magento 2

I have created a custom table in database of magento 2. I want to insert some data into this custom table. I want to pass this data from controller to the custom table in magento 2.4. Please can any ...
Nicola Smith's user avatar
1 vote
0 answers
99 views

Magento 2 Mailchimp Abadoned cart email not working

In the current Using version we are using Magento 2.4. We are Using this Mailchimp Magento extension - https://marketplace.magento.com/mailchimp-mc-magento2.html We upgraded the Magento version from 2....
sumeet bajaj's user avatar
  • 1,266
0 votes
1 answer
399 views

How to add table schema as a dependency in setup patch data?

I am creating a custom Module, in that I created a custom table and patch data. The patch data for inserting data into that table. Now the issue is, the custom table was created through declarative ...
Siranjeevi K S's user avatar
1 vote
1 answer
5k views

Magento 2 How to create graphql mutation

How to create custom graphql mutation in custom module in magento 2. And how to save custom form data in custom table using mutation. THANKS.
Mohit Patel's user avatar
  • 3,681
0 votes
3 answers
1k views

Magneto2: Base table or view not found table amasty_conf_group_attr doesn't exist

The changes made in products attributes doesn't show on the frontend. The part of the database won't update and shows the following message. "Base table or view not found table ...
uziixd's user avatar
  • 3
0 votes
1 answer
243 views

Which tables need to restore to get backup of all customers in magento 2.4.1

I am using magneto 2.4.1. Accidently I have deleted all my customer lists but I have a backup. So now which tables I need to restore to get back those all customer list.
Shubhajay Das's user avatar
0 votes
1 answer
495 views

Magento 2: Get all bundle products

So I have to create a report (SQL Script) which has all the bundle products and all its customizable options. I can get list of all the bundle products using this query. select entity_id, type_id, sku,...
Shivani Singh's user avatar
0 votes
2 answers
127 views

Increase the width of the product table in the order confirmation template

I'm trying to help my friend out who has a Magento Store, (2.3.6). I'm a little new to Magento but am experienced with PHP, HTML, CSS. Order confirmation emails are coming through badly formatted and ...
rhorne's user avatar
  • 1
0 votes
1 answer
218 views

I have confusion take of sales_sequence_profile table in Magento 2

Can anyone explain where what's the use of this table or where it will work? Thanks
Prakash saran's user avatar
0 votes
1 answer
611 views

How to set 2 auto increment id in table[Magento 2]

is there any way to create 2 auto increment id in same table?When im trying to create using db_schema, error showing that only primary key id can get this auto increment.is there any other ways?
mage's user avatar
  • 15
0 votes
4 answers
4k views

Magento 2: How to get last inserted custom table Id without saving new item?

I want to get the last inserted id to my block without adding new data into the table. I want to use this value to automatically filled in my phtml file. I tried getId and it's not working. I just ...
mage's user avatar
  • 15
-1 votes
2 answers
82 views

I need to display table data in my custom module at the front end of the site. Its saying wrong argument for $collection

/*Showdata.php Controller\Index */ <?php namespace Eaglerocket\Customquote\Controller\Index; use Magento\Framework\App\Action\Context; use Magento\Framework\View\Result\PageFactory; use Magento\...
kks's user avatar
  • 19
0 votes
1 answer
893 views

How to get data from table in block magento2? Note: my model is in another module and i want to get data in another module.[frontend]

I have databse table with data.My model was created in one module and i want to get table data in another module's block class, so that i can render those data into my phtml. table name:form columns:...
mage's user avatar
  • 15
0 votes
1 answer
447 views

Add row number in admin custom table Magento 2

I've made a new module. Here, I've override the AbstractFieldArray class. <?php namespace myVendor\myModule\Block\System\Form\Field; use Magento\Config\Block\System\Config\Form\Field\...
Florin Aqir's user avatar
0 votes
1 answer
155 views

Trying to remove unwanted space in a table,

I'm trying to create a 6 cell table on my site that contains 3 images and i want the corners of the three images to touch, with no boarder or padding. I've tried everything I can think of but ...
New2Magento2's user avatar
1 vote
4 answers
2k views

How to check installed extensions on database magento 2

I need to check installed module on database table I hope your help Thanks Thomas
Thomas Peters's user avatar
1 vote
4 answers
4k views

Magento 2 - Check if record with certain value already exist in table before creating it

I created a new table company_shipping_quote. I am writing data into it like this: $quoteId = $quote->getId(); $html = $this->_generateNote($expressRule); $quoteModel = $this->...
Black's user avatar
  • 3,150
0 votes
1 answer
2k views

In which table in database Magento 2 product will insert with image and custom attribute?

What are the basic tables which need to use, so Product data will be inserted with image and custom attribute. Which is visible both in frontend and admin. Please Any one point out the table name for ...
Prits's user avatar
  • 626
0 votes
1 answer
18 views

No show customers in Customers section table

I have a problem after upgrade from 2.3 to 2.4. After correctly upgrate I don't see customers inside the table customers. In particular, I'm seeing only the first row on the table while all other rows ...
Alessnadro's user avatar
0 votes
0 answers
45 views

Magento2 fetch value from catalog_compare_item table

Magento2 How can I get the value of following table 'catalog_compare_item' using a model or any other proper way of Magento?
Arjun's user avatar
  • 3,556
0 votes
1 answer
121 views

Change database in Resource model

I split my database on 3 parts. In my env php is set default, but in one of my model i need to connect to table wich located in different db. How can i change target db?
Mikhaylo HODOVANIUK's user avatar
0 votes
1 answer
231 views

Base DB schema didn't create table

In my report_sales > coupons page I get exception Base table or view not found: 1146 Table salesrule_coupon_aggregated doesn't exist And I find out that system didn't create this table (It doesn't ...
Mikhaylo HODOVANIUK's user avatar
0 votes
1 answer
94 views

I created a custom Module, but table is not created, i also checked in core_resource, it's not there

Here is the code config.xml <?xml version="1.0"?> <config> <modules> <Bms_Calls> <version>0.1.0</version> </...
vinaysirige's user avatar
0 votes
3 answers
888 views

Table prefix error when running - setup:db-declaration:generate-whitelist

I've run the command php bin/magento setup:db-declaration:generate-whitelist --module-name={Vendor_Module} and receive the following error... Magento was installed with a table prefix. Please re-...
Eddie's user avatar
  • 139
2 votes
1 answer
343 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. ...
Davide Iandoli's user avatar
0 votes
1 answer
197 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.
fudu's user avatar
  • 1,258
0 votes
1 answer
668 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 ...
Amrit's user avatar
  • 1
0 votes
0 answers
50 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,...
MagentoMac's user avatar
  • 1,032
0 votes
1 answer
44 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. ...
Gustavo Ulyssea's user avatar
0 votes
1 answer
112 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 (...
SUDHAKAR ARUNACHALAM's user avatar
1 vote
1 answer
617 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"); ...
zus's user avatar
  • 155
1 vote
2 answers
296 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\...
ChristopheS's user avatar
0 votes
1 answer
2k 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 ...
Nittn Warshne's user avatar
1 vote
2 answers
964 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 ...
irshad's user avatar
  • 171
0 votes
1 answer
66 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.
Aaron's user avatar
  • 149
3 votes
1 answer
1k 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....
Ajwad Syed's user avatar
  • 1,591
1 vote
4 answers
445 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 ...
Nagaraju Kasa's user avatar
0 votes
2 answers
660 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-&...
usman's user avatar
  • 440
1 vote
1 answer
652 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); $...
Ajwad Syed's user avatar
  • 1,591
0 votes
0 answers
31 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!
manhtuan tran's user avatar
0 votes
1 answer
2k 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 ...
coderGeek's user avatar
  • 535
3 votes
1 answer
227 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 ...
vitoriodachef's user avatar
0 votes
1 answer
59 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 ...
Sandeep's user avatar
  • 115
2 votes
2 answers
2k 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
Asad Ullah's user avatar
  • 1,461
0 votes
0 answers
486 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
Developper Magento 's user avatar
2 votes
1 answer
639 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 ...
Sweety Masmiya's user avatar