2 exception(s): Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'price' in where clause is ambiguous, query was: SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`name`, `e`.`short_description`, `e`.`description`, `e`.`price`, `e`.`thumbnail`, `e`.`special_price`, `e`.`special_to_date`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`sku_policy` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (final_price < price) AND (stock_status_index.stock_status = 1) ORDER BY `e`.`name` asc Exception #1 (PDOException): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'price' in where clause is ambiguous Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'price' in where clause is ambiguous, query was: SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`name`, `e`.`short_description`, `e`.`description`, `e`.`price`, `e`.`thumbnail`, `e`.`special_price`, `e`.`special_to_date`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`sku_policy` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (final_price < price) AND (stock_status_index.stock_status = 1) ORDER BY `e`.`name` asc
#1 Magento\Framework\DB\Statement\Pdo\Mysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303] #2 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480] #3 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238] #4 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:546] #5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:613] #6 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:128] #7 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737] #8 Zend_Db_Adapter_Abstract->fetchAll() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:1558] #9 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->fetchAll() called at [vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php:21] #10 Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:782] #11 Magento\Framework\Data\Collection\AbstractDb->_fetchAll() called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:1130] #12 Magento\Eav\Model\Entity\Collection\AbstractCollection->_loadEntities() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1129] #13 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->_loadEntities() called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:927] #14 Magento\Eav\Model\Entity\Collection\AbstractCollection->load() called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:832] #15 Magento\Catalog\Model\ResourceModel\Product\Collection->load() called at [vendor/magento/framework/Interception/Interceptor.php:58] #16 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #17 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #18 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callPlugins() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:195] #19 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->load() called at [vendor/magento/framework/Data/Collection.php:838] #20 Magento\Framework\Data\Collection->getIterator() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1779] #21 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getIterator() called at [vendor/magento/module-catalog/Block/Rss/Product/Special.php:130] #22 Magento\Catalog\Block\Rss\Product\Special->getRssData() called at [vendor/magento/module-rss/Model/Rss.php:78] #23 Magento\Rss\Model\Rss->getFeeds() called at [vendor/magento/module-rss/Model/Rss.php:109] #24 Magento\Rss\Model\Rss->createRssXml() called at [vendor/magento/module-rss/Controller/Feed/Index.php:49] #25 Magento\Rss\Controller\Feed\Index->execute() called at [vendor/magento/framework/Interception/Interceptor.php:58] #26 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #27 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #28 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins() called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:26] #29 Magento\Rss\Controller\Feed\Index\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:108] #30 Magento\Framework\App\Action\Action->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #31 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #32 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #33 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins() called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:39] #34 Magento\Rss\Controller\Feed\Index\Interceptor->dispatch() called at [vendor/magento/framework/App/FrontController.php:162] #35 Magento\Framework\App\FrontController->processRequest() called at [vendor/magento/framework/App/FrontController.php:98] #36 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #37 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #38 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:99] #39 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #40 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [app/code/Amasty/InvisibleCaptcha/Plugin/Framework/App/FrontControllerInterface/ValidateCaptcha.php:118] #41 Amasty\InvisibleCaptcha\Plugin\Framework\App\FrontControllerInterface\ValidateCaptcha->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #42 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:69] #43 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #44 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #45 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #46 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->___callPlugins() called at [generated/code/Magento/PageCache/Model/App/FrontController/BuiltinPlugin/Interceptor.php:26] #47 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #48 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #49 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:26] #50 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:116] #51 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:24] #52 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:261] #53 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:40]Exception #1 (PDOException): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'price' in where clause is ambiguous
#1 Magento\Framework\DB\Statement\Pdo\Mysql->Magento\Framework\DB\Statement\Pdo\{closure}() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:107] #2 Magento\Framework\DB\Statement\Pdo\Mysql->tryExecute() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:92] #3 Magento\Framework\DB\Statement\Pdo\Mysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303] #4 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480] #5 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238] #6 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:546] #7 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:613] #8 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:128] #9 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737] #10 Zend_Db_Adapter_Abstract->fetchAll() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:1558] #11 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->fetchAll() called at [vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php:21] #12 Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:782] #13 Magento\Framework\Data\Collection\AbstractDb->_fetchAll() called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:1130] #14 Magento\Eav\Model\Entity\Collection\AbstractCollection->_loadEntities() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1129] #15 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->_loadEntities() called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:927] #16 Magento\Eav\Model\Entity\Collection\AbstractCollection->load() called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:832] #17 Magento\Catalog\Model\ResourceModel\Product\Collection->load() called at [vendor/magento/framework/Interception/Interceptor.php:58] #18 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #19 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #20 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callPlugins() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:195] #21 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->load() called at [vendor/magento/framework/Data/Collection.php:838] #22 Magento\Framework\Data\Collection->getIterator() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1779] #23 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getIterator() called at [vendor/magento/module-catalog/Block/Rss/Product/Special.php:130] #24 Magento\Catalog\Block\Rss\Product\Special->getRssData() called at [vendor/magento/module-rss/Model/Rss.php:78] #25 Magento\Rss\Model\Rss->getFeeds() called at [vendor/magento/module-rss/Model/Rss.php:109] #26 Magento\Rss\Model\Rss->createRssXml() called at [vendor/magento/module-rss/Controller/Feed/Index.php:49] #27 Magento\Rss\Controller\Feed\Index->execute() called at [vendor/magento/framework/Interception/Interceptor.php:58] #28 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #29 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #30 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins() called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:26] #31 Magento\Rss\Controller\Feed\Index\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:108] #32 Magento\Framework\App\Action\Action->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #33 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #34 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #35 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins() called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:39] #36 Magento\Rss\Controller\Feed\Index\Interceptor->dispatch() called at [vendor/magento/framework/App/FrontController.php:162] #37 Magento\Framework\App\FrontController->processRequest() called at [vendor/magento/framework/App/FrontController.php:98] #38 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #39 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #40 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:99] #41 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #42 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [app/code/Amasty/InvisibleCaptcha/Plugin/Framework/App/FrontControllerInterface/ValidateCaptcha.php:118] #43 Amasty\InvisibleCaptcha\Plugin\Framework\App\FrontControllerInterface\ValidateCaptcha->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #44 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:69] #45 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #46 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #47 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #48 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->___callPlugins() called at [generated/code/Magento/PageCache/Model/App/FrontController/BuiltinPlugin/Interceptor.php:26] #49 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #50 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #51 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:26] #52 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:116] #53 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:24] #54 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:261] #55 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:40]