One-Page Checkout [Support Thread]

[lat9]

While I can't explain the root-cause of those logs, it looks like changing line 216 of /includes/classes/observers/class.checkout_one_observer.php to read as follows should correct the situation.

        if (!(isset($_SESSION['opc_error'], $_SESSION['opc']) && $_SESSION['opc_error'] === OnePageCheckout::OPC_ERROR_NO_JS) && $_SESSION['opc']->guestCheckoutEnabled() === true) {

[dbltoe]

After creating logs for @36 hours, it stopped.

I put in the code just to monitor for a while.

THANX

[wsworx]

1.5.8a PHP 8
edit_orders-4.7.1
one_page_checkout-2.5.1
Twitch_SPOON_for_157c
usps-USPS_2024_02_14_K11j
zen_TyPackageTracker-4.1.0

Can someone explain this to me?
I loaded One page Checkout 2.5.1 and now when I try to access the orders page in admin I get this error and none of the orders show up.
The 'o.is_guest_order' is on line 37 of 'OnePageCheckoutAdminObserver.php' but I do not know why it is not present in the database.

Debug Error File
/admin/index.php?cmd=orders, IP address: , Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 includes/classes/db/mysql/query_factory.php(667): trigger_error()
#2 includes/classes/db/mysql/query_factory.php(634): queryFactory->show_error()
#3 includes/classes/db/mysql/query_factory.php(275): queryFactory->set_error()
#4 admin/includes/classes/split_page_results.php(220): queryFactory->Execute()
#5 admin/includes/classes/split_page_results.php(131): splitPageResults->numberRows()
#6 admin/orders.php(1225): splitPageResults->__construct()
#7 admin/index.php(11): require('/home2/wildstee...')
--> PHP Fatal error: 1054:Unknown column 'o.is_guest_order' in 'field list' :: SELECT count(*) as total FROM (SELECT o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, o.order_total, o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.orders_status, o.ip_address, o.language_code , o.is_guest_order FROM (orders o ) LEFT JOIN orders_status s ON (o.orders_status = s.orders_status_id AND s.language_id = 1) ORDER BY o.orders_id DESC) countresults ==> (as called by) admin/includes/classes/split_page_results.php on line 220 <== in includes/classes/db/mysql/query_factory.php on line 667.

[lat9]

FWIW, that field should have been added to the database when OPC was initially installed.

[richard7315]

Hi lat9
We have been trying to integrate the stripe payment module with OPC so we can offer guest checkout with payment via digital wallets (Apple pay or Google pay). Unfortunately we have been unable to get the stripe form to display on the OPC checkout page.

I have posted on the stripe forum for advice – please see my posts for more details.

It would be much appreciated if you could check the stripe code and offer any advice on how to make it compatible with OPC.
Many thanks
Richard

[lat9]

Hi lat9
We have been trying to integrate the stripe payment module with OPC so we can offer guest checkout with payment via digital wallets (Apple pay or Google pay). Unfortunately we have been unable to get the stripe form to display on the OPC checkout page.

I have posted on the stripe forum for advice – please see my posts for more details.

It would be much appreciated if you could check the stripe code and offer any advice on how to make it compatible with OPC.
Many thanks
Richard

Richard, I have no clients that use Stripe so I'm unfamiliar with the operation of that payment module. I took a quick look at the code and I don't have a clue as to where the module is failing.

Does Stripe have a debug setting? If so, enable its debug and OPC's debug and you can send me the logs to my private email (which I'll give you via PM).

[lat9]

v2.5.2 of One-Page Checkout is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2095

This release contains updates for these GitHub issues:

#412: Remove no-longer-used (and problematic) CHECKOUT_ONE_OTTOTAL_SELECTOR setting.
#414: Further simplification of the transition from the checkout_one page to checkout_confirmation, ensuring only that the order's total-value hasn't changed.