Edit History

[email protected] · January 20, 2019

AFter update to 1.7.5 keep getting 500 error in random pages and internal server error when accessing stock

Link to database cannot be established: SQLSTATE[42000] [1203] User p0rtugal_loja already has more than 'max_user_connections' active connections
at line 127 in file classes/db/DbPDO.php

122.     public function connect()
123.     {
124.         try {
125.             $this->link = $this->getPDO($this->server, $this->user, $this->password, $this->database, 5);
126.         } catch (PDOException $e) {
127.             throw new PrestaShopException('Link to database cannot be established: ' . $e->getMessage());
128.         }
129. 
130.         $this->link->exec('SET SESSION sql_mode = \'\'');
131. 
132.         return $this->link;

DbPDOCore->connect - [line 330 - classes/db/Db.php]
DbCore->__construct - [line 241 - classes/db/Db.php] - [4 Arguments]
DbCore::getInstance - [line 48 - config/alias.php]
pSQL - [line 340 - classes/shop/Shop.php] - [1 Arguments]
ShopCore::initialize - [line 119 - config/config.inc.php]
require - [line 42 - admin/index.php] - [1 Arguments]

[email protected] · January 20, 2019

AFter update to 1.7.5 keep getting 500 error in random pages and internal server error when accessing stock

Link to database cannot be established: SQLSTATE[42000] [1203] User p0rtugal_loja already has more than 'max_user_connections' active connections
at line 127 in file classes/db/DbPDO.php

122.     public function connect()
123.     {
124.         try {
125.             $this->link = $this->getPDO($this->server, $this->user, $this->password, $this->database, 5);
126.         } catch (PDOException $e) {
127.             throw new PrestaShopException('Link to database cannot be established: ' . $e->getMessage());
128.         }
129. 
130.         $this->link->exec('SET SESSION sql_mode = \'\'');
131. 
132.         return $this->link;

DbPDOCore->connect - [line 330 - classes/db/Db.php]
DbCore->__construct - [line 241 - classes/db/Db.php] - [4 Arguments]
DbCore::getInstance - [line 48 - config/alias.php]
pSQL - [line 340 - classes/shop/Shop.php] - [1 Arguments]
ShopCore::initialize - [line 119 - config/config.inc.php]
require - [line 42 - admin/index.php] - [1 Arguments]

(3/3) DriverException An exception occured in driver: SQLSTATE[42000] [1203] User p0rtugal_loja already has more than 'max_user_connections' active connections
in AbstractMySQLDriver.php line 115
at AbstractMySQLDriver->convertException('An exception occured in driver: SQLSTATE[42000] [1203] User p0rtugal_loja already has more than \'max_user_connections\' active connections', object(PDOException))in DBALException.php line 145
at DBALException::driverException(object(Driver), object(PDOException))in Driver.php line 47
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'xxxxxxxxxxxxxxxxxxx', 'port' => '', 'dbname' => 'xxxxxxxxxxxxxxxxx', 'user' => 'xxxxxxxxxxxxxxxxxxx', 'password' => 'xxxxxxxxxxxx', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'serverVersion' => 5.0999999999999996447286321199499070644378662109375, 'defaultTableOptions' => array()), 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Connection.php line 360
at Connection->connect()in Connection.php line 942
at Connection->query('SELECT name FROM pshu_module WHERE active = 1')in ModuleRepository.php line 59
at ModuleRepository->getActiveModules()in ModuleRepository.php line 73
at ModuleRepository->getActiveModulesPaths()in appDevDebugProjectContainer.php line 2828
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_RoutingCacheKeyGeneratorService()in appDevDebugProjectContainer.php line 2808
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_CacheProviderService()in appDevDebugProjectContainer.php line 1505
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_LegacyUrlConverterService()in appDevDebugProjectContainer.php line 1668
at appDevDebugProjectContainer->getPrestashop_LegacyUrlListenerService()in appDevDebugProjectContainer.php line 2286
at appDevDebugProjectContainer->ContainerSu2xjni\{closure}()in EventDispatcher.php line 229
at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61
at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 128
at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 250
at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 134
at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))in HttpKernel.php line 127
at HttpKernel->handleRaw(object(Request), 1)in HttpKernel.php line 68
at HttpKernel->handle(object(Request), 1, false)in Kernel.php line 200
at Kernel->handle(object(Request), 1, false)in index.php line 88

(2/3) PDOException SQLSTATE[42000] [1203] User p0rtugal_loja already has more than 'max_user_connections' active connections
in PDOConnection.php line 47
at PDOConnection->__construct('mysql:host=mysql1004.mochahost.com;port=;dbname=p0rtugal_loja;charset=UTF8;', 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Driver.php line 44
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'xxxxxxxxxxxxxxx', 'port' => '', 'dbname' => 'p0rtugal_loja', 'user' => 'xxxxxxxxxxxxxxxx', 'password' => 'xxxxxxxxxxxx', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'serverVersion' => 5.0999999999999996447286321199499070644378662109375, 'defaultTableOptions' => array()), 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Connection.php line 360
at Connection->connect()in Connection.php line 942
at Connection->query('SELECT name FROM pshu_module WHERE active = 1')in ModuleRepository.php line 59
at ModuleRepository->getActiveModules()in ModuleRepository.php line 73
at ModuleRepository->getActiveModulesPaths()in appDevDebugProjectContainer.php line 2828
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_RoutingCacheKeyGeneratorService()in appDevDebugProjectContainer.php line 2808
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_CacheProviderService()in appDevDebugProjectContainer.php line 1505
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_LegacyUrlConverterService()in appDevDebugProjectContainer.php line 1668
at appDevDebugProjectContainer->getPrestashop_LegacyUrlListenerService()in appDevDebugProjectContainer.php line 2286
at appDevDebugProjectContainer->ContainerSu2xjni\{closure}()in EventDispatcher.php line 229
at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61
at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 128
at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 250
at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 134
at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))in HttpKernel.php line 127
at HttpKernel->handleRaw(object(Request), 1)in HttpKernel.php line 68
at HttpKernel->handle(object(Request), 1, false)in Kernel.php line 200
at Kernel->handle(object(Request), 1, false)in index.php line 88

(1/3) PDOException SQLSTATE[42000] [1203] User p0rtugal_loja already has more than 'max_user_connections' active connections
in PDOConnection.php line 43
at PDO->__construct('mysql:host=mysql1004.mochahost.com;port=;dbname=p0rtugal_loja;charset=UTF8;', 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in PDOConnection.php line 43
at PDOConnection->__construct('mysql:host=mysql1004.mochahost.com;port=;dbname=p0rtugal_loja;charset=UTF8;', 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Driver.php line 44
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'xxxxxxxxxxxxxxxxxxxxxxx', 'port' => '', 'dbname' => 'xxxxxxxxxxxxxxxxxxxxxx', 'user' => 'xxxxxxxxxxxxxxxxxxx', 'password' => 'xxxxxxxxxxxxxx', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'serverVersion' => 5.0999999999999996447286321199499070644378662109375, 'defaultTableOptions' => array()), 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Connection.php line 360
at Connection->connect()in Connection.php line 942
at Connection->query('SELECT name FROM pshu_module WHERE active = 1')in ModuleRepository.php line 59
at ModuleRepository->getActiveModules()in ModuleRepository.php line 73
at ModuleRepository->getActiveModulesPaths()in appDevDebugProjectContainer.php line 2828
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_RoutingCacheKeyGeneratorService()in appDevDebugProjectContainer.php line 2808
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_CacheProviderService()in appDevDebugProjectContainer.php line 1505
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_LegacyUrlConverterService()in appDevDebugProjectContainer.php line 1668
at appDevDebugProjectContainer->getPrestashop_LegacyUrlListenerService()in appDevDebugProjectContainer.php line 2286
at appDevDebugProjectContainer->ContainerSu2xjni\{closure}()in EventDispatcher.php line 229
at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61
at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 128
at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 250
at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 134
at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))in HttpKernel.php line 127
at HttpKernel->handleRaw(object(Request), 1)in HttpKernel.php line 68
at HttpKernel->handle(object(Request), 1, false)in Kernel.php line 200
at Kernel->handle(object(Request), 1, false)in index.php line 88

[email protected] · January 20, 2019

AFter update to 1.7.5 keep getting 500 error in random pages and internal server error when accessing stock

Link to database cannot be established: SQLSTATE[42000] [1203] User p0rtugal_loja already has more than 'max_user_connections' active connections
at line 127 in file classes/db/DbPDO.php

122.     public function connect()
123.     {
124.         try {
125.             $this->link = $this->getPDO($this->server, $this->user, $this->password, $this->database, 5);
126.         } catch (PDOException $e) {
127.             throw new PrestaShopException('Link to database cannot be established: ' . $e->getMessage());
128.         }
129. 
130.         $this->link->exec('SET SESSION sql_mode = \'\'');
131. 
132.         return $this->link;

DbPDOCore->connect - [line 330 - classes/db/Db.php]
DbCore->__construct - [line 241 - classes/db/Db.php] - [4 Arguments]
DbCore::getInstance - [line 48 - config/alias.php]
pSQL - [line 340 - classes/shop/Shop.php] - [1 Arguments]
ShopCore::initialize - [line 119 - config/config.inc.php]
require - [line 42 - admin/index.php] - [1 Arguments]

(3/3) DriverException An exception occured in driver: SQLSTATE[42000] [1203] User p0rtugal_loja already has more than 'max_user_connections' active connections
in AbstractMySQLDriver.php line 115
at AbstractMySQLDriver->convertException('An exception occured in driver: SQLSTATE[42000] [1203] User p0rtugal_loja already has more than \'max_user_connections\' active connections', object(PDOException))in DBALException.php line 145
at DBALException::driverException(object(Driver), object(PDOException))in Driver.php line 47
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'mysql1004.mochahost.com', 'port' => '', 'dbname' => 'p0rtugal_loja', 'user' => 'p0rtugal_loja', 'password' => '8JpS.T9.4z', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'serverVersion' => 5.0999999999999996447286321199499070644378662109375, 'defaultTableOptions' => array()), 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Connection.php line 360
at Connection->connect()in Connection.php line 942
at Connection->query('SELECT name FROM pshu_module WHERE active = 1')in ModuleRepository.php line 59
at ModuleRepository->getActiveModules()in ModuleRepository.php line 73
at ModuleRepository->getActiveModulesPaths()in appDevDebugProjectContainer.php line 2828
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_RoutingCacheKeyGeneratorService()in appDevDebugProjectContainer.php line 2808
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_CacheProviderService()in appDevDebugProjectContainer.php line 1505
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_LegacyUrlConverterService()in appDevDebugProjectContainer.php line 1668
at appDevDebugProjectContainer->getPrestashop_LegacyUrlListenerService()in appDevDebugProjectContainer.php line 2286
at appDevDebugProjectContainer->ContainerSu2xjni\{closure}()in EventDispatcher.php line 229
at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61
at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 128
at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 250
at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 134
at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))in HttpKernel.php line 127
at HttpKernel->handleRaw(object(Request), 1)in HttpKernel.php line 68
at HttpKernel->handle(object(Request), 1, false)in Kernel.php line 200
at Kernel->handle(object(Request), 1, false)in index.php line 88

(2/3) PDOException SQLSTATE[42000] [1203] User p0rtugal_loja already has more than 'max_user_connections' active connections
in PDOConnection.php line 47
at PDOConnection->__construct('mysql:host=mysql1004.mochahost.com;port=;dbname=p0rtugal_loja;charset=UTF8;', 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Driver.php line 44
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'mysql1004.mochahost.com', 'port' => '', 'dbname' => 'p0rtugal_loja', 'user' => 'p0rtugal_loja', 'password' => '8JpS.T9.4z', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'serverVersion' => 5.0999999999999996447286321199499070644378662109375, 'defaultTableOptions' => array()), 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Connection.php line 360
at Connection->connect()in Connection.php line 942
at Connection->query('SELECT name FROM pshu_module WHERE active = 1')in ModuleRepository.php line 59
at ModuleRepository->getActiveModules()in ModuleRepository.php line 73
at ModuleRepository->getActiveModulesPaths()in appDevDebugProjectContainer.php line 2828
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_RoutingCacheKeyGeneratorService()in appDevDebugProjectContainer.php line 2808
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_CacheProviderService()in appDevDebugProjectContainer.php line 1505
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_LegacyUrlConverterService()in appDevDebugProjectContainer.php line 1668
at appDevDebugProjectContainer->getPrestashop_LegacyUrlListenerService()in appDevDebugProjectContainer.php line 2286
at appDevDebugProjectContainer->ContainerSu2xjni\{closure}()in EventDispatcher.php line 229
at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61
at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 128
at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 250
at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 134
at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))in HttpKernel.php line 127
at HttpKernel->handleRaw(object(Request), 1)in HttpKernel.php line 68
at HttpKernel->handle(object(Request), 1, false)in Kernel.php line 200
at Kernel->handle(object(Request), 1, false)in index.php line 88

(1/3) PDOException SQLSTATE[42000] [1203] User p0rtugal_loja already has more than 'max_user_connections' active connections
in PDOConnection.php line 43
at PDO->__construct('mysql:host=mysql1004.mochahost.com;port=;dbname=p0rtugal_loja;charset=UTF8;', 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in PDOConnection.php line 43
at PDOConnection->__construct('mysql:host=mysql1004.mochahost.com;port=;dbname=p0rtugal_loja;charset=UTF8;', 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Driver.php line 44
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'mysql1004.mochahost.com', 'port' => '', 'dbname' => 'p0rtugal_loja', 'user' => 'p0rtugal_loja', 'password' => '8JpS.T9.4z', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'serverVersion' => 5.0999999999999996447286321199499070644378662109375, 'defaultTableOptions' => array()), 'p0rtugal_loja', '8JpS.T9.4z', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Connection.php line 360
at Connection->connect()in Connection.php line 942
at Connection->query('SELECT name FROM pshu_module WHERE active = 1')in ModuleRepository.php line 59
at ModuleRepository->getActiveModules()in ModuleRepository.php line 73
at ModuleRepository->getActiveModulesPaths()in appDevDebugProjectContainer.php line 2828
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_RoutingCacheKeyGeneratorService()in appDevDebugProjectContainer.php line 2808
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_CacheProviderService()in appDevDebugProjectContainer.php line 1505
at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_LegacyUrlConverterService()in appDevDebugProjectContainer.php line 1668
at appDevDebugProjectContainer->getPrestashop_LegacyUrlListenerService()in appDevDebugProjectContainer.php line 2286
at appDevDebugProjectContainer->ContainerSu2xjni\{closure}()in EventDispatcher.php line 229
at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61
at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 128
at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 250
at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 134
at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))in HttpKernel.php line 127
at HttpKernel->handleRaw(object(Request), 1)in HttpKernel.php line 68
at HttpKernel->handle(object(Request), 1, false)in Kernel.php line 200
at Kernel->handle(object(Request), 1, false)in index.php line 88

[email protected] · January 20, 2019

AFter update to 1.7.5 keep getting 500 error in random pages and internal server error when accessing stock

Link to database cannot be established: SQLSTATE[42000] [1203] User p0rtugal_loja already has more than 'max_user_connections' active connections
at line 127 in file classes/db/DbPDO.php

122.     public function connect()
123.     {
124.         try {
125.             $this->link = $this->getPDO($this->server, $this->user, $this->password, $this->database, 5);
126.         } catch (PDOException $e) {
127.             throw new PrestaShopException('Link to database cannot be established: ' . $e->getMessage());
128.         }
129. 
130.         $this->link->exec('SET SESSION sql_mode = \'\'');
131. 
132.         return $this->link;

DbPDOCore->connect - [line 330 - classes/db/Db.php]
DbCore->__construct - [line 241 - classes/db/Db.php] - [4 Arguments]
DbCore::getInstance - [line 48 - config/alias.php]
pSQL - [line 340 - classes/shop/Shop.php] - [1 Arguments]
ShopCore::initialize - [line 119 - config/config.inc.php]
require - [line 42 - admin/index.php] - [1 Arguments]

Sign In

Edit History

[email protected]

[email protected]

(3/3) DriverException

(2/3) PDOException

(1/3) PDOException

[email protected]

(3/3) DriverException

(2/3) PDOException

(1/3) PDOException

[email protected]

Browse

Activity

Go back to prestashop.com