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?

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