Questions tagged [query]
Denotes the question related to database SQL query( in context of magento ).
234
questions
0
votes
0answers
23 views
Magento 2 Query to get Product with SKU also
I'm using an extension called M-Connect Autocomplete Search, I'm facing a problem that when user tries to search product by SKU like 3-SC, 3-SC-10, 3-SC-BL, 3-SC-BL-C but can't get any result, maybe ...
1
vote
1answer
40 views
Explanation about getSelect() join() joinLeft()
I don't understand these functions of Magento 1:
getSelect()
join()
joinLeft()
Where can I find a complete doc with all functions documentation ?
Thanks..
1
vote
0answers
18 views
Magento 2 : Which SQL query will be executed in attributes clean console command?
Does any one know which sql query will be executed while running below console command?
$ php bin/magento catalog:product:attributes:cleanup
1
vote
2answers
46 views
magento2 join query
I want to join the main table code with the product_options value giftcard_created_codes
My query till now
$this->getSelect()->joinLeft(['secondTable' => $this->getTable('...
2
votes
0answers
28 views
Magento 2.1.10: Sort by Special Price doesn't working
I'm working on category page, and try to sort the products collection by Special Price.
I've override setCollection() of \Magento\Catalog\Block\Product\ProductList\Toolbar
And the result is the only ...
2
votes
2answers
99 views
Magento 2: Allow empty query field in search
On the webshop that I'm working on, the user can find products by choosing filters (attributes like color/size/category) and/or entering a search query, the search results are then displayed on the ...
1
vote
1answer
16 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
41 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
23 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
24 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
21 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
62 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
24 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
51 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
286 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
65 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
20 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
444 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
184 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
48 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
60 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
38 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
30 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
69 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
29 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
41 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
46 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\...
5
votes
2answers
469 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
156 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
199 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
337 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
85 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
21 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
138 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
63 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
96 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
218 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
40 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
134 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
64 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
29 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
503 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 ...
4
votes
2answers
866 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
234 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((...
1
vote
2answers
1k 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
61 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
59 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
185 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://...
