Barclays ePDQ help please:)

[kuroi]

This is to do with the EPQD URL POST ?

When i go here "http://www.yousite.com/epdq/epdq_result.php"

I Get This

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 ' oid = '', chargetype = '', datetime =' at line 3
in:
[insert into epdq_log set transactionstatus = '', total = , oid = '', chargetype = '', datetime = '']

Is this right or could this be why its not creating Orders in Zen Cart after Transaction

what should the folders be CHMOD be set to?

If you go there without passing in parameters, it will indeed fail.

[kuroi]

A further warning about ePDQ.

The code supplied by them and integrated into this mod uses the php function fsockopen(), which ePDQ have told me today is turned off by default in PHP5. So if your webhost is keeping their PHP up-to-date, there is a real risk that this mod will simply stop working.

Apparently, they have an alternative CURL-based approach that avoids this issue, though I haven't yet managed to get hold of a copy of the code.

[rpain]

Hi - me again.

Still not getting a lot further so I decided to go down the redirect: false line. I'm now getting to the payment area, entering my card details and then getting payment declined. I've now tried it with a couple of cards which I know work.

Has anyone else seen this symptom?

The other thing, if I avoid the redirection option do I need to change thr post url entry to www.domain.com/epdq_cpi_handler.php instead of http://YOUR-SITE-URL/epdq/epdq_result.php within the cpi admin area?


Thanks,

Richard

[kuroi]

If you're actually getting to the ePDQ and then having a legitimate card declined, I'd contact ePDQ support. Their servers log every transaction and their staff can see the log, so should be able to advise as to why the transaction is being rejected.

[LG_UK]

A further warning about ePDQ.

The code supplied by them and integrated into this mod uses the php function fsockopen(), which ePDQ have told me today is turned off by default in PHP5. So if your webhost is keeping their PHP up-to-date, there is a real risk that this mod will simply stop working.

Apparently, they have an alternative CURL-based approach that avoids this issue, though I haven't yet managed to get hold of a copy of the code.

This is the exact error I'm receiving, would seem my webhost is indeed running on PHP5

Help

[LG_UK]

My webhost allows the use of a custom php.ini so ive switched on that option that's off by default and at least the errors have gone away!

[kuroi]

Good to hear. The host I use for public sites, switched the option on for me, so I didn't need to integrate the curl option either.

[bigowl]

I've got the same problem as rpain on 7th december where the transaction is successful and return to the site has blank order number.

The 'epdq_log' table shows that the transaction was successful but the order doesn't appear in my 'orders' table and so isn't shown in orders on my ZenCart admin page.

Trying the simulated ending by calling epdq_cpi_handler.php just does the same thing and returns to the 'Thank You' page with a blank order number and nothing added to the 'orders' table.

The shopping cart still contains the products ordered and so isn't cleared.

[colinr]

Have the problems of integration with Barclays ePDQ CPI been resolved now? Or should it be avoided?

[kuroi]

It should be avoided. Most of the UK banks continue to use the first generation payment systems that were great in their day, but flawed and under-featured in today's e-commerce world.

At Kuroi we understand our clients trust in their banks (though that's wobbling seriously at the moment), but recommend that they use a specialist payment gateway.

Even the client who insisted on it and for whom we built this module has now (happily) switched to a more reliable service.