Jump to content
sebjador

Erreur 500 après validation du paiement

Recommended Posts

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 ^^

 

Share this post


Link to post
Share on other sites

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 ?

Share this post


Link to post
Share on other sites

Absence du status lié au paiement en virement (attente de virement) et/ou désynchronisation des statuts dans la table ps_configuration

Share this post


Link to post
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...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More