Index: branches/5.2.x/core/install/upgrades.php =================================================================== diff -u -N -r15373 -r15378 --- branches/5.2.x/core/install/upgrades.php (.../upgrades.php) (revision 15373) +++ branches/5.2.x/core/install/upgrades.php (.../upgrades.php) (revision 15378) @@ -1,6 +1,6 @@ Application->recallObject('kMultiLanguageHelper'); /* @var $ml_helper kMultiLanguageHelper */ + // make some promo block fields translatable $ml_helper->createFields('promo-block'); $table_name = $this->Application->getUnitOption('promo-block', 'TableName'); @@ -2174,5 +2175,22 @@ $sql = 'ALTER TABLE ' . $table_name . ' DROP Title'; $this->Conn->Query($sql); } + + // fix e-mail event translations + $languages = $ml_helper->getLanguages(); + $table_name = $this->Application->getUnitOption('emailevents', 'TableName'); + + $change_fields = Array ('Subject', 'HtmlBody', 'PlainTextBody'); + + foreach ($languages as $language_id) { + foreach ($change_fields as $change_field) { + $change_field = 'l' . $language_id . '_' . $change_field; + + $sql = "UPDATE " . $table_name . " + SET {$change_field} = REPLACE({$change_field}, '', '') + WHERE {$change_field} LIKE '%m_BaseURL%'"; + $this->Conn->Query($sql); + } + } } } \ No newline at end of file