2 exception(s): Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'url_key' in where clause is ambiguous, query was: SELECT `main_table`.*, IFNULL(noDefaultStore.status, store.status) AS `status`, IFNULL(noDefaultStore.name, store.name) AS `name`, IFNULL(noDefaultStore.meta_title, store.meta_title) AS `meta_title`, IFNULL(noDefaultStore.meta_description, store.meta_description) AS `meta_description`, IFNULL(noDefaultStore.meta_tags, store.meta_tags) AS `meta_tags` FROM `amasty_blog_categories` AS `main_table` LEFT JOIN `amasty_blog_categories_store` AS `store` ON store.category_id = main_table.category_id AND store.store_id = 0 LEFT JOIN `amasty_blog_categories_store` AS `noDefaultStore` ON noDefaultStore.category_id = main_table.category_id AND noDefaultStore.store_id = 1 WHERE (IFNULL(noDefaultStore.status, store.status)=1) AND (`url_key` = 'cuisine') GROUP BY `main_table`.`category_id`, `main_table`.`category_id` LIMIT 1 Exception #1 (PDOException): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'url_key' in where clause is ambiguous Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'url_key' in where clause is ambiguous, query was: SELECT `main_table`.*, IFNULL(noDefaultStore.status, store.status) AS `status`, IFNULL(noDefaultStore.name, store.name) AS `name`, IFNULL(noDefaultStore.meta_title, store.meta_title) AS `meta_title`, IFNULL(noDefaultStore.meta_description, store.meta_description) AS `meta_description`, IFNULL(noDefaultStore.meta_tags, store.meta_tags) AS `meta_tags` FROM `amasty_blog_categories` AS `main_table` LEFT JOIN `amasty_blog_categories_store` AS `store` ON store.category_id = main_table.category_id AND store.store_id = 0 LEFT JOIN `amasty_blog_categories_store` AS `noDefaultStore` ON noDefaultStore.category_id = main_table.category_id AND noDefaultStore.store_id = 1 WHERE (IFNULL(noDefaultStore.status, store.status)=1) AND (`url_key` = 'cuisine') GROUP BY `main_table`.`category_id`, `main_table`.`category_id` LIMIT 1
#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/magento/framework/Data/Collection/Db/FetchStrategy/Query.php:21] #8 Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:782] #9 Magento\Framework\Data\Collection\AbstractDb->_fetchAll() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:677] #10 Magento\Framework\Data\Collection\AbstractDb->getData() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:580] #11 Magento\Framework\Data\Collection\AbstractDb->loadWithFilter() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:565] #12 Magento\Framework\Data\Collection\AbstractDb->load() called at [vendor/magento/framework/Data/Collection.php:301] #13 Magento\Framework\Data\Collection->getFirstItem() called at [vendor/amasty/blog/Model/Repository/CategoriesRepository.php:147] #14 Amasty\Blog\Model\Repository\CategoriesRepository->getByUrlKey() called at [vendor/amasty/blog/Model/PageValidator.php:107] #15 Amasty\Blog\Model\PageValidator->getCategoryId() called at [vendor/amasty/blog/Controller/Router.php:204] #16 Amasty\Blog\Controller\Router->detectRedirect() called at [vendor/amasty/blog/Controller/Router.php:122] #17 Amasty\Blog\Controller\Router->match() called at [vendor/magento/framework/Interception/Interceptor.php:58] #18 Amasty\Blog\Controller\Router\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #19 Amasty\Blog\Controller\Router\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #20 Amasty\Blog\Controller\Router\Interceptor->___callPlugins() called at [generated/code/Amasty/Blog/Controller/Router/Interceptor.php:23] #21 Amasty\Blog\Controller\Router\Interceptor->match() called at [vendor/magento/framework/App/FrontController.php:115] #22 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #23 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #24 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:99] #25 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #26 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:75] #27 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #28 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #29 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:23] #30 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:116] #31 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:23] #32 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:263] #33 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:29]Exception #1 (PDOException): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'url_key' 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: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/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/framework/Data/Collection/AbstractDb.php:677] #12 Magento\Framework\Data\Collection\AbstractDb->getData() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:580] #13 Magento\Framework\Data\Collection\AbstractDb->loadWithFilter() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:565] #14 Magento\Framework\Data\Collection\AbstractDb->load() called at [vendor/magento/framework/Data/Collection.php:301] #15 Magento\Framework\Data\Collection->getFirstItem() called at [vendor/amasty/blog/Model/Repository/CategoriesRepository.php:147] #16 Amasty\Blog\Model\Repository\CategoriesRepository->getByUrlKey() called at [vendor/amasty/blog/Model/PageValidator.php:107] #17 Amasty\Blog\Model\PageValidator->getCategoryId() called at [vendor/amasty/blog/Controller/Router.php:204] #18 Amasty\Blog\Controller\Router->detectRedirect() called at [vendor/amasty/blog/Controller/Router.php:122] #19 Amasty\Blog\Controller\Router->match() called at [vendor/magento/framework/Interception/Interceptor.php:58] #20 Amasty\Blog\Controller\Router\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #21 Amasty\Blog\Controller\Router\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #22 Amasty\Blog\Controller\Router\Interceptor->___callPlugins() called at [generated/code/Amasty/Blog/Controller/Router/Interceptor.php:23] #23 Amasty\Blog\Controller\Router\Interceptor->match() called at [vendor/magento/framework/App/FrontController.php:115] #24 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #25 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #26 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:99] #27 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #28 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:75] #29 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #30 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #31 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:23] #32 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:116] #33 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:23] #34 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:263] #35 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:29]