Postcode Auto Fill support thread

[allmart]

Has anyone used this for Canada?

[pilou2]

V2.0.2 of this encapsulated plugin has been submitted in plugin section and should be available soon.
It is available on Github here.

It corrects a bug in SQL queries where missing country zones will stop installation.
Some code cleaning was done too.

[OldNGrey]

I had v2.0.1 installed, uploaded v2.0.2 to zc_plugins, uninstalled V2.0.1, installed v2.0.2 and received warning on Plugin Manager screen only (no log files)

Unknown collation: 'utf8mb4_ja_0900_as_cs_ks'
Table 'zc220_exp.zones_to_post_code_jp' doesn't exist

and module is not installed.

ZC 2.2; PHP8.4, MariaDB

[pilou2]

I see you are using MariaDB. It does not seem to support the collation 'utf8mb4_ja_0900_as_cs_ks'.
It should be working by replpacing the collation utf8mb4_ja_0900_as_cs_ks by some MariaDB equivalent at the begining of the Japanese postal cade SQL file (lines 9 & 10).
Un fortunately I am not sure MariaDB as an equivalent, I don't have any MariaDB server at hand to test that.
If you do not need Japanese postal codes, you can although modify line 6 of ScriptedInstaller.php, removing 'jp' from the list.

But if version 2.0.1 was working fine there was probably a collation that can be used.

[OldNGrey]

Thanks. The collation for MariaDB is "uca1400_ai_ci" (based on Unicode 14.0) for versions 10.11+

When the postcode (zip code) is entered and the city list is returned in the pop-up window, are the city /towns names supposedto be selectable?

[pilou2]

Yes, for Japan, city and suburb are supposed to be selectable (if there are multipe choices).

The table itself uses general collation but two fields need a 'kana sensitive' collation.

Try replacing 'utf8mb4_ja_0900_as_cs_ks' in file 'zc_plugins\PostAuto\v2.0.2\installer\sql\install\zones_to_post_code_jp.php' by 'uca1400_as_cs' on lines 9 and 10.
If the database can't make the difference between katakana and hiragana, for exemple ア and あ which read the same, then there will be a duplicate index error when installing and everything after this error won't be installed.
If it can make the difference then everything should be installed properly.

[OldNGrey]

Are non-japanese locations supposed to be selectable?
Select country = Australia, entering postcode 4121 returns the surburb Holland Park.
If I click on the suburb field the alternate suburbs (Holland Park, Holland Park East, Holland Park West, Tarragindi, Wellers Hill) are listed in a pop-up box.

They are not selectable from the list. Should they be?