Search code examples
sulu

Sulu update 1.6 > 2.0 - we_analytics

We're currently upgrading sulu 1.6. to 2.0 - while following the guide I noticed, that we_analytics.title stays on varchar(255), while all other varchar fields are converted to varchar(191)

ALTER TABLE we_analytics CHANGE webspace_key webspace_key VARCHAR(191) NOT NULL;
-- this one is missing?: ALTER TABLE we_analytics CHANGE title title VARCHAR(191) NOT NULL;
ALTER TABLE we_analytics CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Is this an error of the docs or correct like this?

Solution

  • This is not an error in the upgrade guide, if at all the problem is within the ORM configuration itself.

    However, this does not matter too much here anyway, because the 191 character limit only applies on index fields in MySQL, so this continues to work. We will only run into troubles when we decide to put an index on that field.