Extensions require database update, Not able to use Mailing,

Question

I'm on the latest versions of Drupal (9.4.8) and CiviCRM (5.55.1) and I'm using Composer to install/update.

Although consulting data from CiviCRM is working fine, I do have a couple of issues:

• extensions require database update
• not able to use Mailings (traditional nor Mosaico)
• displaying status (civicrm/a#/status)
• event registration

They all result in 'unexpected error, try again later' (in Dutch)

I enabled debugging and get this:

Message DB Error: no such field Mode 16 UserInfo UPDATE civicrm_queue SET status = NULL WHERE name = 'ext-upgrade' [nativecode=1054 ** Unknown column 'status' in 'field list'] DebugInfo UPDATE civicrm_queue SET status = NULL WHERE name = 'ext-upgrade' [nativecode=1054 ** Unknown column 'status' in 'field list'] PEAR_Exception: DB Error: no such field in /data/sites/web/instituutvlaamsevolkskunstbe/cms-install/4466-instituut-voor-vlaamse-volkskunst/production/vendor/pear/pear-core-minimal/src/PEAR.php on line 944

• DB_Error: DB Error: no such field in unknown on line unknown

I have been looking for ConfigAndLogs, but I cannot find it in the location where it should be.

Any help would be greatly appreciated. Let me know what information is needed (and where to find it) to get this diagnosed and solved.

Thanks, Stefaan

Answer 1

Can you run CiviCRM upgrade to check if there are any updates required? You can do

cv upgrade:db

or 

drush civicrm-upgrade-db

or 

from UI  http://example.org/civicrm/upgrade?reset=1

If there isn't any updates needed probably running below mysql queries may help

ALTER TABLE civicrm_queue
 ADD COLUMN `status` varchar(16) NULL DEFAULT 'active' COMMENT 'Execution status',
 ADD COLUMN `error` varchar(16) NULL COMMENT 'Fallback behavior for unhandled errors',
 ADD COLUMN `is_template` tinyint NOT NULL DEFAULT 0 COMMENT 'Is this a template configuration (for use by other/future queues)?';