ecpay / hikashop_php Goto Github PK

There is a MySQL error reported here:
https://www.hikashop.com/forum/payment-methods/895192-ecpay-have-sql-syntax-error.html#295097
This comes from the function getECPayOrderID in the file ecpay.php which has a query with a condition on the column "payment_access" which doesn't exist in the table hikashop_order, only in the table hikashop_payment. So either you should add a left join to the hikashop_payment on hikashop_order.order_payment_id = hikashop_payment.payment_id in order to be able to do the where, or you should remove the condition from the where, or do the check