migrations icon indicating copy to clipboard operation
migrations copied to clipboard

Published 20 hours ago • verified publisher icon cakephp

Migration not running on MySQL8

Open frankhdz opened this issue 4 years ago • 2 comments

I created a migration to add a column to a table bin/cake bake migration AddHistoryToUserCatalog history:text

When running the migration I get this error PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mydatabasename' in 'where clause'

Running the same on a mysql5.x database executes without any issues. Running CakePHP3.9 php7.2.24 MySql 8. Staying on mysql 5.x is not an option for me. Has anyone run into this issue? Is there is fix?

frankhdz avatar Oct 08 '20 18:10 frankhdz

You will need phinx 0.12.x for mysql 8 support.

othercorey avatar Oct 08 '20 19:10 othercorey

@frankhdz You can try to backport certain features to 0.11 (and CakePHP 3) if you need to.

dereuromark avatar Oct 12 '20 12:10 dereuromark