Answers.Body: <p>Looking at this further, it appears the issue is that my civicrm_group table does not have a title or a frontend_title.  I have title_ each of my languages and the same for frontend_title.  For example: frontend_titlle_en_US and frontend_title_es_ES</p>
  <p>Tracing it a bit past that I found that the issue did not appear to be related to the upgrade script.</p>
  <p>I did not know much about the database snapshots taken but I had a hunch it came from there.</p>
  <p>I change the &quot;CIVICRM_UPGRADE_SNAPSHOT&quot; variable to FALSE. I was able to continue the upgrade with the cv command past where it was failing before.</p>
  <p>I am going to look at this bit further and try and put in a ticket on CiviCRM GitLab.  I am guessing the issue is with Snapshots and multi-lingual tables.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-12-04T13:12:34.850Z
Answers.Text: That's strange because there is code that is supposed to skip snapshots if multilingual. What do you have in the civicrm_domain table for locales? See https://github.com/civicrm/civicrm-core/blob/b3977df112c547f4b2e446ad2db76d70171ecd75/CRM/Upgrade/Snapshot.php#L89
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-12-10T17:38:10.983Z
Answers.Text: @Demerit, sorry I did not get back to you sooner.  I have "en_USes_ESpt_PTfr_FR" in my locales field. I found this using "select locales from civicrm_domain;"
Answers.UserDisplayName: Josh
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-12-11T00:04:36.187Z
Answers.Text: Ok then it seems like it should have skipped the snapshots, because that's what it checks to see if it's multilingual. So I'm not sure why it didn't.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-12-04T06:30:36.640Z
Answers.LastActivityDate: 2023-12-04T06:30:36.640Z
Answers.UserDisplayName: Josh
Body: <p>I am trying to upgrade between CiviCRM 5.65.2 and 5.67.3. My CMS is Drupal 9.5.</p>
  <p>During the upgrade I get the following error.</p>
  <p>Upgrade DB to 5.65.alpha1: SQL (CRM_Upgrade_Incremental_php_FiveSixtyFive::runSql(5.65.alpha1))</p>
  <p>Cannot execute CREATE TABLE <code>snap_civicrm_v5_65_group</code> ROW_FORMAT=COMPRESSED AS   SELECT id, name, title, frontend_title, description, frontend_description
  FROM civicrm_group
  WHERE name IS NULL OR frontend_title IS NULL OR frontend_title = &quot;&quot; OR frontend_description IS NULL OR frontend_description = &quot;&quot;: DB Error: no such field</p>
  <p>I have checked and my DB User has &quot;GRANT ALL PRIVILEGES&quot;</p>
  <pre><code>GRANT ALL PRIVILEGES ON `civicrm_prod`.* TO 'civi_user'@'%'
  </code></pre>
  <p>I am not sure how to get more information about this error to resolve this.  Any help is greatly appreciated.</p>
  <p>Thanks!</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-12-04T06:21:17.577Z
Comments.Text: The problem is actually with the Snapshot system as part of the upgrade.  I changed
Comments.UserDisplayName: Josh
Tags: <upgrade><database>
Title: CiviCRM Upgrade Fails Between 5.65.2 and 5.67.3
ThreadText: # CiviCRM Upgrade Fails Between 5.65.2 and 5.67.3
  
  (Asked by: username_0 on 2023-12-03)
  
  I am trying to upgrade between CiviCRM 5.65.2 and 5.67.3. My CMS is Drupal 9.5.
  During the upgrade I get the following error.
  Upgrade DB to 5.65.alpha1: SQL (CRM_Upgrade_Incremental_php_FiveSixtyFive::runSql(5.65.alpha1))
  Cannot execute CREATE TABLE snap_civicrm_v5_65_group ROW_FORMAT=COMPRESSED AS   SELECT id, name, title, frontend_title, description, frontend_description
  FROM civicrm_group
  WHERE name IS NULL OR frontend_title IS NULL OR frontend_title = "" OR frontend_description IS NULL OR frontend_description = "": DB Error: no such field
  I have checked and my DB User has "GRANT ALL PRIVILEGES"
  GRANT ALL PRIVILEGES ON `civicrm_prod`.* TO 'civi_user'@'%'
  
  I am not sure how to get more information about this error to resolve this.  Any help is greatly appreciated.
  Thanks!
  
  **Tags:** upgrade, database
  
  > **Comments:**
  > **username_0**: The problem is actually with the Snapshot system as part of the upgrade.  I changed  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2023-12-04. Score: 0
  
  Looking at this further, it appears the issue is that my civicrm\_group table does not have a title or a frontend\_title. I have title\_ each of my languages and the same for frontend\_title. For example: frontend\_titlle\_en\_US and frontend\_title\_es\_ES
  
  Tracing it a bit past that I found that the issue did not appear to be related to the upgrade script.
  
  I did not know much about the database snapshots taken but I had a hunch it came from there.
  
  I change the "CIVICRM\_UPGRADE\_SNAPSHOT" variable to FALSE. I was able to continue the upgrade with the cv command past where it was failing before.
  
  I am going to look at this bit further and try and put in a ticket on CiviCRM GitLab. I am guessing the issue is with Snapshots and multi-lingual tables.
  
  > **Comments:**
  > **username_1**: That's strange because there is code that is supposed to skip snapshots if multilingual. What do you have in the civicrm_domain table for locales? See https://github.com/civicrm/civicrm-core/blob/b3977df112c547f4b2e446ad2db76d70171ecd75/CRM/Upgrade/Snapshot.php#L89  
  > **username_0**: @username_1, sorry I did not get back to you sooner.  I have "en_USes_ESpt_PTfr_FR" in my locales field. I found this using "select locales from civicrm_domain;"  
  > **username_1**: Ok then it seems like it should have skipped the snapshots, because that's what it checks to see if it's multilingual. So I'm not sure why it didn't.  
  
  ---
  
  