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
21 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
26 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
26 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
13 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
21 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
13 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
34 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
33 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
22 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.
2
votes
4answers
2k 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 ...
0
votes
0answers
18 views
Actually i was creating a table in cutom module at that i deleted module_set record from core_resource table
The error is as below:
a:5:{i:0;s:166:"Error in file: "D:\xampp\htdocs\products\app\code\local\Mmodule\Agent\sql\agent_setup\mysql4-install-0.1.0.php" - Can't retrieve entity config: agent/...
0
votes
0answers
9 views
How do I remove the standard shipping option if I already set up a table rate?
Standard shipping cost does not need to be there anymore, since I already have added a table rate to the checkout page. Some help would be appreciated. Thanks.
3
votes
0answers
72 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
0answers
26 views
Is it okay to work with multiple tables in one Repository in Magento 2?
For example :
I update & insert values in multiple tables, with table name specified in different functions in CustomerRepository.php.
I have this function in CustomerRepository.php
public ...
0
votes
1answer
78 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 ...
0
votes
0answers
171 views
Safely truncate table that has foreign keys
I tried truncating a table am_acart_history in PhpMyAdmin and got the following error message:
#1701 - Cannot truncate a table referenced in a foreign key constraint (`vamdev_magdev`.`...
0
votes
0answers
28 views
cron job does not use prefix
I use a prefix for my tables
and everything works except for the cron jobs
i get this error
[2018-01-22 16:16:53] main.CRITICAL: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database....
4
votes
1answer
484 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
0answers
14 views
when I place module unzip in a project there are facing problem with creating tables togather
when I place module unzip in a project there are facing problem with creating tables.
two setup are :
mysql4-install-1.1.1.php
mysql4-upgrade-1.1.1-1.1.2.php
there have specify two tables create ...
0
votes
1answer
367 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
20 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
243 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
326 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
474 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
1k 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
86 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
569 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
410 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
3k 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
203 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
179 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
1k 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
197 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
102 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
13 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..
4
votes
3answers
199 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 ...
0
votes
0answers
43 views
Parameter is not undefined When creating table in admin system config Magento 2
I'm trying to create a table in admin but when i added a column it notifies that "Uncaught ReferenceError: duration is not defined"
Here are my system.xml
<field id="payment_method_group" ...
3
votes
2answers
554 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
3k 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
46 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 ...
1
vote
2answers
2k views
how to upgrade schema to create new table in existing module in magento 1.9?
I need to create a table having id,customer_id,in_time,out_time,in_coordinates,out_coordinates where customer_id will be primary key.
please tell what are the steps after creating sql file in sql ...
2
votes
3answers
2k views
Magento 2 - setup primary key field without auto increment
I want to set a field in my table database with integer type but with no auto-increment id, is this the right way to do it?
$table_lime_provinces->addColumn(
'provinces_id',
\Magento\...
5
votes
3answers
1k views
How to set default value in config.xml file for tables in Magento2 backend system configuration
To create a table configuration in Magento2 backend, we can use some good tutorial in here:
http://www.ibnab.com/en/blog/magento-2/magento-2-backend-guide-to-create-table-setting-in-the-system-...
1
vote
1answer
89 views
How to save value of the new column in the “sales_flat_quote_item” for order decline remarks?
I created a new column in sales_flat_quote_item named itemcomment. i want to to insert textbox value this column.
my form .....comment.phtml
<form id="orderapproval-item-form" class="...
0
votes
2answers
108 views
Show the saved value in admin form: right now it is now showing
I have an admin form that is saving the data to database but it is not showing the values from database once it saved:
protected function _prepareForm()
{
$form = new Varien_Data_Form(array(
...
1
vote
2answers
105 views
DB Table not creating on submit of form: Magento 1.9.2.4
I have form in admin created by custom module i created the function to auto create the table in Database if not exists but it is not working to me as follows:
<?php
$installer = $this; //...
0
votes
0answers
221 views
How to style th and td tag in data table additional-attributes
I need to style the th and td tag in the 'additional-attributes' table (under the More information tab), with the css class: data table additional-attributes. See screenshot.
Where (which less file) ...
3
votes
0answers
315 views
Magento 2 - How to CAST & CONVERT Datatype VARCHAR to INT in query?
I have custom extension in magento 2.
In that, saleslist table to save order & product list with seller.
saleslist table
mageproduct_id | order_id | seller_id | magequntity(varchar)
...
0
votes
1answer
17 views
Problem during translations in return view of an order
I've a multilanguages site in Magento 1.9. In return section there's a table and code of its head is the following:
<table class="data-table" id="my-returns-items-table">
&...
