👋🏾 Looking to join our SuiteCRM Community Working Group? 💌 Open invitation throughout January. Check out all the details here 👈

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

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).

Same thing happening to me on fresh install

+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?

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

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!

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