Mismatched entity and/or field definitions

DESCRIBE `bookable_calendar_opening__date`; +------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+-------+ | bundle | varchar(128) | NO | MUL | | | | deleted | tinyint(4) | NO | PRI | 0 | | | entity_id | int(10) unsigned | NO | PRI | NULL | | | revision_id | int(10) unsigned | NO | MUL | NULL | | | langcode | varchar(32) | NO | PRI | | | | delta | int(10) unsigned | NO | PRI | NULL | | | date_value | bigint(20) | YES | MUL | NULL | | | date_end_value | bigint(20) | YES | MUL | NULL | | | date_duration | int(11) | YES | | NULL | | | date_rrule | int(11) | YES | MUL | NULL | | | date_rrule_index | int(11) | YES | MUL | NULL | | | date_timezone | varchar(32) | YES | | NULL | | +------------------+------------------+------+-----+---------+-------+ 12 rows in set (0,001 sec)

Comments & Activities

Issue created by @ggamba

Comment about 2 months ago →

🇸🇪Sweden Alsén

Hi, after deleting all instances in database and running the following in a hook_update():

$manager = \Drupal::entityDefinitionUpdateManager();
$field = $manager->getFieldStorageDefinition('date', 'bookable_calendar_opening')
$manager->updateFieldStorageDefinition($field);

The table looks like this:

DESCRIBE `bookable_calendar_opening__date`; 
+------------------+------------------+------+-----+---------+-------+
| Field            | Type             | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+-------+
| bundle           | varchar(128)     | NO   | MUL |         |       |
| deleted          | tinyint(4)       | NO   | PRI | 0       |       |
| entity_id        | int(10) unsigned | NO   | PRI | NULL    |       |
| revision_id      | int(10) unsigned | NO   | MUL | NULL    |       |
| langcode         | varchar(32)      | NO   | PRI |         |       |
| delta            | int(10) unsigned | NO   | PRI | NULL    |       |
| date_value       | int(11)          | NO   | MUL | NULL    |       |
| date_end_value   | int(11)          | NO   | MUL | NULL    |       |
| date_duration    | mediumint(9)     | YES  |     | NULL    |       |
| date_rrule       | int(11)          | YES  | MUL | NULL    |       |
| date_rrule_index | int(11)          | YES  | MUL | NULL    |       |
| date_timezone    | varchar(32)      | YES  |     | NULL    |       |
+------------------+------------------+------+-----+---------+-------+
12 rows in set (0.021 sec)

Comment 5 days ago →
🇮🇹Italy ggamba Milano
Thank you Thomas!

date* fields have definitely a different setup. I have in the meantime moved the site on a new installation, so the problem went away for me, but thanks anyway!