V158 Japanese language pack

[pilou2]

A new release is there, v1.3.2 available on GitHub. 新しいリリース v1.3.2 が GitHub で入手可能です。
https://github.com/piloujp/ZenCartv1...ses/tag/v1.3.2
I submitted it to Plugin section too.
There are two bugs fixes, one in admin that prevented to display multiple pages in few admin listings and the other one fixes shipping estimator bug when only one item in cart, quote for Yamato, Sagawa and YuPack was 0.
Some left over translations in admin are now done.
Documentation has been improved too and lots of cleaning has been done.

[pilou2]

Shipping class for Yamato has been updated to October 2023 new (increased) fees...
You can find this update on Github here.

[pilou2]

Japanese Language Pack version 2.0.0 for Zen Cart v2.0.0-alpha1 is available on Github.
Zen Cart v2.0.0-alpha1 の日本語言語パック バージョン 2.0.0 は、Githubで入手できます。
Fresh install and update from ZC v2.0.0-alpha1 work fine with installer. Updating from older versions, Japanese or not should be done manually.
Japanese zones that were double in database for Kanji and alphabet writing are now unique. This dual writing is now handle in code. There is still a problem to update from old data as zone ids change. I am working on an sql update query for that.
Until this is done, this version is for new install of Zen Cart or old English versions updated to V2.0.0-alpha1.

[pilou2]

The Japanese language pack v2.0.0 for the new Zen Cart version 2.0.0 is ready.
You can download it on GitHub here.
It will be soon available in plugin section too.
日本語言語パックをGitHubで公開しました。 ぜひお試しください。間もなくプラグインセクションでも利用できるようになる予定です。

[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/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

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

[pilou2]

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/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

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

This error message appears when MySQL is in STRICT mode. There are two way to fix it:
1- Edit my.ini (or my.conf on Linux) and remove STRICT_ALL_TABLES mode. You should have

sql_mode=""

.
2- Set Null column to yes and default value to NULL in database for field entry_telephone in table address_book. But then you still might have the same error with other fields.
I modified install file so it does not happen again.