Database update from 5.47.2 to 5.47.3 fails with a non en_US database.
Overview
The update from 5.47.2 to 5.47.3 fails in a non-US environment with
Type | DB_Error |
---|---|
Code | -1 |
Message | DB Error: unknown error |
Mode | 16 |
UserInfo | ALTER TABLE civicrm_event_en_GB CHANGE COLUMN event_tz event_tz_bak text NULL DEFAULT NULL COMMENT 'For troubleshooting upgrades post 5.47. Can drop this column if no issues.' [nativecode=1347 ** 'civicrm_test.civicrm_event_en_gb' is not BASE TABLE] |
DebugInfo | ALTER TABLE civicrm_event_en_GB CHANGE COLUMN event_tz event_tz_bak text NULL DEFAULT NULL COMMENT 'For troubleshooting upgrades post 5.47. Can drop this column if no issues.' [nativecode=1347 ** 'civicrm_test.civicrm_event_en_gb' is not BASE TABLE] |
Reproduction steps
- Use Composer to install the code.
- Run the database update. Current behaviour
| Type | DB_Error |
|-----------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Code | -1 |
| Message | DB Error: unknown error |
| Mode | 16 |
| UserInfo | ALTER TABLE civicrm_event_en_GB CHANGE COLUMN event_tz event_tz_bak text NULL DEFAULT NULL COMMENT 'For troubleshooting upgrades post 5.47. Can drop this column if no issues.' [nativecode=1347 ** 'civicrm_test.civicrm_event_en_gb' is not BASE TABLE] |
| DebugInfo | ALTER TABLE civicrm_event_en_GB CHANGE COLUMN event_tz event_tz_bak text NULL DEFAULT NULL COMMENT 'For troubleshooting upgrades post 5.47. Can drop this column if no issues.' [nativecode=1347 ** 'civicrm_test.civicrm_event_en_gb' is not BASE TABLE] |
Expected behaviour
Database update should run to completion.
Environment information
- Browser: Edge but irrelevant.
- CiviCRM: 5.47.2/5.47.3
- PHP: 7.4_ but probably irrelevant.
- CMS: Drupal 9.3.9/... but probably irrelvant
- Database: MySQL 8.0.28 but may not be relevant.
- Web Server: IIS 10 but probably irrelevant.
Comments
I had unzipped the localisation files to \vendor\civicrm\civicrm-core before running the update script. I suspect a vanilla en_US installation won't show the issue.