Index: branches/5.2.x/core/install/upgrades.sql =================================================================== diff -u -N -r16084 -r16201 --- branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 16084) +++ branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 16201) @@ -2925,3 +2925,10 @@ ALTER TABLE Themes ADD StylesheetFile VARCHAR( 255 ) NOT NULL DEFAULT ''; UPDATE Themes SET StylesheetFile = 'platform/inc/styles.css' WHERE `Name` = 'advanced'; + +UPDATE EmailTemplates +SET l1_Subject = REPLACE(l1_Subject, "Field name='Username'", 'UserTitle'), l1_HtmlBody = REPLACE(l1_HtmlBody, "Field name='Username'", 'UserTitle') +WHERE TemplateName LIKE 'USER%'; +UPDATE EmailTemplates +SET l1_Subject = REPLACE(l1_Subject, 'Field name="Username"', 'UserTitle'), l1_HtmlBody = REPLACE(l1_HtmlBody, 'Field name="Username"', 'UserTitle') +WHERE TemplateName LIKE 'USER%';