order details not going into db properly

Hi Ray

Trying to finish off an ecart installation and I have clearly done something wrong.

Items get added to cart fine, checkout takes me dirctly to paypal and I can successfully pay in paypal.

Once you come back to the checkout_success page the transaction summary is not being added to the db at all and the order details are being added to the db in a strange way (see attached screenshot 1.png) - have also attached the pp_confirma nd _PHP.php page

What have I done wrong?

Cheers

Jamie

It doesn't seem like this confirm page would have this problem. Are you sure it is paypal orders not credit card orders? It might be related to the not inserting transaction issue.

It is probably failing that insert because of a field that doesn't allow null not having a set value... like the OrderUserID column. A good way to debug that is to add debug code after line 179 like:

var_dump($ConditionalQuery);
die();

That should let you know why the orders table isn't inserting. Once that is working it may fix the details issue. If not we can work on that one next.

Ok thanks. It was a couple of columns that werent liking null as a value - that now allows the order details and summary to go into the db fine.

Couple of things that still are an issue.

1. /hairmekanix/shop-product-details_s.php?perm=gift- is being added to the DetailSKU column in the orderdetails table

2. the telephone number is not being passed back from paypal and I know that paypal is set to do this as in the live site is another ecart install and its successfully adding the phone number

cheers

Jamie

1) Are you sure it is stored correctly in the eCart to begin with? What happens when you display that column in the cart?

2) We can add debug code to the pp_confirm.php page to see if it is passed and try to figure out why it isn't viewable. After line 24 add debug code:
var_dump($_SESSION);
die();

Then view source and post the result to me in the private area. I'll take a look and see what I think.

Ok, source in PM

also, echoing the SKU <?php echo $MotleyCart->DisplayInfo("SKU"); ?> returns that URL /hairmekanix/shop-product-details_s.php?perm=gift-vouchers

On line 35 of pp_confirm.php try replacing: "PayerInfo->ContactPhone" with :"ContactPhone"

It looks like paypal may have moved the phone number field outside of hte payerinfo tag.

If the value is incorrect on the cart page that means the issue must be when it is added to the cart.

changing to ContactPhone didnt work

have added the product detail page .... have got the itemSKU in the atc and its referencing the right column in the db but it still adding the product url ....

It looks like line 157 is out of sync.

It has:

$MotleyCart->AddToCart($ATC_AddIfIn, $ATC_RedirectIfIn, $ATC_itemID, $ATC_itemName, $ATC_itemDescription, $ATC_itemThumbnail, $ATC_itemWeight, $ATC_itemQuantity, $ATC_itemPrice, $ATC_itemColour, $ATC_itemReturnLink);

it should be:

$MotleyCart->AddToCart($ATC_AddIfIn, $ATC_RedirectIfIn, $ATC_itemID, $ATC_itemName, $ATC_itemDescription, $ATC_itemThumbnail, $ATC_itemWeight, $ATC_itemQuantity, $ATC_itemPrice, $ATC_itemColour, $ATC_itemSKU, $ATC_itemReturnLink);

great thats got it thanks

any other suggestions re the contact phone?

No. I can debug it with you tomorrow. It seems like it would work.