SQL script during installation failed

[stefsegers]

Hey all,

I watched the video tutorial and did everything they showed.

I downloaded CMSMS, setup the dbase and did a normal install. After that I did the video tutor. and got until the point of the SQL query.

What I got with

UPDATE cms_content SET prop_names = REPLACE(prop_names,'content_nl','content_en') WHERE prop_names LIKE '%content_en%';

0 rows are affected.

So nothing changed at all.

After going to the admin or website there's nothing to be found that looks like a multi lang website.

What am I doing wrong?

Stef

[alby]

What I got with

UPDATE cms_content SET prop_names = REPLACE(prop_names,'content_nl','content_en') WHERE prop_names LIKE '%content_en%';

0 rows are affected.

So nothing changed at all.

After going to the admin or website there's nothing to be found that looks like a multi lang website.

Sure,
in README.FIRST there is:
UPDATE cms_content SET prop_names = REPLACE(prop_names,'content_en','content_en,content_it,content_fr') WHERE prop_names LIKE '%content_en%';

UPDATE in cms_content the field prop_names and REPLACE rows with content_en with content_en,content_it,content_fr

you want REPLACE content_nl (not exist) with content_en .......

IF YOU WANT en and nl THEN:
UPDATE cms_content SET prop_names = REPLACE(prop_names,'content_en','content_en,content_nl') WHERE prop_names LIKE '%content_en%';


Alby

[stefsegers]

I think I got it working!