Database failure on upgrade from 7.11.19 to 7.11.20

SuiteCRM Forum - English Language Installation & Upgrade Help
1

In the logs I see:

Tue Jul 13 12:37:20 2021 [363588][1][FATAL]  Query Failed: ALTER TABLE users   DROP INDEX idx_user_name,  ADD INDEX idx_user_name (user_name,is_group,status,last_name,first_name,id): MySQL error 1071: Specified key was too long; max key length is 1000 bytes

Can anyone advise me on how to proceed?

2

Answering my own issue, for anyone else experiencing this see this ticket:

1 Like