PayPal RESTful API Payment Module

[BillJ]

Using Paypalr 1.0.2 with ZC 1.58a and OPC 2.4.6, I've seen this e-mail alert a few times over the last day or two:

ALERT: PayPal Checkout Error (Order Requires Attention)

An error was returned by PayPal when attempting to initiate an order. As a courtesy, only the error 'code' was shown to your customer.  The details of the error are shown below.

{
    "errNum": 400,
    "errMsg": "An interface error (400) was returned from PayPal.",
    "curlErrno": 0,
    "name": "INVALID_REQUEST",
    "message": "Request is not well-formed, syntactically incorrect, or violates schema.",
    "details": [
        {
            "field": "/purchase_units",
            "value": "",
            "location": "body",
            "issue": "MISSING_REQUIRED_PARAMETER",
            "description": "A required field / parameter is missing."
        },
        {
            "field": "/intent",
            "value": "",
            "location": "body",
            "issue": "MISSING_REQUIRED_PARAMETER",
            "description": "A required field / parameter is missing."
        }
    ],
    "debug_id": "7610a5441e3e4"
}

I *think* each one has been for a payment in EUR while our store's default currency is GBP. This is a new issue - I've been using Paypalr for months without seeing this before.
I also have the Paypalr and OPC debug logs that I can send if it helps.

I have checked other, successful orders today and they include both card and Paypal payments via Paypalr.

[lat9]

Using Paypalr 1.0.2 with ZC 1.58a and OPC 2.4.6, I've seen this e-mail alert a few times over the last day or two:

ALERT: PayPal Checkout Error (Order Requires Attention)

An error was returned by PayPal when attempting to initiate an order. As a courtesy, only the error 'code' was shown to your customer.  The details of the error are shown below.

{
    "errNum": 400,
    "errMsg": "An interface error (400) was returned from PayPal.",
    "curlErrno": 0,
    "name": "INVALID_REQUEST",
    "message": "Request is not well-formed, syntactically incorrect, or violates schema.",
    "details": [
        {
            "field": "/purchase_units",
            "value": "",
            "location": "body",
            "issue": "MISSING_REQUIRED_PARAMETER",
            "description": "A required field / parameter is missing."
        },
        {
            "field": "/intent",
            "value": "",
            "location": "body",
            "issue": "MISSING_REQUIRED_PARAMETER",
            "description": "A required field / parameter is missing."
        }
    ],
    "debug_id": "7610a5441e3e4"
}

I *think* each one has been for a payment in EUR while our store's default currency is GBP. This is a new issue - I've been using Paypalr for months without seeing this before.
I also have the Paypalr and OPC debug logs that I can send if it helps.

I have checked other, successful orders today and they include both card and Paypal payments via Paypalr.

Yep, shoot me the paypalr logs (the OPC ones aren't going to "tell the story"), please.

[BillJ]

Yep, shoot me the paypalr logs (the OPC ones aren't going to "tell the story"), please.

On its way. Thanks!

[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?

[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