Upgrading to 5.51 RC fails through the web interface, but works with `cv` and `drush`.
Overview
I commented on this issue in the Town Square: https://chat.civicrm.org/civicrm/pl/kpcoyh7hx3nzunx34ejbe8h8aw
Running the database upgrade to 5.51 RC by visiting /civicrm/upgrade?reset=1
fails with this message:
"DB Error: no such field"
UPDATE civicrm_queue SET status = NULL WHERE name = 'CRM_Upgrade' [nativecode=1054 ** Unknown column 'status' in 'field list'
Running the same upgrade with cv
or drush
works.
Reproduction steps
- Install an older version of Civi (e.g. 5.49.5) on Drupal 7.88
- Replace the Civi module with 5.51 RC (civicrm-RC-drupal.tar.gz ( 5.51.beta1-202206120040 ))
- Visit /civicrm/upgrade?reset=1 in the web interface, and run the upgrade
- Observe that it crashes with "DB Error: no such field"
- Try again, to confirm that it consistently fails in the web interface
- Run the upgrade with
cv upgrade:db
or drush, and observe that it works
Current behaviour
After the failure in the web interface, the Drupal log of our production clone contained a message with this string:
UPDATE civicrm_queue SET status = NULL WHERE name = 'CRM_Upgrade' [nativecode=1054 ** Unknown column 'status' in 'field list'
I didn't find any upgrade messages in the Drupal log of the clean install, I'm not sure why.
Expected behaviour
The web interface upgrade normally works the same as the command line process.
Environment information
- Browser: Firefox 91.9.1esr (64-bit)
- CiviCRM: from 5.49.5 to 5.51.beta1 (5.51.beta1-202206120040)
-
PHP: 7.3.33-1+0
20211119.91+debian101.gbp618351 - CMS: Drupal 7.88
- Database: mariadb Ver 15.1 Distrib 10.3.34-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
- Web Server: apache2 2.4.38-3+deb10u7