patak wrote:
Hi alby and all other,
Firts of all, thank you for this great CMS. I realy love it and useing it on couple of projects.
But what is my problem?
I need to "uninstall" the MLE from one of my project because my customer no more need multilang site.
I mean that I want to remove 3 of 4 installed languages.
How to do it?
Thank you for help and sorry for my poor English
Jan
Or drop your langs and keeping only the only language in config_lang.php
or depend which langs you use and queries that you have apply.
BACKUP your DATABASE and test in local environment first
In this example
XX is the block of final mono-language and
XX, YY and ZZ are your block langs in config_lang.php
[I'm going to memory!]
Check this condition and apply only if true:
you have apply the SQL queries of README.FIRST exactly (ie: add always new columns and
not rename content_name and menu_text)
UPDATE `cms_content` SET `content_name`=`content_name_XX`, `menu_text`=`menu_text_XX`;
UPDATE `cms_htmlblobs` SET `html`=`html_XX`;
IF (and only if) you use extended version (README.FIRST.extended), apply also:
UPDATE `cms_content` SET `metadata`=`metadata_XX`, `titleattribute`=`titleattribute_XX`;
So far everything is safe, now you have to apply this that break MLE:
UPDATE `cms_content` SET `prop_names`= REPLACE(`prop_names`,'content_XX,content_YY,content_ZZ','content_en') WHERE `prop_names` LIKE '%content_XX%';
NOW (are alternative) IF XX = en:
DELETE FROM `cms_content_props`WHERE `content`= `content_YY` OR `content`= `content_ZZ`;
ELSE (no language equal to en or en = YY):
DELETE FROM `cms_content_props`WHERE `content`= `content_YY` OR `content`= `content_ZZ`;
UPDATE `cms_content_props`SET `content`= `content_en` WHERE `content`= `content_XX`;[/i]
well, rename config_lang.php et voilà
Alby
