Error message when trying to publish an exhibition (data too long)

Gerard_La Foneria

Dear all,
We are trying to publish part of an exhibition, but when we attempt to do so, the following error message appears:

We understand that the issue may be related to “data too long for column indexations_related.” We have reviewed the titles of the related interviews, and in some cases, they were probably too long. We have now limited them to a maximum of 64 characters, including spaces.
Could the problem be related to the length of the titles? Do we need to further reduce them to a specific maximum number of characters?
Best,

Alex

Gerard_La Foneria Could the problem be related to the length of the titles?

No, the issue lies with the column indexation_related, which necessitates storing all indexation and related data, in other words all connections from the indexation fields.

This column is defined in diffusion ontology as field_text

Therefore, this column can accommodate 65.536 characters. However, if the public data exceeds this limit, the error appears. (i.e. when the public section contains numerous indexations).

Gerard_La Foneria Do we need to further reduce them to a specific maximum number of characters?

No, you need to modify the diffusion definition within the ontology for this node to alter the data type that this column can accommodate in MySQL or MariaDB from field_text to field_mediumtext. You can see the text sizes here

And change the current column in MySQL or MariaDB:

ALTER TABLE `ts_mujer_y_memoria`
CHANGE `indexations_related` `indexations_related` mediumtext;

With this change the column can handle: 16.777.216 characters and the error disappears.

Best

Gerard_La Foneria

Fantastic, it’s now possible to publish with the changes applied. Thank you!