Index: win_installer/updater/src/ant/update-core-database.xml
===================================================================
diff -u -ra346e8c8f13dc57dfca4a13f75d0b4276969e207 -rc939ed4717ab29a8f5402970030834a267047f24
--- win_installer/updater/src/ant/update-core-database.xml (.../update-core-database.xml) (revision a346e8c8f13dc57dfca4a13f75d0b4276969e207)
+++ win_installer/updater/src/ant/update-core-database.xml (.../update-core-database.xml) (revision c939ed4717ab29a8f5402970030834a267047f24)
@@ -12,11 +12,24 @@
userid="${db.username}"
password="${db.password}"
encoding="utf8"
- onerror="continue">
+ onerror="abort">
-
+
+
+
+
+ The below script will fail if the database tables are already INNODB, this will not affect the update.
+
+
+
\ No newline at end of file
Index: win_installer/updater/src/sql/updateLocales.sql
===================================================================
diff -u
--- win_installer/updater/src/sql/updateLocales.sql (revision 0)
+++ win_installer/updater/src/sql/updateLocales.sql (revision c939ed4717ab29a8f5402970030834a267047f24)
@@ -0,0 +1,27 @@
+-- Fixing Japanese language string. See LDEV-1702
+-- checks if the languages in the language pack exist
+-- inserts rows into lams_supported_locale iff the languages dont exist
+drop table if exists locale_temp;
+
+create table locale_temp (
+ language_iso_code VARCHAR(2) NOT NULL
+ , country_iso_code VARCHAR(2)
+ , description VARCHAR(255) NOT NULL
+ , direction VARCHAR(3) NOT NULL
+ , combined VARCHAR(5) NOT NULL
+ , fckeditor_code VARCHAR(10)
+)TYPE=InnoDB;
+
+-- the combined column must be 'language_iso_code,country_iso_code' or 'language_iso_code'. It must match the value
+-- given by SELECT CONCAT_WS(',',l.language_iso_code,l.country_iso_code) FROM lams_supported_locale l
+INSERT INTO locale_temp (language_iso_code, country_iso_code, description, direction, combined, fckeditor_code) VALUES ('ja','JP','日本語','LTR','ja,JP', 'ja');
+
+INSERT INTO lams_supported_locale (language_iso_code, country_iso_code, description, direction, fckeditor_code)
+(SELECT t.language_iso_code, t.country_iso_code, t.description, t.direction, t.fckeditor_code
+FROM locale_temp t WHERE t.combined NOT IN
+(SELECT CONCAT_WS(',',l.language_iso_code,l.country_iso_code) FROM lams_supported_locale l));
+drop table if exists locale_temp;
+
+-- Fixing Japanese language string. See LDEV-1702
+-- description description may be set to "Japanese (Japan)"
+UPDATE lams_supported_locale SET description='日本語' WHERE language_iso_code='ja' AND country_iso_code='JP';
\ No newline at end of file