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"
157
questions
1
vote
2
answers
46
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 ...
- 11
1
vote
0
answers
42
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,123
0
votes
1
answer
44
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 ...
- 954
0
votes
1
answer
559
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,157
0
votes
3
answers
50
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
44
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.
- 355
0
votes
1
answer
43
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
0
answers
254
views
How to edit a table built with localstorage
I have built an application that takes user input and adds the values to a table on submit. I wanted to integrate an undo button that removes the most recent item that was added from the table. Here ...
- 1
0
votes
2
answers
30
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
0
answers
21
views
Magento 2 | Join a table to getLoadedProductCollection()
I'm trying to join the tier price table to the getLoadedProductCollection () collection located in the list.phtml file.
What I would like to do is filter the products in the current category by tier ...
- 285
0
votes
1
answer
41
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
0
answers
27
views
Magento 2.4: How to add a new table in Magento DB to retrieve one of its fields to calculate brokerage that gets added to the shipping to Canada?
FedEx module's Carrier.php is extended in custom shipping module of our Magento store to get shipping rates for Canadian addresses. I used FedEx results object to set the carrier to custom shipping as ...
- 527
0
votes
1
answer
164
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?
- 5
0
votes
3
answers
2k
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 ...
- 5
-1
votes
2
answers
49
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
295
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:...
- 5
0
votes
1
answer
308
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
67
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
3
answers
573
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
0
votes
4
answers
2k
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->...
- 2,402
0
votes
1
answer
901
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 ...
- 526
0
votes
1
answer
16
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
21
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,426
0
votes
1
answer
60
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
34
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
27
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
2
answers
463
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
180
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.
...
- 133
0
votes
1
answer
82
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,168
0
votes
1
answer
359
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
37
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,013
0
votes
1
answer
35
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.
...
- 111
0
votes
1
answer
28
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
536
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");
...
- 103
1
vote
2
answers
218
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\...
- 35
0
votes
1
answer
1k
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
513
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 ...
- 161
0
votes
1
answer
60
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.
- 139
3
votes
1
answer
694
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,521
1
vote
4
answers
370
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,566
0
votes
2
answers
402
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-&...
- 422
1
vote
1
answer
439
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,521
0
votes
0
answers
29
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 ...
- 467
3
votes
1
answer
131
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,162
0
votes
1
answer
45
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
978
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,321
0
votes
0
answers
357
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,527
2
votes
1
answer
395
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,301
3
votes
0
answers
241
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?
- 103