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"
158
questions
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\...
- 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?
- 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 ...
- 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 ...
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 ...
- 89
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....
- 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 ...
- 1,152
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.
- 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 ...
- 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.
- 375
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,...
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 ...
- 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
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?
- 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 ...
- 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\...
- 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:...
- 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\...
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 ...
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
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->...
- 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 ...
- 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 ...
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?
- 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?
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 ...
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>
</...
- 105
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-...
- 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.
...
- 155
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.
- 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 ...
- 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,...
- 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.
...
- 153
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 (...
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");
...
- 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\...
- 45
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 ...
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 ...
- 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.
- 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....
- 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 ...
- 5,826
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-&...
- 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);
$...
- 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!
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 ...
- 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 ...
- 3,480
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 ...
- 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
- 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
- 1,593
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 ...
- 1,371