Post by siteadvice » Fri Oct 10, 2014 11:28 pm

The subject line pretty much says it all, really.

I'm working on a site where occasional orders are disappearing into the Missing Orders status when customers check out using the standard SagePay extension. The payment is complete but when you track down the order in the Dashboard, the VPSTxId has not been stored and in fact there is no data at all in the History tab.

The site is running on v1.5.5.1 of Opencart.

Anyone know possible reasons for this? Opencart's System Error logs don't show anything useful.

Are there any tell-tale signs in the order details I should look for that might reveal a pattern in the incorrect orders?

The site gets too many orders for it to be practical for the office managers to cross-reference the SagePay confirmation emails against the Opencart Dashboard. So in practice, Missing Orders are staying missing until a customer complains.

Are there any known bugs with that version of the SagePay payment extension?

inframes.com Website Design with Opencart, Wordpress, Lucee and bespoke application design and development


User avatar
New member

Posts

Joined
Mon Oct 24, 2011 8:12 pm

Post by cau96176 » Sat Oct 11, 2014 4:32 am

Might sound like a daft suggestion as I'm not a developer - more of a hash bash see if it works type....

Have you tried copying over the 1.5.6 version of the SagePay module and seeing if it works?

New member

Posts

Joined
Sat Feb 01, 2014 11:51 pm

Post by siteadvice » Sat Oct 11, 2014 7:49 pm

cau96176 wrote:Have you tried copying over the 1.5.6 version of the SagePay module and seeing if it works?
Not a bad suggestion and it may come to that, but it' could be an inconclusive result.

This is an intermittent problem, so I don't know at this stage whether the extension is in fact the cause. If I try to upgrade the extension, it might not work at all, which would at least cut off one possible alternative. But if it appeared to function correctly, then I'm at square one. The current system has worked every time I've ever tested it. And to my knowledge, no customer has ever reported an error. So upgrading the extension in isolation could potentially make the problem worse and I wouldn't even know!

inframes.com Website Design with Opencart, Wordpress, Lucee and bespoke application design and development


User avatar
New member

Posts

Joined
Mon Oct 24, 2011 8:12 pm

Post by cau96176 » Sun Oct 12, 2014 10:09 pm

Ah Cheers for the feedback.

What about increasing the SQL timeout from 20sec to 120sec in the php.ini file?

New member

Posts

Joined
Sat Feb 01, 2014 11:51 pm

Post by siteadvice » Mon Oct 13, 2014 12:10 am

cau96176 wrote:What about increasing the SQL timeout from 20sec to 120sec in the php.ini file?
Could certainly try it. Again, not sure if there's an evidence to suggest an error of this sort. As I say, I haven't heard any reports of errors from customers and I would have thought a MySQL timeout would result in a noticeable error.

inframes.com Website Design with Opencart, Wordpress, Lucee and bespoke application design and development


User avatar
New member

Posts

Joined
Mon Oct 24, 2011 8:12 pm

Post by cau96176 » Mon Oct 13, 2014 3:23 am

I'll leave it to the pro!! I just wondered if all your transactions were good and most other customers were good too.....then it could just be an occasional reply from the DB coming too late.

Again - utter guessing from me!

Hope you get it sorted!

New member

Posts

Joined
Sat Feb 01, 2014 11:51 pm
Who is online

Users browsing this forum: No registered users and 9 guests