CiviCRM Community Forums (archive)

We are using a multi-language installation with
English, French, Italian, Russian, Spanish all active is a simple installation of CiviCRM. The system is set up of an international event. Only one event exists in this database with about 10 custom data fields for event questions with tick box or selectable answers.
After upgrading to 3.3.6 we have found that when contact records are created or edited (with the language set as English) then the title in the display name is changed to the Russian value i.e. Miss becomes Госпожица.
We have created a list of titles and included all the translations for each language. Russian is the 4th language in the list when adding the different language values.
Looking at the contact table in the database I see that the display_name_##_## displays the title in Russian. The ##_## reflect that this error affects all the country code tables not just the en_GB column.

Any ideas?


This error has resulted in the need to update the database table values themselves but would like to make sure the code is corrected before we execute this update on the display name in the contact table

So the reason it is getting set as russian is that Russian is the last language in the 'multilingual trigger magic loop', presumably because russian is the last language alphabetically.

We looked at the civicrm_contact_before_update triggers.  They are pasted here: http://paste2.org/p/1351506

On line 495 ( I broke each line on a ; ) it correctly finds and sets the gb prefix.

IF NEW.prefix_id IS NOT NULL THEN
SELECT v.label_en_GB INTO @prefix
FROM civicrm_option_value v JOIN civicrm_option_group g ON (v.option_group_id = g.id)
WHERE g.name = 'individual_prefix' AND v.value = NEW.prefix_id;
Presumably display_name_en_GB should then be set, but instead, it cycles through all the other languages, ending with ru_RU.

Then, starting at line 555, it cycles through languages again and sets display names based on the last value of @prefix, which in this case uses the Russian prefix for all contacts.