BONJOUR à tous ce Bug n'est PAS RESOLU pour moi à fin 2021
Suis chez OVH
j'ai perdu l'accès au catalogue produits par ce Bug apparu à l'été 2021 ? donc longtemps après la refonte à neuf en version 1.7.1.2 d'un vieux site
nota j'ai un autre probleme depuis le debut des "faux profils de clients " qui s'inscrivent et que j'efface régulièrement comme je n'utilise pas le site pour vendre à distance
je m'en fout un peu... MAIS suis bien curieux de comprendre et d' aider ceux pour qui c'est vital...
STORE INFORMATION
PrestaShop version: 1.7.1.2
Shop URL: http://lavieenarts.fr/
Current theme in use: warehouse (au passage je signale que >>
Your warehouse theme version is outdated. Latest theme version is: 4.5.0. Your version is 4.1.5) mais je ne l'ai pas mis à jour...
Your web browser:
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15
Server information:
Linux #1 SMP Mon May 10 09:26:52 CEST 2021 x86_64
Server software version: Apache
PHP version: 7.1.33
Memory limit: 512M
Max execution time: 165
Upload Max File size: 128M
Habituellement j'utilise Safari Mais soudain quand je tente d'afficher le catalogue produits j'obtenais une page blanche
j'essaye donc Chrome et là j'arrive à MIEUX afficher le BO et notamment le menu déroulant de Advanced Parameters/
DONC j'ai mis encode debug (ASTUCE ! >> gardez la page du BO ouverte sur le bouton du mode debug pour pouvoir repasser facilement le mode debug en Off) !!!
et ça m'a affiché plein d'erreurs notamment une dB erronée(Mod3 au lieu de Mod 1) voir ci dessous
mais surtout je n'arrivais plus à me connecter :
ni au BO (heureusement j'avais gardé la page advanced parameters / Performance ouverte sur Chrome)
ni au site...
j'ai donc repassé le mode debug en OFF (après avoir copié tous les messages d'erreurs)
quand sous SAFARI j'essaye d'afficher la page catalogue produits j'obtiens un message d'alerte
>>>
INVALID SECURITY TOKEN
I understand the risks and I really want to display this page
puis un affichage partiel du BO et toujours pas accès au catalogue...
<<<
et sous CHROME j'obtiens
>>
Cette page ne fonctionne pas
Impossible de traiter cette demande via lavieenarts.fr à l'heure actuelle.
HTTP ERROR 500
<<
alors qu'en mode debug sur
https://lavieenarts.fr/admin6275/index.php/product/catalog?_token=niQIYmGIvjXp8hDoaebmPzt0t6bYblFX_Fc8HuKhdOw
j'obtenais
Whoops, looks like something went wrong.
4/4ConnectionException in AbstractMySQLDriver.php line 103:An exception occured in driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
in AbstractMySQLDriver.php line 103
at AbstractMySQLDriver->convertException('An exception occured in driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known', 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' => 'lavieenamod3.mysql.db', 'port' => '3306', 'dbname' => 'lavieenamod3', 'user' => 'lavieenamod3', 'password' => 'Lavieenamod3', 'charset' => 'UTF8', 'driverOptions' => array(), 'serverVersion' => '5.1'), 'lavieenamod3', 'Lavieenamod3', array()) in Connection.php line 360
at Connection->connect() in Connection.php line 833
at Connection->executeQuery('SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1', array('3', '1', 'ProductController', 'catalogAction'), array('integer', 'integer', 'string', 'string')) in BasicEntityPersister.php line 712
at BasicEntityPersister->load(array('employee' => '3', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction'), null, null, array(), null, '1', null) in EntityRepository.php line 196
at EntityRepository->findOneBy(array('employee' => '3', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction')) in AdminProductDataProvider.php line 79
at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 135
at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'desc')
at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'desc')) in bootstrap.php.cache line 3247
at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3206
at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3360
at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2562
at Kernel->handle(object(Request), '1', false) in index.php line 86
3/4PDOException in PDOConnection.php line 47:SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
in PDOConnection.php line 47
at PDOConnection->__construct('mysql:host=lavieenamod3.mysql.db;port=3306;dbname=lavieenamod3;charset=UTF8;', 'lavieenamod3', 'Lavieenamod3', array()) in Driver.php line 44
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'lavieenamod3.mysql.db', 'port' => '3306', 'dbname' => 'lavieenamod3', 'user' => 'lavieenamod3', 'password' => 'Lavieenamod3', 'charset' => 'UTF8', 'driverOptions' => array(), 'serverVersion' => '5.1'), 'lavieenamod3', 'Lavieenamod3', array()) in Connection.php line 360
at Connection->connect() in Connection.php line 833
at Connection->executeQuery('SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1', array('3', '1', 'ProductController', 'catalogAction'), array('integer', 'integer', 'string', 'string')) in BasicEntityPersister.php line 712
at BasicEntityPersister->load(array('employee' => '3', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction'), null, null, array(), null, '1', null) in EntityRepository.php line 196
at EntityRepository->findOneBy(array('employee' => '3', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction')) in AdminProductDataProvider.php line 79
at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 135
at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'desc')
at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'desc')) in bootstrap.php.cache line 3247
at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3206
at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3360
at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2562
at Kernel->handle(object(Request), '1', false) in index.php line 86
2/4PDOException in PDOConnection.php line 43:SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
in PDOConnection.php line 43
at PDO->__construct('mysql:host=lavieenamod3.mysql.db;port=3306;dbname=lavieenamod3;charset=UTF8;', 'lavieenamod3', 'Lavieenamod3', array()) in PDOConnection.php line 43
at PDOConnection->__construct('mysql:host=lavieenamod3.mysql.db;port=3306;dbname=lavieenamod3;charset=UTF8;', 'lavieenamod3', 'Lavieenamod3', array()) in Driver.php line 44
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'lavieenamod3.mysql.db', 'port' => '3306', 'dbname' => 'lavieenamod3', 'user' => 'lavieenamod3', 'password' => 'Lavieenamod3', 'charset' => 'UTF8', 'driverOptions' => array(), 'serverVersion' => '5.1'), 'lavieenamod3', 'Lavieenamod3', array()) in Connection.php line 360
at Connection->connect() in Connection.php line 833
at Connection->executeQuery('SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1', array('3', '1', 'ProductController', 'catalogAction'), array('integer', 'integer', 'string', 'string')) in BasicEntityPersister.php line 712
at BasicEntityPersister->load(array('employee' => '3', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction'), null, null, array(), null, '1', null) in EntityRepository.php line 196
at EntityRepository->findOneBy(array('employee' => '3', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction')) in AdminProductDataProvider.php line 79
at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 135
at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'desc')
at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'desc')) in bootstrap.php.cache line 3247
at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3206
at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3360
at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2562
at Kernel->handle(object(Request), '1', false) in index.php line 86
1/4PDOException in PDOConnection.php line 43:PDO::__construct(): php_network_getaddresses: getaddrinfo failed: Name or service not known
in PDOConnection.php line 43
at PDO->__construct('mysql:host=lavieenamod3.mysql.db;port=3306;dbname=lavieenamod3;charset=UTF8;', 'lavieenamod3', 'Lavieenamod3', array()) in PDOConnection.php line 43
at PDOConnection->__construct('mysql:host=lavieenamod3.mysql.db;port=3306;dbname=lavieenamod3;charset=UTF8;', 'lavieenamod3', 'Lavieenamod3', array()) in Driver.php line 44
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'lavieenamod3.mysql.db', 'port' => '3306', 'dbname' => 'lavieenamod3', 'user' => 'lavieenamod3', 'password' => 'Lavieenamod3', 'charset' => 'UTF8', 'driverOptions' => array(), 'serverVersion' => '5.1'), 'lavieenamod3', 'Lavieenamod3', array()) in Connection.php line 360
at Connection->connect() in Connection.php line 833
at Connection->executeQuery('SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1', array('3', '1', 'ProductController', 'catalogAction'), array('integer', 'integer', 'string', 'string')) in BasicEntityPersister.php line 712
at BasicEntityPersister->load(array('employee' => '3', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction'), null, null, array(), null, '1', null) in EntityRepository.php line 196
at EntityRepository->findOneBy(array('employee' => '3', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction')) in AdminProductDataProvider.php line 79
at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 135
at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'desc')
at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'desc')) in bootstrap.php.cache line 3247
at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3206
at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3360
at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2562
at Kernel->handle(object(Request), '1', false) in index.php line 86
NOTA j'ai supprimé la dB mod3 mais à priori ce n'était pas la cause du bug puisque le probleme est apparu avant la suppression de la dB