PayPal IPN - can't tell what customer ordered

[JoMaze]

I have a similar problem. The customer ordered and paid via paypa and the only notification i rec'd was from paypal, but the receipt didn't say what the customer ordered. There was no record of an order placed in my Admin, so I had to email the cust and asked them what they bought!

I have everything set to email me, so i'm not sure why I didnt get the receipt though my ZC admin. I contaced paypal yesterday about why there's no order detail in their receipt and they said it was because of something ZC, but I'm clueless as to what's not set up right.

All of my orders through Auth.net work just fine, so i'm not sure where to start with this paypal thing. Oh, I was running the PayPal IPN and just a minute ago I activated the PayPal Express and turned off the IPN in hopes that maybe one works better than the other for me....now I just have to wait for an order!

So if anyone could help me on the Admin side, I'd really appreciate it.

jo

[DrByte]

FAQ on common causes of PayPal problems:
http://www.zen-cart.com/wiki/index.php/PayPal

[babyface]

I'm not sure whether this may help, but one of the problems we were having after we installed all the patches and made sure all the settings were correct was the following error after payment was completed in Paypal

1406 Data too long for column 'last_page_url' at row 1
in:

[update <<<INPUT DATA REMOVED FOR PRIVACY>>>]

Increasing the size of the "last_page_url" field in the sql database fixed the error of the paypal orders not being completed and everything is working fine (well almost - we're getting duplicate orders now, but that's better then not getting the information).

[BUTTSTTUB]

where can i go to find the last url field

[DrByte]

/includes/functions/whos_online.php
change this line (around 34):

  $wo_user_agent = zen_db_prepare_input($_SERVER['HTTP_USER_AGENT']);

to:

  $wo_user_agent = substr(zen_db_prepare_input($_SERVER['HTTP_USER_AGENT']), 0, 254);

[Veazer]

I'm having the same issue with PayPal IPN. The last successful transaction was on 9/12. All paypal ipn transactions currently return the customer to the store and report that the order was successful but the order does not appear. Also, the order number shown on the 'success' page is their previous successful order, not the the number their order should be.

I tried changing /includes/functions/whos_online.php as noted above but this didn't fix the problem. Also, the DB field was already 255 chars so i didn't change it.

Anything I can do to debug the issue?