Database Failure and Upgrade Skipping to Commit Upgrade Without Patch Uploaded

[pgr]

The critical part of your log messages is this: error 1071: Specified key was too long; max key length is 1000 bytes

With that, you’ll find a few similar threads here in the forums, like this one:

Upgrade not possible. --> Database failure. Please refer to suitecrm.log for details.

Thanks @shad at first I couldn’t change the field length in Studio because I would get database failure when trying to change the value. So I FIRST changed the column length in the Database. Then I would still get database failure on rebuild because the DB didn’t match SuiteCRM vardefs. So… magic trick… First change the DB length, THEN change them in SuiteCRM Studio to match. THEN repair and rebuild. Now all tables synced!!! Thanks for the help.

That has a few workarounds, and a link to a helpful video.

But the easiest suggestion is to upgrade MySQL from 5.6 to 5.7