Problem with a payment - getting 500 internal errors - Finnish bank gateway

[koikko]

Hi! (sorry my english, I hope you understand it)
I've encountered a major promlem with a finnish bank gateways.
By the first, I tested two of them (nordea.php and op.php) in my local server and they works.
But live server there are two promlems.
Minor is : If the customer select first one (nordea.php) and push checkout button everything is OK.
But if the customer select second option (op.php) and push checkout button error message appear.
But if the customer push browser back button and select first option and press checkout and again browser back button and now select second options and press checkout button then him/her can can enter bank for payment.
Error message is 1064 somekind of that 'check your mysql syntax ....".

Major problem is:
When customer reach bank and do payment. return shop and then http error 500,internal server error.
In my local it works.

Any ideas or want to more details?

[aivo]

Same problem here, is there any solution?

OP payment error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' . MOD_FI_BANK_ID . ' (session_id) VALUES ('2232af79f2cd8a98838
in:
[INSERT INTO ' . MOD_FI_BANK_ID . ' (session_id) VALUES ('2232af79f2cd8a98838813feee35f0cf')]

?n the old version of zen, it's working normally.

[aivo]

I found the bug in Osuuspankki file includes/modules/payment/op.php

OLD:
-------------
if (empty($refid->fields['id'])) { // If not, we create a new one
$db->Execute("INSERT INTO ' . MOD_FI_BANK_ID . ' (session_id) VALUES ('" . session_id() . "')"); // Make the reservation

------------
NEW:
-------------

if (empty($refid->fields['id'])) { // If not, we create a new one
$db->Execute("INSERT INTO " . MOD_FI_BANK_ID . " (session_id) VALUES ('" . session_id() . "')"); // Make the reservation