Answers.Body: <p>The solution is to manually create <code>data_type</code> field in <code>log_civicrm_option_group</code> table.</p>
  
  <pre><code>ALTER TABLE `log_civicrm_option_group` ADD `data_type` VARCHAR(128) 
  CHARACTER SET utf8 COLLATE utf8_unicode_ci 
  NULL DEFAULT NULL 
  COMMENT 'Data Type of Option Group.';
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-10T14:01:02.647Z
Answers.LastActivityDate: 2017-07-10T17:06:39.160Z
Answers.LastEditDate: 2017-07-10T17:06:39.160Z
Answers.UserDisplayName: Djordje Marjanovic
Body: <p>Trying to upgrade from 4.7.11 to 4.7.12 but failed.</p>
  
  <p>Here is debug info:</p>
  
  <pre><code>[Error: Add Data Type column to civicrm_option_group]
  Error Field Error Value
  Type    DB_Error
  Code    -19
  Message DB Error: no such field
  Mode    16
  
  UserInfo:
      UPDATE `civicrm_option_group_en_US` SET `data_type` = 'Integer' WHERE name IN ('activity_type', 'gender', 'payment_instrument', 'participant_role', 'event_type') [nativecode=1054 ** Unknown column 'data_type' in 'field list']
  
  DebugInfo
      UPDATE `civicrm_option_group_en_US` SET `data_type` = 'Integer' WHERE name IN ('activity_type', 'gender', 'payment_instrument', 'participant_role', 'event_type') [nativecode=1054 ** Unknown column 'data_type' in 'field list']
  </code></pre>
  
  <p>However, field <code>data_type</code> DOES exist.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-11T03:11:17.707Z
Comments.Text: You sure you mean 4.7.12 rather than the latest release which is 4.7.21
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-11T09:18:01.033Z
Comments.Text: Yes, since updates were not done regularly, I was trying to make it from 4.7.10 to 4.7.21.
Comments.UserDisplayName: Djordje Marjanovic
Tags: <drupal><upgrade>
Title: Upgrade to Drupal 4.7.12 failed (while upgrading from 4.7.11 to 4.7.21)
ThreadText: # Upgrade to Drupal 4.7.12 failed (while upgrading from 4.7.11 to 4.7.21)
  
  (Asked by: username_0 on 2017-07-10)
  
  Trying to upgrade from 4.7.11 to 4.7.12 but failed.
  Here is debug info:
  [Error: Add Data Type column to civicrm_option_group]
  Error Field Error Value
  Type    DB_Error
  Code    -19
  Message DB Error: no such field
  Mode    16
  
  UserInfo:
      UPDATE `civicrm_option_group_en_US` SET `data_type` = 'Integer' WHERE name IN ('activity_type', 'gender', 'payment_instrument', 'participant_role', 'event_type') [nativecode=1054 ** Unknown column 'data_type' in 'field list']
  
  DebugInfo
      UPDATE `civicrm_option_group_en_US` SET `data_type` = 'Integer' WHERE name IN ('activity_type', 'gender', 'payment_instrument', 'participant_role', 'event_type') [nativecode=1054 ** Unknown column 'data_type' in 'field list']
  
  However, field data_type DOES exist.
  
  **Tags:** drupal, upgrade
  
  > **Comments:**
  > **username_1**: You sure you mean 4.7.12 rather than the latest release which is 4.7.21  
  > **username_0**: Yes, since updates were not done regularly, I was trying to make it from 4.7.10 to 4.7.21.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2017-07-10. Score: 1 | Accepted answer
  
  The solution is to manually create data_type field in log_civicrm_option_group table.
  ALTER TABLE `log_civicrm_option_group` ADD `data_type` VARCHAR(128) 
  CHARACTER SET utf8 COLLATE utf8_unicode_ci 
  NULL DEFAULT NULL 
  COMMENT 'Data Type of Option Group.';
  
  
  ---
  
  