search

zengenuity / civicrm_groupprice

CiviCRM extension that allows you to limit the display of individual prices in price sets to specific groups. This can be used to implement members-only pricing for events, as well as other use cases.
Other
3 stars 9 forks source link

Problem with i18n #2

Closed samuelsov closed 6 years ago

samuelsov commented 8 years ago

Queries using CRM_Core_DAO::executeQuery are not working with a multilingual installation because of a limitation in CiviCRM Core. The name of the table is replaced by the equivalent language specific table in the query. The problem is that "civicrm_groupprice" contains "civicrm_group" which is another valid civicrm table.

For example the query "SELECT * FROM civicrm_groupprice" will be replaced by "SELECT * FROM civicrm_group_fr_CAprice".

One way to fix this is to change the name of the table to something more unique. Otherwise we have to change CiviCRM Core to fix this.

samuelsov commented 6 years ago

It has been fixed in core - see https://issues.civicrm.org/jira/browse/CRM-19093