Problem/Motivation
Testing upgrade from wxt 4.3.0 to 4.3.4
noticed several important modules vanished. Required those
Step 1)
composer up drupalwxt/wxt drupal/core symfony/css-selector drupal/swiftmailer tijsverkoyen/css-to-inline-styles symfony/deprecation-contracts -W
Step 2)
Noticed several modules missing, first error was crashing on moderation_dashboard missing.
Step 3) restore missing modules
composer.phar require drupal/moderation_dashboard drupal/panelizer drupal/panels_ipe drupal/moderation_sidebar drupal/lightning_scheduler drupal/lightning_media
Step 4) crashes again
The website encountered an unexpected error. Please try again later.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "block_content__scheduled_transition_date" does not exist LINE 3: "block_content__scheduled_transition_date" "t" ^: SELECT "t".* FROM "block_content__scheduled_transition_date" "t" WHERE ("entity_id" IN (:db_condition_placeholder_0, :db_condition_placeholder_1,
....
....
[:db_condition_placeholder_17] => zxx ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->loadFromDedicatedTables() (line 1230 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
also experienced a password_policy error
> [error] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "t1"
> LINE 1: DELETE t1 FROM "password_policy_history" t1 INNER JOIN "pass...
> ^: DELETE t1 FROM "password_policy_history" t1 INNER JOIN "password_policy_history" t2 WHERE t1.id < t2.id AND t1.pass_hash = t2.pass_hash AND t1.timestamp = t2.timestamp; Array
> (
> )
🐛
[ansi-sql compliant updates] - postgresql/mssql/mysql/sqlite password_policy_update_8304
Needs review
Steps to reproduce
Not sure, it's occuring on a 4.3.0 to 4.3.4 upgrade.
Proposed resolution
Apply this patch PRIOR to upgrading:
https://www.drupal.org/files/issues/2022-10-03/wxt-allow_password_policy... →
uninstall both lightning_scheduler AND password_policy (patch allows this)
export updated configuration
then composer upgrade -W and upgrade
optionally install password_policy module and remove patch afterwards at some point.
Remaining tasks
TBD
User interface changes
TBD
API changes
TBD
Data model changes
TBD