Hi Alby,
For the sql querys, I was able to make the change for number I. in the README.FIRST file but i am confused on what to for number II. and III.
Ok,
a. I suppose (for example) that you want:
en_US,
it_IT and
fr_FRb. and relative blocklanguage are (prev compatibility with MLE 1.02):
en,
it and
fr(Same of config_lang)
II. After install of 1.1.2 in prop_names column of cms_content there is
content_en (this is because CMSMS is monolingual)
With:
UPDATE `cms_content` SET `prop_names`= REPLACE(`prop_names`,'
content_en','
content_en,content_it,content_fr') WHERE `prop_names` LIKE '%content_en%';
substitute
content_en with
content_en,content_it,content_fr (i.e. your content_
blocklanguage, see
b. for blocklanguage)
III. In cms_content_props tables there is
content_en (this is because CMSMS is monolingual)
You must enter new rows relative to 'content_it' and after 'content_fr' for ALL items of content_en:
For
content_it:
INSERT INTO `cms_content_props` (`content_id`,`type`,`prop_name`,`param1`,`param2`,`param3`,`content`,`create_date`,`modified_date`)
SELECT `content_id`,`type`, '
content_it' ,`param1`,`param2`,`param3`,`content`,`create_date`,`modified_date`
FROM `cms_content_props` WHERE `prop_name` = 'content_en' AND `type` = 'string';
For
content_fr:
INSERT INTO `cms_content_props` (`content_id`,`type`,`prop_name`,`param1`,`param2`,`param3`,`content`,`create_date`,`modified_date`)
SELECT `content_id`,`type`, '
content_fr' ,`param1`,`param2`,`param3`,`content`,`create_date`,`modified_date`
FROM `cms_content_props` WHERE `prop_name` = 'content_en' AND `type` = 'string';
English isn't my language, if there are errors please correct me
Best regards
Alby