One-Page Checkout [Support Thread]

[ikirin]

zencart 2.0
php 8.3
one_page_checkout-2.5.1
ZC200LangPack_JP_2.0.0[japanese]
Q:
After the module is uploaded, the zencart backend cannot log in, prompting this error.

--> PHP Fatal error: MySQL error 1364: Field 'entry_telephone' doesn't have a default value :: INSERT INTO address_book (customers_id, entry_firstname, entry_lastname, entry_street_address, entry_country_id, entry_zone_id) VALUES ('2', 'Guest', 'Customer, **do not remove**', 'Default billing address', '107', '293') ==> (as called by) /home/xxx/public_html/includes/functions/database.php on line 134 <== in /home/e99adba/public_html/includes/classes/db/mysql/query_factory.php on line 714. 

A:
Update database fields
ALTER TABLE `address_book` CHANGE `entry_telephone` `entry_telephone` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;

[lat9]

zencart 2.0
php 8.3
one_page_checkout-2.5.1
ZC200LangPack_JP_2.0.0[japanese]
Q:
After the module is uploaded, the zencart backend cannot log in, prompting this error.

--> PHP Fatal error: MySQL error 1364: Field 'entry_telephone' doesn't have a default value :: INSERT INTO address_book (customers_id, entry_firstname, entry_lastname, entry_street_address, entry_country_id, entry_zone_id) VALUES ('2', 'Guest', 'Customer, **do not remove**', 'Default billing address', '107', '293') ==> (as called by) /home/xxx/public_html/includes/functions/database.php on line 134 <== in /home/e99adba/public_html/includes/classes/db/mysql/query_factory.php on line 714. 

A:
Update database fields
ALTER TABLE `address_book` CHANGE `entry_telephone` `entry_telephone` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;

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

[ikirin]

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]

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

[lat9]

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.

[ikirin]

OK, I have reported this issue

[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/1TDR...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.

[lat9]

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/1TDR...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.