Questions tagged [query]
Denotes the question related to database SQL query( in context of magento ).
1
vote
1answer
12 views
How to solve warning “fetchAll can be memory inefficient for large data sets” in magento2
I am getting a warning as
"fetch All can be memory inefficient for large data sets",
When I did MEQP2.
Please anyone can help me to resolve this warning.
I am getting a warning in below line
$...
0
votes
2answers
29 views
How to resolve the “Direct object instantiation (object of \Zend_Db_Expr) is discouraged in Magento 2”?
I am getting warning as
"Direct object instantiation (object of \Zend_Db_Expr) is discouraged
in Magento2"
when I did MEQP2.
Please anyone can help me to resolve this warning.
I am getting ...
0
votes
1answer
22 views
Why magento2 outputs the query while showing data from ResourceModel collection Factory..?
protected $productCollectionFactory;
public function __construct(
.....
\Custom\MyModule\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory,
...
) {
...
1
vote
1answer
23 views
Update sales order immediately after inserted
I want to update the sales order right after it is inserted.
I want to reflect the change on the sales order conformation email also which is going to the customer.
So i have prepared the below code ...
0
votes
0answers
19 views
Magento 2.2.3 order listing page too slow in admin
I am using Magento 2.2.3 it is in production mode. The order listing page in admin loads very slow. I have been facing this issue since long.
To debug this I have also tried enabling query log ...
1
vote
1answer
16 views
Magento 2 Custom Filters
Dear Magento 2 developers,
I am currently new in the Magento 2 development, now I struggle about how to make custom Product filter on the sidebar, like the picture below.
My new brand column in ...
0
votes
0answers
23 views
Category page take too much time to load because of search_tmp_* table
my sites category page slows down because firing query for search_tmp_* table take more than 1 second and it runs saveral time on one page load here is the query :
7624 ## QUERY
SQL: INSERT INTO ...
0
votes
0answers
19 views
Why product collection query not showing “color” attribute in select?
Case 1:
$collection = $this->product->getCollection()
->addAttributeToSelect('color');
echo $collection->getSelect()->__toString();
Output:
SELECT `e`.* FROM `...
0
votes
0answers
32 views
Magento 2.3: SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)
I'm very new to magento 2.3, I'm facing some error maybe from DB side....
Here is my code:
/app/code/EC/Customimport/Controller/Adminhtml/Index/Import.php
<?php
namespace EC\Customimport\...
1
vote
3answers
183 views
Quote id is empty when inserting multiple records into cart in magento2
I am adding product to cart from ajax by passing product id
Here is my controller code.
use Magento\Framework\Controller\ResultFactory;
use Magento\Framework\App\Action\Action;
use Magento\...
1
vote
0answers
39 views
Magento 2 - Query Builder
I need to create a query with searchCriteriaBuilder with this condition:
WHERE visibility = [value] AND status = [value] AND ((category_id = [value] AND designer = [value]) OR (category_id = [value]))...
1
vote
1answer
18 views
Magento 2 add query string to url when redirect to 404 page
Magento 2 custom module i am trying to add query param
https://test.com/index?id=L_FRR3039-ODKLWG-GP4QPY
if i give above format getting 404 page not found
https://test.com/index?id=L_FRR3039
it ...
1
vote
1answer
160 views
SQL Query for custom attribute
I have create custom attribute in product upc
I want custom query (sql) to get SKUs and UPCs
Can anyone tell me the related tables from where I can get data, or if anyone can share query that would ...
1
vote
1answer
21 views
magento 1 query generated back tics are wrongly placed
I have an issue in Magento 1, where the SQL query that is getting generated has the back tics wrongly placed.
This is a piece of the code that helps to provide the collection to the grid layout.
...
2
votes
2answers
147 views
Magento 2 query url rewrite
If I have URL like this -
mainpage.com/products?test_category=99
and want it to be rewritten to this
mainpage.com/testproducts
Since magento2 URL rewrite won't take query how can this be ...
0
votes
2answers
46 views
Pulling credit memo from database using mysql quesry
I'm trying to pull a credit memo from the directly from the database but i keep getting the below error
ERROR:
You have an error in your SQL syntax; check the manual that
corresponds to your ...
0
votes
1answer
33 views
how to enable disabled products via query?
Hi I want to enable all products I have in my Magento 2 store, is there any query to enable all products we have using a single sql query ?
Thanks
0
votes
0answers
26 views
Magento 2 Query in custom model file not working
I am working on the Magento 2 custom model file, my table name is custom_log, then I have created the following model file in my module directory.
Test/Customlog/Model/Log.php
namespace Test\...
0
votes
1answer
27 views
Fetch all the students on the basis of ascending marks
This query fetches all the student name and there ids on basis of topics but i want to get these result on basis of ascending marks ... i.e select student_name and ids where student_topic = topic but ...
0
votes
0answers
58 views
How to get Product Rewrite url in magento 2 by Query
I need Rewrites URL in Magento 2 by query. I tried below code.
<?php
namespace Dev\Core\Helper;
use Magento\Framework\App\Helper\Context;
use Magento\Framework\App\ResourceConnection;
class Cart ...
1
vote
1answer
27 views
Calculating average price of specific products over time
I'm trying to create a graph that will show the average price of specific products on my site over a period of time. What I'm struggling with is coming up with the most efficient query to use, in ...
0
votes
0answers
36 views
InnoDB temporary tablespace size explodes after reindex
Within a Magento 2.2.6 installation we currently have a peculiar problem, where MySQL's Temporary Tablespace of InnoDB (ibtmp1) suddenly explodes in size, growing seemingly indefinitely until the disk ...
2
votes
1answer
40 views
How to get the orders above the order id and How to use the limit in magento 2
I need to write code to get next 10 orders above the given order id.
<?php
namespace Learning\GreetingMessage\Controller\Index;
use Magento\Framework\Controller\ResultFactory;
use Magento\...
3
votes
2answers
338 views
SQL query kills entire server
I caught the following query via mysql's SHOW FULL PROCESSLIST; which was eating the whole CPU / RAM on my server (32GB Ram, i7 hexacore CPU) rendering the entire server unusable for more than 3 hours....
-1
votes
2answers
122 views
Magento 1 Update/append product categories in database
I want mysql query for append or add new category ID to exsting product categories.
2
votes
1answer
164 views
Magento 2.2.5: how to query in observer best practice
I'm looking for best practice on how to query to database in observer.
Ok so this is the idea, i use observer to catch event catalog_product_save_after (which will be fired after product is saved in ...
2
votes
2answers
273 views
Magento2 Query Param Binding
->having(
'COUNT(*) ' . '<= 3 '
)
Hardcoded value 3 need to come From:
This is the query to return most viewed products biggest views number:
SELECT COUNT(report_event.object_id)...
1
vote
1answer
79 views
The PurposeOfShipmentType is null, empty or invalid. please give me ans how to solve this?
2018-09-12T11:10:10+00:00 DEBUG (7): Array
(
[request] => Array
(
[WebAuthenticationDetail] => Array
(
[UserCredential] => Array
...
0
votes
1answer
18 views
is reference block inside reference block is a good thing or bad?
Before anything, I already searched this online and didn't find anything satisfactory.
I was working on a project where I had to add an extra column in order items section of every place.
Everything ...
1
vote
2answers
84 views
How i can call SQL statement directly with magento 2
how to call SQL statements directly to database with Magento 2, This is not recommended, but in some situation we need to do this, for some very special tasks
0
votes
0answers
62 views
Magento 1.9 SQL Query to random show invoices product - costumer name and country , product name, image, invoice time
I need help with Magento 1.9 mySQL Query.
I would like to get the Mysql Query for random show buy-ed product (last 10day), customer name, customer country, product name, image url, invoice create time,...
1
vote
0answers
80 views
Magento 2 query builder conditional order by
I have this query builder, which works fine.
$collection->getSelect()->joinLeft(
'sales_order_item',
'e.entity_id = sales_order_item.product_id',
array('qty_ordered'=>'SUM(...
0
votes
3answers
171 views
Magento 2. What is the role of the search_query table
Magento 2.
What is the role of the search_query table?
Where is it used?
Should I ever clear it?
What would be the impact of clearing it?
0
votes
1answer
34 views
How to get data after adding attributes
So, I created adapter:
$adapter = $this->_getWriteAdapter();
After that I added some attributes for select:
$select = $adapter->select();
$select->from(array('o' => $this->getT...
$...
1
vote
1answer
98 views
Magento 2 update query with AND
I want to run a update query but it is not working with multiple conditions.
$where = ['parent_id' => (int)$shipmentId,
'order_item_id' => (int)$itemId,
];
...
0
votes
1answer
56 views
Magento 2 set updated_time through query
I want to update column "updated_time" through query but it is not working. Where I am wrong?
$where = ['entity_id' => (int)$customerData,
];
$connection->update(
...
0
votes
1answer
28 views
Configurable Product MSRP
I'm working on a query where I need to grab the MSRP from a simple product for orders placed to run some finance calculations (margin...).
The sales_flat_order_item table includes the configurable ...
4
votes
1answer
437 views
One to many relationship in M2
I am working on a module where I have to implement one to many relationship. I have one table for series with id and name field and one table series_product where I have id, series_id, product_id and ...
3
votes
2answers
671 views
How to Update a Column in Magento 1.9
How to make an "Update" query in Magento 1.9? I have no Idea how to do it.
I added "filtered" column in catalog_product_entity table.
I have the product I.D and here's my Query.
$productId = '9';
$...
0
votes
1answer
182 views
Magento 2 bind param to query in order by clause
I'm trying to bind params to order by with expressions clause in Magento 2, my insecure code looks like:
$order = new \Zend_Db_Expr("POW((main_table.long - $this->_coordinates['lat']), 2) + POW((...
0
votes
0answers
33 views
How to join tables in Magento 2 script
Table 1: Contains 3 records
Column names are att_id and name
Vinson
Yadhav
Vinay
Table 2: Contains 3 records
Column names are att_id and **age*
15
20
55
Table 3:Contains one record, here ...
1
vote
2answers
859 views
Cardinality violation: 1241 Operand should contain 1 column(s)
I am getting error when I run the below query in my database
Cardinality violation: 1241 Operand should contain 1 column(s)
SELECT `main_table`.*, COUNT( item1.product_id ) AS `i_count` FROM `...
0
votes
1answer
60 views
Convert a sql query to magento
I have two queries,
1.
{
$select = $this->_getReadAdapter()->select()->from(array('main_table' => $this->getMainStoreTable($category->getStoreId())), array('main_table....
0
votes
1answer
58 views
Magento 2: What's best way to convert MySql to Magento
I've below MySql query, I would like to change use it in Magento format.
How can i do that ?
SELECT customer_entity_varchar.value, customer_entity_text.value from customer_entity INNER JOIN ...
1
vote
1answer
163 views
SQL query: getting customer attributes (M1) - This type of clause was previously parsed
I'm trying to output customer information:
total sales
number of orders
email
dob
phone
firstname
lastname
country
state
zip code
I am using this to create custom reports using this plugin:
https://...
2
votes
1answer
915 views
Customer Repository Interface, Limit Results
I'm trying to grab the oldest customer, using the customer repository from the database.
Here's my code so far:
// if custom is active
$isActivefilter = $this->filter
->...
0
votes
1answer
288 views
Magento 2 : How to Write Conditional Query in Collection Method
How to write this query in magento2 collection method ?
SELECT o.increment_id, o.base_grand_total, h.status,o.created_at , h.created_at
FROM sales_order AS o
RIGHT JOIN sales_order_status_history AS ...
0
votes
2answers
89 views
Get Product id in magento2
Get product_Id using following query,
public function getProductsIdBySku($skus)
{
$select = $this->getReadConnection()
->select()
->from($this->...
0
votes
1answer
81 views
How copy all Categories attributes for store view A to default store view
I would like to copy categories attributes (e.g title, search engine optimization text like url_key, contents, description etc) from a store view navigation to the default navigation.
In other words,...
1
vote
1answer
874 views
Magento 2 direct sql query for insert not working
I was trying to insert values into mlx_cot_custom_option_type_value because module files are encrypted.I want to add something after product save
i am using catalog_product_save_after event
Here is ...
