Answers.Body: <p>Can you run CiviCRM upgrade to check if there are any updates required? You can do</p>
  <pre><code>cv upgrade:db
  
  or 
  
  drush civicrm-upgrade-db
  
  or 
  
  from UI  http://example.org/civicrm/upgrade?reset=1
  </code></pre>
  <p>If there isn't any updates needed probably running below mysql queries may help</p>
  <pre><code>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)?';
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-18T16:02:45.747Z
Answers.Text: Hello Pradeep, 
  Really strange: I had updates from 5.41.2 pending. Somehow these were not taken into account when running upgrade after new version installation ... I'm still not out of the woods though: civicrm/a#/status is still not opening properly (unexpected error) and although installed (   "civicrm/cv": "^0.3.30", ) i cannot run cv from SSH. Neither can I run the drush civicrm-upgrade-db command :(
Answers.UserDisplayName: Stefaan H
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-21T11:23:01.237Z
Answers.Text: what issues are you facing? Can you run the upgrade from UI?
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-23T20:34:56.293Z
Answers.Text: The upgrade is now completed, but I cannot access pages like the 'status' page and 'create new mailing'
Answers.UserDisplayName: Stefaan H
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-24T11:33:27.003Z
Answers.Text: there must be JS error, can you check browser console?
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-05T19:46:24.723Z
Answers.Text: When checking the browser console (F12) I get this on the home page
  
  js_U-fU1jg4A2k571eM0YNR6K4qEt9th39RHGxYMQcur1o.js:3265 
          
         Uncaught Error: Quick Edit could not associate the rendered entity field markup (with [data-quickedit-field-id="media/3/field_media_video_file/nl/default"]) with the corresponding rendered entity markup:
  
  not OK maybe, but this doesn't seem to be the error  that is causing the trouble
Answers.UserDisplayName: Stefaan H
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-02-18T17:20:48.473Z
Answers.Text: Any idea how to resolve JS errors ?
Answers.UserDisplayName: Stefaan H
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-14T12:31:53.560Z
Answers.LastActivityDate: 2022-11-14T12:31:53.560Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I'm on the latest versions of Drupal (9.4.8) and CiviCRM (5.55.1) and I'm using Composer to install/update.</p>
  <p>Although consulting data from CiviCRM is working fine, I do have a couple of issues:</p>
  <ul>
  <li>extensions require database update</li>
  <li>not able to use Mailings (traditional nor Mosaico)</li>
  <li>displaying status (civicrm/a#/status)</li>
  <li>event registration</li>
  </ul>
  <p>They all result in 'unexpected error, try again later' (in Dutch)</p>
  <p>I enabled debugging and get this:</p>
  <p>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</p>
  <ul>
  <li>DB_Error: DB Error: no such field in unknown on line unknown</li>
  </ul>
  <p>I have been looking for ConfigAndLogs, but I cannot find it in the location where it should be.</p>
  <p>Any help would be greatly appreciated. Let me know what information is needed (and where to find it) to get this diagnosed and solved.</p>
  <p>Thanks,
  Stefaan</p>
  
Tags: <drupal><extension><database>
Title: Extensions require database update, Not able to use Mailing,
ThreadText: # Extensions require database update, Not able to use Mailing,
  
  (Asked by: username_0 on 2022-11-14)
  
  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,
  username_0
  
  **Tags:** drupal, extension, database
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-11-14. Score: 2
  
  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)?';
  
  ```
  
  > **Comments:**
  > **username_0**: Hello username_1,  Really strange: I had updates from 5.41.2 pending. Somehow these were not taken into account when running upgrade after new version installation ... I'm still not out of the woods though: civicrm/a#/status is still not opening properly (unexpected error) and although installed (   "civicrm/cv": "^0.3.30", ) i cannot run cv from SSH. Neither can I run the drush civicrm-upgrade-db command :(  
  > **username_1**: what issues are you facing? Can you run the upgrade from UI?  
  > **username_0**: The upgrade is now completed, but I cannot access pages like the 'status' page and 'create new mailing'  
  > **username_1**: there must be JS error, can you check browser console?  
  > **username_0**: When checking the browser console (F12) I get this on the home page  js_U-fU1jg4A2k571eM0YNR6K4qEt9th39RHGxYMQcur1o.js:3265                  Uncaught Error: Quick Edit could not associate the rendered entity field markup (with [data-quickedit-field-id="media/3/field_media_video_file/nl/default"]) with the corresponding rendered entity markup:  not OK maybe, but this doesn't seem to be the error  that is causing the trouble  
  > **username_0**: Any idea how to resolve JS errors ?  
  
  ---
  
  