Zen Cart 1.5.6c
One Page Checkout recently updated to version 2.2.0
Latest Square Up version
The problem
Customers complained they see a blank page and/or an error message when trying to purchase Gift Certificates. Error message on screen "Warning: and error occurred...."
After running all the tests I could think of, disabling OPC and using check/money order as a payment method the issue persists. Reverting to the original store template, disabling OPC and paying with check/money order the issue persist, which leads me to believe there is something happening non related to either Square nor OPC.
The only thing that actually worked and I was able to place an order for a gift certificate was by changing the Yes, Skip Shipping Address, to No, Normal Shipping Rules, which treats the item as a regular product. I'm inclined to believe something isn't working when shipping isn't required, but I have no idea where to even begin to check.
Log (private values replaced with XXXXXXXXX):
[18-Feb-2020 11:24:08 America/Detroit] Request URI: /index.php?main_page=checkout_process, IP address: XXXXXXX
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/includes/functions/functions_general.php:952]
#5 zen_db_perform() called at [/includes/classes/order.php:695]
#6 order->create() called at [/includes/modules/checkout_process.php:95]
#7 require(/includes/modules/checkout_process.php) called at [/includes/modules/pages/checkout_process/header_php.php:14]
#8 require(/includes/modules/pages/checkout_process/header_php.php) called at [/home/koolwedd/public_html/index.php:36]
--> PHP Fatal error: 1366:Incorrect integer value: '' for column `koolwedd_TEMP`.`orders`.`delivery_address_format_id` at row 1 :: INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address) VALUES ('1', 'XXXXXXXX', '', 'XXXXXXXX', '', 'XXXXXXX', 'XXXXX', 'XXXXXX', 'United States', '0000000000', 'XXXXXXX', '2', ' ', '', '', '', '', '', '', '', '', 'XXXX', '', 'XXXXXXX', '', 'XXXXXXX', 'XXXX', 'XX', 'United States', '2', 'Check/Money Order', 'moneyorder', 'Free Shipping-', 'free', '', '', '', '', '', now(), '1', '100', '0', 'USD', '1.000000', 'XXXXXXX') ==> (as called by) /includes/functions/functions_general.php on line 952 <== in /includes/classes/db/mysql/query_factory.php on line 171.
Has anyone seen this behavior before? Any clue where the problem could be and how can it be solved?
Bookmarks