CMS Made Simple Forums

OlafNoehring wrote:
What columns do you mean (what should their name be, in which tables)?

In the database I find for example the table
cms7_content
with the fields
content_name
menu_text
...
prop_names

The MLE install renames fields content_name to content_name_en.  If the field name is content_name, you'll not get it working.  Same thing about menu_text.

Hi

strange that nothing happened to the fields - I will try ro rename the columns by hand and see what happens.
I have no explanation why the renaming did not work - maybe because my table prefix was not cms_ ? (but cms7) ?

I will keep you updated if the renaming was successfull.
Olaf

no, the prefix wouldn't matter.

I can't understand why this has failed on so many systems.  But manual rename is the only solution by far.

Hi

well, it worked - once only...
I saw the page, but then I I clicked on a language flag and I got the old "Not found" page again.

I have manually renamed the fields in table  cms7_content to
menu_text_en
content_name_en

Olaf

Please also add content_name_de and menu_text_de fields.

Hi

do I need those files for every language?
content_name_fr
menu_text_fr
....?

Olaf

Just for the languages you are going to use with your web site.

hi
yes, but i mean for all of them .... ?

olaf

yes, one content_name_xx and menu_text_xx pair per language.

HI

ok, will try.
But I don't think this solution is future safe. I think it would be more usefull to introduce a new table where the contents (1 column) for language X (1 column) get's drawn from - as well as the menu text (1 column) for that language. The new table should be linked by ID (1 column) with the now used content table.
Did you consider this?
The huge advantage I see is, that no database space is "wasted" - no empty fields if nopage for a language exists. Also the default language could be a fall back solution if a page in an additional language does not exist.
Also it would be very easy to add new languages afterwards.

Olaf

Yes, this approach will be implemented in cmsms core.  The current version of MLE is just a hack, don't forget this.

Hi

thanks for your help, it seems to work now.
Do you think there will be a way to transfer the mle hack contents/pages to the official multilanguage version?

Olaf

Yes, I will try to come up with an update tool.

Hi

well, another problem surfaced:
string(61) "Smarty error: unable to read resource: "globalcontent:footer""

Do I need to change any other tables (for example to the languages I use, add fields...)

Olaf

You probably forgot the "htmlblobs" table.
Have a look at the following post, it helped me out a lot:
http://forum.cmsmadesimple.org/index.ph ... l#msg43180