Jump to content

Impossible d'afficher les catégories produits, modules et expédition


Recommended Posts

Bonjour, je viens de migrer mon Prestashop de local vers un hébergeur, j'ai eu pas mal de soucis à régler mais là je ne trouve pas la solution. Tout fonctionne bien sauf quand je clique sur catalogue et modules, ou j'ai une page qui s'affiche: 

 

 

Whoops, looks like something went wrong. 3/3DriverException in AbstractMySQLDriver.php line 115:An exception occured in driver: could not find driver

  1. in AbstractMySQLDriver.php line 115
  2. at AbstractMySQLDriver->convertException('An exception occured in driver: could not find driver', 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' => '167.114.1.152', 'port' => '3306', 'dbname' => 'lecostum_database', 'user' => 'lecostum_charlescostumier', 'password' => 'costumiercharles257', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))'), 'serverVersion' => '5.1'), 'lecostum_charlescostumier', 'costumiercharles257', 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 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('1', '1', 'ProductController', 'catalogAction'), array('integer', 'integer', 'string', 'string')) in BasicEntityPersister.php line 712
  7. at BasicEntityPersister->load(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction'), nullnullarray(), null, '1', null) in EntityRepository.php line 196
  8. at EntityRepository->findOneBy(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction')) in AdminProductDataProvider.php line 88
  9. at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 137
  10. at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'desc')
  11. at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'desc')) in bootstrap.php.cache line 3247
  12. at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3206
  13. at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3360
  14. at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2562
  15. at Kernel->handle(object(Request), '1', false) in index.php line 86

2/3PDOException in PDOConnection.php line 47:could not find driver

  1. in PDOConnection.php line 47
  2. at PDOConnection->__construct('mysql:host=167.114.1.152;port=3306;dbname=lecostum_database;charset=UTF8;', 'lecostum_charlescostumier', 'costumiercharles257', 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' => '167.114.1.152', 'port' => '3306', 'dbname' => 'lecostum_database', 'user' => 'lecostum_charlescostumier', 'password' => 'costumiercharles257', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))'), 'serverVersion' => '5.1'), 'lecostum_charlescostumier', 'costumiercharles257', 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 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('1', '1', 'ProductController', 'catalogAction'), array('integer', 'integer', 'string', 'string')) in BasicEntityPersister.php line 712
  6. at BasicEntityPersister->load(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction'), nullnullarray(), null, '1', null) in EntityRepository.php line 196
  7. at EntityRepository->findOneBy(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction')) in AdminProductDataProvider.php line 88
  8. at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 137
  9. at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'desc')
  10. at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'desc')) in bootstrap.php.cache line 3247
  11. at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3206
  12. at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3360
  13. at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2562
  14. at Kernel->handle(object(Request), '1', false) in index.php line 86

1/3PDOException in PDOConnection.php line 43:could not find driver

  1. in PDOConnection.php line 43
  2. at PDO->__construct('mysql:host=167.114.1.152;port=3306;dbname=lecostum_database;charset=UTF8;', 'lecostum_charlescostumier', 'costumiercharles257', 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=167.114.1.152;port=3306;dbname=lecostum_database;charset=UTF8;', 'lecostum_charlescostumier', 'costumiercharles257', 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' => '167.114.1.152', 'port' => '3306', 'dbname' => 'lecostum_database', 'user' => 'lecostum_charlescostumier', 'password' => 'costumiercharles257', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))'), 'serverVersion' => '5.1'), 'lecostum_charlescostumier', 'costumiercharles257', 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 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('1', '1', 'ProductController', 'catalogAction'), array('integer', 'integer', 'string', 'string')) in BasicEntityPersister.php line 712
  7. at BasicEntityPersister->load(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction'), nullnullarray(), null, '1', null) in EntityRepository.php line 196
  8. at EntityRepository->findOneBy(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction')) in AdminProductDataProvider.php line 88
  9. at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 137
  10. at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'desc')
  11. at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'desc')) in bootstrap.php.cache line 3247
  12. at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3206
  13. at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3360
  14. at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2562
  15. at Kernel->handle(object(Request), '1', false) in index.php line 86

Et quand je vais sur expédition, j'ai un message différent qui s'affiche:

 

Whoops, looks like something went wrong. 1/1UndefinedMethodException in AdminCarriersController.php line 147:Attempted to call an undefined method named "fetchColumn" of class "mysqli_result".

  1. in AdminCarriersController.php line 147
  2. at AdminCarriersControllerCore->renderList() in AdminController.php line 2099
  3. at AdminControllerCore->initContent() in Controller.php line 205
  4. at ControllerCore->run() in Dispatcher.php line 379
  5. at DispatcherCore->dispatch() in index.php line 95

Tout le reste fonctionne.

J'ai activé le dev_mode pour voir tout ceci, sinon c'est juste écrit erreur 500

Pouvez vous m'aider ? 

 

Voici quelques infos supplémentaire:

version de prestashop: 1.7.2.0

url de la boutique: http://lecostumier.ca

Thème: Classic

Hébergeur: WHC

 

Edit: je viens de voir que dans mon installation locale, quand je veux entrer un nouveau produit, il me redirige vers le tableau de bord. Il m'est donc impossible d'entrer un nouveau produit

Edited by quentinsmx (see edit history)
Link to comment
Share on other sites

Voici la solution pour ceux qui pourrais rencontrer le même problème:

Sur le panneau de configuration de l'hébergeur, il suffit de trouver l'option "pdo_mysql" qui pour ma part ce trouvais dans "php selector" et qui n'était pas activée.

On l'active et tout fonctionne. 

Link to comment
Share on other sites

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
×
×
  • Create New...