Upgrading to CiviCRM 5.43.1 fails
Overview
Please describe your problem or bug in detail.
If you have already posted on https://civicrm.stackexchange.com or https://chat.civicrm.org, please include the link to that conversation.
Reproduction steps
- Update the code
- Run the update.
- Get 'unknown column' error.
- Recover database backup and add the missing columns manually.
- Rerun the backup.
- Get the invalid use of NULL error.
Current behaviour
What happens currently. Please provide error messages, screenshots or gifs (LICEcap, SilentCast) where appropriate.
Expected behaviour
The update should run.
Environment information
- Browser: Edge but probably no relevant
- CiviCRM: 5.41.2/5.43.1
- PHP: 7.4.25_ but probably not relevant
- CMS: Drupal 9.2.8 but probably not relevant
- Database: MySQL 8.0.27
- Web Server: IIS but probably not relevant.
Comments
Anything else you would like the reviewer to note. Removing the NOT from the query in \vendor/civicrm/civicrm-core/CRM\Upgrade/Incremental/php/FiveFortyThree.php line 205 cures the latter error.