Onomastic thesaurus publication error

Gerard_La Foneria

Dear all,

we have had some issues while publishing some terms from onomastic thesaurus. Here you have the message error:

Anybody knows we're is the base problem and how to fix it?

Alex

As you can see in the error the space column does not have enough «space» to store the data. This can happen when you have a large amount of data and the column definition does not allow to handle this amount of data.

You can see the definition in the ontology for the column space, the column is defined as field_text that can handle L < 2¹⁶ = (64 Kilobytes), see it full definition here, therefore, if your data is longer than 64 KB you will need to change the column to the next storage option as Medium text that can handle L < 2²⁴ = (16 Megabytes).

You can use a simple SQL command as:

ALTER TABLE `ts_onomastic`
CHANGE `space` `space` mediumtext COLLATE 'utf8mb4_unicode_ci' NULL DEFAULT ('NULL') COMMENT 'Geolocalización - hierarchy31'`;

An to avoid this kind of problems we will change the ontology definition to create the space column as Medium text. But if you have more than 16MB the error will happen again.

I hope is clear.

Best