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_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_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 (12764, 11841, 11842, 12598, 12614, 11828, 12292, 12797, 12362, 12222, 12420)) AND (t_d.attribute_id IN ('73', '87', '88', '89', '109', '110', '111', '119', '122', '133', '156', '170', '187', '193', '194', '198', '203', '208', '211', '215', '216', '224', '266', '267', '289', '384', '385')) 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_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_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 (12764, 11841, 11842, 12598, 12614, 11828, 12292, 12797, 12362, 12222, 12420)) AND (t_d.attribute_id IN ('76', '272', '282', '323', '324', '325', '326', '327', '328', '329', '330', '331', '332', '333', '334', '335', '336', '337', '338', '339', '340', '341', '342', '343', '344', '345', '346', '347', '348', '349', '350', '351', '352', '353', '354', '355', '356', '357', '358', '359', '360', '361', '362', '363', '364', '365')) 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_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` 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 (12764, 11841, 11842, 12598, 12614, 11828, 12292, 12797, 12362, 12222, 12420)) AND (t_d.attribute_id IN ('78', '81', '121', '197')) 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_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` 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 (12764, 11841, 11842, 12598, 12614, 11828, 12292, 12797, 12362, 12222, 12420)) AND (t_d.attribute_id IN ('79', '80', '94', '95', '321')) 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_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_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 (12764, 11841, 11842, 12598, 12614, 11828, 12292, 12797, 12362, 12222, 12420)) AND (t_d.attribute_id IN ('83', '93', '97', '123', '125', '126', '127', '128', '131', '134', '142', '167', '188', '189', '190', '191', '192', '195', '196', '199', '201', '202', '205', '206', '209', '214', '217', '219', '222', '223', '225', '241', '265', '268', '273', '288', '320', '367', '386')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))PDOException: SQLSTATE[HY000] [2002] No such file or directory in /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:128 Stack trace: #0 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(128): PDO->__construct('mysql:host=loca...', 'ukled-user', 'gVfdkTudWgUG', Array) #1 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(410): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(861): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect() #4 /home/ukled/htdocs/www.ukled.co.uk/generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php(1636): Zend_Db_Adapter_Abstract->quote('', NULL) #5 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(931): Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->quote('', NULL) #6 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(1489): Zend_Db_Adapter_Abstract->quoteInto('log_id = ?', '', NULL, NULL) #7 /home/ukled/htdocs/www.ukled.co.uk/generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php(362): Magento\Framework\DB\Adapter\Pdo\Mysql->quoteInto('log_id = ?', '', NULL, NULL) #8 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Select.php(1031): Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->quoteInto('log_id = ?', '', NULL) #9 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Select.php(496): Zend_Db_Select->_where('log_id = ?', '', NULL, true) #10 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/DB/Select.php(120): Zend_Db_Select->where('log_id = ?', '', NULL) #11 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/EntityManager/Db/ReadRow.php(54): Magento\Framework\DB\Select->where('log_id = ?', '') #12 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/EntityManager/Operation/Read/ReadMain.php(63): Magento\Framework\EntityManager\Db\ReadRow->execute('Mirasvit\\Search...', NULL) #13 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/EntityManager/Operation/Read.php(108): Magento\Framework\EntityManager\Operation\Read\ReadMain->execute(Object(Mirasvit\SearchReport\Model\Log), NULL) #14 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/EntityManager/EntityManager.php(70): Magento\Framework\EntityManager\Operation\Read->execute(Object(Mirasvit\SearchReport\Model\Log), NULL, Array) #15 /home/ukled/htdocs/www.ukled.co.uk/vendor/mirasvit/module-search-report/src/SearchReport/Repository/LogRepository.php(65): Magento\Framework\EntityManager\EntityManager->load(Object(Mirasvit\SearchReport\Model\Log), NULL) #16 /home/ukled/htdocs/www.ukled.co.uk/vendor/mirasvit/module-search-report/src/SearchReport/Service/LogService.php(81): Mirasvit\SearchReport\Repository\LogRepository->get(NULL) #17 /home/ukled/htdocs/www.ukled.co.uk/vendor/mirasvit/module-search-report/src/SearchReport/Plugin/ResponsePlugin.php(105): Mirasvit\SearchReport\Service\LogService->logClick(NULL) #18 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/Interception/Interceptor.php(121): Mirasvit\SearchReport\Plugin\ResponsePlugin->beforeSendResponse(Object(Magento\Framework\App\Response\Http\Interceptor)) #19 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\Response\Http\Interceptor->Magento\Framework\Interception\{closure}() #20 /home/ukled/htdocs/www.ukled.co.uk/generated/code/Magento/Framework/App/Response/Http/Interceptor.php(117): Magento\Framework\App\Response\Http\Interceptor->___callPlugins('sendResponse', Array, Array) #21 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/App/ExceptionHandler.php(103): Magento\Framework\App\Response\Http\Interceptor->sendResponse() #22 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/App/ExceptionHandler.php(70): Magento\Framework\App\ExceptionHandler->handleDeveloperMode(Object(Magento\Framework\App\Bootstrap), Object(Zend_Db_Adapter_Exception), Object(Magento\Framework\App\Response\Http\Interceptor)) #23 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/App/Http.php(156): Magento\Framework\App\ExceptionHandler->handle(Object(Magento\Framework\App\Bootstrap), Object(Zend_Db_Adapter_Exception), Object(Magento\Framework\App\Response\Http\Interceptor), Object(Magento\Framework\App\Request\Http)) #24 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\App\Http->catchException(Object(Magento\Framework\App\Bootstrap), Object(Zend_Db_Adapter_Exception)) #25 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\App\Http\Interceptor->___callParent('catchException', Array) #26 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\Http\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Bootstrap), Object(Zend_Db_Adapter_Exception)) #27 /home/ukled/htdocs/www.ukled.co.uk/generated/code/Magento/Framework/App/Http/Interceptor.php(39): Magento\Framework\App\Http\Interceptor->___callPlugins('catchException', Array, Array) #28 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/App/Bootstrap.php(267): Magento\Framework\App\Http\Interceptor->catchException(Object(Magento\Framework\App\Bootstrap), Object(Zend_Db_Adapter_Exception)) #29 /home/ukled/htdocs/www.ukled.co.uk/pub/index.php(40): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http\Interceptor)) #30 {main} Next Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory in /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:144 Stack trace: #0 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(410): Zend_Db_Adapter_Pdo_Mysql->_connect() #2 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(861): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect() #3 /home/ukled/htdocs/www.ukled.co.uk/generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php(1636): Zend_Db_Adapter_Abstract->quote('', NULL) #4 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(931): Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->quote('', NULL) #5 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(1489): Zend_Db_Adapter_Abstract->quoteInto('log_id = ?', '', NULL, NULL) #6 /home/ukled/htdocs/www.ukled.co.uk/generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php(362): Magento\Framework\DB\Adapter\Pdo\Mysql->quoteInto('log_id = ?', '', NULL, NULL) #7 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Select.php(1031): Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->quoteInto('log_id = ?', '', NULL) #8 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/zendframework1/library/Zend/Db/Select.php(496): Zend_Db_Select->_where('log_id = ?', '', NULL, true) #9 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/DB/Select.php(120): Zend_Db_Select->where('log_id = ?', '', NULL) #10 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/EntityManager/Db/ReadRow.php(54): Magento\Framework\DB\Select->where('log_id = ?', '') #11 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/EntityManager/Operation/Read/ReadMain.php(63): Magento\Framework\EntityManager\Db\ReadRow->execute('Mirasvit\\Search...', NULL) #12 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/EntityManager/Operation/Read.php(108): Magento\Framework\EntityManager\Operation\Read\ReadMain->execute(Object(Mirasvit\SearchReport\Model\Log), NULL) #13 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/EntityManager/EntityManager.php(70): Magento\Framework\EntityManager\Operation\Read->execute(Object(Mirasvit\SearchReport\Model\Log), NULL, Array) #14 /home/ukled/htdocs/www.ukled.co.uk/vendor/mirasvit/module-search-report/src/SearchReport/Repository/LogRepository.php(65): Magento\Framework\EntityManager\EntityManager->load(Object(Mirasvit\SearchReport\Model\Log), NULL) #15 /home/ukled/htdocs/www.ukled.co.uk/vendor/mirasvit/module-search-report/src/SearchReport/Service/LogService.php(81): Mirasvit\SearchReport\Repository\LogRepository->get(NULL) #16 /home/ukled/htdocs/www.ukled.co.uk/vendor/mirasvit/module-search-report/src/SearchReport/Plugin/ResponsePlugin.php(105): Mirasvit\SearchReport\Service\LogService->logClick(NULL) #17 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/Interception/Interceptor.php(121): Mirasvit\SearchReport\Plugin\ResponsePlugin->beforeSendResponse(Object(Magento\Framework\App\Response\Http\Interceptor)) #18 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\Response\Http\Interceptor->Magento\Framework\Interception\{closure}() #19 /home/ukled/htdocs/www.ukled.co.uk/generated/code/Magento/Framework/App/Response/Http/Interceptor.php(117): Magento\Framework\App\Response\Http\Interceptor->___callPlugins('sendResponse', Array, Array) #20 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/App/ExceptionHandler.php(103): Magento\Framework\App\Response\Http\Interceptor->sendResponse() #21 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/App/ExceptionHandler.php(70): Magento\Framework\App\ExceptionHandler->handleDeveloperMode(Object(Magento\Framework\App\Bootstrap), Object(Zend_Db_Adapter_Exception), Object(Magento\Framework\App\Response\Http\Interceptor)) #22 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/App/Http.php(156): Magento\Framework\App\ExceptionHandler->handle(Object(Magento\Framework\App\Bootstrap), Object(Zend_Db_Adapter_Exception), Object(Magento\Framework\App\Response\Http\Interceptor), Object(Magento\Framework\App\Request\Http)) #23 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\App\Http->catchException(Object(Magento\Framework\App\Bootstrap), Object(Zend_Db_Adapter_Exception)) #24 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\App\Http\Interceptor->___callParent('catchException', Array) #25 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\Http\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Bootstrap), Object(Zend_Db_Adapter_Exception)) #26 /home/ukled/htdocs/www.ukled.co.uk/generated/code/Magento/Framework/App/Http/Interceptor.php(39): Magento\Framework\App\Http\Interceptor->___callPlugins('catchException', Array, Array) #27 /home/ukled/htdocs/www.ukled.co.uk/vendor/magento/framework/App/Bootstrap.php(267): Magento\Framework\App\Http\Interceptor->catchException(Object(Magento\Framework\App\Bootstrap), Object(Zend_Db_Adapter_Exception)) #28 /home/ukled/htdocs/www.ukled.co.uk/pub/index.php(40): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http\Interceptor)) #29 {main}