Custom payment method validation error

[koraledrewniane]

Hello, my customers receive an error while processing checkout with CoD. It's strange because custompaymentmmodule works fine until this week. Can someone help?
 

[ThirtyBeesDatabaseException]

Unknown column 'cpmc.id_custom_payment_method' in 'on clause'
 

SELECT DISTINCT cpm.*, cpml.`id_lang`, cpms.`id_shop`,
cpmg.`id_group`,
cpml.`name`, cpml.`description`, cpml.`description_success`, cpml.`description_short`
FROM `tb_custom_payment_method` cpm
LEFT JOIN `tb_custom_payment_method_lang` `cpml` ON cpml.`id_custom_payment_method` = cpm.`id_custom_payment_method` AND cpml.`id_lang` = 2
LEFT JOIN `tb_custom_payment_method_shop` `cpms` ON cpms.`id_custom_payment_method` = cpm.`id_custom_payment_method` AND cpms.`id_shop` = 1
INNER JOIN `tb_custom_payment_method_group` cpmg ON cpmc.`id_custom_payment_method` = cpm.`id_custom_payment_method` AND cpmg.`id_group` IN (3)
WHERE (`active` = 1)

at line 844 in file classes/db/Db.php

 

839.         if ($webserviceCall && $errno) {
840.             $dbg = debug_backtrace();
841.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
842.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('TB_INSTALLATION_IN_PROGRESS')) {
843.             if ($sql) {
844.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
845.             }
846. 
847.             throw new PrestaShopDatabaseException($this->getMsgError());
848.         }
849.     }

• DbCore->displayError - [line 488 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 709 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 179 - modules/custompayments/classes/CustomPaymentMethod.php] - [1 Arguments]
• CustomPaymentsModule\CustomPaymentMethod::getCustomPaymentMethods - [line 449 - modules/custompayments/custompayments.php] - [4 Arguments]
• CustomPayments->getCustomPaymentMethods - [line 74 - modules/custompayments/controllers/front/validation.php] - [1 Arguments]
• CustompaymentsvalidationModuleFrontController->postProcess - [line 251 - classes/controller/Controller.php]
• ControllerCore->run - [line 253 - classes/controller/FrontController.php]
• FrontControllerCore->run - [line 837 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 33 - index.php]

[datakick]

@yaniv14 was right, this bug was already fixed in January, but we forgot to release new version. I've just packed and release new version of this module 

[yaniv14]

My guess is that you have to manually pick this commit: https://github.com/thirtybees/custompayments/commit/69681528df138a9fc96d3b72c246da28993d0afc

because I don't  think its part of the latest version.

[koraledrewniane]

It works. Thanks.