Upgrade to 7.11.6 fails. [FATAL] Query Failed: ALTER TABLE users ("MySQL error 1071: Specified key was too long")

SuiteCRM Forum - English Language Installation & Upgrade Help
#1

While upgrading from version 7.11.5, sugarcrm.log reports:

[FATAL] Query Failed: ALTER TABLE users modify COLUMN first_name varchar(255) NULL , modify COLUMN last_name varchar(255) NULL : MySQL error 1071: Specified key was too long; max key length is 1000 bytes

If this ALTER TABLE command is changed so fields width are changed to 60 (instead of 255) the error disappears.

Note: if you go to “About” menu, it shows “correctly” 7.11.6 (as if the upgrade process run all the way).

#2

Same thing happening to me on fresh install

#3

+1 also occured to me, I ran the same with 60 instead,
ALTER TABLE users modify COLUMN first_name varchar(60) NULL , modify COLUMN last_name varchar(60) NULL ;
which worked although when I do a quick repair the system still recommends I run the command again?

#4

Hi every one

this is the Issue:

https://github.com/salesagility/SuiteCRM/issues/7509

And the fix is quite easy:

https://github.com/salesagility/SuiteCRM/pull/7510/files

Sorry for the inconvenience.

2 Likes
Error al instalar suitecrm en wampserver......... help please!
#5

Alright then!

This issue was flagged “resolved-next-release” too, so version 7.11.7 will solve this definitely.

In the meantime, please use the fix as indicated in the GitHub entry above.

Thanks to all!

#6

This is still not fixed in the current v7.11.20 download version from https://suitecrm.com/download/

I also get the following errors

Notice: Trying to access array offset on value of type null in /home/encorese/suitecrm2.encoreservices.eu/include/utils.php on line 1845
Notice: Trying to access array offset on value of type null in /home/encorese/suitecrm2.encoreservices.eu/include/utils.php on line 1799

Giving up on SuiteCRM