One-Page Checkout [Support Thread]

[njcyx]

Hi @lat9,

No plug-in, but I added a php file to extend the session/shopping cart expiry time. Not sure if it is related.

<?php define('SESSION_TIMEOUT_CATALOG', 7200);

This file is under /includes/extra_configures/my_ultra_long_session_timeout.php file

Reference link:

https://www.zen-cart.com/showthread....29#post1321729

[lat9]

Looks like that could happen if an error occurred in either initializeResponseStatus or there was an issue with the shipping selection.

I'll be changing that method to read

    // -----
    // Called to format methods' return of the order's current total,
    // rounding to the number of decimal digits in the session's active
    // currency.
    //
    protected function formatOrderTotal()
    {
        global $currencies;

        return $_SESSION['opc_saved_order_total'] ?? $currencies->format(0);
    }

[lat9]

GitHub issue created to track the above change: https://github.com/lat9/one_page_checkout/issues/417

[njcyx]

GitHub issue created to track the above change: https://github.com/lat9/one_page_checkout/issues/417

Thanks!

[gothstone]

After upgrading to the new Square_webPay 1.2.1 I found a bug in (I think) OPC. While checking out and paying with Square_webPay, OR check/money order but NOT Paypal Restfull, If I change what's in the special Instructions or Comments field (or whatever 'TABLE_HEADING_COMMENTS' was defined to originally) I get the error "Your orders details have changed. Please review the current values and re-submit. I had had trouble with this previously with paypal, but not connected it to the comments field.
ZenCart - 1.5.8a
Bootstrap - 3.6.0
OPC - 2.5.1
Square_webPay (paid version) - 1.2.1
PayPal Checkout (RESTful) - 1.0.2

Hoping to upgrade OCP to 2.5.2 today, will post if it still happens in that version.

[gothstone]

Lol, NM, I should have just trusted in lat9! 2.5.2 DOES in fact fix that prob! Thank you Cindy!!!!

[lat9]

Lol, NM, I should have just trusted in lat9! 2.5.2 DOES in fact fix that prob! Thank you Cindy!!!!

Most excellent!

[njcyx]

Hi @lat9,

No plug-in, but I added a php file to extend the session/shopping cart expiry time. Not sure if it is related.

<?php define('SESSION_TIMEOUT_CATALOG', 7200);

This file is under /includes/extra_configures/my_ultra_long_session_timeout.php file

Reference link:

https://www.zen-cart.com/showthread....29#post1321729

Hmm, I searched the keyword "SESSION_TIMEOUT_CATALOG" and I found my same post back in 2024...

The modules I installed now are: OPC, some shipping modules, local sales tax, sales report II, monthly sales and tax summary and google recapchar.

[lat9]

Hmm, I searched the keyword "SESSION_TIMEOUT_CATALOG" and I found my same post back in 2024...

The modules I installed now are: OPC, some shipping modules, local sales tax, sales report II, monthly sales and tax summary and google recapchar.

The log you posted indicates that the issue is that data types in the saved session's OPC variable aren't compatible with those now 'required' by the v2.6.0 update.

While I'll keep my eye out for other reports of this issue, I've got no "good" solution for you other than running the following SQL queries after you've made a full backup of your database:

TRUNCATE TABLE sessions;
TRUNCATE TABLE whos_online;

[njcyx]

The log you posted indicates that the issue is that data types in the saved session's OPC variable aren't compatible with those now 'required' by the v2.6.0 update.

While I'll keep my eye out for other reports of this issue, I've got no "good" solution for you other than running the following SQL queries after you've made a full backup of your database:

TRUNCATE TABLE sessions;
TRUNCATE TABLE whos_online;

Hi @lat9, thanks. I just tried your suggestion in the testing server and it worked! After I cleaned both tables, The white screen tab can display as normal.

Regarding my database, I used zc database conversion tool (v2.0.1) to convert my database to utf8mb4_unicode_520_c from (I suspected) utf8, when I upgraded my site to zc210.