I have the same problem but with the groups_field_data table:
Hello,
When I was migrating my system from Debian 9 to Debian 10 (also PHP7.0 to PHP7.3) I get a database problem :
----------------------------------------------------------------------------------------------------------------------------------------------------------
[php7:notice] [pid 1371] [client 192.168.2.4:39046] Uncaught PHP Exception Drupal\\Core\\Entity\\EntityStorageException: "SQLSTATE[HY000]: General error: 1364 Field 'revision_id' doesn't have a default value: INSERT INTO {menu_link_content_data} (id, bundle, langcode, title, description, menu_name, link__uri, link__title, link__options, external, rediscover, weight, expanded, enabled, parent, changed, default_langcode) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16); Array\n(\n [:db_insert_placeholder_0] => 678\n [:db_insert_placeholder_1] => menu_link_content\n [:db_insert_placeholder_2] => fr\n [:db_insert_placeholder_3] => Disponibilit\xc3\xa9\n [:db_insert_placeholder_4] => disponibilite, dba, oracle, ingres, mysql,etudes, audit, base de donnees, base de donn\xc3\xa9e\n [:db_insert_placeholder_5] => main\n [:db_insert_placeholder_6] => entity:node/16\n [:db_insert_placeholder_7] => \n [:db_insert_placeholder_8] => a:1:{s:10:"attributes";a:1:{s:5:"title";s:89:"disponibilite, dba, oracle, ingres, mysql,etudes, audit, base de donnees, base de donn\xc3\xa9e";}}\n [:db_insert_placeholder_9] => 0\n [:db_insert_placeholder_10] => 0\n [:db_insert_placeholder_11] => 18\n [:db_insert_placeholder_12] => 0\n [:db_insert_placeholder_13] => 1\n [:db_insert_placeholder_14] => \n [:db_insert_placeholder_15] => 1507895633\n [:db_insert_placeholder_16] => 1\n)\n" at /var/www/consult/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php line 847, referer: http://consult2.jpp.fr:81/node/16/edit
------------------------------------------------------------------------------------------------------------------------------------------------------------------
I look table definition and the "revision_field" from "menu_link_content" does not have a default value :
revision_id : `revision_id` int(10) unsigned DEFAULT NULL,
After correcting the field :
alter table menu_link_content modify revision_id int(10) unsigned default 0;
I get another error (same error for table menu_link_content_data and corrected by :
alter table menu_link_content_data modify revision_id int(10) unsigned default 0;
All went OK ant the installation works well.
Regards
JP P
Fixed
8.8 ⚰️
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
I have the same problem but with the groups_field_data table: