Zen Cart Logo
Forums / General Questions / Problem with a payment - getting 500 internal errors - Finnish bank gateway

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

Locked

Views: 1,958

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
23 Jul 2007, 11:01 PM
#1
koikko avatar

koikko

New Zenner

Join Date:
Jul 2007
Posts:
1
Plugin Contributions:
0

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

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?

12 Sep 2007, 7:32 AM
#2
aivo avatar

aivo

New Zenner

Join Date:
Jan 2004
Posts:
6
Plugin Contributions:
0

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

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.

18 Sep 2007, 8:51 AM
#3
aivo avatar

aivo

New Zenner

Join Date:
Jan 2004
Posts:
6
Plugin Contributions:
0

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

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