SQL-error Identifier Name is Too Long - Question | JoomShaper
🎃 Halloween Sale is Live! Get 35% OFF on all plans. Sale ends soon! Get Offer

SQL-error Identifier Name is Too Long

O

Ola

SP Page Builder 4 months 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

0
3 Answers
Atick Eashrak Shuvo
Atick Eashrak Shuvo
Accepted Answer
Support Agent 4 months ago #194752

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

0
O
Ola
Accepted Answer
4 months ago #194898

Thanks! :-)

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

0
Atick Eashrak Shuvo
Atick Eashrak Shuvo
Accepted Answer
Support Agent 4 months ago #194961

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

0