Jump to content
blackpink

500 Server Error : Link to database cannot be established

Recommended Posts

Bonjour,

Hier j'ai voulu changer mon mot de passe de la base de données et bug :

Link to database cannot be established: SQLSTATE[HY000] [1045] Access denied for user 'dbo.........'@',,.,,,.,,.24' (using password: YES)
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;

J'ai donc appelé mon hébergeur qui lui veut bien le faire moyennant finance, je voulais donc savoir la marche à suivre pour résoudre ce problème.

Merci d'avance

Share this post


Link to post
Share on other sites

C'est bien de changer le mot de passe dans votre base de données mais avez-vous donné l'information à votre Prestashop ?

Share this post


Link to post
Share on other sites

accès refusé à la base de donnés tu as regarder dans la configuration de ton prestashop ?
version 1.6 -> dans le ftp dossier config -> settings.inc.php
Version 1.7 -> App/config/parametres.php

Le mot de passe est bien changer à ce niveau ?

Share this post


Link to post
Share on other sites
Posted (edited)

Bonsoir,

Quand je veux me connecter sur mon back office j'ai une page blanche.

Par contre des que je mets en mod débug  il fonctionne je peux me connecter celà vient de quoi svp

Merci d'avance

prestashop 1.7.5.2

Edited by blackpink (see edit history)

Share this post


Link to post
Share on other sites

Vide ton cache

supprime le dossier prod & dev dans le ftp 

Tu va dans VAR/CACHE/ delete les deux dossiers. Puis enlève le debug pour voir. 

Share this post


Link to post
Share on other sites

Apparemment celà fonctionne.

Pas tout à fait fini de vider le cache mais je peux me connecter.

Des que c'est fini je te dis ce qu'il en ait

Share this post


Link to post
Share on other sites

Si c’est pas fini pas très grave tu retourne sur ton back office tu va dans les performances et tu clique sur le bouton vide le cache :) .

Share this post


Link to post
Share on other sites

Excuse mais un peu de retard à l'allumage tout fonctionne sauf probleme sur les stats ça mouline tout le temps.

Share this post


Link to post
Share on other sites

Sa viens du serveur dans ce cas :s.
surement des réglages à faire de ce côté.

dans ta console F12 tu as une erreur ?
 

Share this post


Link to post
Share on other sites

Bonjour,

Dites moi quand je mets DEBUG j'ai cette erreur :

Notice à la ligne 101 du fichier /homepages/21/d780141553/htdocs/clickandbuilds/PrestaShop/MyeCommerce/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Handler/StrictSessionHandler.php
[8] SessionHandler::gc(): ps_files_cleanup_dir: opendir(/tmp/.priv) failed: Permission denied (13)

Pourriez me dire ce qu'il faut faire

Merci

Share this post


Link to post
Share on other sites
Posted (edited)

Bonjour,

Chez quel hébergeur êtes-vous ? 

Car là c'est le dossier temporaire qui n'est pas accessible.

Bonne journée !

Edited by Mathieu R (see edit history)

Share this post


Link to post
Share on other sites

Bonsoir,

D'accord, c'est bizarre j'ai jamais vu ce soucis chez Ionos, il faut que vous demandiez au support de "Changer les permissions du /tmp/.priv" de sorte a ce que vous puissiez écrire dessus.

 

Bonne jorunée !

Share this post


Link to post
Share on other sites

Bonjour,

J'ai refait mon site entierement et là en vérifiant en mettant en mode "debug" j'ai ces erreurs :

Warning à la ligne 2636 du fichier /homepages/21/d780141553/htdocs/clickandbuilds/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php
[2] "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

Warning à la ligne 2665 du fichier /homepages/21/d780141553/htdocs/clickandbuilds/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php
[2] "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

Pourriez vous me dire comment y remédier je vous en remercie par avance.

Share this post


Link to post
Share on other sites

quel version de php ?
Ce son des warning pas des erreurs.
Donc pas important en réalité.

Share this post


Link to post
Share on other sites

Bonjour

Je suis en version : PHP 7.3

je voudrais quand meme bien le résoudre ce souci.

Voilà l'ensemble qu'il me met lol

ContextErrorException

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

in UnitOfWork.php line 2636

at ErrorHandler->handleError(2, '"continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?', '/homepages/21/d780141553/htdocs/clickandbuilds/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php', 2636, array('file' => '/homepages/21/d780141553/htdocs/clickandbuilds/vendor/composer/../doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php'))in ClassLoader.php line 444

at include()in ClassLoader.php line 444

at Composer\Autoload\includeFile('/homepages/21/d780141553/htdocs/clickandbuilds/vendor/composer/../doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php')in ClassLoader.php line 322

at ClassLoader->loadClass('Doctrine\\ORM\\UnitOfWork')in DebugClassLoader.php line 159

at DebugClassLoader->loadClass('Doctrine\\ORM\\UnitOfWork')

at spl_autoload_call('Doctrine\\ORM\\UnitOfWork')in EntityManager.php line 160

at EntityManager->__construct(object(Connection), object(Configuration), object(ContainerAwareEventManager))in EntityManager.php line 850

at EntityManager::create(object(Connection), object(Configuration))in appDevDebugProjectContainer.php line 1820

at appDevDebugProjectContainer->getDoctrine_Orm_DefaultEntityManagerService()in appDevDebugProjectContainer.php line 1930

at appDevDebugProjectContainer->getPrestashop_Adapter_DataProvider_ModuleService()in appDevDebugProjectContainer.php line 2325

at appDevDebugProjectContainer->getPrestashop_Twig_Extension_HookService()in appDevDebugProjectContainer.php line 2546

at appDevDebugProjectContainer->getTwigService()in appDevDebugProjectContainer.php line 2430

at appDevDebugProjectContainer->getProfilerService()in appDevDebugProjectContainer.php line 3444

at appDevDebugProjectContainer->getProfilerListenerService()in appDevDebugProjectContainer.php line 2961

at appDevDebugProjectContainer->ContainerUxrzjbf\{closure}()in EventDispatcher.php line 145

at EventDispatcher->removeListener('kernel.exception', array(object(ExceptionListener), 'onKernelException'))in ContainerAwareEventDispatcher.php line 96

at ContainerAwareEventDispatcher->removeListener('kernel.exception', array(object(ExceptionListener), 'onKernelException'))in TraceableEventDispatcher.php line 75

at TraceableEventDispatcher->removeListener('kernel.exception', array(object(ExceptionListener), 'onKernelException'))in ExceptionListener.php line 82

at ExceptionListener->unregister(object(TraceableEventDispatcher))in Firewall.php line 92

at Firewall->onKernelFinishRequest(object(FinishRequestEvent))in FirewallListener.php line 57

at FirewallListener->onKernelFinishRequest(object(FinishRequestEvent), 'kernel.finish_request', object(TraceableEventDispatcher))in WrappedListener.php line 115

at WrappedListener->__invoke(object(FinishRequestEvent), 'kernel.finish_request', object(TraceableEventDispatcher))in EventDispatcher.php line 212

at EventDispatcher->doDispatch(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.finish_request', object(FinishRequestEvent))in EventDispatcher.php line 44

at EventDispatcher->dispatch('kernel.finish_request', object(FinishRequestEvent))in TraceableEventDispatcher.php line 143

at TraceableEventDispatcher->dispatch('kernel.finish_request', object(FinishRequestEvent))in HttpKernel.php line 210

at HttpKernel->finishRequest(object(Request), 1)in HttpKernel.php line 74

at HttpKernel->handle(object(Request), 1, false)in Kernel.php line 200

at Kernel->handle(object(Request), 1, false)in index.php line 86

2 ) Autre souci je ne peux plus mette le module paypal.

 

Share this post


Link to post
Share on other sites

En plus ne peut plus sortir du mode "debug" me remet la page que j'ai mise plus haut avec un autre message :

Notice à la ligne 101 du fichier /homepages/21/d780141553/htdocs/clickandbuilds/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Handler/StrictSessionHandler.php
[8] SessionHandler::gc(): ps_files_cleanup_dir: opendir(/tmp/.priv) failed: Permission denied (13)

Share this post


Link to post
Share on other sites

Résolu pour le mode "debug" je suis repassé en PHP 7.2 et celà fonctionne mieux.

Par contre souci pour le téléchargement sur mon site de paypal me met cette erreur :

{"ps_rem88_redirection":"https:\/\/itrottinette.com\/clickandbuilds\/admin7110n4prt\/index.php?controller=TrustedModule&token=69c7607ee53020a3e31d0b7ca02056d4&module_name=paypal&_token="}

Share this post


Link to post
Share on other sites

Supprime ton htaccess.

désactiver la réecriture d'url.
re supprime ton htaccess 
réactive la réecriture d'url.

vide le cache manuellement dans Var/cache tu supprime les deux dossier dev & prod.

Ensuite test ?

Share this post


Link to post
Share on other sites
Posted (edited)

Désolé pas eu le temps de revenir je m'en excuse. Par contre efficace.

Là j'ai un autre souci :

(1/1) ContextErrorException

Notice: Undefined index: id

in ps_categoryproducts.php line 336

at Ps_Categoryproducts->getInformationFromConfiguration(array('product' => object(ProductLazyArray), 'category' => object(Category), 'smarty' => object(SmartyDevTemplate), 'cookie' => object(Cookie), 'cart' => object(Cart)))in ps_categoryproducts.php line 232

at Ps_Categoryproducts->renderWidget('displayFooterProduct', array('product' => object(ProductLazyArray), 'category' => object(Category), 'smarty' => object(SmartyDevTemplate), 'cookie' => object(Cookie), 'cart' => object(Cart)))in Hook.php line 975

at HookCore::coreRenderWidget(object(Ps_Categoryproducts), 'displayFooterProduct', array('product' => object(ProductLazyArray), 'category' => object(Category), 'smarty' => object(SmartyDevTemplate), 'cookie' => object(Cookie), 'cart' => object(Cart)))in Hook.php line 927

at HookCore::exec('displayFooterProduct', array('product' => object(ProductLazyArray), 'category' => object(Category), 'smarty' => object(SmartyDevTemplate), 'cookie' => object(Cookie), 'cart' => object(Cart)), null)in smarty.config.inc.php line 167

at smartyHook(array('h' => 'displayFooterProduct', 'product' => object(ProductLazyArray), 'category' => object(Category)), object(SmartyDevTemplate))in SmartyLazyRegister.php line 83

at SmartyLazyRegister->__call('smartyHook', array(array('h' => 'displayFooterProduct', 'product' => object(ProductLazyArray), 'category' => object(Category)), object(SmartyDevTemplate)))in a35c1068d72f0181fb30da1dc33587c534a016bf_2.file.layout-both-columns.tpl.php line 441

at Block_1770825605d666debc00ec4_81020412->callBlock(object(SmartyDevTemplate))in smarty_internal_runtime_inheritance.php line 248

at Smarty_Internal_Runtime_Inheritance->callBlock(object(Block_1770825605d666debc00ec4_81020412), object(SmartyDevTemplate))in smarty_internal_runtime_inheritance.php line 184

at Smarty_Internal_Runtime_Inheritance->process(object(SmartyDevTemplate), object(Block_1770825605d666debc00ec4_81020412))in smarty_internal_runtime_inheritance.php line 156

at Smarty_Internal_Runtime_Inheritance->instanceBlock(object(SmartyDevTemplate), 'Block_1770825605d666debc00ec4_81020412', 'product_footer')in a35c1068d72f0181fb30da1dc33587c534a016bf_2.file.layout-both-columns.tpl.php line 134

at content_5d666debc05b73_15407205(object(SmartyDevTemplate))in smarty_template_resource_base.php line 123

at Smarty_Template_Resource_Base->getRenderedTemplateCode(object(SmartyDevTemplate))in smarty_template_compiled.php line 114

at Smarty_Template_Compiled->render(object(SmartyDevTemplate))in smarty_internal_template.php line 216

at Smarty_Internal_Template->render()in smarty_internal_template.php line 385

at Smarty_Internal_Template->_subTemplateRender('layouts/layout-both-columns.tpl', null, 'layouts/layout-full-width.tpl', 0, 3600, array(), 2, false, null, null)in smarty_internal_runtime_inheritance.php line 125

at Smarty_Internal_Runtime_Inheritance->endChild(object(SmartyDevTemplate), 'layouts/layout-both-columns.tpl')in d736df95005b5b5ad8d2cfe8a545649eb73a90f3_2.file.layout-full-width.tpl.php line 42

at content_5d666debbd07d7_75937914(object(SmartyDevTemplate))in smarty_template_resource_base.php line 123

at Smarty_Template_Resource_Base->getRenderedTemplateCode(object(SmartyDevTemplate))in smarty_template_compiled.php line 114

at Smarty_Template_Compiled->render(object(SmartyDevTemplate))in smarty_internal_template.php line 216

at Smarty_Internal_Template->render()in smarty_internal_template.php line 385

at Smarty_Internal_Template->_subTemplateRender('layouts/layout-full-width.tpl', null, 'layouts/layout-full-width.tpl', 0, 3600, array(), 2, false, null, null)in smarty_internal_runtime_inheritance.php line 125

at Smarty_Internal_Runtime_Inheritance->endChild(object(SmartyDevTemplate), 'layouts/layout-full-width.tpl')in 660f21f5cb1b4fdb6b560696e1f043add81b71ae_2.file.product.tpl.php line 53

at content_5d666e7cbf3bd6_45011025(object(SmartyDevTemplate))in smarty_template_resource_base.php line 123

at Smarty_Template_Resource_Base->getRenderedTemplateCode(object(SmartyDevTemplate))in smarty_template_compiled.php line 114

at Smarty_Template_Compiled->render(object(SmartyDevTemplate))in smarty_internal_template.php line 216

at Smarty_Internal_Template->render(false, 0)in smarty_internal_templatebase.php line 232

at Smarty_Internal_TemplateBase->_execute(object(SmartyDevTemplate), null, 'layouts/layout-full-width.tpl', null, 0)in smarty_internal_templatebase.php line 116

at Smarty_Internal_TemplateBase->fetch('catalog/product.tpl', null, 'layouts/layout-full-width.tpl', null, false, true, false)in SmartyDev.php line 40

at SmartyDev->fetch('catalog/product.tpl', null, 'layouts/layout-full-width.tpl')in FrontController.php line 683

at FrontControllerCore->smartyOutputContent('catalog/product.tpl')in FrontController.php line 667

at FrontControllerCore->display()in Controller.php line 311

at ControllerCore->run()in Dispatcher.php line 515

at DispatcherCore->dispatch()in index.php line 28

J'ai cette erreur et je suis dans la panade.

Merci

Edited by blackpink
pas terminer (see edit history)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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