ppn-uk

Hi,

I have an oscommerce site that is very modded - including PWA and fast easy checkout (which kind of supercedes the PWA mod).

All works well except that on very rare occasions I get problems with customers who create an account. There are two distinct types of problem:

1. The customer goes trough to the payment gateway (Securehosting.com) and complete their payment but the link back to oscommerce fails - I think because the customer_id has somehow moved on by 1 so is out of sequence with what actually exists in oscommerce.....but I can't replicate this to debug - it's just a hunch at the moment....

2. The second problem occurs earlier on - the customer clicks to go to the payment page and they get a page not found error.....this is less common than problem 1. I've been looking into the latest customer to be affected by this, and see something slightly odd in PHPMyAdmin - which might be a red herring.....but.....if I browse the customers table in phpmyadmin and navigate to the last page of entries, the customer row doesn't show up. If I do a select in phpmyadmin, it finds the customer row, and if I sort the entire table using browse and sorting on the customer_id field, the row does show up....

I can't see why this would cause my problem, but can anyone explain that behaviour in phpmyadmin? It's all I've got to go on for problem 2 at the moment!


Any suggestions for problem 1 or problem 2 would be gratefully received.


A.

pursuit

just a quick thought RE q2: the problem is not related to what you see in the customers table, ie, how the records are listed in phpMyAdmin. I think what you see when you browse the table is the records are listed by the physical storage place where a record or records are in, eg, record or customer one would be the first and so on. but later when records are deleted, they leave empty space and if new records are added then they would fill in the empty space, which results in records added later appear at the beginning of the table depending on if and where theres any empty space. So to put it this way: latest added records do not necassarily appear at the end of the table.

Sorry, I do not have exact answers to your two questions without more detailed info about your osc shop.