3.1.0-beta - Phinx Error Migration

[pitoco02]

CMS Version

3.1.0-beta
IIS Server PHP 7.2

Issue

Guys!
It throws an error during the phinx migration:

I was trying to migrate from 3.0.7 to 3.1.0-beta (IIS Instalation)

Any suggestion?
thanks!

[natasha]

Hi, what version MySQL are you using?

[pitoco02]

Hi Natasha!
Here it is:

I have other CMS databases working fine on this server, including 3.0.x version and one 3.1.0-beta version manually installed

Thank you!

[dan]

Hi,

Ironically I ran into this too - root cause for me was the aouth_clients table being latin1 instead of utf8.

I think this would solve it

ALTER TABLE `aouth_clients` CHARACTER SET utf8 COLLATE utf8_general_ci

Edit: bug created for this here:

Upgrade: phinx migration fails 3.0 to 3.1.0-beta (FK create)

Thanks,
Dan

[pitoco02]

Hi Dan and Natasha!

Thank’s again for the answer!

For me it was also necessary to update the Collation of the Columns to utf8_general_ci

ALTER TABLE `oauth_clients` 
CHANGE COLUMN `id` `id` VARCHAR(254) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ,
CHANGE COLUMN `secret` `secret` VARCHAR(254) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ,
CHANGE COLUMN `name` `name` VARCHAR(254) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ;

But it works for me.

Thank you!