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 ')) ORDER BY `e`.`sku` ASC' at line 1, query was: SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`color`, `e`.`color_value`, `e`.`cost`, `e`.`created_at`, `e`.`description`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`image_label`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`main_color`, `e`.`main_color_value`, `e`.`mgs_brand`, `e`.`mgs_brand_value`, `e`.`mgs_j360`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`required_options`, `e`.`short_description`, `e`.`silhouette`, `e`.`size`, `e`.`size_value`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`stock_brasschaat`, `e`.`stock_gent`, `e`.`stock_kraainem`, `e`.`stock_waterloo`, `e`.`stock_wavre`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`ts_dimensions_height`, `e`.`ts_dimensions_length`, `e`.`ts_dimensions_width`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`weight`, `e`.`weight_type` FROM `catalog_product_flat_1` AS `e` WHERE (((e.required_options != 1))) AND (e.entity_id IN()) ORDER BY `e`.`sku` ASC 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 ')) ORDER BY `e`.`sku` ASC' at line 1 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 ')) ORDER BY `e`.`sku` ASC' at line 1, query was: SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`color`, `e`.`color_value`, `e`.`cost`, `e`.`created_at`, `e`.`description`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`image_label`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`main_color`, `e`.`main_color_value`, `e`.`mgs_brand`, `e`.`mgs_brand_value`, `e`.`mgs_j360`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`required_options`, `e`.`short_description`, `e`.`silhouette`, `e`.`size`, `e`.`size_value`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`stock_brasschaat`, `e`.`stock_gent`, `e`.`stock_kraainem`, `e`.`stock_waterloo`, `e`.`stock_wavre`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`ts_dimensions_height`, `e`.`ts_dimensions_length`, `e`.`ts_dimensions_width`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`weight`, `e`.`weight_type` FROM `catalog_product_flat_1` AS `e` WHERE (((e.required_options != 1))) AND (e.entity_id IN()) ORDER BY `e`.`sku` ASC #0 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/vwww/www.anne-sophie.be/www/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array) #2 /var/vwww/www.anne-sophie.be/www/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /var/vwww/www.anne-sophie.be/www/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT 1 AS `st...', Array) #4 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(533): Zend_Db_Adapter_Pdo_Abstract->query('SELECT 1 AS `st...', Array) #5 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(605): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT 1 AS `st...', Array) #6 /var/vwww/www.anne-sophie.be/www/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(737): Magento\Framework\DB\Adapter\Pdo\Mysql->query(Object(Magento\Framework\DB\Select), Array) #7 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php(21): Zend_Db_Adapter_Abstract->fetchAll(Object(Magento\Framework\DB\Select), Array) #8 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Data/Collection/AbstractDb.php(774): Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll(Object(Magento\Framework\DB\Select), Array) #9 /var/vwww/www.anne-sophie.be/www/vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php(1115): Magento\Framework\Data\Collection\AbstractDb->_fetchAll(Object(Magento\Framework\DB\Select)) #10 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(1129): Magento\Eav\Model\Entity\Collection\AbstractCollection->_loadEntities(false, false) #11 /var/vwww/www.anne-sophie.be/www/vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php(913): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->_loadEntities(false, false) #12 /var/vwww/www.anne-sophie.be/www/vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php(777): Magento\Eav\Model\Entity\Collection\AbstractCollection->load(false, false) #13 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Catalog\Model\ResourceModel\Product\Collection->load(false, false) #14 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callParent('load', Array) #15 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->Magento\Framework\Interception\{closure}() #16 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(195): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callPlugins('load', Array, Array) #17 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Data/Collection.php(831): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->load() #18 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(1766): Magento\Framework\Data\Collection->getIterator() #19 /var/vwww/www.anne-sophie.be/www/app/code/Kinamo/AnneSophieCustom/Block/StockInStores.php(114): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getIterator() #20 /var/vwww/www.anne-sophie.be/www/generated/code/Kinamo/AnneSophieCustom/Block/StockInStores/Interceptor.php(63): Kinamo\AnneSophieCustom\Block\StockInStores->getAllColors() #21 /var/vwww/www.anne-sophie.be/www/app/design/frontend/Mgs/claue_child/Kinamo_AnneSophieCustom/templates/stock-in-stores.phtml(103): Kinamo\AnneSophieCustom\Block\StockInStores\Interceptor->getAllColors() #22 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/var/vwww/www.a...') #23 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/Template.php(270): Magento\Framework\View\TemplateEngine\Php->render(Object(Kinamo\AnneSophieCustom\Block\StockInStores\Interceptor), '/var/vwww/www.a...', Array) #24 /var/vwww/www.anne-sophie.be/www/generated/code/Kinamo/AnneSophieCustom/Block/StockInStores/Interceptor.php(687): Magento\Framework\View\Element\Template->fetchView('/var/vwww/www.a...') #25 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/Template.php(300): Kinamo\AnneSophieCustom\Block\StockInStores\Interceptor->fetchView('/var/vwww/www.a...') #26 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/AbstractBlock.php(667): Magento\Framework\View\Element\Template->_toHtml() #27 /var/vwww/www.anne-sophie.be/www/generated/code/Kinamo/AnneSophieCustom/Block/StockInStores/Interceptor.php(999): Magento\Framework\View\Element\AbstractBlock->toHtml() #28 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(557): Kinamo\AnneSophieCustom\Block\StockInStores\Interceptor->toHtml() #29 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(533): Magento\Framework\View\Layout->_renderBlock('product.physica...') #30 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('product.physica...') #31 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('product.physica...') #32 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('product.physica...', false) #33 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('product.physica...', false) #34 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('product.info.ty...', false) #35 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('product.info.ty...') #36 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('product.info.ty...') #37 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('product.info.ty...', true) #38 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/AbstractBlock.php(507): Magento\Framework\View\Layout\Interceptor->renderElement('product.info.ty...', true) #39 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Block/Product/View/Interceptor.php(778): Magento\Framework\View\Element\AbstractBlock->getChildHtml('product.info.ty...', true) #40 /var/vwww/www.anne-sophie.be/www/app/design/frontend/Mgs/claue_child/Magento_Catalog/templates/product/view/detail_layout.phtml(142): Magento\Catalog\Block\Product\View\Interceptor->getChildHtml('product.info.ty...') #41 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/var/vwww/www.a...') #42 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/Template.php(270): Magento\Framework\View\TemplateEngine\Php->render(Object(Magento\Catalog\Block\Product\View\Interceptor), '/var/vwww/www.a...', Array) #43 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Block/Product/View/Interceptor.php(544): Magento\Framework\View\Element\Template->fetchView('/var/vwww/www.a...') #44 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/Template.php(300): Magento\Catalog\Block\Product\View\Interceptor->fetchView('/var/vwww/www.a...') #45 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/AbstractBlock.php(667): Magento\Framework\View\Element\Template->_toHtml() #46 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Block/Product/View/Interceptor.php(869): Magento\Framework\View\Element\AbstractBlock->toHtml() #47 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(557): Magento\Catalog\Block\Product\View\Interceptor->toHtml() #48 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(533): Magento\Framework\View\Layout->_renderBlock('product.detail....') #49 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('product.detail....') #50 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('product.detail....') #51 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('product.detail....', false) #52 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('product.detail....', false) #53 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('content', false) #54 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('content') #55 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('content') #56 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('content', false) #57 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('content', false) #58 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('main', false) #59 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('main') #60 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('main') #61 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('main', false) #62 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('main', false) #63 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('columns', false) #64 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('columns') #65 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('columns') #66 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('columns', false) #67 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('columns', false) #68 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('main.content', false) #69 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('main.content') #70 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('main.content') #71 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('main.content', false) #72 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('main.content', false) #73 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('page.wrapper', false) #74 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('page.wrapper') #75 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('page.wrapper') #76 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('page.wrapper', false) #77 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('page.wrapper', false) #78 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('root', false) #79 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('root') #80 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('root') #81 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('root', true) #82 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(954): Magento\Framework\View\Layout\Interceptor->renderElement('root') #83 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\View\Layout->getOutput() #84 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\View\Layout\Interceptor->___callParent('getOutput', Array) #85 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\View\Layout\Interceptor->Magento\Framework\Interception\{closure}() #86 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(494): Magento\Framework\View\Layout\Interceptor->___callPlugins('getOutput', Array, Array) #87 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Result/Page.php(257): Magento\Framework\View\Layout\Interceptor->getOutput() #88 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Result/Layout.php(170): Magento\Framework\View\Result\Page->render(Object(Magento\Framework\App\Response\Http\Interceptor)) #89 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\View\Result\Layout->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor)) #90 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(138): MGS\Mpanel\Block\Framework\Page\Interceptor->___callParent('renderResult', Array) #91 /var/vwww/www.anne-sophie.be/www/app/code/Aheadworks/Layerednav/Model/Plugin/Result.php(93): MGS\Mpanel\Block\Framework\Page\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Response\Http\Interceptor)) #92 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(135): Aheadworks\Layerednav\Model\Plugin\Result->aroundRenderResult(Object(MGS\Mpanel\Block\Framework\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor)) #93 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(153): MGS\Mpanel\Block\Framework\Page\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Response\Http\Interceptor)) #94 /var/vwww/www.anne-sophie.be/www/generated/code/MGS/Mpanel/Block/Framework/Page/Interceptor.php(156): MGS\Mpanel\Block\Framework\Page\Interceptor->___callPlugins('renderResult', Array, Array) #95 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/App/Http.php(139): MGS\Mpanel\Block\Framework\Page\Interceptor->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor)) #96 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/App/Http/Interceptor.php(24): Magento\Framework\App\Http->launch() #97 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/App/Bootstrap.php(257): Magento\Framework\App\Http\Interceptor->launch() #98 /var/vwww/www.anne-sophie.be/www/pub/index.php(44): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http\Interceptor)) #99 {main} 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 ')) ORDER BY `e`.`sku` ASC' at line 1 #0 /var/vwww/www.anne-sophie.be/www/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/vwww/www.anne-sophie.be/www/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array) #3 /var/vwww/www.anne-sophie.be/www/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #4 /var/vwww/www.anne-sophie.be/www/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT 1 AS `st...', Array) #5 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(533): Zend_Db_Adapter_Pdo_Abstract->query('SELECT 1 AS `st...', Array) #6 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(605): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT 1 AS `st...', Array) #7 /var/vwww/www.anne-sophie.be/www/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(737): Magento\Framework\DB\Adapter\Pdo\Mysql->query(Object(Magento\Framework\DB\Select), Array) #8 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php(21): Zend_Db_Adapter_Abstract->fetchAll(Object(Magento\Framework\DB\Select), Array) #9 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Data/Collection/AbstractDb.php(774): Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll(Object(Magento\Framework\DB\Select), Array) #10 /var/vwww/www.anne-sophie.be/www/vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php(1115): Magento\Framework\Data\Collection\AbstractDb->_fetchAll(Object(Magento\Framework\DB\Select)) #11 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(1129): Magento\Eav\Model\Entity\Collection\AbstractCollection->_loadEntities(false, false) #12 /var/vwww/www.anne-sophie.be/www/vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php(913): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->_loadEntities(false, false) #13 /var/vwww/www.anne-sophie.be/www/vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php(777): Magento\Eav\Model\Entity\Collection\AbstractCollection->load(false, false) #14 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Catalog\Model\ResourceModel\Product\Collection->load(false, false) #15 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callParent('load', Array) #16 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->Magento\Framework\Interception\{closure}() #17 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(195): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callPlugins('load', Array, Array) #18 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Data/Collection.php(831): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->load() #19 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(1766): Magento\Framework\Data\Collection->getIterator() #20 /var/vwww/www.anne-sophie.be/www/app/code/Kinamo/AnneSophieCustom/Block/StockInStores.php(114): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getIterator() #21 /var/vwww/www.anne-sophie.be/www/generated/code/Kinamo/AnneSophieCustom/Block/StockInStores/Interceptor.php(63): Kinamo\AnneSophieCustom\Block\StockInStores->getAllColors() #22 /var/vwww/www.anne-sophie.be/www/app/design/frontend/Mgs/claue_child/Kinamo_AnneSophieCustom/templates/stock-in-stores.phtml(103): Kinamo\AnneSophieCustom\Block\StockInStores\Interceptor->getAllColors() #23 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/var/vwww/www.a...') #24 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/Template.php(270): Magento\Framework\View\TemplateEngine\Php->render(Object(Kinamo\AnneSophieCustom\Block\StockInStores\Interceptor), '/var/vwww/www.a...', Array) #25 /var/vwww/www.anne-sophie.be/www/generated/code/Kinamo/AnneSophieCustom/Block/StockInStores/Interceptor.php(687): Magento\Framework\View\Element\Template->fetchView('/var/vwww/www.a...') #26 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/Template.php(300): Kinamo\AnneSophieCustom\Block\StockInStores\Interceptor->fetchView('/var/vwww/www.a...') #27 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/AbstractBlock.php(667): Magento\Framework\View\Element\Template->_toHtml() #28 /var/vwww/www.anne-sophie.be/www/generated/code/Kinamo/AnneSophieCustom/Block/StockInStores/Interceptor.php(999): Magento\Framework\View\Element\AbstractBlock->toHtml() #29 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(557): Kinamo\AnneSophieCustom\Block\StockInStores\Interceptor->toHtml() #30 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(533): Magento\Framework\View\Layout->_renderBlock('product.physica...') #31 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('product.physica...') #32 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('product.physica...') #33 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('product.physica...', false) #34 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('product.physica...', false) #35 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('product.info.ty...', false) #36 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('product.info.ty...') #37 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('product.info.ty...') #38 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('product.info.ty...', true) #39 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/AbstractBlock.php(507): Magento\Framework\View\Layout\Interceptor->renderElement('product.info.ty...', true) #40 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Block/Product/View/Interceptor.php(778): Magento\Framework\View\Element\AbstractBlock->getChildHtml('product.info.ty...', true) #41 /var/vwww/www.anne-sophie.be/www/app/design/frontend/Mgs/claue_child/Magento_Catalog/templates/product/view/detail_layout.phtml(142): Magento\Catalog\Block\Product\View\Interceptor->getChildHtml('product.info.ty...') #42 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/var/vwww/www.a...') #43 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/Template.php(270): Magento\Framework\View\TemplateEngine\Php->render(Object(Magento\Catalog\Block\Product\View\Interceptor), '/var/vwww/www.a...', Array) #44 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Block/Product/View/Interceptor.php(544): Magento\Framework\View\Element\Template->fetchView('/var/vwww/www.a...') #45 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/Template.php(300): Magento\Catalog\Block\Product\View\Interceptor->fetchView('/var/vwww/www.a...') #46 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Element/AbstractBlock.php(667): Magento\Framework\View\Element\Template->_toHtml() #47 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Catalog/Block/Product/View/Interceptor.php(869): Magento\Framework\View\Element\AbstractBlock->toHtml() #48 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(557): Magento\Catalog\Block\Product\View\Interceptor->toHtml() #49 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(533): Magento\Framework\View\Layout->_renderBlock('product.detail....') #50 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('product.detail....') #51 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('product.detail....') #52 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('product.detail....', false) #53 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('product.detail....', false) #54 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('content', false) #55 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('content') #56 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('content') #57 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('content', false) #58 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('content', false) #59 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('main', false) #60 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('main') #61 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('main') #62 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('main', false) #63 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('main', false) #64 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('columns', false) #65 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('columns') #66 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('columns') #67 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('columns', false) #68 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('columns', false) #69 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('main.content', false) #70 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('main.content') #71 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('main.content') #72 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('main.content', false) #73 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('main.content', false) #74 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('page.wrapper', false) #75 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('page.wrapper') #76 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('page.wrapper') #77 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('page.wrapper', false) #78 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('page.wrapper', false) #79 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(535): Magento\Framework\View\Layout->_renderContainer('root', false) #80 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('root') #81 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(488): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('root') #82 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('root', true) #83 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Layout.php(954): Magento\Framework\View\Layout\Interceptor->renderElement('root') #84 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\View\Layout->getOutput() #85 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\View\Layout\Interceptor->___callParent('getOutput', Array) #86 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\View\Layout\Interceptor->Magento\Framework\Interception\{closure}() #87 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/View/Layout/Interceptor.php(494): Magento\Framework\View\Layout\Interceptor->___callPlugins('getOutput', Array, Array) #88 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Result/Page.php(257): Magento\Framework\View\Layout\Interceptor->getOutput() #89 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/View/Result/Layout.php(170): Magento\Framework\View\Result\Page->render(Object(Magento\Framework\App\Response\Http\Interceptor)) #90 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\View\Result\Layout->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor)) #91 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(138): MGS\Mpanel\Block\Framework\Page\Interceptor->___callParent('renderResult', Array) #92 /var/vwww/www.anne-sophie.be/www/app/code/Aheadworks/Layerednav/Model/Plugin/Result.php(93): MGS\Mpanel\Block\Framework\Page\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Response\Http\Interceptor)) #93 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(135): Aheadworks\Layerednav\Model\Plugin\Result->aroundRenderResult(Object(MGS\Mpanel\Block\Framework\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor)) #94 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/Interception/Interceptor.php(153): MGS\Mpanel\Block\Framework\Page\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Response\Http\Interceptor)) #95 /var/vwww/www.anne-sophie.be/www/generated/code/MGS/Mpanel/Block/Framework/Page/Interceptor.php(156): MGS\Mpanel\Block\Framework\Page\Interceptor->___callPlugins('renderResult', Array, Array) #96 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/App/Http.php(139): MGS\Mpanel\Block\Framework\Page\Interceptor->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor)) #97 /var/vwww/www.anne-sophie.be/www/generated/code/Magento/Framework/App/Http/Interceptor.php(24): Magento\Framework\App\Http->launch() #98 /var/vwww/www.anne-sophie.be/www/vendor/magento/framework/App/Bootstrap.php(257): Magento\Framework\App\Http\Interceptor->launch() #99 /var/vwww/www.anne-sophie.be/www/pub/index.php(44): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http\Interceptor)) #100 {main}