Magento 2 Error filtering template?How to add date filed in admin & show on front in magento2Magento 2 CMS Page getList() repository methods does not return expected objectmain.CRITICAL: Plugin class doesn't existModel Override issue in magento 2Magento 2.1 Create a filter in the product grid by new attributeI have created an extension to show Customer Company Name in Order grid. But when creating new order, order is not showing in order gridHaving trouble exporting products from Magento 2.x. Fatal error: Uncaught Error: Call to a member function getName()Magento offline custom Payment method with drop down listMagento 2: How to override model resource configurable fileMagento 2.3 Can't view module's front end page output?
Why do we use polarized capacitors?
Some basic questions on halt and move in Turing machines
How do you conduct xenoanthropology after first contact?
Is it legal to have the "// (c) 2019 John Smith" header in all files when there are hundreds of contributors?
Sort in WP_Query(), not filter? Is it possible?
Is every set a filtered colimit of finite sets?
I see my dog run
Is repealing the EU Withdrawal Act a precondition of revoking Article 50?
How can I fix this gap between bookcases I made?
Patience, young "Padovan"
Wild Shape Centaur Into a Giant Elk: do their Charges stack?
How to create a consistant feel for character names in a fantasy setting?
What happens when a metallic dragon and a chromatic dragon mate?
Domain expired, GoDaddy holds it and is asking more money
How to answer pointed "are you quitting" questioning when I don't want them to suspect
Why is making salt water prohibited on Shabbat?
OA final episode explanation
Mapping arrows in commutative diagrams
LM317 - Calculate dissipation due to voltage drop
Could a US political party gain complete control over the government by removing checks & balances?
Need help identifying/translating a plaque in Tangier, Morocco
Shall I use personal or official e-mail account when registering to external websites for work purpose?
Crop image to path created in TikZ?
Information to fellow intern about hiring?
Magento 2 Error filtering template?
How to add date filed in admin & show on front in magento2Magento 2 CMS Page getList() repository methods does not return expected objectmain.CRITICAL: Plugin class doesn't existModel Override issue in magento 2Magento 2.1 Create a filter in the product grid by new attributeI have created an extension to show Customer Company Name in Order grid. But when creating new order, order is not showing in order gridHaving trouble exporting products from Magento 2.x. Fatal error: Uncaught Error: Call to a member function getName()Magento offline custom Payment method with drop down listMagento 2: How to override model resource configurable fileMagento 2.3 Can't view module's front end page output?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
After installed module we are getting one error message called
"Error filtering template: You cannot define a correlation name
'stock' more than once"
Mentioned with below code. Can anyone advise how to solve?
<?php
/**
* @package Interjar_ConfigurableChildVisibility
* @author Interjar Ltd
* @author Josh Carter <josh@interjar.com>
*/
declare(strict_types=1);
namespace InterjarConfigurableChildVisibilityModelResourceModelProduct;
use MagentoFrameworkDBSelect;
use MagentoCatalogModelResourceModelProductBaseSelectProcessorInterface;
use MagentoCatalogInventoryApiStockConfigurationInterface;
use MagentoCatalogInventoryModelStockStatus as StockStatus;
use MagentoCatalogInventoryModelResourceModelStockStatus as StockStatusResource;
class StockStatusBaseSelectProcessor implements BaseSelectProcessorInterface
/**
* @var StockConfigurationInterface
*/
private $stockConfig;
/**
* @var StockStatusResource
*/
private $stockStatusResource;
/**
* @param StockConfigurationInterface $stockConfig
* @param StockStatusResource $stockStatusResource
*/
public function __construct(
StockConfigurationInterface $stockConfig,
StockStatusResource $stockStatusResource
)
$this->stockConfig = $stockConfig;
$this->stockStatusResource = $stockStatusResource;
/**
* @inheritdoc
*/
public function process(Select $select)
if (!$this->stockConfig->isShowOutOfStock())
$select->joinInner(
['stock' => $this->stockStatusResource->getMainTable()],
sprintf(
'stock.product_id = %s.entity_id',
BaseSelectProcessorInterface::PRODUCT_TABLE_ALIAS
),
[]
)->where(
'stock.stock_status = ?',
StockStatus::STATUS_IN_STOCK
);
return $select;
magento2 template stock inventory
asked Apr 5 at 5:28
Nagaraju KasaNagaraju Kasa
2,75821541
add a comment |
After installed module we are getting one error message called
"Error filtering template: You cannot define a correlation name
'stock' more than once"
Mentioned with below code. Can anyone advise how to solve?
<?php
/**
* @package Interjar_ConfigurableChildVisibility
* @author Interjar Ltd
* @author Josh Carter <josh@interjar.com>
*/
declare(strict_types=1);
namespace InterjarConfigurableChildVisibilityModelResourceModelProduct;
use MagentoFrameworkDBSelect;
use MagentoCatalogModelResourceModelProductBaseSelectProcessorInterface;
use MagentoCatalogInventoryApiStockConfigurationInterface;
use MagentoCatalogInventoryModelStockStatus as StockStatus;
use MagentoCatalogInventoryModelResourceModelStockStatus as StockStatusResource;
class StockStatusBaseSelectProcessor implements BaseSelectProcessorInterface
/**
* @var StockConfigurationInterface
*/
private $stockConfig;
/**
* @var StockStatusResource
*/
private $stockStatusResource;
/**
* @param StockConfigurationInterface $stockConfig
* @param StockStatusResource $stockStatusResource
*/
public function __construct(
StockConfigurationInterface $stockConfig,
StockStatusResource $stockStatusResource
)
$this->stockConfig = $stockConfig;
$this->stockStatusResource = $stockStatusResource;
/**
* @inheritdoc
*/
public function process(Select $select)
if (!$this->stockConfig->isShowOutOfStock())
$select->joinInner(
['stock' => $this->stockStatusResource->getMainTable()],
sprintf(
'stock.product_id = %s.entity_id',
BaseSelectProcessorInterface::PRODUCT_TABLE_ALIAS
),
[]
)->where(
'stock.stock_status = ?',
StockStatus::STATUS_IN_STOCK
);
return $select;
magento2 template stock inventory
asked Apr 5 at 5:28
Nagaraju KasaNagaraju Kasa
2,75821541
what for is thesin%s.entity_id? I think the error comes from there
– magefms
Apr 5 at 5:42
add a comment |
After installed module we are getting one error message called
"Error filtering template: You cannot define a correlation name
'stock' more than once"
Mentioned with below code. Can anyone advise how to solve?
<?php
/**
* @package Interjar_ConfigurableChildVisibility
* @author Interjar Ltd
* @author Josh Carter <josh@interjar.com>
*/
declare(strict_types=1);
namespace InterjarConfigurableChildVisibilityModelResourceModelProduct;
use MagentoFrameworkDBSelect;
use MagentoCatalogModelResourceModelProductBaseSelectProcessorInterface;
use MagentoCatalogInventoryApiStockConfigurationInterface;
use MagentoCatalogInventoryModelStockStatus as StockStatus;
use MagentoCatalogInventoryModelResourceModelStockStatus as StockStatusResource;
class StockStatusBaseSelectProcessor implements BaseSelectProcessorInterface
/**
* @var StockConfigurationInterface
*/
private $stockConfig;
/**
* @var StockStatusResource
*/
private $stockStatusResource;
/**
* @param StockConfigurationInterface $stockConfig
* @param StockStatusResource $stockStatusResource
*/
public function __construct(
StockConfigurationInterface $stockConfig,
StockStatusResource $stockStatusResource
)
$this->stockConfig = $stockConfig;
$this->stockStatusResource = $stockStatusResource;
/**
* @inheritdoc
*/
public function process(Select $select)
if (!$this->stockConfig->isShowOutOfStock())
$select->joinInner(
['stock' => $this->stockStatusResource->getMainTable()],
sprintf(
'stock.product_id = %s.entity_id',
BaseSelectProcessorInterface::PRODUCT_TABLE_ALIAS
),
[]
)->where(
'stock.stock_status = ?',
StockStatus::STATUS_IN_STOCK
);
return $select;
magento2 template stock inventory
asked Apr 5 at 5:28
Nagaraju KasaNagaraju Kasa
2,75821541
After installed module we are getting one error message called
"Error filtering template: You cannot define a correlation name
'stock' more than once"
Mentioned with below code. Can anyone advise how to solve?
<?php
/**
* @package Interjar_ConfigurableChildVisibility
* @author Interjar Ltd
* @author Josh Carter <josh@interjar.com>
*/
declare(strict_types=1);
namespace InterjarConfigurableChildVisibilityModelResourceModelProduct;
use MagentoFrameworkDBSelect;
use MagentoCatalogModelResourceModelProductBaseSelectProcessorInterface;
use MagentoCatalogInventoryApiStockConfigurationInterface;
use MagentoCatalogInventoryModelStockStatus as StockStatus;
use MagentoCatalogInventoryModelResourceModelStockStatus as StockStatusResource;
class StockStatusBaseSelectProcessor implements BaseSelectProcessorInterface
/**
* @var StockConfigurationInterface
*/
private $stockConfig;
/**
* @var StockStatusResource
*/
private $stockStatusResource;
/**
* @param StockConfigurationInterface $stockConfig
* @param StockStatusResource $stockStatusResource
*/
public function __construct(
StockConfigurationInterface $stockConfig,
StockStatusResource $stockStatusResource
)
$this->stockConfig = $stockConfig;
$this->stockStatusResource = $stockStatusResource;
/**
* @inheritdoc
*/
public function process(Select $select)
if (!$this->stockConfig->isShowOutOfStock())
$select->joinInner(
['stock' => $this->stockStatusResource->getMainTable()],
sprintf(
'stock.product_id = %s.entity_id',
BaseSelectProcessorInterface::PRODUCT_TABLE_ALIAS
),
[]
)->where(
'stock.stock_status = ?',
StockStatus::STATUS_IN_STOCK
);
return $select;
magento2 template stock inventory
magento2 template stock inventory
asked Apr 5 at 5:28
Nagaraju KasaNagaraju Kasa
2,75821541
asked Apr 5 at 5:28
Nagaraju KasaNagaraju Kasa
2,75821541
edited Apr 5 at 5:34
Nagaraju Kasa
asked Apr 5 at 5:28
Nagaraju KasaNagaraju Kasa
2,75821541
asked Apr 5 at 5:28
Nagaraju KasaNagaraju Kasa
2,75821541
asked Apr 5 at 5:28
Nagaraju KasaNagaraju Kasa
2,75821541
2,75821541
what for is thesin%s.entity_id? I think the error comes from there
– magefms
Apr 5 at 5:42
add a comment |
what for is thesin%s.entity_id? I think the error comes from there
– magefms
Apr 5 at 5:42
what for is the
s in %s.entity_id? I think the error comes from there– magefms
Apr 5 at 5:42
what for is the
s in %s.entity_id? I think the error comes from there– magefms
Apr 5 at 5:42
add a comment |
1 Answer
1
active
oldest
votes
Print and debug the $select , it seems that stock or 'stock' => $this->stockStatusResource->getMainTable() has already been in the select query and you are trying to join it again.
answered Apr 5 at 5:34
Anshu MishraAnshu Mishra
5,65652662
Thanks for the reply @ansgy mishra so can u show me how to change that process method.?
– Nagaraju Kasa
Apr 5 at 5:36
@NagarajuKasa Share the printed result of the query.
– Anshu Mishra
Apr 5 at 6:12
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f268858%2fmagento-2-error-filtering-template%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Print and debug the $select , it seems that stock or 'stock' => $this->stockStatusResource->getMainTable() has already been in the select query and you are trying to join it again.
answered Apr 5 at 5:34
Anshu MishraAnshu Mishra
5,65652662
Thanks for the reply @ansgy mishra so can u show me how to change that process method.?
– Nagaraju Kasa
Apr 5 at 5:36
@NagarajuKasa Share the printed result of the query.
– Anshu Mishra
Apr 5 at 6:12
add a comment |
Print and debug the $select , it seems that stock or 'stock' => $this->stockStatusResource->getMainTable() has already been in the select query and you are trying to join it again.
answered Apr 5 at 5:34
Anshu MishraAnshu Mishra
5,65652662
Thanks for the reply @ansgy mishra so can u show me how to change that process method.?
– Nagaraju Kasa
Apr 5 at 5:36
@NagarajuKasa Share the printed result of the query.
– Anshu Mishra
Apr 5 at 6:12
add a comment |
Print and debug the $select , it seems that stock or 'stock' => $this->stockStatusResource->getMainTable() has already been in the select query and you are trying to join it again.
answered Apr 5 at 5:34
Anshu MishraAnshu Mishra
5,65652662
Print and debug the $select , it seems that stock or 'stock' => $this->stockStatusResource->getMainTable() has already been in the select query and you are trying to join it again.
answered Apr 5 at 5:34
Anshu MishraAnshu Mishra
5,65652662
answered Apr 5 at 5:34
Anshu MishraAnshu Mishra
5,65652662
answered Apr 5 at 5:34
Anshu MishraAnshu Mishra
5,65652662
answered Apr 5 at 5:34
Anshu MishraAnshu Mishra
5,65652662
5,65652662
Thanks for the reply @ansgy mishra so can u show me how to change that process method.?
– Nagaraju Kasa
Apr 5 at 5:36
@NagarajuKasa Share the printed result of the query.
– Anshu Mishra
Apr 5 at 6:12
add a comment |
Thanks for the reply @ansgy mishra so can u show me how to change that process method.?
– Nagaraju Kasa
Apr 5 at 5:36
@NagarajuKasa Share the printed result of the query.
– Anshu Mishra
Apr 5 at 6:12
Thanks for the reply @ansgy mishra so can u show me how to change that process method.?
– Nagaraju Kasa
Apr 5 at 5:36
Thanks for the reply @ansgy mishra so can u show me how to change that process method.?
– Nagaraju Kasa
Apr 5 at 5:36
@NagarajuKasa Share the printed result of the query.
– Anshu Mishra
Apr 5 at 6:12
@NagarajuKasa Share the printed result of the query.
– Anshu Mishra
Apr 5 at 6:12
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f268858%2fmagento-2-error-filtering-template%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
what for is the
sin%s.entity_id? I think the error comes from there– magefms
Apr 5 at 5:42