sagepay Order Not Showing In zen - Payment IS in payment gateway

Hi and thanks for reading (any help greatly aprpeciated!!!)

Randomly several orders are not showing in the zencart BUT payment is going through and being taken by sagepay. The only difference i can see is the return URL

the successful ones display:

WEBADDRESS/index.php?main_page=checkout_processX

while the unsuccesful ones show:

WEBADDRESS/index.php?main_page=checkout_process&zenid=XXXXXXXXXXXXXXXXXXXXXXXXXXX

(X is removed zen ID number as unsire of security issues of showing that number)

The following is the Site / PHP Info

Zen Cart 1.3.8a
Database Patch Level: 1.3.8
v1.3.8 [2008-12-18 14:31:57] (Fresh Installation)
v1.3.8 [2008-12-18 14:31:57] (Fresh Installation)

HTTP Server: Apache/2
PHP Version: 5.2.17 (Zend: 2.2.0)
PHP Memory Limit: 128M
PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 1,595 kB Database Index Size: 808 kB

I have contacted SAGE who say this is down to teh site, I have checked with Hosting company to ensure no server issues so it must be down to something within zen....

any help, advice, or medicated drugs to numb me would be greatly appreciated!!!

Matt

UPDATE -

Afte rmuch digging I THINK i may have figured this out...

I believe the store session is timing out (if customer hasnt been 'fast enough' to pay at the payment gateway stage...

I have added the following to the php.ini file which hopefully will resolve this issue....

session.gc_maxlifetime = 0

Basically it means the session is 'live' until the browser is closed...so the redirect would in fact not affect the store session meaning the customer can go take make a brew or take a dump (?!) and the session will still be live....

editing this file is fairly new to me so i still have to test but if any more experienced out there can support this theory it would be really appreciated!!!!

Matt

Hi gents... had a similar problem - http://www.zen-cart.com/forum/showth...700#post995700

I THINK ... THINK (PRAY!!) I solved it!!!

UPDATE FROM MY POST

Afte rmuch digging I THINK i may have figured this out...

I believe the store session is timing out (if customer hasnt been 'fast enough' to pay at the payment gateway stage...

I have added the following to the php.ini file which hopefully will resolve this issue....

session.gc_maxlifetime = 0

Basically it means the session is 'live' until the browser is closed...so the redirect would in fact not affect the store session meaning the customer can go take make a brew or take a dump (?!) and the session will still be live....

editing this file is fairly new to me so i still have to test but if any more experienced out there can support this theory it would be really appreciated!!!!

Matt

ok didnt seem to work... :censored:

:censored: went out for 25 mins came back and it has timed out...maybe browser timeout tho... any thoughts??

also just changed includes/configure.php

changed define('SQL_CACHE_METHOD', 'none');

to

define('SQL_CACHE_METHOD', 'file');

testing now ....

This may be off topic, but you are using an old version of Zen Cart that is vulnerable to hacking - you NEED to upgrade ASAP!

hey yeah just a lil bit ;) but at least you read it! :P will def upgrade once this issue is resolved...any advice??? *begs*