V158 Japanese language pack

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.

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

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.

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で公開しました。 ぜひお試しください。間もなくプラグインセクションでも利用できるようになる予定です。

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

---

Quote:

---

Originally Posted by 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.

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

---

---

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

Code:

---

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.

You can try the v2.1.0-beta1, now available on GitHub.
There are lots of improvements on admin translation which is now as smooth as catalog side.
ZC 日本語言語パック v2.1.0-beta1 が GitHub で公開されました。
管理者の翻訳には多くの改善が加えられ、カタログ側と同じくらいスムーズになりました。

Japanese Language Pack v2.1.0 has been submitted in plugin section and should be available in few days.
It is an update for Zen Cart v2.1.0.
Now that all parts of ZC language strings can be changed on the fly, the option to choose English or Japanese admin at install has been removed.
Few (14) plugins' translations have been added in a separate folder.
Please read the documentation file provided for different installation/update cases.

日本語言語パック v2.1.0 は プラグイン セクション に提出されており、数日以内に利用可能になる予定です。
Zen Cart v2.1.0 のアップデートです。
ZC 言語文字列のすべての部分をオンザフライで変更できるようになったため、インストール時に英語または日本語の管理を選択するオプションは削除されました。
いくつかの (14) プラグインの翻訳が別のフォルダーに追加されました。
さまざまなインストール/更新ケースについては、提供されているドキュメント ファイルをお読みください。

Japanese Language Pack v2.1.1j has been released in plugin section.
All Japanese modules (shipping, payment and order total) are now encapsulated. They should be easier to maintain and update.
Shipping rates for Japanese shipping modules are now saved in a new table in database.
A new module (Tarifs) to view and edit shipping table rates through ZC admin has been added.
ZC last bugs corrections added.
Few plugins translations added for a total of 32.
If you want last updates and bug corrections, please download from GitHub by clicking on the green 'Code' button on the right and then 'Download Zip' at the bottom of the new tab.

プラグインセクションに日本語言語パック v2.1.1j がリリースされました。
すべての日本語モジュール（配送、支払い、注文合計）がカプセル化されました。これにより、メンテナンスと更新が容易になります。
日本語配送モジュールの配送料は、データベース内の新しいテーブルに保存されるようになりました。
ZC管理画面から配送料を表示・編集できる新しいモジュール（Tarifs）が追加されました。
ZCの最新のバグ修正が追加されました。
いくつかのプラグインの翻訳が追加され、合計 32 件になりました。
最新のアップデートやバグ修正が必要な場合は、右側の緑色の「コード」ボタンをクリックし、新しいタブの下部にある「Zip をダウンロード」をクリックして、GitHub からダウンロードしてください。