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.
HTML Code:
--> 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/xxx/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;
I carefully checked all the files and found that this field is in the Japanese language module
HTML Code:
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
Bookmarks