No upgrade from 2.3.9. to 3.1.2

[pitoco02]

Hi!
Take a look in this topics, im pretty sure that will help you:

Migration 1.8.11 to 3.0.3

basically you need: PHP 7.2 pay attention to all php.ini configuration requirements reported by Xibo Delete the 1.8.11 files, keeping only the ‘web/settings.php’ file (that is your database connection) Paste the new CMS V2.3 files into the old CMS files folder Configure the folder ‘vendor/bin’ according to the topic below: Open CMD in administrator mode, and run the command: 'php vendor/bin/phinx migrate -c phinx.php' You have migrated to version 2.3, now do the same process, updating …

If the error persists, you may need to follow these steps:

3.1.0-beta - Phinx Error Migration

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: Thanks, Dan

3.1.0-beta - Phinx Error Migration

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!