Jump to content

Probleme site prestashop http error 500


Recommended Posts

image.thumb.png.3ce66038c3e802563b1a897b07e92272.png

Bonjour a tous

J'ai vraiment besoin de votre aide.

J'ai une erreur http error 500 qui s'affiche sur mon site depuis quelques semaine.

J'ai consulté quelques forum afin de trouver une solution ou on m'a dit d'activer le mode debug sur prestashop. J'ai finalement pu activer le mode debug mais c'est en ce moment ou s'affiche plein de probleme a regler mais en vrai j'ai un peu de mal a gerer tous sa et j'aimerais trouver de l'aide ici.

Voila ci-dessous ce que sa m'affiche comme problème: 

 

(4/4) DBALException

An exception occured while establishing a connection to figure out your platform version.
You can circumvent this by setting a 'server_version' configuration value

For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673

in ConnectionFactory.php line 79

at ConnectionFactory->getDatabasePlatform(object(Connection))in ConnectionFactory.php line 50

at ConnectionFactory->createConnection(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => '', 'dbname' => 'c1651672c_pre430', 'user' => 'c1651672c_pre430', 'password' => 'Rp[6S1!8tx', 'charset' => 'utf8mb4', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'defaultTableOptions' => array()), object(Configuration), object(ContainerAwareEventManager), array('enum' => 'string'))in appDevDebugProjectContainer.php line 2718

at appDevDebugProjectContainer->getDoctrine_Dbal_DefaultConnectionService()in getPrestashop_ModuleKernel_RepositoryService.php line 8

at require('/home/c1651672c/public_html/var/cache/dev/ContainerO1cojfg/getPrestashop_ModuleKernel_RepositoryService.php')in appDevDebugProjectContainer.php line 2615

at appDevDebugProjectContainer->load('getPrestashop_ModuleKernel_RepositoryService.php')in appDevDebugProjectContainer.php line 4495

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_RoutingCacheKeyGeneratorService()in appDevDebugProjectContainer.php line 4475

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_CacheProviderService()in appDevDebugProjectContainer.php line 2982

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_LegacyUrlConverterService()in appDevDebugProjectContainer.php line 3241

at appDevDebugProjectContainer->getPrestashop_LegacyUrlListenerService()in appDevDebugProjectContainer.php line 3896

at appDevDebugProjectContainer->ContainerO1cojfg\{closure}()in EventDispatcher.php line 231

at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61

at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 129

at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 259

at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 137

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 82

(3/4) DriverException

An exception occurred in driver: SQLSTATE[42000] [1203] User c1651672c_pre430 already has more than 'max_user_connections' active connections

in AbstractMySQLDriver.php line 106

at AbstractMySQLDriver->convertException('An exception occurred in driver: SQLSTATE[42000] [1203] User c1651672c_pre430 already has more than \'max_user_connections\' active connections', object(PDOException))in DBALException.php line 169

at DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred in driver: SQLSTATE[42000] [1203] User c1651672c_pre430 already has more than \'max_user_connections\' active connections')in DBALException.php line 155

at DBALException::driverException(object(Driver), object(PDOException))in Driver.php line 28

at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => '', 'dbname' => 'c1651672c_pre430', 'user' => 'c1651672c_pre430', 'password' => 'Rp[6S1!8tx', 'charset' => 'utf8mb4', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'defaultTableOptions' => array()), 'c1651672c_pre430', 'Rp[6S1!8tx', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Connection.php line 356

at Connection->connect()in Connection.php line 422

at Connection->getDatabasePlatformVersion()in Connection.php line 382

at Connection->detectDatabasePlatform()in Connection.php line 324

at Connection->getDatabasePlatform()in ConnectionFactory.php line 77

at ConnectionFactory->getDatabasePlatform(object(Connection))in ConnectionFactory.php line 50

at ConnectionFactory->createConnection(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => '', 'dbname' => 'c1651672c_pre430', 'user' => 'c1651672c_pre430', 'password' => 'Rp[6S1!8tx', 'charset' => 'utf8mb4', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'defaultTableOptions' => array()), object(Configuration), object(ContainerAwareEventManager), array('enum' => 'string'))in appDevDebugProjectContainer.php line 2718

at appDevDebugProjectContainer->getDoctrine_Dbal_DefaultConnectionService()in getPrestashop_ModuleKernel_RepositoryService.php line 8

at require('/home/c1651672c/public_html/var/cache/dev/ContainerO1cojfg/getPrestashop_ModuleKernel_RepositoryService.php')in appDevDebugProjectContainer.php line 2615

at appDevDebugProjectContainer->load('getPrestashop_ModuleKernel_RepositoryService.php')in appDevDebugProjectContainer.php line 4495

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_RoutingCacheKeyGeneratorService()in appDevDebugProjectContainer.php line 4475

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_CacheProviderService()in appDevDebugProjectContainer.php line 2982

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_LegacyUrlConverterService()in appDevDebugProjectContainer.php line 3241

at appDevDebugProjectContainer->getPrestashop_LegacyUrlListenerService()in appDevDebugProjectContainer.php line 3896

at appDevDebugProjectContainer->ContainerO1cojfg\{closure}()in EventDispatcher.php line 231

at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61

at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 129

at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 259

at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 137

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 82

(2/4) PDOException

SQLSTATE[42000] [1203] User c1651672c_pre430 already has more than 'max_user_connections' active connections

in PDOConnection.php line 31

at PDOConnection->__construct('mysql:host=localhost;port=;dbname=c1651672c_pre430;charset=utf8mb4;', 'c1651672c_pre430', 'Rp[6S1!8tx', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Driver.php line 25

at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => '', 'dbname' => 'c1651672c_pre430', 'user' => 'c1651672c_pre430', 'password' => 'Rp[6S1!8tx', 'charset' => 'utf8mb4', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'defaultTableOptions' => array()), 'c1651672c_pre430', 'Rp[6S1!8tx', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Connection.php line 356

at Connection->connect()in Connection.php line 422

at Connection->getDatabasePlatformVersion()in Connection.php line 382

at Connection->detectDatabasePlatform()in Connection.php line 324

at Connection->getDatabasePlatform()in ConnectionFactory.php line 77

at ConnectionFactory->getDatabasePlatform(object(Connection))in ConnectionFactory.php line 50

at ConnectionFactory->createConnection(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => '', 'dbname' => 'c1651672c_pre430', 'user' => 'c1651672c_pre430', 'password' => 'Rp[6S1!8tx', 'charset' => 'utf8mb4', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'defaultTableOptions' => array()), object(Configuration), object(ContainerAwareEventManager), array('enum' => 'string'))in appDevDebugProjectContainer.php line 2718

at appDevDebugProjectContainer->getDoctrine_Dbal_DefaultConnectionService()in getPrestashop_ModuleKernel_RepositoryService.php line 8

at require('/home/c1651672c/public_html/var/cache/dev/ContainerO1cojfg/getPrestashop_ModuleKernel_RepositoryService.php')in appDevDebugProjectContainer.php line 2615

at appDevDebugProjectContainer->load('getPrestashop_ModuleKernel_RepositoryService.php')in appDevDebugProjectContainer.php line 4495

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_RoutingCacheKeyGeneratorService()in appDevDebugProjectContainer.php line 4475

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_CacheProviderService()in appDevDebugProjectContainer.php line 2982

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_LegacyUrlConverterService()in appDevDebugProjectContainer.php line 3241

at appDevDebugProjectContainer->getPrestashop_LegacyUrlListenerService()in appDevDebugProjectContainer.php line 3896

at appDevDebugProjectContainer->ContainerO1cojfg\{closure}()in EventDispatcher.php line 231

at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61

at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 129

at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 259

at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 137

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 82

(1/4) PDOException

SQLSTATE[42000] [1203] User c1651672c_pre430 already has more than 'max_user_connections' active connections

in PDOConnection.php line 27

at PDO->__construct('mysql:host=localhost;port=;dbname=c1651672c_pre430;charset=utf8mb4;', 'c1651672c_pre430', 'Rp[6S1!8tx', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in PDOConnection.php line 27

at PDOConnection->__construct('mysql:host=localhost;port=;dbname=c1651672c_pre430;charset=utf8mb4;', 'c1651672c_pre430', 'Rp[6S1!8tx', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Driver.php line 25

at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => '', 'dbname' => 'c1651672c_pre430', 'user' => 'c1651672c_pre430', 'password' => 'Rp[6S1!8tx', 'charset' => 'utf8mb4', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'defaultTableOptions' => array()), 'c1651672c_pre430', 'Rp[6S1!8tx', array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'))in Connection.php line 356

at Connection->connect()in Connection.php line 422

at Connection->getDatabasePlatformVersion()in Connection.php line 382

at Connection->detectDatabasePlatform()in Connection.php line 324

at Connection->getDatabasePlatform()in ConnectionFactory.php line 77

at ConnectionFactory->getDatabasePlatform(object(Connection))in ConnectionFactory.php line 50

at ConnectionFactory->createConnection(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => '', 'dbname' => 'c1651672c_pre430', 'user' => 'c1651672c_pre430', 'password' => 'Rp[6S1!8tx', 'charset' => 'utf8mb4', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'defaultTableOptions' => array()), object(Configuration), object(ContainerAwareEventManager), array('enum' => 'string'))in appDevDebugProjectContainer.php line 2718

at appDevDebugProjectContainer->getDoctrine_Dbal_DefaultConnectionService()in getPrestashop_ModuleKernel_RepositoryService.php line 8

at require('/home/c1651672c/public_html/var/cache/dev/ContainerO1cojfg/getPrestashop_ModuleKernel_RepositoryService.php')in appDevDebugProjectContainer.php line 2615

at appDevDebugProjectContainer->load('getPrestashop_ModuleKernel_RepositoryService.php')in appDevDebugProjectContainer.php line 4495

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_RoutingCacheKeyGeneratorService()in appDevDebugProjectContainer.php line 4475

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_CacheProviderService()in appDevDebugProjectContainer.php line 2982

at appDevDebugProjectContainer->getPrestashop_Bundle_Routing_Converter_LegacyUrlConverterService()in appDevDebugProjectContainer.php line 3241

at appDevDebugProjectContainer->getPrestashop_LegacyUrlListenerService()in appDevDebugProjectContainer.php line 3896

at appDevDebugProjectContainer->ContainerO1cojfg\{closure}()in EventDispatcher.php line 231

at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61

at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 129

at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 259

at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 137

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 82

Capture d’écran 2021-06-05 à 14.27.02

image.thumb.png.da5f017505e2f906cfd3195ca82ad16f.pngCapture d’écran 2021-06-05 à 14.27.46

image.thumb.png.adf5dff43edbe9ea16b3a570cea8c2e1.pngCapture d’écran 2021-06-05 à 14.31.40

image.thumb.png.b267615f0b9f85cd5952c4a7e914e922.pngCapture d’écran 2021-06-05 à 14.32.43

image.thumb.png.f4d694307c3e2de73b70e47d8f872376.pngCapture d’écran 2021-06-05 à 14.34.54

image.thumb.png.003ec407a63001d7d59d31d31488c7e4.pngCapture d’écran 2021-06-05 à 14.35.58

image.thumb.png.654bd2a00db621607a5505dc696d0133.pngCapture d’écran 2021-06-05 à 14.36.42

image.thumb.png.a717f033f23b53cd16feaaad99e2ae7d.pngCapture d’écran 2021-06-05 à 14.39.29

image.png

Share this post


Link to post
Share on other sites

Woupla !
Attention, tu donnes tes logs en clair createConnection(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => '', 'dbname' => 'c1651672c_pre430', 'user' => 'c1651672c_pre430', 'password' => '********, 'charset' => 'utf8mb4', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE(@@sql_mode,\'ONLY_FULL_GROUP_BY\',\'\'))'), 'defaultTableOptions'

Je te conseille de masquer au moins le mot de passe ;)

Sinon tu as plus d'infos à nous donner ? C'est un site en prod ou en test ? Je vois du localhost.
Tu utilises quel environnement de test si c'est le cas ? 
Je ne suis pas sure mais je pense que ton problème vient de ton serveur.

Share this post


Link to post
Share on other sites

Bonjour,

J'ai le même problème depuis début mai, voir forum ici : https://www.prestashop.com/forums/topic/1048779-plus-dacc%C3%A8s-cot%C3%A9-admin-erreur-type-500-sur-site-parfaitement-fonctionnel-cot%C3%A9-client/

Donc vous n'êtes pas la seule !

Je suis chez OVH. Après contact avec eux, ils m'ont dit d'améliorer la configuration de ma base de données...En bref, débrouillez-vous.

On m'a suggéré que mon site avait été piraté, parce que j'avais la 1.7.7.0 et que maintenant c'est la 1.7.7.5....Je ne crois pas que ce soit le cas.

Je n'ai pas trouvé la solution à ce problème.

Je n'ai pas eu le temps de m'en occuper étant en pleine saison pour moi, mais j'envisage de tout ré-installer en tachant de récupérer la base de données pour garder les fiches produits, etc...

Si vous trouvez une solution autre, merci de m'en faire part !

Bon courage

Share this post


Link to post
Share on other sites

  • 6 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More