This is likely an error that has come about as part of an upgrade. We went from CiviCRM 5.31 to 5.44 about a month ago and everything appeared to go well with the incremental database updates, etc.
However, when merging contacts in Civi, we now get a traceback with the following error:
[nativecode=1146 ** Table 'fthdc_civi.civicrm_translation' doesn't exist]
I won't paste the whole trace, but the start of the SQL query is:
(SELECT 'civicrm_translation' as civicrm_table, 'entity_id' as field_name FROM civicrm_translation WHERE entity_table = 'civicrm_contact' LIMIT 1) UNION (SELECT ...
Checking the database, it's true that the civicrm_translation table doesn't appear to exist.
Questions are:
- When did the civicrm_translation table appear in Civi?
- Is this something that should have been created in the upgrade process?
- Is there anything that I can do to create this table and the necessary data in order to make merging contacts start working again?
Also, is this a bug that needs reporting?
Thanks in anticipation.