SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (41, 224, 44, 43, 255, 250, 251, 45, 229, 143, 142, 222, 145, 248, 219, 146, 231, 220, 149, 230, 148, 237, 144, 239, 147, 232, 233, 236, 234, 249, 254, 235)) AND (t_d.attribute_id IN ('45', '161', '168', '169', '170', '171', '172', '173', '174', '175', '277', '273', '283', '286', '304')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (41, 224, 44, 43, 255, 250, 251, 45, 229, 143, 142, 222, 145, 248, 219, 146, 231, 220, 149, 230, 148, 237, 144, 239, 147, 232, 233, 236, 234, 249, 254, 235)) AND (t_d.attribute_id IN ('159', '162', '163', '164', '165', '166', '167', '251', '252', '255', '284', '285', '287', '303')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (41, 224, 44, 43, 255, 250, 251, 45, 229, 143, 142, 222, 145, 248, 219, 146, 231, 220, 149, 230, 148, 237, 144, 239, 147, 232, 233, 236, 234, 249, 254, 235)) AND (t_d.attribute_id IN ('160', '176', '253', '254', '276', '275', '274')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/tjuffie/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:128 Stack trace: #0 /var/www/tjuffie/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(128): PDO->__construct() #1 /var/www/tjuffie/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /var/www/tjuffie/magento2/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(413): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /var/www/tjuffie/magento2/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(578): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect() #4 /var/www/tjuffie/magento2/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(616): Magento\Framework\DB\Adapter\Pdo\Mysql->_query() #5 /var/www/tjuffie/magento2/generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php(128): Magento\Framework\DB\Adapter\Pdo\Mysql->query() #6 /var/www/tjuffie/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(756): Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->query() #7 /var/www/tjuffie/magento2/generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php(1571): Zend_Db_Adapter_Abstract->fetchRow() #8 /var/www/tjuffie/magento2/vendor/magento/framework/EntityManager/Db/ReadRow.php(61): Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->fetchRow() #9 /var/www/tjuffie/magento2/vendor/magento/framework/EntityManager/Operation/Read/ReadMain.php(63): Magento\Framework\EntityManager\Db\ReadRow->execute() #10 /var/www/tjuffie/magento2/vendor/magento/framework/EntityManager/Operation/Read.php(108): Magento\Framework\EntityManager\Operation\Read\ReadMain->execute() #11 /var/www/tjuffie/magento2/vendor/magento/framework/EntityManager/EntityManager.php(70): Magento\Framework\EntityManager\Operation\Read->execute() #12 /var/www/tjuffie/magento2/vendor/mirasvit/module-search-report/src/SearchReport/Repository/LogRepository.php(65): Magento\Framework\EntityManager\EntityManager->load() #13 /var/www/tjuffie/magento2/vendor/mirasvit/module-search-report/src/SearchReport/Service/LogService.php(81): Mirasvit\SearchReport\Repository\LogRepository->get() #14 /var/www/tjuffie/magento2/vendor/mirasvit/module-search-report/src/SearchReport/Plugin/ResponsePlugin.php(105): Mirasvit\SearchReport\Service\LogService->logClick() #15 /var/www/tjuffie/magento2/vendor/magento/framework/Interception/Interceptor.php(121): Mirasvit\SearchReport\Plugin\ResponsePlugin->beforeSendResponse() #16 /var/www/tjuffie/magento2/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\Response\Http\Interceptor->Magento\Framework\Interception\{closure}() #17 /var/www/tjuffie/magento2/generated/code/Magento/Framework/App/Response/Http/Interceptor.php(117): Magento\Framework\App\Response\Http\Interceptor->___callPlugins() #18 /var/www/tjuffie/magento2/vendor/magento/framework/App/ExceptionHandler.php(103): Magento\Framework\App\Response\Http\Interceptor->sendResponse() #19 /var/www/tjuffie/magento2/vendor/magento/framework/App/ExceptionHandler.php(70): Magento\Framework\App\ExceptionHandler->handleDeveloperMode() #20 /var/www/tjuffie/magento2/vendor/magento/framework/App/Http.php(156): Magento\Framework\App\ExceptionHandler->handle() #21 /var/www/tjuffie/magento2/vendor/magento/framework/App/Bootstrap.php(267): Magento\Framework\App\Http->catchException() #22 /var/www/tjuffie/magento2/pub/index.php(40): Magento\Framework\App\Bootstrap->run() #23 {main} Next Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory in /var/www/tjuffie/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:144 Stack trace: #0 /var/www/tjuffie/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 /var/www/tjuffie/magento2/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(413): Zend_Db_Adapter_Pdo_Mysql->_connect() #2 /var/www/tjuffie/magento2/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(578): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect() #3 /var/www/tjuffie/magento2/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(616): Magento\Framework\DB\Adapter\Pdo\Mysql->_query() #4 /var/www/tjuffie/magento2/generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php(128): Magento\Framework\DB\Adapter\Pdo\Mysql->query() #5 /var/www/tjuffie/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(756): Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->query() #6 /var/www/tjuffie/magento2/generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php(1571): Zend_Db_Adapter_Abstract->fetchRow() #7 /var/www/tjuffie/magento2/vendor/magento/framework/EntityManager/Db/ReadRow.php(61): Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->fetchRow() #8 /var/www/tjuffie/magento2/vendor/magento/framework/EntityManager/Operation/Read/ReadMain.php(63): Magento\Framework\EntityManager\Db\ReadRow->execute() #9 /var/www/tjuffie/magento2/vendor/magento/framework/EntityManager/Operation/Read.php(108): Magento\Framework\EntityManager\Operation\Read\ReadMain->execute() #10 /var/www/tjuffie/magento2/vendor/magento/framework/EntityManager/EntityManager.php(70): Magento\Framework\EntityManager\Operation\Read->execute() #11 /var/www/tjuffie/magento2/vendor/mirasvit/module-search-report/src/SearchReport/Repository/LogRepository.php(65): Magento\Framework\EntityManager\EntityManager->load() #12 /var/www/tjuffie/magento2/vendor/mirasvit/module-search-report/src/SearchReport/Service/LogService.php(81): Mirasvit\SearchReport\Repository\LogRepository->get() #13 /var/www/tjuffie/magento2/vendor/mirasvit/module-search-report/src/SearchReport/Plugin/ResponsePlugin.php(105): Mirasvit\SearchReport\Service\LogService->logClick() #14 /var/www/tjuffie/magento2/vendor/magento/framework/Interception/Interceptor.php(121): Mirasvit\SearchReport\Plugin\ResponsePlugin->beforeSendResponse() #15 /var/www/tjuffie/magento2/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\Response\Http\Interceptor->Magento\Framework\Interception\{closure}() #16 /var/www/tjuffie/magento2/generated/code/Magento/Framework/App/Response/Http/Interceptor.php(117): Magento\Framework\App\Response\Http\Interceptor->___callPlugins() #17 /var/www/tjuffie/magento2/vendor/magento/framework/App/ExceptionHandler.php(103): Magento\Framework\App\Response\Http\Interceptor->sendResponse() #18 /var/www/tjuffie/magento2/vendor/magento/framework/App/ExceptionHandler.php(70): Magento\Framework\App\ExceptionHandler->handleDeveloperMode() #19 /var/www/tjuffie/magento2/vendor/magento/framework/App/Http.php(156): Magento\Framework\App\ExceptionHandler->handle() #20 /var/www/tjuffie/magento2/vendor/magento/framework/App/Bootstrap.php(267): Magento\Framework\App\Http->catchException() #21 /var/www/tjuffie/magento2/pub/index.php(40): Magento\Framework\App\Bootstrap->run() #22 {main}