Black Friday 2026 50% off every plan Our biggest deal of the year on #1 Joomla products.
Ends in 12d 07h 32m 32s
Claim 50% off
Solved SP Page Builder

SQL-error Identifier name is too long

Asked by Ola 1 year ago Last activity 1 year ago

Hi!

I am trying to install Pagebuilder on a new site. I get this error, never had it before.

JInstaller: :Installera: SQL-fel Identifier name 'jos_mysitename__1_sppagebuilder_collection_item_values_ibfk_1' is too long

What can this be?

Kind regards
Ola

Accepted answer

Marked as the solution
Atick Eashrak Shuvo Staff

Hi Ola,

Thank you for reaching out, and we sincerely apologize for the inconvenience you're experiencing.

The error you're encountering is due to an identifier name in the database exceeding the maximum allowed length in MySQL. This is typically caused by a long table prefix, which leads to overly long constraint or key names during installation.

To resolve this issue, please ensure your table prefix follows these best practices:

  • Ideally three or four characters long
  • Contains only alphanumeric characters
  • Must end with an underscore (_)

Kind regards

2 more replies

Ola Asked this

Thanks! :-)

Made a new installation with shorter prefix and it works fine now.

Atick Eashrak Shuvo Staff

Hi Ola,

You're most welcome — I'm glad to hear it's working fine now! 😊

If you run into any other issues or have further questions, feel free to reach out anytime. We're always here to help.

Kind regards

Log in to reply.