sebjador Posted August 23, 2019 Share Posted August 23, 2019 Bonjour, Lors de la validation du paiement (uniquement payement par virement) une erreur 500 est générée à la place de ma vente ... 😢 Je suis en prestashop 1.6.1.7, hébergé chez OVH. Rien n'a été modifié dernièrement. J'ai activé le mode debug et j'ai ceci en retour: [PrestaShopDatabaseException] Duplicate entry '0' for key 'PRIMARY' INSERT INTO `prstshp_orders` (`id_address_delivery`, `id_address_invoice`, `id_cart`, `id_currency`, `id_shop_group`, `id_shop`, `id_lang`, `id_customer`, `id_carrier`, `current_state`, `secure_key`, `payment`, `module`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `total_discounts`, `total_discounts_tax_incl`, `total_discounts_tax_excl`, `total_paid`, `total_paid_tax_incl`, `total_paid_tax_excl`, `total_paid_real`, `total_products`, `total_products_wt`, `total_shipping`, `total_shipping_tax_incl`, `total_shipping_tax_excl`, `carrier_tax_rate`, `total_wrapping`, `total_wrapping_tax_incl`, `total_wrapping_tax_excl`, `round_mode`, `round_type`, `shipping_number`, `conversion_rate`, `invoice_number`, `delivery_number`, `invoice_date`, `delivery_date`, `valid`, `reference`, `date_add`, `date_upd`) VALUES ('13', '13', '997', '2', '1', '1', '2', '2', '26', '0', '985da8d6b0c6ec4b23865cdff1ff141b', 'Virement bancaire', 'bankwire', '0', '0', NULL, '0', '0', '0', '0', '570', '570', '537.74', '0', '537.74', '570', '0', '0', '0', '6', '0', '0', '0', '4', '3', NULL, '0.909256', '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', 'VRMLBPIHP', '2019-08-23 15:54:15', '2019-08-23 15:54:15') 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 763 - classes/db/Db.php] - [1 Arguments] DbCore->q - [line 514 - classes/db/Db.php] - [2 Arguments] DbCore->insert - [line 487 - classes/ObjectModel.php] - [3 Arguments] ObjectModelCore->add - [line 309 - classes/order/Order.php] - [2 Arguments] OrderCore->add - [line 341 - classes/PaymentModule.php] PaymentModuleCore->validateOrder - [line 64 - modules/bankwire/controllers/front/validation.php] - [9 Arguments] BankwireValidationModuleFrontController->postProcess - [line 178 - classes/controller/Controller.php] ControllerCore->run - [line 367 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Je n'arrive pas à décrypter ce message d'erreur. Ni même à trouver un indice qui m'indiquerait quel plugin désactiver. Est ce que quelqu'un de charitable pourrait me venir en aide ? Merci d'avance ^^ Link to comment Share on other sites More sharing options...
Eolia Posted August 23, 2019 Share Posted August 23, 2019 une commande avec un id 0 effectivement c'est un problème. Mais en plus il y en a déjà un donc ca fait doublon. ca fonctionnait avant ? Il y a des commandes en BO ? Pas de modification quelconque de la base de données ? Link to comment Share on other sites More sharing options...
doekia Posted August 23, 2019 Share Posted August 23, 2019 Absence du status lié au paiement en virement (attente de virement) et/ou désynchronisation des statuts dans la table ps_configuration 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