ABSOLU PARIS Posted April 20, 2015 Share Posted April 20, 2015 Bonjour, Je cherche de l'aide car depuis peu lorsqu'un nouveau client veut s'enregistrer sur mon site le message suivant apparait [PrestaShopDatabaseException]Unknown column 'id_shop_group' in 'field list' SELECT GROUP_CONCAT(id_shop_group) as groupid FROM ps_sendin_newsletter WHERE email = "[email protected]" GROUP BY email LIMIT 1at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. }631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. {633. if ($sql)634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. throw new PrestaShopDatabaseException($this->getMsgError());636. }637. }638.639. /** DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 547 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 2754 - modules/sendinblue/sendinblue.php] - [1 Arguments] Sendinblue->subscribeByruntimeRegister - [line 322 - modules/sendinblue/sendinblue.php] - [10 Arguments] Sendinblue->callhookRegister - [line 113 - modules/sendinblue/sendinblue.php] Sendinblue->__construct - [line 1031 - classes/module/Module.php] ModuleCore::getInstanceByName - [line 463 - classes/Hook.php] - [1 Arguments] HookCore::exec - [line 448 - classes/controller/FrontController.php] - [1 Arguments] FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php] IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Quelqu'un connait ce problème ?Merci d'avanceEric Link to comment Share on other sites More sharing options...
kayol10 Posted June 8, 2015 Share Posted June 8, 2015 Any solution Eric? I have the same issue Avais tu trouves une solution? Radu Bonjour, Je cherche de l'aide car depuis peu lorsqu'un nouveau client veut s'enregistrer sur mon site le message suivant apparait[PrestaShopDatabaseException]Unknown column 'id_shop_group' in 'field list' SELECT GROUP_CONCAT(id_shop_group) as groupid FROM ps_sendin_newsletter WHERE email = "[email protected]" GROUP BY email LIMIT 1at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. }631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. {633. if ($sql)634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. throw new PrestaShopDatabaseException($this->getMsgError());636. }637. }638.639. /** DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 547 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 2754 - modules/sendinblue/sendinblue.php] - [1 Arguments] Sendinblue->subscribeByruntimeRegister - [line 322 - modules/sendinblue/sendinblue.php] - [10 Arguments] Sendinblue->callhookRegister - [line 113 - modules/sendinblue/sendinblue.php] Sendinblue->__construct - [line 1031 - classes/module/Module.php] ModuleCore::getInstanceByName - [line 463 - classes/Hook.php] - [1 Arguments] HookCore::exec - [line 448 - classes/controller/FrontController.php] - [1 Arguments] FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php] IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Quelqu'un connait ce problème ?Merci d'avanceEric Link to comment Share on other sites More sharing options...
kayol10 Posted June 8, 2015 Share Posted June 8, 2015 Eric, I dont know if you understand what I am saying, mais j'ai trouve une solution La solution va tres bien pour moi I'll switch back to English In the ps_sendin_newsletter table, I have changed the name of the column from id_group_shop to id_shop_group which is being referenced in sendinblue.php Hope it helps you as well Radu Bonjour, Je cherche de l'aide car depuis peu lorsqu'un nouveau client veut s'enregistrer sur mon site le message suivant apparait[PrestaShopDatabaseException]Unknown column 'id_shop_group' in 'field list' SELECT GROUP_CONCAT(id_shop_group) as groupid FROM ps_sendin_newsletter WHERE email = "[email protected]" GROUP BY email LIMIT 1at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. }631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. {633. if ($sql)634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. throw new PrestaShopDatabaseException($this->getMsgError());636. }637. }638.639. /** DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 547 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 2754 - modules/sendinblue/sendinblue.php] - [1 Arguments] Sendinblue->subscribeByruntimeRegister - [line 322 - modules/sendinblue/sendinblue.php] - [10 Arguments] Sendinblue->callhookRegister - [line 113 - modules/sendinblue/sendinblue.php] Sendinblue->__construct - [line 1031 - classes/module/Module.php] ModuleCore::getInstanceByName - [line 463 - classes/Hook.php] - [1 Arguments] HookCore::exec - [line 448 - classes/controller/FrontController.php] - [1 Arguments] FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php] IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Quelqu'un connait ce problème ?Merci d'avanceEric Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now