[5.x]: Internal server error - shortcodesToEmoji

[samdi]

[5.x]: Internal server error - shortcodesToEmoji

[i-just]

Hi, thanks for reaching out! Could you please post the full stack trace for this error?

[samdi]

In admin page, I access a structure entry with this error: https://cldup.com/n20M4rtNN9.png
View the entry with this error: https://cldup.com/7gO0jMSBU7.png

[i-just]

Thanks! I can’t seem to replicate this issue. Any chance you could send your composer.json, composer.lock and database export to [email protected] and point out the entry that is giving you this error?

[samdi]

Thanks for your info. I think if there is something wrong due to the changing the field type (table to plain text). The entry is saved the table data of the previous field type while the field type is plain text. In database table element_sites > content of all entries, the data of table field is still existing, for example.

{"col1":"Original title","col2":"Abc title"},{"col1":"Alternative title","col2":"XYZ title"}

Anyway, I deleted those entries. Do you think if the issue is due to changing the type of field and the old data exists in the element_sites > content?

[i-just]

Thanks for providing more info!

due to the changing the field type (table to plain text)

With that missing piece of information, I can replicate it straight away.

When you change the type of the field, Craft doesn’t alter your data in the database. In Craft 4, changing a Field Type could lead to a database column that stored this data to be altered, therefore leading to data loss. In Craft 5, content is stored in a json column, but data incompatibility can still occur. There’s a warning under the Field Type dropdown about potential data loss and the types that should be safe to switch to don’t have the warning icon next to them.

You can still change the Field Type to one with a warning, but issues like this can occur. You can use the resave command to fix this. You can use it to clear out the field value or change it to something else. For example, php craft resave/entries --section blog --type article --set table --to "=" --if-empty 0 will clear out the value of a field with a handle table for a section blog and entry type article.

I hope this helps!
I will close this now, but feel free to reach out if you run into any more problems.