One-Page Checkout [Support Thread]

lat9:

The entry_telephone field is not in the as-shipped Zen Cart address_book table. Any idea where that field's presence comes from?

I carefully checked all the files and found that this field is in the Japanese language module

ZC200LangPack_JP\zc_install\sql\plugins\mysql_japanese_install.sql
ZC200LangPack_JP\sql\mysql_japanese_install.sql
in 75 line
ALTER TABLE address_book ADD COLUMN entry_telephone varchar(32) NOT NULL;


ZC200LangPack_JP\zc_install\sql\updates\mysql_upgrade_zencart_200200.sql
ZC200LangPack_JP\sql\mysql_upgrade_zencart_200200.sql
in 75 line
ALTER TABLE address_book ADD COLUMN entry_telephone varchar(32) NOT NULL;


php file using this field:
ZC200LangPack_JP\admin\customers.php
ZC200LangPack_JP\admin-JP\customers.php
ZC200LangPack_JP\includes\classes\Customer.php
ZC200LangPack_JP\includes\classes\order.php
ZC200LangPack_JP\includes\functions\functions_addresses.php
ZC200LangPack_JP\includes\modules\checkout_new_address.php
ZC200LangPack_JP\includes\modules\pages\address_book_process\header_php.php

ikirin:

I carefully checked all the files and found that this field is in the Japanese language module

ZC200LangPack_JP\zc_install\sql\plugins\mysql_japanese_install.sql
ZC200LangPack_JP\sql\mysql_japanese_install.sql
in 75 line
ALTER TABLE address_book ADD COLUMN entry_telephone varchar(32) NOT NULL;

ZC200LangPack_JP\zc_install\sql\updates\mysql_upgrade_zencart_200200.sql
ZC200LangPack_JP\sql\mysql_upgrade_zencart_200200.sql
in 75 line
ALTER TABLE address_book ADD COLUMN entry_telephone varchar(32) NOT NULL;

php file using this field:
ZC200LangPack_JP\admin\customers.php
ZC200LangPack_JP\admin-JP\customers.php
ZC200LangPack_JP\includes\classes\Customer.php
ZC200LangPack_JP\includes\classes\order.php
ZC200LangPack_JP\includes\functions\functions_addresses.php
ZC200LangPack_JP\includes\modules\checkout_new_address.php
ZC200LangPack_JP\includes\modules\pages\address_book_process\header_php.php

That is an issue with the Japanese language-pack then; I suggest reporting in that plugin's support-thread.

OK, I have reported this issue

I am in the final prep of moving up to 2.0x from 1.5.7c. I have everything documented and working except for payment modules as I am working on a local server and can't really test those. I just installed OPC and got this screen when I tried to checkout.

https://drive.google.com/file/d/1TDRbFSVRNs6KG_AolpYvDkD3hYcaMwTt/view?usp=drive_link

Is this a result of me not having Square or Paypal (our normal payment methods) installed? Or did I mess up somewhere? This is actually the second time I have tried this and I have full backups just in case.

g2ktcf:

I am in the final prep of moving up to 2.0x from 1.5.7c. I have everything documented and working except for payment modules as I am working on a local server and can't really test those. I just installed OPC and got this screen when I tried to checkout.

https://drive.google.com/file/d/1TDRbFSVRNs6KG_AolpYvDkD3hYcaMwTt/view?usp=drive_link

Is this a result of me not having Square or Paypal (our normal payment methods) installed? Or did I mess up somewhere? This is actually the second time I have tried this and I have full backups just in case.
That link requires me to login to something I don't have credentials for. Check the OPC settings for payment methods allowed for guest checkout, as a guess.

lat9:

That link requires me to login to something I don't have credentials for. Check the OPC settings for payment methods allowed for guest checkout, as a guess.

https://drive.google.com/file/d/1TDRbFSVRNs6KG_AolpYvDkD3hYcaMwTt/view?usp=sharing

that should allow anyone to see it.

lat9:

That link requires me to login to something I don't have credentials for. Check the OPC settings for payment methods allowed for guest checkout, as a guess.

I knew I forgot to change the jQuery Selector to #ottotal .ot-text.

That took care of the popup error but the "Sorry our expidited checkout process cannot be used. Click here to use our alternate checkout process" So it looks like I have a javascript error?

Also, I am logged in as a customer, not a guest if that makes any difference.

g2ktcf:

I knew I forgot to change the jQuery Selector to #ottotal .ot-text.

That took care of the popup error but the "Sorry our expidited checkout process cannot be used. Click here to use our alternate checkout process" So it looks like I have a javascript error?

Also, I am logged in as a customer, not a guest if that makes any difference.
Check your browser's "Console Logs", there might be multiple versions of jQuery being loaded.

ah, there is an error associated with #ottotal .ot-text.

here is the console view of the error. At first, I thought I typed in the jQuery selector wrong.

https://drive.google.com/file/d/1pSQjS-fxCrOakeMvqZlX1AyILBnL1GCA/view?usp=sharing

g2ktcf:

ah, there is an error associated with #ottotal .ot-text.

here is the console view of the error. At first, I thought I typed in the jQuery selector wrong.

https://drive.google.com/file/d/1pSQjS-fxCrOakeMvqZlX1AyILBnL1GCA/view?usp=sharing
Looks like you've got multiple versions of jQuery 3.7.1 loaded.

lat9:

Looks like you've got multiple versions of jQuery 3.7.1 loaded.

I know NOTHING about jQuery...where should I be looking to fix?

g2ktcf:

I know NOTHING about jQuery...where should I be looking to fix?
In your current template's /common/html_header.php. If you use your browser's "Inspect" feature and then look in the <head>, you'll likely see two <script> tags loading version 3.7.1 of jQuery.

lat9:

In your current template's /common/html_header.php. If you use your browser's "Inspect" feature and then look in the <head>, you'll likely see two <script> tags loading version 3.7.1 of jQuery.

Well I have walked through the entire header and I only have one referencing 3.7.1 and it is

<script src="https://code.jquery.com/jquery-3.7.1.min.js" integrity="sha256-/JqT3SQfawRcv/BIHPThkBvs0OEvtFFmqPF/lYI/Cxo=" crossorigin="anonymous"></script>

There are two other jQuery scripts but it does not look right

<script src="includes/modules/pages/checkout_one/jquery.checkout_one.min.js?1712319903" defer=""></script>
<script src="includes/modules/pages/checkout_one/jquery.checkout_one_addr.min.js?1712319904" defer=""></script>

g2ktcf:

Well I have walked through the entire header and I only have one referencing 3.7.1 and it is

> 
> There are two other jQuery scripts but it does not look right
> 
> ```
<script src="includes/modules/pages/checkout_one/jquery.checkout_one.min.js?1712319903" defer=""></script>
<script src="includes/modules/pages/checkout_one/jquery.checkout_one_addr.min.js?1712319904" defer=""></script>

Is the site publicly available? If so, shoot me the link via PM.

Those additional jQuery scripts are loaded (and required by) OPC.

lat9:

Is the site publicly available? If so, shoot me the link via PM.

Those additional jQuery scripts are loaded (and required by) OPC.

this is a local test environment. :( But it is the last Bootstrap Beta 6 not the fully updated version if that helps.

I am just curious why it does not recognize #ottotal .ot-text.

found it :clap:

OMG I have been fighting this for days. I kept asking myself, why is the jQuery selector showing an error in the console. Well, I copied that selector string out of another post but the selector was at the end of a sentence...so I got

#ottotal > .ot-text.

instead of the correct

#ottotal > .ot-text

That extra period causes a mess!

g2ktcf:

found it :clap:

OMG I have been fighting this for days. I kept asking myself, why is the jQuery selector showing an error in the console. Well, I copied that selector string out of another post but the selector was at the end of a sentence...so I got

#ottotal > .ot-text.

> 
> instead of the correct 
> 
> ```
#ottotal > .ot-text

That extra period causes a mess!
Nice one; thanks for reporting back!

1.5.7d
responsive_classic clone
OPC 2.5.1
EO 4.6.2
Square WebPay
PayPal Express

Had strange transaction yesterday with 1.899999999999999911182158029987476766109466552734375 as the weight.

After that, all OPC Guests are getting the Your order's details have changed.

display logs since then (83)

[04-Jun-2024 03:15:22 America/New_York] PHP Fatal error: Uncaught Error: Call to a member function guestCheckoutEnabled() on int in /includes/classes/observers/class.checkout_one_observer.php:216
Stack trace:
#0 /includes/autoload_func.php(61): checkout_one_observer->messageCheck()
#1 /includes/application_top.php(222): require('/home/******/...')
#2 /index.php(25): require('/home/******/...')
#3 {main}
thrown in /includes/classes/observers/class.checkout_one_observer.php on line 216

[04-Jun-2024 03:15:22 America/New_York] Request URI: /, IP address: 92.88.171.253
--> PHP Fatal error: Uncaught Error: Call to a member function guestCheckoutEnabled() on int in /includes/classes/observers/class.checkout_one_observer.php:216
Stack trace:
#0 /includes/autoload_func.php(61): checkout_one_observer->messageCheck()
#1 /includes/application_top.php(222): require('/home/******/...')
#2 /index.php(25): require('/home/******/...')
#3 {main}
thrown in /includes/classes/observers/class.checkout_one_observer.php on line 216.
```Re-entering CC and submitting the order goes through.

No one admits to any changes to files or settings.

Can PM or email OPC log before the incidents if needed.

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'][B], $_SESSION['opc'][/B]) && $_SESSION['opc_error'] === OnePageCheckout::OPC_ERROR_NO_JS) && $_SESSION['opc']->guestCheckoutEnabled() === true) {

After creating logs for @36 hours, it stopped. :dontgetit

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

THANX