2 exception(s): Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (NULL)' at line 8, query was: SELECT `klassificator_idx1`.`attribute_id`, `klassificator_idx1`.`value`, `klassificator_idx1`.`entity_id` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id IN(1) INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=277 INNER JOIN `catalog_product_index_eav` AS `quantity_and_stock_status_idx` ON quantity_and_stock_status_idx.entity_id = e.entity_id AND quantity_and_stock_status_idx.attribute_id = 258 AND quantity_and_stock_status_idx.store_id = '1' AND quantity_and_stock_status_idx.value IN (1) INNER JOIN `catalog_product_index_eav` AS `klassificator_idx1` ON klassificator_idx1.entity_id = e.entity_id AND klassificator_idx1.store_id = '1' AND klassificator_idx1.attribute_id = '168' WHERE AND (NULL) Exception #1 (PDOException): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (NULL)' at line 8 Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (NULL)' at line 8, query was: SELECT `klassificator_idx1`.`attribute_id`, `klassificator_idx1`.`value`, `klassificator_idx1`.`entity_id` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id IN(1) INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=277 INNER JOIN `catalog_product_index_eav` AS `quantity_and_stock_status_idx` ON quantity_and_stock_status_idx.entity_id = e.entity_id AND quantity_and_stock_status_idx.attribute_id = 258 AND quantity_and_stock_status_idx.store_id = '1' AND quantity_and_stock_status_idx.value IN (1) INNER JOIN `catalog_product_index_eav` AS `klassificator_idx1` ON klassificator_idx1.entity_id = e.entity_id AND klassificator_idx1.store_id = '1' AND klassificator_idx1.attribute_id = '168' WHERE AND (NULL)
#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:560] #5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:627] #6 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737] #7 Zend_Db_Adapter_Abstract->fetchAll() called at [vendor/swissup/module-ajaxlayerednavigation/Model/ResourceModel/Layer/Filter/Attribute.php:415] #8 Swissup\Ajaxlayerednavigation\Model\ResourceModel\Layer\Filter\Attribute->getRawFacetedDataSetV1() called at [vendor/swissup/module-ajaxlayerednavigation/Model/ResourceModel/Layer/Filter/Attribute.php:373] #9 Swissup\Ajaxlayerednavigation\Model\ResourceModel\Layer\Filter\Attribute->getRawFacetedData() called at [vendor/swissup/module-ajaxlayerednavigation/Model/ResourceModel/Layer/Filter/Attribute.php:486] #10 Swissup\Ajaxlayerednavigation\Model\ResourceModel\Layer\Filter\Attribute->getFacetedData() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/Attribute.php:205] #11 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\Attribute->getOptionsCustomFacetedData() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/Attribute.php:174] #12 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\Attribute->getOptionsFacetedData() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/Attribute.php:113] #13 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\Attribute->_getItemsData() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/AbstractFilter.php:311] #14 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\AbstractFilter->_initItems() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/AbstractFilter.php:288] #15 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\AbstractFilter->getItems() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/AbstractFilter.php:299] #16 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\AbstractFilter->getItemsCount() called at [vendor/swissup/module-ajaxlayerednavigation/view/frontend/templates/layer/view.phtml:40] #17 include() called at [vendor/magento/framework/View/TemplateEngine/Php.php:71] #18 Magento\Framework\View\TemplateEngine\Php->render() called at [vendor/magento/framework/Interception/Interceptor.php:58] #19 Magento\Framework\View\TemplateEngine\Php\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #20 Magento\Framework\View\TemplateEngine\Php\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #21 Magento\Framework\View\TemplateEngine\Php\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/TemplateEngine/Php/Interceptor.php:23] #22 Magento\Framework\View\TemplateEngine\Php\Interceptor->render() called at [vendor/magento/framework/View/Element/Template.php:273] #23 Magento\Framework\View\Element\Template->fetchView() called at [vendor/magento/framework/View/Element/Template.php:303] #24 Magento\Framework\View\Element\Template->_toHtml() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1111] #25 Magento\Framework\View\Element\AbstractBlock->Magento\Framework\View\Element\{closure}() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1115] #26 Magento\Framework\View\Element\AbstractBlock->_loadCache() called at [vendor/magento/framework/View/Element/AbstractBlock.php:675] #27 Magento\Framework\View\Element\AbstractBlock->toHtml() called at [vendor/magento/framework/View/Layout.php:578] #28 Magento\Framework\View\Layout->_renderBlock() called at [vendor/magento/framework/View/Layout.php:555] #29 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #30 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #31 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #32 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #33 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #34 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #35 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #36 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #37 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #38 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #39 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #40 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #41 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #42 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #43 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #44 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #45 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #46 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #47 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #48 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:975] #49 Magento\Framework\View\Layout->getOutput() called at [vendor/magento/framework/Interception/Interceptor.php:58] #50 Magento\Framework\View\Layout\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #51 Magento\Framework\View\Layout\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #52 Magento\Framework\View\Layout\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:41] #53 Magento\Framework\View\Layout\Interceptor->getOutput() called at [vendor/magento/framework/View/Result/Page.php:258] #54 Magento\Framework\View\Result\Page->render() called at [vendor/magento/framework/View/Result/Layout.php:171] #55 Magento\Framework\View\Result\Layout->renderResult() called at [vendor/magento/framework/Interception/Interceptor.php:58] #56 Magento\Framework\View\Result\Page\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #57 Magento\Framework\View\Result\Page\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #58 Magento\Framework\View\Result\Page\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Result/Page/Interceptor.php:23] #59 Magento\Framework\View\Result\Page\Interceptor->renderResult() called at [vendor/magento/framework/App/Http.php:120] #60 Magento\Framework\App\Http->launch() called at [vendor/magento/framework/App/Bootstrap.php:263] #61 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:29]Exception #1 (PDOException): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (NULL)' at line 8
#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:560] #7 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:627] #8 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737] #9 Zend_Db_Adapter_Abstract->fetchAll() called at [vendor/swissup/module-ajaxlayerednavigation/Model/ResourceModel/Layer/Filter/Attribute.php:415] #10 Swissup\Ajaxlayerednavigation\Model\ResourceModel\Layer\Filter\Attribute->getRawFacetedDataSetV1() called at [vendor/swissup/module-ajaxlayerednavigation/Model/ResourceModel/Layer/Filter/Attribute.php:373] #11 Swissup\Ajaxlayerednavigation\Model\ResourceModel\Layer\Filter\Attribute->getRawFacetedData() called at [vendor/swissup/module-ajaxlayerednavigation/Model/ResourceModel/Layer/Filter/Attribute.php:486] #12 Swissup\Ajaxlayerednavigation\Model\ResourceModel\Layer\Filter\Attribute->getFacetedData() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/Attribute.php:205] #13 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\Attribute->getOptionsCustomFacetedData() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/Attribute.php:174] #14 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\Attribute->getOptionsFacetedData() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/Attribute.php:113] #15 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\Attribute->_getItemsData() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/AbstractFilter.php:311] #16 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\AbstractFilter->_initItems() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/AbstractFilter.php:288] #17 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\AbstractFilter->getItems() called at [vendor/swissup/module-ajaxlayerednavigation/Model/Layer/Filter/AbstractFilter.php:299] #18 Swissup\Ajaxlayerednavigation\Model\Layer\Filter\AbstractFilter->getItemsCount() called at [vendor/swissup/module-ajaxlayerednavigation/view/frontend/templates/layer/view.phtml:40] #19 include() called at [vendor/magento/framework/View/TemplateEngine/Php.php:71] #20 Magento\Framework\View\TemplateEngine\Php->render() called at [vendor/magento/framework/Interception/Interceptor.php:58] #21 Magento\Framework\View\TemplateEngine\Php\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #22 Magento\Framework\View\TemplateEngine\Php\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #23 Magento\Framework\View\TemplateEngine\Php\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/TemplateEngine/Php/Interceptor.php:23] #24 Magento\Framework\View\TemplateEngine\Php\Interceptor->render() called at [vendor/magento/framework/View/Element/Template.php:273] #25 Magento\Framework\View\Element\Template->fetchView() called at [vendor/magento/framework/View/Element/Template.php:303] #26 Magento\Framework\View\Element\Template->_toHtml() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1111] #27 Magento\Framework\View\Element\AbstractBlock->Magento\Framework\View\Element\{closure}() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1115] #28 Magento\Framework\View\Element\AbstractBlock->_loadCache() called at [vendor/magento/framework/View/Element/AbstractBlock.php:675] #29 Magento\Framework\View\Element\AbstractBlock->toHtml() called at [vendor/magento/framework/View/Layout.php:578] #30 Magento\Framework\View\Layout->_renderBlock() called at [vendor/magento/framework/View/Layout.php:555] #31 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #32 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #33 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #34 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #35 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #36 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #37 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #38 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #39 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #40 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #41 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #42 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #43 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #44 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #45 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #46 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #47 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:606] #48 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557] #49 Magento\Framework\View\Layout->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510] #50 Magento\Framework\View\Layout->renderElement() called at [vendor/magento/framework/View/Layout.php:975] #51 Magento\Framework\View\Layout->getOutput() called at [vendor/magento/framework/Interception/Interceptor.php:58] #52 Magento\Framework\View\Layout\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #53 Magento\Framework\View\Layout\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #54 Magento\Framework\View\Layout\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:41] #55 Magento\Framework\View\Layout\Interceptor->getOutput() called at [vendor/magento/framework/View/Result/Page.php:258] #56 Magento\Framework\View\Result\Page->render() called at [vendor/magento/framework/View/Result/Layout.php:171] #57 Magento\Framework\View\Result\Layout->renderResult() called at [vendor/magento/framework/Interception/Interceptor.php:58] #58 Magento\Framework\View\Result\Page\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #59 Magento\Framework\View\Result\Page\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #60 Magento\Framework\View\Result\Page\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Result/Page/Interceptor.php:23] #61 Magento\Framework\View\Result\Page\Interceptor->renderResult() called at [vendor/magento/framework/App/Http.php:120] #62 Magento\Framework\App\Http->launch() called at [vendor/magento/framework/App/Bootstrap.php:263] #63 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:29]