Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Index name too large in table 'bitbag_sylius_cms_plugin_frequently_asked_question_translation' #105

Closed
h3llr4iser opened this issue Nov 24, 2017 · 1 comment

Comments

@h3llr4iser
Copy link
Contributor

I have a problem doing a migration:

[Doctrine\DBAL\Exception\DriverException]
An exception occurred while executing 'CREATE TABLE bitbag_sylius_cms_plugi
n_frequently_asked_question_translation (id INT AUTO_INCREMENT NOT NULL, tr
anslatable_id INT NOT NULL, question VARCHAR(1500) NOT NULL, answer LONGTEX
T NOT NULL, locale VARCHAR(255) NOT NULL, INDEX IDX_1F3306412C2AC5D3 (trans
latable_id), UNIQUE INDEX bitbag_sylius_cms_plugin_frequently_asked_questio
n_translation_uniq_trans (translatable_id, locale), PRIMARY KEY(id)) DEFAUL
T CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':

SQLSTATE[42000]: Syntax error or access violation: 1059 Le nom de l'identif
icateur 'bitbag_sylius_cms_plugin_frequently_asked_question_translation_uni
q_trans' est trop long

@bitbager
Copy link
Member

CC @shinoks,

Thanks! We tested it only on SQLite, so didn't notice it could be too long for MySQL.

#106 PR should fix it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants