Error: ER_TOO_LONG_IDENT: Identifier name

System Information
  • Strapi Version: 4.17.0
  • Operating System: Mac OS 12.7.3
  • Database: MySQL
  • Node Version: 20.11.0
  • NPM Version: 10.2.4
  • Yarn Version: 1.22.21

Hi friends , my project works great on PostgreSQL, but I’m migrating to MySQL and I have been fighting with that issue, I changed the name of the component from the admin panel, but I believe in the code of Strapi in some parts the long name continue. What can I do to solve this? any help is welcome. thank you.

short answer is it’s a bug we are aware of, can’t fix in the v4 lifecycle, intend on fixing it in v5

There are some workarounds you can do to fix it per content-type/component without losing data but it does require some work. Info is in this bug report: