PayPal RESTful API Payment Module

[lsde]

zc 1.58a
php 7.4
opc 2.5.1
paypal RESTful 1.1.0

Received error log below after installing and testing paypal RESTful. We had a nearly identical error on a test site with zc 2.1.0 and php 8.1 using a database only upgrade from a copy of the 158a database. Maybe a database issue?

[16-Mar-2025 17:32:48 UTC] Request URI: /index.php?main_page=checkout_process, IP address: 71.200.5.177, Language id 1
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:703]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:648]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:289]
#4 queryFactory->Execute() called at [/includes/functions/database.php:133]
#5 zen_db_perform() called at [/includes/modules/payment/paypalr.php:1898]
#6 paypalr->after_order_create() called at [/includes/classes/payment.php:306]
#7 payment->after_order_create() called at [/includes/modules/checkout_process.php:103]
#8 require(/includes/modules/checkout_process.php) called at [/includes/modules/pages/checkout_process/header_php.php:13]
#9 require(/includes/modules/pages/checkout_process/header_php.php) called at [/index.php:35]
--> PHP Fatal error: MySQL error 1364: Field 'business' doesn't have a default value :: INSERT INTO paypal (order_id, txn_type, module_name, module_mode, reason_code, payment_type, payment_status, invoice, mc_currency, first_name, last_name, payer_email, payer_id, payer_status, receiver_email, receiver_id, txn_id, num_cart_items, mc_gross, date_added, last_modified, notify_version, expiration_time, memo, address_name, address_street, address_city, address_state, address_zip, address_country, payment_date, payment_gross, payment_fee, settle_amount, settle_currency, exchange_rate) VALUES ('9956', 'CREATE', 'paypalr', 'CAPTURE', '', 'paypal', 'CAPTURED', xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
17:32:47', '14.84', '1.01', '13.83', 'USD', null) ==> (as called by) /includes/functions/database.php on line 133 <== in /includes/classes/db/mysql/query_factory.php on line 703.

Any help would be appreciated.
Thanks

[lat9]

zc 1.58a
php 7.4
opc 2.5.1
paypal RESTful 1.1.0

Received error log below after installing and testing paypal RESTful. We had a nearly identical error on a test site with zc 2.1.0 and php 8.1 using a database only upgrade from a copy of the 158a database. Maybe a database issue?

[16-Mar-2025 17:32:48 UTC] Request URI: /index.php?main_page=checkout_process, IP address: 71.200.5.177, Language id 1
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:703]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:648]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:289]
#4 queryFactory->Execute() called at [/includes/functions/database.php:133]
#5 zen_db_perform() called at [/includes/modules/payment/paypalr.php:1898]
#6 paypalr->after_order_create() called at [/includes/classes/payment.php:306]
#7 payment->after_order_create() called at [/includes/modules/checkout_process.php:103]
#8 require(/includes/modules/checkout_process.php) called at [/includes/modules/pages/checkout_process/header_php.php:13]
#9 require(/includes/modules/pages/checkout_process/header_php.php) called at [/index.php:35]
--> PHP Fatal error: MySQL error 1364: Field 'business' doesn't have a default value :: INSERT INTO paypal (order_id, txn_type, module_name, module_mode, reason_code, payment_type, payment_status, invoice, mc_currency, first_name, last_name, payer_email, payer_id, payer_status, receiver_email, receiver_id, txn_id, num_cart_items, mc_gross, date_added, last_modified, notify_version, expiration_time, memo, address_name, address_street, address_city, address_state, address_zip, address_country, payment_date, payment_gross, payment_fee, settle_amount, settle_currency, exchange_rate) VALUES ('9956', 'CREATE', 'paypalr', 'CAPTURE', '', 'paypal', 'CAPTURED', xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
17:32:47', '14.84', '1.01', '13.83', 'USD', null) ==> (as called by) /includes/functions/database.php on line 133 <== in /includes/classes/db/mysql/query_factory.php on line 703.

Any help would be appreciated.
Thanks

I don't know the history of your site, but for a zc158a (and later) site's paypal table, the business field is defined as

varchar(128) NOT NULL default ''

Updating your database to use the expected 'schema' for that table's field will correct the issue that you've posted.

[dbltoe]

Upgrade from 1.5.7 to latest github
PHP 8.3
OPC
PayPal RESTful
USPS RESTful
EO
OPC

Accept Credit Cards set to Yes

Users are getting an error message stating the CC must be at leastr 18 characters. Adding dashes to the CC# stops that, but then the process fails as expected.

Set the debug on an got nothing but a series of

() validateCredentials: Checking ().The curlPost (v1/oauth2/token) request was successful (200).

[g2ktcf]

ON my checkout page, The CC icons spill out of the frame with Discover overlapping the next payment option. I tried uploading a screen shot but got "you have exceeded your limit". wlcartistry.com is the live site. This issue sounds familiar but I could not find anything by searching this thread.


ZC 2.0.1
OPC
Paypal Restful
Zelle
IH
Bootstrap
Clone a Template
Edit Orders
DBIO

[simon1066]

ON my checkout page, The CC icons spill out of the frame with Discover overlapping the next payment option. I tried uploading a screen shot but got "you have exceeded your limit". wlcartistry.com is the live site. This issue sounds familiar but I could not find anything by searching this thread.


ZC 2.0.1
OPC
Paypal Restful
Zelle
IH
Bootstrap
Clone a Template
Edit Orders
DBIO

You would just need to increase the width of the div that contains the icons. I'm not familiar with the Bootstrap template but the code you are looking for is

.ppr-button-choice label {
  cursor: pointer;
  height: 4rem;
  font-weight: bold;
  width: 11rem;
  display: inline-block;
  text-align: center;
}

Increasing the width to say 14rem should do it



That css code is shown as being inline so I'm not sure where it's located, perhaps in some javascript. The simplest way (perhaps the best?) is to add this to the end of your stylesheet.css

.ppr-button-choice label {
  width: 14rem!important;
}

[g2ktcf]

That did it. Added that last bit to /includes/templates/WLC_Bootstrap/css/site_specific_styles.php.

Thank You!

[lat9]

Upgrade from 1.5.7 to latest github
PHP 8.3
OPC
PayPal RESTful
USPS RESTful
EO
OPC

Accept Credit Cards set to Yes

Users are getting an error message stating the CC must be at leastr 18 characters. Adding dashes to the CC# stops that, but then the process fails as expected.

Set the debug on an got nothing but a series of

() validateCredentials: Checking ().The curlPost (v1/oauth2/token) request was successful (200).

You've apparently got Configuration / Minimum Values / Credit Card Number set to 18 (for whatever reason).

[lat9]

You would just need to increase the width of the div that contains the icons. I'm not familiar with the Bootstrap template but the code you are looking for is

.ppr-button-choice label {
  cursor: pointer;
  height: 4rem;
  font-weight: bold;
  width: 11rem;
  display: inline-block;
  text-align: center;
}

Increasing the width to say 14rem should do it



That css code is shown as being inline so I'm not sure where it's located, perhaps in some javascript. The simplest way (perhaps the best?) is to add this to the end of your stylesheet.css

.ppr-button-choice label {
  width: 14rem!important;
}

That did it. Added that last bit to /includes/templates/WLC_Bootstrap/css/site_specific_styles.php.

Thank You!

Thanks to both of you! FWIW, I've captured this in one of the payment-modules "Frequently Asked Questions": https://github.com/lat9/paypalr/wiki...sked-Questions

[g2ktcf]

I just noticed something interesting. My live store is ZC 2.0.1 and my dev site is 2.1.0.

I did NOT have the same issue in 2.1.0. Once I installed Paypal Restful, the checkout page was correct from the start.

[Jeff_Mash]

I'm just curious if anyone can reproduce this confirmed issue with PayPal Restful v1.1.0 Beta-1 with OPC v2.4.6.

In the Admin, set your transaction for AUTHORIZE (so you won't actually be charged anything).
Place an order using the GUEST checkout (for the One Page Checkout plug). Use a different state than the current state of your store location.
After your order is in your system, pull up the DETAILS by clicking the "Click for Additional Payment Handling Options" link, and hit the DETAILS button.
See if the STATE being passed to PayPal is correct or not.

For me (using ZC 1.5.8a), it will ALWAYS pass "CA" to PayPal if the user is checking out as a GUEST account only.

(If they are not checking out as a guest account, then it works fine and the correct state is passed to PayPal).

I have reported this in the GitHub but figured I'd post here in case any other users may be seeing this same behavior (with it posting the wrong State only if using a GUEST checkout.