V158 Japanese language pack

Hello everybody,

I have just made a Japanese language pack and it has been released in the plugin section:（日本語のv1.5.8言語パックをリリースしました！）
https://www.zen-cart.com/downloads.php?do=file&id=2359
This is an heavy modification of Zen Cart v 1.5.8 (only) but after installing it you should be able to use Japanese in your shop and have name with furigana and addresses properly formated and it includes Japanese shipping modules too for Yamato, Sagawa and Japanese Post.

There are still two 'things to do':
First I plan to make a Japanese version of the Readme explanation file. As I am not so good at explaining in Japanese I will appreciate some help/correction from native speaker. :wink:
Secondly I want to optimize calculation algorythms for parcel size. This is more on the long term for this one.

Please if you try/use it I will appreciate any feedback.
And don't hesitate if you have any questions.
Thanks! 宜しくお願いします。

Hi @pilou2, we are having a discussion about language packs and wondered if you new pack uses UTF8 character set.

Quote:

---

Originally Posted by brittainmark

Hi @pilou2, we are having a discussion about language packs and wondered if you new pack uses UTF8 character set.

---

Yes charset is set to utf-8 in language files and files themselves are all utf8 encoded.

Version 1.1.0 has been released.
It adds local PHP Japanese calendar, which means the era can be displayed in date. For 2022 it is Reiwa 4 (令和４) and it is displayed in admin header date.
I use an extra function for that with default format parameter

Code:

---

'r年（Gy年）MMMMd日 EEEE HH:mm:ss ZZZZ'

---

but you can put your own string format (IntlDate format) in header file at line 203 as an argument for the function zen_set_local_calendar(). Result is like this:
2022年（令和4年）12月10日 土曜日 00:43:37 GMT+09:00
Enjoy!

Arigato!

Version 1.1.6 of Japanese Language Pack is ready for release. Modifications/updates are as follow:

Modified customer.php in admin so that dob field is required or not depending on field length setting in admin like for customer side.
Typo corrections in language files.
Added filter in function zen_get_country_zone to display only Japanese name for Japan zones when in Japanese and English names otherwise.
Updated categories and rates for Japanese Post Class jpparcel.php Renamed all files and variable from jppercel... to jpparcel... which includes module file and language files. Old files named jppercel....something should be deleted:
'...\includes\classes\_jppercel.php'
'...\includes\languages\english\modules\shipping\lang.jppercelems.php'
'...\includes\languages\japanese\modules\shipping\lang.jppercelems.php'
'...\includes\modules\shipping\jppercelems.php'

It is already available on Github and should be soon in plugin page.:wink:
https://www.zen-cart.com/downloads.php?do=file&id=2359

Quote:

---

Originally Posted by pilou2

... Old files named jppercel....something should be deleted:
'...\includes\classes\_jppercel.php'
'...\includes\languages\english\modules\shipping\lang.jppercelems.php'
'...\includes\languages\japanese\modules\shipping\lang.jppercelems.php'
'...\includes\modules\shipping\jppercelems.php'
...

---

Please follow this more detailed steps to update to V1.1.6 :
- After copying all new files, install shipping module jpparcelems with same settings as jppercelems.
- Uninstall shipping module jppercelems.
- Delete these files :
'...\includes\classes\_jppercel.php'
'...\includes\languages\english\modules\shipping\lang.jppercelems.php'
'...\includes\languages\japanese\modules\shipping\lang.jppercelems.php'
'...\includes\modules\shipping\jppercelems.php'
Done!

Hello A new update (v1.1.8) has been submitted in Plugin area. It should be available soon.
If you can't wait go get it on Github! It is easier there to see which files are new or recently modified.
There are some important bug fix and a new shipping module 'International ePacket'.

Hello pilou2,Thanks for the Japanese language pack!
In ZEN-CART v158
I get an error when uploading the "mysql_japanese_install.sql" file in the SQL folder in PhpMyAdmin. Other than that, I can upload the file.
MYSQL message
#住所フォーマット追加 (#Add address format)
INSERT INTO address_format VALUES（21,'$postcode$cr$sate$city$streets$cr$lastname $firstname 様')
#1136-1行目で、列の数が値の数と一致しません。(#1136-In line 1, the number of columns does not match the number of values.)

If I upload the mysql_japanese_install.sql file again.
#注文ステータス (#Order status)
INSERT INTO orders_status VALUES ('5','1' 'Sent',40)
#1062 - '5-1'は索引 'PRIMARY'　で重複しています。(#1062 - '5-1' is duplicated in index 'PRIMARY'.)

Next time I upload the contents of ADMIN-JP to the admin folder using FTP software.
When I add a new item I get an error and cannot add it.
I get an error message "If you were entering information, press the BACK button in your browser and re-check the information you If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data."
Thanks in advance.

Quote:

---

I get an error when uploading the "mysql_japanese_install.sql" file in the SQL folder in PhpMyAdmin. Other than that, I can upload the file.
MYSQL message
#住所フォーマット追加 (#Add address format)
INSERT INTO address_format VALUES（21,'$postcode$cr$sate$city$streets$cr$lastname $firstname 様')
#1136-1行目で、列の数が値の数と一致しません。(#1136-In line 1, the number of columns does not match the number of values.)

---

Fujimasa san, sorry for the mistake. here is the correct sql request:
INSERT INTO address_format VALUES (21, '〒$postcode$cr$state$city$streets$cr$lastname $firstname 様', '$city $country');

But you can't use INSERT two time on same database/table. It is only to add new data. To change existing data the MySQL command 'UPDATE' is used.
When you have an error like that don't upload the whole SQL file again just go to sql tab in phpmyadmin and copy / paste the correct MySQL query there.

Quote:

---

Next time I upload the contents of ADMIN-JP to the admin folder using FTP software.
When I add a new item I get an error and cannot add it.
I get an error message "If you were entering information, press the BACK button in your browser and re-check the information you If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data."

---

I am going to check that but a log file would be very helpful. Just after the error happens look in 'logs' folder (in cart root) where a new file should have been created. Please copy and paste the relevant part of this log file.

Thanks pilou2 for the quick response.
I rewrote line 21 of the SQL and pasted it in the sql tab, but it did not work.
I reinstalled all of ZEN-CART and pasted "mysql_japanese_install.sql" and no error. Thanks.
The error in line #1136-1 seems to have been caused by a double upload as you suggested.
Now I have no more problems adding products, and the storfront page is displaying well.

I was able to proceed and uploaded 'mysql_japanese_admin_menu.sql' as well.
I uploaded the admin-JP contents to the admin folder using FTP software.
At this time, there was one error that 'myadmin/includes/languages/japanese/images/buttons/button_display.gif' could not be uploaded.

I logged into the admin panel, but it was not in Japanese.
I tried uploading 'mysql_japanese_config.sql' in the SQL folder, and the 'japanese' combo box appeared on the admin screen and I was able to make the admin screen Japanese.

However, when I go to the modules menu to view payment modules, etc,

'Error: Module could not be loaded because the corresponding language file does not exist: /mydomain/myfolder/includes/languages/japanese/modules/modules/payment/authorizenet.php'

'Error: Module could not be loaded because the corresponding language file does not exist: /mydomain/~
I get seme 10 errors, and similar errors for other shipping modules, etc.'

Are there any other files that should be uploaded?

Quote:

---

Originally Posted by fujimasa

I was able to proceed and uploaded 'mysql_japanese_admin_menu.sql' as well.
I uploaded the admin-JP contents to the admin folder using FTP software.
At this time, there was one error that 'myadmin/includes/languages/japanese/images/buttons/button_display.gif' could not be uploaded.

---

This is most likely an FTP upload problem, just try to upload this file again.

Quote:

---

I logged into the admin panel, but it was not in Japanese.
I tried uploading 'mysql_japanese_config.sql' in the SQL folder, and the 'japanese' combo box appeared on the admin screen and I was able to make the admin screen Japanese.

---

You have to add Japanese language in admin. But 'mysql_japanese_config.sql' did it for you. I already added explanations in readme file for next release.

Quote:

---

However, when I go to the modules menu to view payment modules, etc,

'Error: Module could not be loaded because the corresponding language file does not exist: /mydomain/myfolder/includes/languages/japanese/modules/modules/payment/authorizenet.php'

'Error: Module could not be loaded because the corresponding language file does not exist: /mydomain/~
I get seme 10 errors, and similar errors for other shipping modules, etc.'

Are there any other files that should be uploaded?

---

These are Zen Cart pre-installed module and I did not do any Japanese version of them because they generally not used in Japan. I will add some more explanation in next release and perhaps include the English version in Japanese folder. This what you have to do to fix it, copy all modules language files that have an error from English folder to Japanese folder mirroring the English folders and files.
In general, if you add modules in the future always add language files in both English and Japanese folders.

Quote:

---

Originally Posted by fujimasa

I was able to proceed and uploaded 'mysql_japanese_admin_menu.sql' as well.
I uploaded the admin-JP contents to the admin folder using FTP software.
At this time, there was one error that 'myadmin/includes/languages/japanese/images/buttons/button_display.gif' could not be uploaded.

---

This is mostly due to an FTP upload problem. Just try to upload this file again.

Quote:

---

I logged into the admin panel, but it was not in Japanese.
I tried uploading 'mysql_japanese_config.sql' in the SQL folder, and the 'japanese' combo box appeared on the admin screen and I was able to make the admin screen Japanese.

---

You need to add Japanese language as a new language before being able to use it. The 'mysql_japanese_config.sql' file did it for you.

Quote:

---

However, when I go to the modules menu to view payment modules, etc,

'Error: Module could not be loaded because the corresponding language file does not exist: /mydomain/myfolder/includes/languages/japanese/modules/modules/payment/authorizenet.php'

'Error: Module could not be loaded because the corresponding language file does not exist: /mydomain/~
I get same 10 errors, and similar errors for other shipping modules, etc.'

Are there any other files that should be uploaded?

---

All these modules are Zen Cart build-in modules for which there is no Japanese version mainly because they are not used in Japan. They (and any module in general) need a language file for each language installed in Zen Cart. As there is no Japanese version, just copy English language files to Japanese language folder respecting folders organization. I should probably add them to next release or at least add some explanation in readme file.

Thank you for all these feed backs it will help improving this plugin.

Quote:

---

Originally Posted by fujimasa

However, when I go to the modules menu to view payment modules, etc,

'Error: Module could not be loaded because the corresponding language file does not exist: /mydomain/myfolder/includes/languages/japanese/modules/modules/payment/authorizenet.php'

'Error: Module could not be loaded because the corresponding language file does not exist: /mydomain/~
I get seme 10 errors, and similar errors for other shipping modules, etc.'

Are there any other files that should be uploaded?

---

Actually these files are already translated and included in the pack! Looking at the path, folder 'modules' appears too times in your error message: '/mydomain/myfolder/includes/languages/japanese/modules/modules/payment/authorizenet.php'
I don't know why. Perhaps some problem with upload?
I did a full Japanese version install with the pack on a newly installed Zen Cart 1.58a and there was no problem at all (after correcting the first SQL error).
Please check your folder 'modules' is actually in '..\includes\languages\japanese\modules\'.

To forum Admin.
I have recently three posts that did not make it to the forum on two different threads and then two of them reappeared one or two days later and one is lost at least for now.
Could you have a look please and delete the double post on this thread and this message too after you read it. It seems to happen when I use 'Go Advanced' and 'preview' but not with 'Quick Post'.
Thanks.

Hello pilou2!
I had Saturday and Sunday off and Monday to get some work done.

I was able to do the 'myadmin/includes/languages/japanese/images/buttons/button_display.gif' by uploading it again.

I have experimented with various test pages since then, and when I add 'mysql_japanese_config.sql', the Japanese combo box appears, but I get an error on the storefront page.' This page is not working, the domain cannot process this request at this time. HTTP ERROR 500'
If I change the PHP language setting on the server from 8 to 7.4 module mode, the storefront page seems to display. However, it was an incomplete display.

Then I read your reply and tried the following
The "Japanese" folder and the "lang.japanese.php" file in the "ZC158LangPack_JP\includes\languages", I uploaded them to the "/Mydomain/Myfolder/includes/languages" folder on my server.

A combo box appeared where I could switch between Japanese and English. I was able to go to the payment and shipping module tabs and they displayed correctly. Excellent.
' mysql_japanese_config.sql' and the faulty front page now displays correctly.
However, the top page and other displays are now probably from your own page.
The payment methods etc. are also probably the same as on your page.
This helped me understand that I could change the storefront text by changing the text in the folders.

I have not uploaded the Japanese pack for the module, but it now displays correctly. I am going to try to manipulate it in various ways.

Quote:

---

However, the top page and other displays are now probably from your own page.
The payment methods etc. are also probably the same as on your page.
This helped me understand that I could change the storefront text by changing the text in the folders.

---

Your are right I need to do some clean up.
To modify these information you do it exactly like an English version. Most of it can be done from admin menu, especially in 'tools->define page editor' but for things like logo you have to edit some files.
Please have a look at documentation, it is English but well done and easy to understand. You could start here:
https://docs.zen-cart.com/user/new_user_topics/

The only part specific to Japanese that you need to change is the shipping quote in modules for Sagawa, Yamato and Yupack. They depends on where you ship from and if you have a contract or not with these companies.
Files to edit are in 'includes\classes\' :
'includes\classes\_sagawa.php'
'includes\classes\_yamato.php'
'includes\classes\_yupack.php'
In function quote there is a big array with all quotes (送料). You need to adjust these if you have a contract. Then below is another array with codes like this 'AC'=>'N04' that define which quote number (N04) to use to send from one area (A) to another (C). I send from Okinawa and quotes (送料) will probably very different for you.
It takes time but you have to do it one time or sometime more when shipping prices increase.
がんばって！

Hello pilou2 thanks for everything.
I did the installation in the following order
SQL
mysql_japanese_admin_menu.sql install
mysql_japanese_install.sql install
File
email ,images, includes

At this point, there was no combo box to switch to Japanese on the admin page.
I found that the Japanese combo box appeared only after installing 'mysql_japanese_config.sql'.

I also found
Uploading "ZC158LangPack_JP > includes > templates" seems to cause an error on the storefront page.
That error did not appear in my environment until I closed the browser and reopened it.
The error is on the page where you click on login to register as a new member.
The Submit the Information '送信'　button at the bottom of the page disappears.
This probably had something to do with the "template_default" in "includes/templates" on the server.
I tried to avoid affecting "template_default" and switched to another template with the ride-on function, and the button appeared.
It may be just my environment, so please check.

In the Japanese readme, "email", "images", and "includes" are uploaded, but I had the impression that I could also upload them. I think it is the impression of the word "CAN" "出来る" that I can do.

Quote:

---

Originally Posted by fujimasa

Hello pilou2 thanks for everything.
I did the installation in the following order
SQL
mysql_japanese_admin_menu.sql install
mysql_japanese_install.sql install
File
email ,images, includes

At this point, there was no combo box to switch to Japanese on the admin page.
I found that the Japanese combo box appeared only after installing 'mysql_japanese_config.sql'.

---

I modified 'mysql_japanese_install.sql' to set Japanese language and make Language Box visible from the beginning.

Quote:

---

I also found
Uploading "ZC158LangPack_JP > includes > templates" seems to cause an error on the storefront page.
That error did not appear in my environment until I closed the browser and reopened it.
The error is on the page where you click on login to register as a new member.
The Submit the Information '送信'　button at the bottom of the page disappears.
This probably had something to do with the "template_default" in "includes/templates" on the server.
I tried to avoid affecting "template_default" and switched to another template with the ride-on function, and the button appeared.
It may be just my environment, so please check.

---

Problem is not necessary with template it could be a language constant or a variable that is not found provoking an error 500 on the server. You should have more details in log file in '/logs' folder. I checked here and there was no problem...

Quote:

---

In the Japanese readme, "email", "images", and "includes" are uploaded, but I had the impression that I could also upload them. I think it is the impression of the word "CAN" "出来る" that I can do.

---

I changed it to:
Zen Cart v1.5.8 を更新、プラグイン、またはその他の変更なしで新規インストールした場合は、すべてのストアフロント サイド ファイル（フォルダー：email、images、includes）をカートにコピーして下さい「既存のファイルを上書きします」。
I hope it is better like this.
I have just made a new release v1.2.1 that I sent yesterday to plugin section of Zen Cart site but it takes few days to appear and today' fixes are not included.
But the release v1.2.1 on Github is up to date with correction mentioned in this post:
https://github.com/piloujp/ZenCartv1...ses/tag/v1.2.1

Version 1.2.1 is released.
It should be available soon in plugin section but it is better to download from Github where it is already there and up to date (plugin section one has a small error in it).
https://github.com/piloujp/ZenCartv1...ses/tag/v1.2.1
I will use this post to add a tutorial for the quickest way to install Japanese pack on a freshly installed Zen Cart v1.5.8 or v1.5.8a:

- First you need a new Zen Cart v1.5.8 or v1.5.8a already installed and working in English version but with no plugin added.
- After that backup all cart files by making a copy somewhere and Database by exporting everything in an SQL file. If something goes wrong, using these backup you can start from zero without re-installing English version.
- Then run SQL queries in 'mysql_japanese_install.sql', 'mysql_japanese_config.sql' and if you want admin fully Japanese 'mysql_japanese_admin_menu.sql'. You can do this by importing these files in a tool like phpMyAdmin or by copying queries into Zen Cart admin SQL tool or whatever you like. If some error occurs during this process, fix it before doing next step! Continuing with errors will just mess up things.
- Now copy to your cart folders 'email', 'images' and 'includes' including all files and subfolders. If you use FTP, check that everything has been uploaded.
- Finally, copy content of admin-JP (or admin-EN if you want to keep admin in English) to your cart admin folder. Don't copy folder itself has names are different for each installation.

You are done!
You still have to configure/install modules you want to use like you would do with an English version. For shipping modules have a look at readme file.

Tip: In case you run into troubles and after few fixing attempts things don't get better, start again from zero using backups. It is generally faster.

Hello pilou2
Thank you for releasing Version 1.2.1.
I was able to register products, register customers, and even receive orders in Japanese. I am very impressed.

And
When a customer registers himself, an error message "Please select your prefecture from the pull-down menu" appears after he presses the submit button.
This was cured by going to >General Settings>Customer Account Settings>Prefecture name drop down(＞一般設定＞顧客アカウントの設定＞都道府県名ドロップダウン) and setting the display to TRUE.

When I went to >Modules > Shipping Module Settings.
For example, when I click on "Sagawa Express, 3-7 days", the properties appear on the right side.
I may have had it explained to me in the past, but I could not get it to work.
I found the Japanese text in "ZC158LangPack_JP>includes>modules>shipping>sagawa.php".

About "Readme-jp.txt". There is "File, case 1:" and "File, Case 2:"

> In fact, there are 11 Shipping modules, 4 Payment modules, and 3 Total_Order modules.
> "here"
>- The cla for shipping modules.

The end of the explanation for the upgraded case of "File, Case 2":,
Is the "here" part correct?

It looked like case 2 continued until the "> setting:."

Quote:

---

Originally Posted by fujimasa

Hello pilou2
Thank you for releasing Version 1.2.1.
I was able to register products, register customers, and even receive orders in Japanese. I am very impressed.

And
When a customer registers himself, an error message "Please select your prefecture from the pull-down menu" appears after he presses the submit button.
This was cured by going to >General Settings>Customer Account Settings>Prefecture name drop down(＞一般設定＞顧客アカウントの設定＞都道府県名ドロップダウン) and setting the display to TRUE.

---

You did the right thing. It seems there is a bug in Zen Cart, nothing to do with language. It happens in English too. I have a fix that I will submit to Zen Cart developer team. Thanks for finding it.

Quote:

---

When I went to >Modules > Shipping Module Settings.
For example, when I click on "Sagawa Express, 3-7 days", the properties appear on the right side.
I may have had it explained to me in the past, but I could not get it to work.
I found the Japanese text in "ZC158LangPack_JP>includes>modules>shipping>sagawa.php".

---

To have text in Japanese in modules you have to uncomment Japanese text and comment English one at the end of module file.
Add /* on line after '// English' and add */ on line before '// Japanese' to comment English part and remove /* on line after '// Japanese' and */ that is after Japanese part to uncomment Japanese.
Then install or re-install module in admin and you get Japanese. Module default setting is good but you have to add a tax class for Sagawa module (prices without tax), then choose a zone where you want to use this module like Japan, Japan except Okinawa/Hokkaido or just your prefecture. These zones must be created before in admin menu. At the end choose display order for this module. 0 if you want it to come first, big number to display it at the end.

Quote:

---

About "Readme-jp.txt". There is "File, case 1:" and "File, Case 2:"

> In fact, there are 11 Shipping modules, 4 Payment modules, and 3 Total_Order modules.
> "here"
>- The cla for shipping modules.

The end of the explanation for the upgraded case of "File, Case 2":,
Is the "here" part correct?

It looked like case 2 continued until the "> setting:."

---

I am not sure to understand what you mean. Only thing I found in the readme is that end of case 2 is not clear and module preparation seems to be part of case 2 only. I will change that and make it clear where case 2 ends.

Thanks for all you experience returns.

An important bug fix for Japanese admin users has been added on Github.
https://github.com/piloujp/ZenCartv1...-Language-Pack
With this fix you should be able to access Customer list without problem.
To download click on green button 'code' on the right then 'Download ZIP'. It will download all pack files in a zip.
To know which files are modified, from top page click on '...commits' on the right just below green 'Code' button. Then click on last commit name at the top of the list.
For a fix like this, you can safely copy these new files in your cart overwriting old ones.
日本語の管理者ユーザー向けの重要なバグ修正が Github に追加されました。
この修正により、顧客リストに問題なくアクセスできるようになります。
ダウンロードするには、右側にある緑色の「コード」ボタンをクリックしてから、「ZIP をダウンロード」をクリックします。
どのファイルが変更されているかを知るには、トップ ページから、緑色の [コード] ボタンのすぐ下にある [...commits] をクリックします。 次に、リストの上部にある最後のコミット名をクリックします。

Hello,
I found a new bug:
Japanese prefecture name Gunma was misspelled in zones table. SQL query install file has been corrected an is available on Github.
To correct it in your database, please run this query:
UPDATE zones SET zone_name='Gunma' WHERE zone_name='Gumma';

A new release v1.2.3 has just been submitted in Plugin section and is already available on Github.

Class shipping can now do multi-boxing on size or weight. ePacket module do multi-boxing based on weight and LetterPack Plus, which is a prepaid envelope, do it using dimension. Algorithm for size calculation has been improved too.
Modified admin customer edit form so that less mandatory fields are required.
Updated filter for Japanese prefectures names (Kanji or romaji) so it does not filter out other languages using non-standard characters.
Japanese prefecture Gunma spelling was corrected in zones table and SQL queries.
Added comments in Japanese shipping modules class for Yamato, Sagawa and Yupack. There are in a structured way more like example to make customization easier.
Modification of some SQL queries for database setting.
Aligned icons with text in few shipping modules.
Corrected bug in Japanese admin that prevented to see Customer list page.
Updated all files to Zen Cart v1.5.8a.
Updated instructions in readme files.
Few minor bugs fix.

Well, just after a new release, as usually, I found an annoying bug in install SQL query.
The query in 'mysql_japanese_install.sql' file that set Japanese language sets it with code 'jp' instead of 'ja'. You can check in your admin 'Localization -> Language' and change it there if necessary. It will avoid warning an error log files.
Updated file is on Github if you did not install yet.
https://github.com/piloujp/ZenCartv1...-Language-Pack

New release on GitHub, v1.2.5:
https://github.com/piloujp/ZenCartv1...-Language-Pack

v1.3.0 has just been released on GitHub and submitted in plugin section.
Zen Cart installer has been added and it has never been easier to install this plugin. It could be done in few minutes only for a new cart install.
A new HTML documentation has been created too for all installation cases which should makes things easier, even when installing over a cart full of plugins.
Enjoy, and feedback are most welcome.

V1.3.0 with installer is finally available in plugin section and, as usually after a big release, I already found an annoying bug that prevents to display multiple pages in some admin listing when using Japanese menus.
A fix for this bug is available on GitHub.
v1.3.0の日本語管理メニューにバグがあるため、GitHubからダウンロードしてください。

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 からダウンロードしてください。