ePDQ installation problems

01 Mar 2009, 19:09

#1

New Zenner

Join Date:: Jan 2009
Posts:: 32
Plugin Contributions:: 0

ePDQ installation problems

Hi,
I've just spent the last 6 hours installing the ePDQ payment module. I've gone through the installation readme files, and began testing transactions through my shop, with a live card. However, i get to payment confirmation, and the card is declined (i know it works elsewhere) - i click 'continue' and where it should return me to my store, i get error page showing this:

1054 Unknown column 'timestamp' in 'order clause'
in:
[select transactionstatus from epdq_log where oid='c1-o1' order by timestamp desc limit 1]

Very puzzling, and i'm really not sure where to go from here!

Any help appreciated.
Thanks,

02 Mar 2009, 00:18

#2

kuroi

Totally Zenned

Join Date:: Apr 2006
Posts:: 10,475
Plugin Contributions:: 9

Re: ePDQ installation problems

I think there's something a bit hooky with the install and uninstall scripts and the uninstall is an older version of the install. That's my oops :blush:

But you have an oops too, in that you've run the uninstall instead of the install. Just running the install version again should clear this.

That said, I strongly recommend against using the ePDQ service. Barclays merchant account - no problem. But I would recommend using a better and more reliable gateway such as Protx for interacting with it.

02 Mar 2009, 09:34

#3

kvwlls

New Zenner

Join Date:: Jan 2009
Posts:: 32
Plugin Contributions:: 0

Re: ePDQ installation problems

Ah great, ran the installation patch and it works fine now. Well, when i say fine, my test transactions are still being declined. I'm using the £11.11 test figure as suggested by barclaycard's tutorial, and using my own (live) Visa card. Is this normal and do i now need to get ePDQ to set the account to 'live' to allow accepted transactions?

Thanks for the advice, think i'll persist now after all the time spent on it so far!!

02 Mar 2009, 09:43

#4

kuroi

Totally Zenned

Join Date:: Apr 2006
Posts:: 10,475
Plugin Contributions:: 9

Re: ePDQ installation problems

kvwlls:
Ah great, ran the installation patch and it works fine now. Well, when i say fine, my test transactions are still being declined. I'm using the £11.11 test figure as suggested by barclaycard's tutorial, and using my own (live) Visa card. Is this normal and do i now need to get ePDQ to set the account to 'live' to allow accepted transactions?

I've worked on too many payment mods to remember the specifics of this one, but the documentation was quite good. It's the way it works that's rather dated. On the transaction acceptance, it's possible that that specific transaction amount also needs to be used with a Barclays supplied test card number.

kvwlls:
Thanks for the advice, think i'll persist now after all the time spent on it so far!!

I made that mistake too, egged on by a client who was adamant that she wanted ePDQ (she's now reversed that position and is going Protx).

02 Dec 2009, 14:49

#5

shane78

Banned

Join Date:: Oct 2008
Posts:: 876
Plugin Contributions:: 0

Re: ePDQ installation problems

I was just looking into EPDQ Payment Module to work with barclaycard.co.uk/business/accepting-payments/epdq-cpi/

As we have a business bank account with Barclays....
would you recommend i avoid this method then?

i was thinking of using paypal pro...? or ceons sage

...hmm

any advice?

02 Dec 2009, 14:57

#6

kuroi

Totally Zenned

Join Date:: Apr 2006
Posts:: 10,475
Plugin Contributions:: 9

Re: ePDQ installation problems

mcshane78:
I was just looking into EPDQ Payment Module to work with http://www.barclaycard.co.uk/business/accepting-payments/epdq-cpi/

As we have a business bank account with Barclays....
would you recommend i avoid this method then?

i was thinking of using paypal pro...? or ceons sage

...hmm

any advice?

Both of those work immensely better than ePDQ. My preference is for Ceon's Sage which both works
and is well-supported. Paypal Pro is fairly good though can be a bit buggy under some conditions, but if you've ever looked at the complexities and inconsistencies of the Paypal API it would be clear why. Increasingly I'm seeing clients use both and push credit card transactions through Sage to keep the transaction costs down.