SQL-Exception during entup

Created on 9 January 2024, 12 months ago

Problem/Motivation

SQL-Errors (In SqlContentEntityStorage.php line 1605):

 Exception thrown while performing a schema update. SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'link_override__uri' doesn't exist in table: ALTER TABLE "menu_link_content_field_rev  
  ision" ADD INDEX "menu_link_content_field__link_override__uri" ("link_override__uri" (30)); Array                                                                                                            
  (                                                                                                                                                                                                            
  )    

Also (In ExceptionHandler.php line 52)

SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'link_override__uri' doesn't exist in table: ALTER TABLE "menu_link_content_field_revision" ADD INDEX "menu_link_content_field__link_ove  
  rride__uri" ("link_override__uri" (30)); Array                                                                                                                                                               
  (                                                                                                                                                                                                            
  )

And (In StatementWrapperIterator.php line 111):

SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'link_override__uri' doesn't exist in table

Steps to reproduce

Updated from Drupal 9 to Drupal 10
On the status page I got the warnings to update entity type.
So I installed and update entities:

composer require 'drupal/devel_entity_updates:^4.1';
drush en devel_entity_updates -y
drush entup -y

Proposed resolution

Stop running and fallback if error. Or give feedback, that tables are not ready from an affected module.

Maybe the error is caused by another module, like translatable_menu_link_uri ( https://www.drupal.org/project/translatable_menu_link_uri/issues/3259442 🐛 Notice: Undefined index: link_override__title in Drupal\Core\Entity\Sql\SqlContentEntityStorage->loadFromSharedTables Fixed ).

🐛 Bug report
Status

Closed: works as designed

Version

4.1

Component

Base system

Created by

🇩🇪Germany thomaswalther Rhein-Main Area

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024