Just had two errors:
1st) Migration failed because key types were not exactly the same (key and foreighn key).
Had to set correct type:
ALTER TABLEtbl_auth_assignmentCHANGEuser_id user_idint(11) NOT NULL AFTERitem_name;
2nd) Query failed because it was trying to compare keys with different collations, utf8_general and utf8_unicode. Fixed by casting to same type:
ALTER TABLEauth_item_groupCHANGEcode codevarchar(64) COLLATE 'utf8_unicode_ci' NOT NULL FIRST, CHANGEname namevarchar(255) COLLATE 'utf8_unicode_ci' NOT NULL AFTERcode;
Just had two errors:
1st) Migration failed because key types were not exactly the same (key and foreighn key).
Had to set correct type:
ALTER TABLEtbl_auth_assignmentCHANGEuser_idint(11) NOT NULL AFTERitem_name;2nd) Query failed because it was trying to compare keys with different collations, utf8_general and utf8_unicode. Fixed by casting to same type:
ALTER TABLEauth_item_groupCHANGEcodevarchar(64) COLLATE 'utf8_unicode_ci' NOT NULL FIRST, CHANGEnamevarchar(255) COLLATE 'utf8_unicode_ci' NOT NULL AFTERcode;