Open Closed

FYI MySQL Index length bug - fix #955


0
paulbackhouse created

I managed to complete the upgrade to 0.8.0.3 and finally resolve the EF missing cmdlet problem - fix by the way is rollback EF to 6.1.1 and everything works perfectly with latest ABP stuff :) cmds are back (i.e add-migrations)

anyway, FYI. In the migration script, the Table "AbpUserLoginAttempts" tries to create and index on TenancyName, UserNameOrEmailAddress and Result. It will fail in MySql due to max length exceeding in the index (ref: http://stackoverflow.com/questions/8746 ... 1000-bytes)

To fix, change the length of the column UserNameOrEmailAddress from varchar(256) to varchar(255). 255 is the max default index capacity.

In case you want to put that in next release for MySql users


1 Answer(s)