Error when adding new page with non-ascii characters in a page field

[Gideon So]

I create a page reference field that allows user to create new page in the page edit page. I got this error:

Error adding page "一二三" - SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (ascii_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

 think it worked fine before I upgraded to 3.0.115.

Any idea?

Gideon

[Gideon So]

Hi,

I think this is a bug in the Page Reference field  which was introduced after core version 3.0.106. I tested it with both multi-language and single language setting. Both of them give the same error when trying to create a page with non ASCII page name in the page edit page. Should I report this to the github bug issue?

Gideon

[Gideon So]

Hi,

After testing with different version of the core. I found that the creation of page in page field function normally up to 3.0.110. It doesn't work anymore from 3.0.111. I will file a bug report to github.

Gideon

[Gideon So]

Please help to bump this issue in github. I think this bug is quite critical.

https://github.com/processwire/processwire-issues/issues/724

Gideon

[Gideon So]

This is a blocking bug that prevent non-ascii user upgrade the core beyond 3.0.110. @ryan any chance to take a look at it??

Gideon

[BitPoet]

I've added a few details about the cause of the expection to the issue. In short, the pages.name table is created with an ascii charset by the installer, which should probably be changed.

As a workaround, after installation, execute the following statement:

ALTER TABLE pages MODIFY COLUMN `name` varchar(128) character set utf8 NOT NULL;

(Change utf8 to utf8mb4 if you selected that character set in the installer)

[Gideon So]

@szabesz I tested @BitPoet solution and it works well. Thanks BitPoet for the work around but hope that @ryan will make this change to the core.

Gideon