Details
-
Type:
Bug
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 4.7.29
-
Fix Version/s: None
-
Component/s: Core CiviCRM
-
Labels:None
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Needs Funding
-
Verified?:No
Description
We run single-language (en_GB) CiviCRM under Joomla. After updates we have noticed that we get 'no such field' errors. They appear to be caused by certain fields not being created in views. Here is an example:
civicrm_price_field_value contains fields help_pre_en_GB and help_post_en_GB.
The view civicrm_price_field_value_en_gb when created by the update process is missing:
`civicrm_price_field_value`.`help_pre_en_GB` AS `help_pre`,
`civicrm_price_field_value`.`help_post_en_GB` AS `help_post`
and they have to be inserted manually using PHPMySQL. I'm not familiar enough with the upgrade process to know how to resolve this.
This is similar to: CRM-20548 and may be an example of a more generic issue.