Martin Lines Posted February 10, 2020 Share Posted February 10, 2020 I recently upgraded to 6.2.8. I had to do a clean install and then bring back in the database etc. Since then, IPN from Paypal has not worked. I can look in Paypal and can see the IPN is sent OK and can see the "200" response recorded both in Paypal and in the Apache log on my server. However the transaction stays at "pending" in cubecart There are no errors in the Cubecart error log (apart from Timezone errors) How can I track further where it is failing? Link to comment Share on other sites More sharing options...
bsmither Posted February 10, 2020 Share Posted February 10, 2020 The PayPal gateway code will take the data sent in the IPN and verify it with PayPal by executing a CURL request. This request, the data sent with it, and the response received is logged in CubeCart's Request Log (find it in admin). Please determine if there are log entries for these PayPal transactions. If CubeCart can determine the cart_order_id for this transaction, certain things happen, including a log entry in the order's Transaction Logs. Please determine if there are entries on the Transaction Logs tab. Link to comment Share on other sites More sharing options...
Martin Lines Posted February 10, 2020 Author Share Posted February 10, 2020 Looking in Request Log. Successful sales have 4 entry lines in the Request Log - all are where "Express Checkout" was used. Sales stuck at Pending have 2 entry lines which almost seem to be webpage code rather than a transaction (see below) I can manually force Paypal to re-send the IPN, I do not see any entry appear in the request log? Nothing appears in the Order history apart from a burst of multiple pending entries from the gateway. Request Sent - https://api-3t.paypal.com/nvp L_BUTTONVAR0=subtotal%3D25.20&L_BUTTONVAR1=invoice%3D200210-131312-4354&L_BUTTONVAR2=paymentaction%3Dsale&L_BUTTONVAR3=currency_code%3DGBP&L_BUTTONVAR4=buyer_email%3Dphil.ski2003%40gmail.com&L_BUTTONVAR5=first_name%3DPHILIP&L_BUTTONVAR6=last_name%3DHANSEN&L_BUTTONVAR7=address1%3D22+hillside+Eastdean&L_BUTTONVAR8=address2%3D&L_BUTTONVAR9=city%3DEastbourne&L_BUTTONVAR10=state%3D&L_BUTTONVAR11=zip%3DBN20+0HE&L_BUTTONVAR12=country%3DGB&L_BUTTONVAR13=billing_first_name%3DPHILIP&L_BUTTONVAR14=billing_last_name%3DHANSEN&L_BUTTONVAR15=billing_address1%3D22+hillside+Eastdean&L_BUTTONVAR16=billing_address2%3D&L_BUTTONVAR17=billing_city%3DEastbourne&L_BUTTONVAR18=billing_state%3D&L_BUTTONVAR19=billing_zip%3DBN20+0HE&L_BUTTONVAR20=billing_country%3DGB&L_BUTTONVAR21=showHostedThankyouPage%3Dfalse&L_BUTTONVAR22=bn%3DCubeCart_Cart_HostedProUMP_v6&L_BUTTONVAR23=template%3DtemplateD&L_BUTTONVAR24=return%3Dhttps%3A%2F%2Fwww.bigjimny.com%2Fstore2%2Findex.php%3F_a%3Dcomplete&L_BUTTONVAR25=cancel_return%3Dhttps%3A%2F%2Fwww.bigjimny.com%2Fstore2%2Findex.php%3F_a%3Dgateway&L_BUTTONVAR26=notify_url%3Dhttps%3A%2F%2Fwww.bigjimny.com%2Fstore2%2Findex.php%3F_g%3Drm%26type%3Dplugins%26cmd%3Dcall%26module%3DPayPal_Pro&BUTTONCODE=TOKEN&BUTTONTYPE=PAYMENT&METHOD=BMCreateButton&VERSION=112&PWD=8S39498232UY88DY&USER=bigjimny_api1.lines-family.com&SIGNATURE=A-vOW1cL7HT4gPOihcEcJAuy3CRzA3xHQ8yujybW-bBnui4J70Z9VXps Response received WEBSITECODE=%3cform%20action%3d%22https%3a%2f%2fsecurepayments%2epaypal%2ecom%2fwebapps%2fHostedSoleSolutionApp%2fwebflow%2fsparta%2fhostedSoleSolutionProcess%22%20method%3d%22post%22%3e%0a%3cinput%20type%3d%22hidden%22%20name%3d%22hosted_button_id%22%20value%3d%22HSSS%2d0UJYhSjiKg3t92IpFDajWYCHUhD3yXoVCCj7nmfOSAogvzBWPl10luVKFlD6D2b98rgb0A%22%3e%0a%3cinput%20type%3d%22image%22%20src%3d%22https%3a%2f%2fwww%2epaypalobjects%2ecom%2fen_GB%2fi%2fbtn%2fbtn_paynow_LG%2egif%22%20border%3d%220%22%20name%3d%22submit%22%20alt%3d%22PayPal%20%e2%80%93%20The%20safer%2c%20easier%20way%20to%20pay%20online%21%22%3e%0a%3cimg%20alt%3d%22%22%20border%3d%220%22%20src%3d%22https%3a%2f%2fwww%2epaypalobjects%2ecom%2fen_GB%2fi%2fscr%2fpixel%2egif%22%20width%3d%221%22%20height%3d%221%22%3e%0a%3c%2fform%3e%0a&EMAILLINK=https%3a%2f%2fsecurepayments%2epaypal%2ecom%2fwebapps%2fHostedSoleSolutionApp%2fwebflow%2fsparta%2fhostedSoleSolutionProcess%3fhosted_button_id%3dHSSS%2d0UJYhSjiKg3t92IpFDajWYCHUhD3yXoVCCj7nmfOSAogvzBWPl10luVKFlD6D2b98rgb0A&HOSTEDBUTTONID=HSSS%2d0UJYhSjiKg3t92IpFDajWYCHUhD3yXoVCCj7nmfOSAogvzBWPl10luVKFlD6D2b98rgb0A&TIMESTAMP=2020%2d02%2d10T13%3a13%3a24Z&CORRELATIONID=46449e8f1521d&ACK=Success&VERSION=112&BUILD=53816562 Link to comment Share on other sites More sharing options...
bsmither Posted February 10, 2020 Share Posted February 10, 2020 Please confirm exactly what PayPal module you are using. My comment above references the module that uses ipnpb.paypal.com as the address to request the verification. Is it PayPal Pro? Link to comment Share on other sites More sharing options...
Martin Lines Posted February 10, 2020 Author Share Posted February 10, 2020 PayPal Checkout Faster & More Secure Checkout 1.2.6 Plugins CubeCart Limited Link to comment Share on other sites More sharing options...
bsmither Posted February 10, 2020 Share Posted February 10, 2020 It looks like (but I am not familiar with how PayPal operates) what is getting received by the CURL request is some HTML that is intended to be shown as part of the payment page that gets displayed on your site. There is this: https://www.cubecart.com/extensions/plugins/paypal-checkout which the images certainly suggest this is the case. It's weird that the last modified date of this module is just a few days ago, but that there is this difficulty. Link to comment Share on other sites More sharing options...
vidmarc Posted February 11, 2020 Share Posted February 11, 2020 Is this the best Paypal plugin? Link to comment Share on other sites More sharing options...
Martin Lines Posted February 11, 2020 Author Share Posted February 11, 2020 Just now, vidmarc said: Is this the best Paypal plugin? I dont know, is it? It has worked fine for a number of years but since I did a clean install and database restore it has malfunctioned. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.