Database Update Errors After Update to Drupal 10

This issue was resolved with a custom install hook.

Automatically closed - issue fixed for 2 weeks with no activity.

@bigmoves - I am also facing the same issue after upgrade to D10. Could you please explain what custom install hooks you have used for fixing this?

I don't know what bigmoves used, but we used this (hacky) update function:

/**
 * Fix up menu_link_content_field_revision tables.
 */
function project_update_9001() {
  $db = \Drupal::database();
  try {
    $db->query("ALTER TABLE menu_link_content_field_revision ADD `link_override__uri` varchar(2048) DEFAULT NULL COMMENT 'The URI of the link.';");
    $db->query("ALTER TABLE menu_link_content_field_revision ADD `link_override__title` varchar(255) DEFAULT NULL COMMENT 'The link text.';");
    $db->query("ALTER TABLE menu_link_content_field_revision ADD `link_override__options` longblob DEFAULT NULL COMMENT 'Serialized array of options for the link.';");
  } catch (\Exception $e) {}
}

Don't use custom code, use patch from 🐛 Notice: Undefined index: link_override__title in Drupal\Core\Entity\Sql\SqlContentEntityStorage->loadFromSharedTables Fixed