- Issue created by @jsimonet
- Merge request !15Add hook_install to update base field definition of menu_link_content β (Open) created by jsimonet
- π¬π§United Kingdom LiamPower
Thanks jsimonet - especially for the steps to reproduce. I'll try and test this over the weekend!
- π¬π§United Kingdom LiamPower
@jsimonet what version of Drupal did you get the steps to reproduce on? Following them with a fresh install of Drupal 11 and adding both the module and the module's config file to the exported config adds the table menu_link_content__menu_item_roles
@liampower Thank you for your reply.
Iβm confused β following your feedback, I can no longer reproduce the issue, even though it was consistently occurring on four different machines and in the test environment.
Iβll take more time to try and reproduce it, and will provide a detailed procedure if the problem reoccurs.The project where the issue occurred was still in Drupal 10.4.3.
- πΊπΈUnited States fsayoub
Confirmed. I am on Drupal 10.4.6. This was during a production release. Everything tested out fine on lower environments. Once it hit production, the menu urls were receiving a WSOD.
- πΊπΈUnited States fsayoub
Tested the code in the patch and was receiving the same error.
Steps to reproduce:
- Install via composer
- Edit menu link to limit to Admin role
- Export necessary config
- Push to lower envs (where prod database gets cloned down each time a branch is pushed)
- Push to prod (where no db is updated)
- Receive same error (error from issue reshared for client privacy):
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db.menu_link_content__menu_item_roles' doesn't exist: SELECT "t".* FROM "menu_link_content__menu_item_roles" "t" WHERE ("entity_id" IN (:db_condition_placeholder_0)) AND ("deleted" = :db_condition_placeholder_1) AND ("langcode" IN (:db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4)) ORDER BY "delta" ASC; Array ( [:db_condition_placeholder_0] => 2 [:db_condition_placeholder_1] => 0 [:db_condition_placeholder_2] => fr [:db_condition_placeholder_3] => und [:db_condition_placeholder_4] => zxx ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->loadFromDedicatedTables() (line 1242 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
I was also unable to uninstall the module, to bring the site back up. A similar error comes up, regarding base table or view not found.