1

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.

  • You sure you mean 4.7.12 rather than the latest release which is 4.7.21 – petednz - fuzion Jul 11 '17 at 3:11
  • Yes, since updates were not done regularly, I was trying to make it from 4.7.10 to 4.7.21. – Djordje Marjanovic Jul 11 '17 at 9:18
1

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.';

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.