DB error (during last upgrade step) ⚠

💬 General Discussion
1

This happened during the final step after upgrade and at custom fields…

Tue Jun 15 21:40:17 2021 [33358][8b3ba8d1-f0e7-a0be-2dbf-5e3328ef8b86][FATAL] Mysqli_query failed.
Tue Jun 15 21:40:17 2021 [33358][8b3ba8d1-f0e7-a0be-2dbf-5e3328ef8b86][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
Tue Jun 15 21:40:17 2021 [33358][8b3ba8d1-f0e7-a0be-2dbf-5e3328ef8b86][FATAL] Exception handling in /home/public_html/include/MVC/Controller/SugarController.php:409
Tue Jun 15 21:40:17 2021 [33358][8b3ba8d1-f0e7-a0be-2dbf-5e3328ef8b86][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.

I do see that it refers to:
Specified key was too long; max key length is 1000 bytes

So I guess that is the main error? Not sure what key the system is referring to.

Any ideas of what went wrong here? :thinking:

Thanks in advance.
PowerQuest

2

Can you please share the steps on how you have created custom field means through Script or Studio? If you” ve created it through Script then please share your code.

3

Hi @urvi.variance :smiley:
I made those fields just the normal way through the studio.

Kind regards
PowerQuest