Local Checkout not storing transaction details in database

I have a problem that affects the saving of the customer transaction data into the orders table. I tested my website, expressbugs.com using PayPal and after a successful transaction, all of the details are saved to the orders table. However, when I tested the payments with the local credit card checkout the transaction data is not being saved to the orders table. Please help me!

Regards,
Robert Crespo

Can I see a copy of the confirm.php page and the pp_confrm.php page?

Ray,

I have attached the files. Please let me know where I am going wrong.

Regards,
Robert

It appears to me that the confirm page database storage would work. Does the credit card payment go through?

I'll probably need to debug it... can you provide a url where I can reproduce the problem and FTP access to your server? That would help me debug since I can't spot the problem.

Ray,

I just did a test payment and everything worked for the local checkout! I forgot to do a test payment last week after I modified the confirm.php page with code from the pp_confirm.php page. I remember changing the "WA eCart Store Cart Details in Db" to

if ("" == "") // Trigger

I changed the trigger from the "submit" button to "=="

Thank you,
Robert

That is actually an issue... it should be using the same IF statement for the database store as it does for the payment processing portion.... update lines 298 and 359 to use:

(isset($_POST["Payment_submit"]) || isset($_POST["Payment_submit_x"]))

Ray,

I am going to make the updates as you direct. After I make the update I will let retest and see if it all still works.

Regards,
Robert