gatla2 Posted December 19, 2018 Share Posted December 19, 2018 Bonjour j ai un problème , mon site tourne sur prestashop 1.6.1.2, le bouton ajouter au panier ne fonctionne pas et j ai ce message erreur ci dessous, merci de aider à résoudre le problème: UPDATE `ps_cart` SET `id_cart` = '88540',`id_shop_group` = '1',`id_shop` = '1',`id_address_delivery` = '442',`id_address_invoice` = '442',`id_carrier` = '0',`id_currency` = '4',`id_customer` = '3',`id_guest` = '4618',`id_lang` = '2',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '',`secure_key` = '68d5faed34eaf71f4fe540b9340c365a',`allow_seperated_package` = '0',`date_add` = '2018-11-20 23:57:48',`date_upd` = '2018-12-20 00:14:08',`quote` = '0' WHERE `id_cart` = 88540 at line 791 in file classes/db/Db.php 786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 790. if ($sql) { 791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 792. } 793. 794. throw new PrestaShopDatabaseException($this->getMsgError()); 795. } 796. } DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 48 - override/classes/db/Db.php] - [1 Arguments] Db->query - [line 763 - classes/db/Db.php] - [1 Arguments] DbCore->q - [line 559 - classes/db/Db.php] - [2 Arguments] DbCore->update - [line 652 - classes/ObjectModel.php] - [5 Arguments] ObjectModelCore->update - [line 213 - classes/Cart.php] - [1 Arguments] CartCore->update - [line 336 - controllers/front/OrderController.php] OrderControllerCore->processAddress - [line 177 - controllers/front/OrderController.php] OrderControllerCore->initContent - [line 189 - classes/controller/Controller.php] ControllerCore->run - [line 43 - override/classes/controller/Controller.php] Controller->run - [line 367 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Link to comment Share on other sites More sharing options...
Eolia Posted December 20, 2018 Share Posted December 20, 2018 Il manque le message d'erreur lui-même^^ (1ère ligne) Link to comment Share on other sites More sharing options...
gatla2 Posted December 22, 2018 Author Share Posted December 22, 2018 Hi Eolia oui désolé j ai pas fait attention , voilà tout le message d erreur : Unknown column 'quote' in 'field list' UPDATE `ps_cart` SET `id_cart` = '90366',`id_shop_group` = '1',`id_shop` = '1',`id_address_delivery` = '442',`id_address_invoice` = '442',`id_carrier` = '17',`id_currency` = '4',`id_customer` = '3',`id_guest` = '4618',`id_lang` = '2',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '{\"442\":\"17,\"}',`secure_key` = '68d5faed34eaf71f4fe540b9340c365a',`allow_seperated_package` = '0',`date_add` = '2018-12-18 23:09:26',`date_upd` = '2018-12-22 12:27:22',`quote` = '0' WHERE `id_cart` = 90366 at line 791 in file classes/db/Db.php 786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 790. if ($sql) { 791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 792. } 793. 794. throw new PrestaShopDatabaseException($this->getMsgError()); 795. } 796. } DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 48 - override/classes/db/Db.php] - [1 Arguments] Db->query - [line 763 - classes/db/Db.php] - [1 Arguments] DbCore->q - [line 559 - classes/db/Db.php] - [2 Arguments] DbCore->update - [line 652 - classes/ObjectModel.php] - [5 Arguments] ObjectModelCore->update - [line 213 - classes/Cart.php] - [1 Arguments] CartCore->update - [line 336 - controllers/front/OrderController.php] OrderControllerCore->processAddress - [line 177 - controllers/front/OrderController.php] OrderControllerCore->initContent - [line 189 - classes/controller/Controller.php] ControllerCore->run - [line 43 - override/classes/controller/Controller.php] Controller->run - [line 367 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Link to comment Share on other sites More sharing options...
Eolia Posted December 22, 2018 Share Posted December 22, 2018 Ok donc effectivement la colonne "quote" n'existe pas nativement dans ps_cart. Celle-ci a du être ajoutée par un module et un override doit la mettre à jour. Sand doute un module de devis mal installé ou désinstallé mais qui n'a pas supprimé ses overrides. Link to comment Share on other sites More sharing options...
gatla2 Posted December 22, 2018 Author Share Posted December 22, 2018 53 minutes ago, Eolia said: Ok donc effectivement la colonne "quote" n'existe pas nativement dans ps_cart. Celle-ci a du être ajoutée par un module et un override doit la mettre à jour. Sand doute un module de devis mal installé ou désinstallé mais qui n'a pas supprimé ses overrides. au fait je ne trouve pas de module devis dans ma liste de module, sinon comment je peux supprimer ce message? Link to comment Share on other sites More sharing options...
Eolia Posted December 22, 2018 Share Posted December 22, 2018 DbCore->query - [line 48 - override/classes/db/Db.php] - [1 Arguments] Pouvez-vous me copier/coller le contenu de cet override ici svp ? 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