[SQL?] [1.7.2.0] Prestashop on synology, weird case

[TomaszT]

Hello.

I'm new in Prestashop and I try to do my best to make it work... 

Installation on SYNOLOGY nas was very smooth. I got public IP. FrontOffice and BackOffice works almost fine:

When I click on "modules" OR when I try to change shop theme OR when I click Catalogue/products - ERROR 500 appears, in debug mode it looks like this:

 

.....I tried to rename or delete \app\cache\dev folder. 

 

Any advice? 

:)

3/3ConnectionException in AbstractMySQLDriver.php line 103:An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory

1. in AbstractMySQLDriver.php line 103
2. at AbstractMySQLDriver->convertException('An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory', object(PDOException)) in DBALException.php line 145
3. at DBALException::driverException(object(Driver), object(PDOException)) in Driver.php line 47
4. at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'xxxxxxxxxx', 'port' => 'xxxxxxx', 'dbname' => 'xxxxxxx', 'user' => 'xxxxx', 'password' => 'xxxxxxx', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))'), 'serverVersion' => '5.1'), 'xxxxxxxxx', 'xxxxxxxxxxxxxxxxx', array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))')) in Connection.php line 360
5. at Connection->connect() in Connection.php line 833
6. at Connection->executeQuery('SELECT p0_.id AS id_0, p0_.id_employee AS id_employee_1, p0_.id_module AS id_module_2, p0_.date_add AS date_add_3, p0_.date_upd AS date_upd_4 FROM ps_module_history p0_ WHERE p0_.id_employee = ?', array('1'), array('integer')) in Connection.php line 899
7. at Connection->executeCacheQuery('SELECT p0_.id AS id_0, p0_.id_employee AS id_employee_1, p0_.id_module AS id_module_2, p0_.date_add AS date_add_3, p0_.date_upd AS date_upd_4 FROM ps_module_history p0_ WHERE p0_.id_employee = ?', array('1'), array('integer'), object(QueryCacheProfile)) in Connection.php line 830
8. at Connection->executeQuery('SELECT p0_.id AS id_0, p0_.id_employee AS id_employee_1, p0_.id_module AS id_module_2, p0_.date_add AS date_add_3, p0_.date_upd AS date_upd_4 FROM ps_module_history p0_ WHERE p0_.id_employee = ?', array('1'), array('integer'), object(QueryCacheProfile)) in SingleSelectExecutor.php line 50
9. at SingleSelectExecutor->execute(object(Connection), array('1'), array('integer')) in Query.php line 321
10. at Query->_doExecute() in AbstractQuery.php line 969
11. at AbstractQuery->executeIgnoreQueryCache(null, '1') in AbstractQuery.php line 924
12. at AbstractQuery->execute(null, '1') in AbstractQuery.php line 727
13. at AbstractQuery->getResult() in ModuleDataProvider.php line 101
14. at ModuleDataProvider->findByName('tc_bestsellers') in ModuleRepository.php line 452
15. at ModuleRepository->getModule('tc_bestsellers') in ModuleManager.php line 333
16. at ModuleManager->disable('tc_bestsellers') in ThemeManager.php line 266
17. at ThemeManager->doDisableModules(array('tc_bestsellers', 'tc_blocktopcms', 'tc_brandlogo', 'tc_categorycmsblock', 'tc_featuredproducts', 'tc_imageslider', 'tc_leftbanner', 'tc_newproducts', 'tc_parallaxcmsblock', 'tc_serviceblock', 'tc_sidebestsellers', 'tc_sidefeaturedproducts', 'tc_sidenewproducts', 'tc_sidespecials', 'tc_specials', 'tc_testimonialcmsblock')) in ThemeManager.php line 195
18. at ThemeManager->disable('craze') in ThemeManager.php line 164
19. at ThemeManager->enable('classic') in AdminThemesController.php line 307
20. at AdminThemesControllerCore->postProcess() in Controller.php line 194
21. at ControllerCore->run() in Dispatcher.php line 379
22. at DispatcherCore->dispatch() in index.php line 95

 

2/3PDOException in PDOConnection.php line 47:SQLSTATE[HY000] [2002] No such file or directory

1. in PDOConnection.php line 47
2. at PDOConnection->__construct('mysql:host=localhost;port=xxxxxxxxx;dbname=xxxxxxxxxx;charset=UTF8;', 'xxxxxxxxxxxxxxxxxx', 'xxxxxxxxxxxxxxx', array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))')) in Driver.php line 44
3. at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => 'xxxxxxxxxxxxxx', 'dbname' => 'xxxxxxxxxxxxxx', 'user' => 'xxxxxxxxxxxxxxxx', 'password' => 'xxxxxxxxxxxxxxxxx', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))'), 'serverVersion' => '5.1'), 'xxxxxxxxxxxx', 'xxxxxxxxxxxxxxxxx', array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))')) in Connection.php line 360
4. at Connection->connect() in Connection.php line 833
5. at Connection->executeQuery('SELECT p0_.id AS id_0, p0_.id_employee AS id_employee_1, p0_.id_module AS id_module_2, p0_.date_add AS date_add_3, p0_.date_upd AS date_upd_4 FROM ps_module_history p0_ WHERE p0_.id_employee = ?', array('1'), array('integer')) in Connection.php line 899
6. at Connection->executeCacheQuery('SELECT p0_.id AS id_0, p0_.id_employee AS id_employee_1, p0_.id_module AS id_module_2, p0_.date_add AS date_add_3, p0_.date_upd AS date_upd_4 FROM ps_module_history p0_ WHERE p0_.id_employee = ?', array('1'), array('integer'), object(QueryCacheProfile)) in Connection.php line 830
7. at Connection->executeQuery('SELECT p0_.id AS id_0, p0_.id_employee AS id_employee_1, p0_.id_module AS id_module_2, p0_.date_add AS date_add_3, p0_.date_upd AS date_upd_4 FROM ps_module_history p0_ WHERE p0_.id_employee = ?', array('1'), array('integer'), object(QueryCacheProfile)) in SingleSelectExecutor.php line 50
8. at SingleSelectExecutor->execute(object(Connection), array('1'), array('integer')) in Query.php line 321
9. at Query->_doExecute() in AbstractQuery.php line 969
10. at AbstractQuery->executeIgnoreQueryCache(null, '1') in AbstractQuery.php line 924
11. at AbstractQuery->execute(null, '1') in AbstractQuery.php line 727
12. at AbstractQuery->getResult() in ModuleDataProvider.php line 101
13. at ModuleDataProvider->findByName('tc_bestsellers') in ModuleRepository.php line 452
14. at ModuleRepository->getModule('tc_bestsellers') in ModuleManager.php line 333
15. at ModuleManager->disable('tc_bestsellers') in ThemeManager.php line 266
16. at ThemeManager->doDisableModules(array('tc_bestsellers', 'tc_blocktopcms', 'tc_brandlogo', 'tc_categorycmsblock', 'tc_featuredproducts', 'tc_imageslider', 'tc_leftbanner', 'tc_newproducts', 'tc_parallaxcmsblock', 'tc_serviceblock', 'tc_sidebestsellers', 'tc_sidefeaturedproducts', 'tc_sidenewproducts', 'tc_sidespecials', 'tc_specials', 'tc_testimonialcmsblock')) in ThemeManager.php line 195
17. at ThemeManager->disable('craze') in ThemeManager.php line 164
18. at ThemeManager->enable('classic') in AdminThemesController.php line 307
19. at AdminThemesControllerCore->postProcess() in Controller.php line 194
20. at ControllerCore->run() in Dispatcher.php line 379
21. at DispatcherCore->dispatch() in index.php line 95

1/3PDOException in PDOConnection.php line 43:SQLSTATE[HY000] [2002] No such file or directory

1. in PDOConnection.php line 43
2. at PDO->__construct('mysql:host=localhost;port=xxxxxxxx;dbname=xxxx;charset=UTF8;', 'xxxxxxx', 'xxxxxxxxxxx', array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))')) in PDOConnection.php line 43
3. at PDOConnection->__construct('mysql:host=localhost;port=xxxxxxxxxxxxxxxxx;dbname=xxxxxxx;charset=UTF8;', 'xxxxxxxxx', 'xxxxxxx', array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))')) in Driver.php line 44
4. at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => '/run/mysqld/mysqld10.sock', 'dbname' => 'xxxxx', 'xxxxxx' => 'xxxxxxxx', 'password' => 'xxxxxxxxxxxxxxxx', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))'), 'serverVersion' => '5.1'), 'xxxxxxxxxxxxxxxxxx', 'xxxxxxxxxxxxx', array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))')) in Connection.php line 360
5. at Connection->connect() in Connection.php line 833
6. at Connection->executeQuery('SELECT p0_.id AS id_0, p0_.id_employee AS id_employee_1, p0_.id_module AS id_module_2, p0_.date_add AS date_add_3, p0_.date_upd AS date_upd_4 FROM ps_module_history p0_ WHERE p0_.id_employee = ?', array('1'), array('integer')) in Connection.php line 899
7. at Connection->executeCacheQuery('SELECT p0_.id AS id_0, p0_.id_employee AS id_employee_1, p0_.id_module AS id_module_2, p0_.date_add AS date_add_3, p0_.date_upd AS date_upd_4 FROM ps_module_history p0_ WHERE p0_.id_employee = ?', array('1'), array('integer'), object(QueryCacheProfile)) in Connection.php line 830
8. at Connection->executeQuery('SELECT p0_.id AS id_0, p0_.id_employee AS id_employee_1, p0_.id_module AS id_module_2, p0_.date_add AS date_add_3, p0_.date_upd AS date_upd_4 FROM ps_module_history p0_ WHERE p0_.id_employee = ?', array('1'), array('integer'), object(QueryCacheProfile)) in SingleSelectExecutor.php line 50
9. at SingleSelectExecutor->execute(object(Connection), array('1'), array('integer')) in Query.php line 321
10. at Query->_doExecute() in AbstractQuery.php line 969
11. at AbstractQuery->executeIgnoreQueryCache(null, '1') in AbstractQuery.php line 924
12. at AbstractQuery->execute(null, '1') in AbstractQuery.php line 727
13. at AbstractQuery->getResult() in ModuleDataProvider.php line 101
14. at ModuleDataProvider->findByName('tc_bestsellers') in ModuleRepository.php line 452
15. at ModuleRepository->getModule('tc_bestsellers') in ModuleManager.php line 333
16. at ModuleManager->disable('tc_bestsellers') in ThemeManager.php line 266
17. at ThemeManager->doDisableModules(array('tc_bestsellers', 'tc_blocktopcms', 'tc_brandlogo', 'tc_categorycmsblock', 'tc_featuredproducts', 'tc_imageslider', 'tc_leftbanner', 'tc_newproducts', 'tc_parallaxcmsblock', 'tc_serviceblock', 'tc_sidebestsellers', 'tc_sidefeaturedproducts', 'tc_sidenewproducts', 'tc_sidespecials', 'tc_specials', 'tc_testimonialcmsblock')) in ThemeManager.php line 195
18. at ThemeManager->disable('craze') in ThemeManager.php line 164
19. at ThemeManager->enable('classic') in AdminThemesController.php line 307
20. at AdminThemesControllerCore->postProcess() in Controller.php line 194
21. at ControllerCore->run() in Dispatcher.php line 379
22. at DispatcherCore->dispatch() in index.php line 95