PayPal RESTful API Payment Module

[swguy]

When I press the Confirm Order button in PayPal, I get sent back to the cart, but I'm logged off.

The only PayPal log I have is the first one created:

2024-06-28 13:40:16: (index) ppr_webhook_main (return, live) starts.
{
"op": "return",
"token": "***",
"PayerID": "***",
"main_page": "index"
}

[swguy]

I wonder if this is a samesite cookie issue?


Tested - nope, that's not the problem.

[swguy]

For some reason, $_SESSION['PayPalRestful'] is not set on return. And a logout has been done.

Everything looks good right before the handoff:

2024-06-28 23:50:53: (checkout_confirmation) pre_confirmation_check, sending the payer-action off to PayPal.

I'm wondering if there's a session issue on their server. Investigating.

[gothstone]

Since I switched from PayPal Express to RESTful I get a couple errors every time someone uses it. I had hoped that getting all my updates done would fix, but it has not. I have not yet tried this in my 2.0.1 dev environment. Currently on:
ZC 1.5.8a
Bootstrap 3.7.2
OPC 2.5.2
PayPal Checkout Restful 1.0.2
PayPal Express Checkout 1.5.8 (disabled)
PHP 8.1.29

First Error:

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id not set
#0 /includes/modules/payment/paypal/paypal_functions.php(48): zen_debug_error_handler()
#1 /includes/init_includes/init_paypal_ipn_sessions.php(34): ipn_get_stored_session()
#2 /includes/autoload_func.php(40): require_once('/home/pcs/publi...')
#3 /includes/application_top.php(237): require('/home/pcs/publi...')
#4 /ipn_main_handler.php(122): require('/home/pcs/publi...')
--> PHP Warning: Undefined array key 1 in /includes/modules/payment/paypal/paypal_functions.php on line 48.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id not set
#0 /includes/modules/payment/paypal/paypal_functions.php(55): zen_debug_error_handler()
#1 /includes/init_includes/init_paypal_ipn_sessions.php(34): ipn_get_stored_session()
#2 /includes/autoload_func.php(40): require_once('/home/pcs/publi...')
#3 /includes/application_top.php(237): require('/home/pcs/publi...')
#4 /ipn_main_handler.php(122): require('/home/pcs/publi...')
--> PHP Warning: Undefined array key 1 in /includes/modules/payment/paypal/paypal_functions.php on line 55.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id 1
#0 /includes/modules/payment/paypal/paypal_functions.php(48): zen_debug_error_handler()
#1 /ipn_main_handler.php(217): ipn_get_stored_session()
--> PHP Warning: Undefined array key 1 in /includes/modules/payment/paypal/paypal_functions.php on line 48.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id 1
#0 /includes/modules/payment/paypal/paypal_functions.php(55): zen_debug_error_handler()
#1 /ipn_main_handler.php(217): ipn_get_stored_session()
--> PHP Warning: Undefined array key 1 in /includes/modules/payment/paypal/paypal_functions.php on line 55.

Second Error:

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id not set
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(561): preg_match()
#2 /includes/classes/db/mysql/query_factory.php(513): queryFactory->getBindVarValue()
#3 /includes/modules/payment/paypal/paypal_functions.php(48): queryFactory->bindVars()
#4 /includes/init_includes/init_paypal_ipn_sessions.php(34): ipn_get_stored_session()
#5 /includes/autoload_func.php(40): require_once('/home/pcs/publi...')
#6 /includes/application_top.php(237): require('/home/pcs/publi...')
#7 /ipn_main_handler.php(122): require('/home/pcs/publi...')
--> PHP Deprecated: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in /includes/classes/db/mysql/query_factory.php on line 561.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id not set
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(177): mysqli_real_escape_string()
#2 /includes/classes/db/mysql/query_factory.php(562): queryFactory->prepare_input()
#3 /includes/classes/db/mysql/query_factory.php(513): queryFactory->getBindVarValue()
#4 /includes/modules/payment/paypal/paypal_functions.php(48): queryFactory->bindVars()
#5 /includes/init_includes/init_paypal_ipn_sessions.php(34): ipn_get_stored_session()
#6 /includes/autoload_func.php(40): require_once('/home/pcs/publi...')
#7 /includes/application_top.php(237): require('/home/pcs/publi...')
#8 /ipn_main_handler.php(122): require('/home/pcs/publi...')
--> PHP Deprecated: mysqli_real_escape_string(): Passing null to parameter #2 ($string) of type string is deprecated in /includes/classes/db/mysql/query_factory.php on line 177.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(561): preg_match()
#2 /includes/classes/db/mysql/query_factory.php(513): queryFactory->getBindVarValue()
#3 /includes/modules/payment/paypal/paypal_functions.php(48): queryFactory->bindVars()
#4 /ipn_main_handler.php(217): ipn_get_stored_session()
--> PHP Deprecated: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in /includes/classes/db/mysql/query_factory.php on line 561.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(177): mysqli_real_escape_string()
#2 /includes/classes/db/mysql/query_factory.php(562): queryFactory->prepare_input()
#3 /includes/classes/db/mysql/query_factory.php(513): queryFactory->getBindVarValue()
#4 /includes/modules/payment/paypal/paypal_functions.php(48): queryFactory->bindVars()
#5 /ipn_main_handler.php(217): ipn_get_stored_session()
--> PHP Deprecated: mysqli_real_escape_string(): Passing null to parameter #2 ($string) of type string is deprecated in /includes/classes/db/mysql/query_factory.php on line 177.

Thoughts or suggestions?

[gothstone]

Well it looks like this does NOT happen in my 2.0.1 dev environment, so hopefully its fixed in the new version.

[lat9]

Noting that those errors identified in the 2nd post back are coming from the ipn_main_handler.php, which is not part of the PayPal RESTful implementation.

[brittainmark]

I am testing this module against a sandbox account and have come across a problem.
If a customer makes a sucessful purchase using paypal restful and then attempts to make a second purchase with out loging out one of 2 things happen.
The first time I tried it the paypal restful module was disable so paypal could not be used for the second transaction.
This produced an admin log. (so it may have been a different issue as i sucessfully issues a refund).

[09-Aug-2024 10:38:01 UTC] Request URI: /sales/ILSadmin/index.php?cmd=orders&origin=index&page=1&oID=2087&action=edit, IP address: 127.0.0.1, Language id 1

#0 [internal function]: zen_debug_error_handler()

#1 /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php(547): trigger_error()
#2 /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php(534): paypalr->setConfigurationDisabled()
#3 /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php(291): paypalr->validateConfiguration()
#4 /home/lotus/public_html/innerlightcrystals/sales/ILSadmin/orders.php(514): paypalr->__construct()
#5 /home/lotus/public_html/innerlightcrystals/sales/ILSadmin/index.php(16): require('...')
--> PHP Warning: Setting configuration disabled: The <b>sandbox</b> credentials for the <var>paypalr</var> payment module are invalid. in /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php on line 547.

The second time I tested it (having logged out and back in) I got the message " We are unable to process your PayPal Checkout payment at this time. Please contact us for assistance."
I think this is the pertenat bit of the log file

    "errMsg": "An interface error (422) was returned from PayPal.",
    "curlErrno": 0,
    "name": "UNPROCESSABLE_ENTITY",
    "message": "The requested action could not be performed, semantically incorrect, or failed business validation.",
    "details": [
        {
            "issue": "ORDER_ALREADY_CAPTURED",
            "description": "Order already captured.If 'intent=CAPTURE' only one capture per order is allowed."
        }

This is against zen cart 2.0.1 using php 8.3.9 mysql 8.3.9
If you need any further info please let me know.

[mprough]

When I press the Confirm Order button in PayPal, I get sent back to the cart, but I'm logged off.

The only PayPal log I have is the first one created:

2024-06-28 13:40:16: (index) ppr_webhook_main (return, live) starts.
{
"op": "return",
"token": "***",
"PayerID": "***",
"main_page": "index"
}

I don't see where this is solved. I have this similar issue

Zen Cart 2.1.0
PHP 8.3
OPC 2.5.4
Boot 3.7.4
PayPal RESTful 1.0.5

2025-01-13 09:46:08: (checkout_one_confirmation) ==> End confirmPaymentSource
2025-01-13 09:46:08: (checkout_one_confirmation) pre_confirmation_check, sending the payer-action off to PayPal.
************************************************

************************************************

2025-01-13 09:46:10: (index) ppr_webhook_main (cancel, live) starts.
{
"op": "cancel",
"token": "xxxxxxx",
"main_page": "index"
}
************************************************

2025-01-13 09:46:10: (checkout_one) validateCredentials: Checking (1).
TokenCache::get, using saved access-token; expires in 30171 seconds.

************************************************

Thanks
Melanie

[lat9]

@mprough, the PayPal log you supplied would indicate that the customer cancelled the transaction at PayPal.

[mprough]

@mprough, the PayPal log you supplied would indicate that the customer cancelled the transaction at PayPal.

I didn't, see below