- Issue created by @mee_sha
- 🇩🇪Germany jox
I ran into this as well.
What's happening is that
field_time_value
in the database (MySQL/MariaDB in my case) changed from typeVARCHAR(8)
toTIME
.What worked for me was:
- Dump (backup) the affected tables.
- Truncate (empty) those tables.
- Update the entity definitions.
- Restore the tables.
Restoring the
VARCHAR
values into theTIME
field worked without any issues.For example:
$ composer require drupal/devel_entity_updates $ drush en devel_entity_updates $ mysqldump --no-create-info MY_DATABASE node__field_time node_revision__field_time >time_field_table_data.sql $ echo "TRUNCATE TABLE node__field_time; TRUNCATE TABLE node_revision__field_time;" | mysql MY_DATABASE $ drush entup $ mysql MY_DATABASE < backup/time_field_table_data.sql