Index: branches/5.1.x/core/install/upgrades.sql =================================================================== diff -u -r13140 -r13151 --- branches/5.1.x/core/install/upgrades.sql (.../upgrades.sql) (revision 13140) +++ branches/5.1.x/core/install/upgrades.sql (.../upgrades.sql) (revision 13151) @@ -1636,12 +1636,17 @@ FROM <%TABLE_PREFIX%>Permissions WHERE Permission = 'in-portal:configemail.edit'; +ALTER TABLE Events ADD l1_Description text; + UPDATE Events e SET e.l1_Description = ( SELECT p.Translation FROM <%TABLE_PREFIX%>Phrase p WHERE (p.Phrase = e.Description) AND (p.LanguageId = 1) ); -ALTER TABLE Events DROP Description; +UPDATE Events SET Description = l1_Description; +ALTER TABLE Events DROP l1_Description; + DELETE FROM Phrase WHERE Phrase LIKE 'la_event_%'; +DELETE FROM PersistantSessionData WHERE VariableName = 'phrases_columns_.';