Cmsadesimple multilingual with installer

[katon]

please contact me at katon (at) gmail (dot) com, and I will try to help you.

[eeinarsson]

The Icelandic flag

[gelöscht durch Administrator]

[katon]

Thanks to everybody.  I have released build 4 with the two new flags and with fixes to the bugs you guys have discovered.

[swgreed]

Hi,
I just fresh-installed build 4 with 'German' as additional language, but the main page just results in a 404 Error. (The original 1.0.2 release worked fine)
However I am able to get access to the admin panel of build 4.

Could this be the result of missing UTF-8 support in the database?
How can I change my database to UTF-8 (using phpmyadmin)?

[katon]

  I don't think your problem is related to the database encoding.  There seems to be a bug that I haven't managed to reproduce on my system.  Can you email me the dump of your database?  I am afraid the installer failed to alter database structure accordingly.

[swgreed]

Thanks for your support.

You got a PM. (Can't see your email)

[katon]

I have looked at your dump, and found that the table structure wasn't changed.  The installer failed to alter your tables - probably because of your MySQL version or settings.  If you can, try to run these queries from mysql console.  In version 1.1 the installer will not be altering tables, so we won't have to worry about this.

[swgreed]

I tried, but I couldn't make it work
Guess I'll have to wait for 1.1 then...

Looking forward to it

[katon]

You could try to make the changes with phpMyAdmin.  Or maybe there is a way to change MySQL settings to allow executing ALTER queries?  By the way, did it give you any error messages?

[swgreed]

In fact, I tried it with phpMyAdmin, truncating the DB tables and then importing 'initial.sql' and 'extra.sql'.
I just received "duplicate entries" while importing 'extra.sql'. Therefore I just tried the bigger 'extra.sql' only, but it the 404 status remained.
However no errors occured during that operation.

Sorry, but I am not that deep into altering tables...

[katon]

hmm... You definitely don't need extra.sql

[Ronson]

Hi Katon,
I just tried the last build 4, but the problem still persists. Check your e-mail for more info

[knorrhane]

I was having the same problem as Ronson and swgreed. The appropriate tables where not created in the installation so I added them manually with instructions from katon.

First I did an install om build4. When trying to access the front page I got the 404-error. I logged in to phpMyAdmin and changed the following manually.

In the content table, rename columns content_name and menu_text to content_name_en and menu_text_en accordingly.  Plus add columns content_name_de and menu_text_de. If you have installed additional languages, add columns for these to ie. for swedish add content_name_se and menu_text_se.

Further, In the htmlblobs table, rename the column html to html_en and add column html_de and if you have additional languages add them here to.  That's it.

Thank you katon for the fast answers and support. It's very appreciated!

[swgreed]

Thanks to knorrhane, I was able to set up the MLE version on my webspace as well

However the setting in the config_lang.php

Code: Select all

define('DEFAULT_LANG', 'de');

only seems to work here, if pretty urls are enabled:

Code: Select all

$config['internal_pretty_urls'] = true;

otherwise I'll always land on the English site by default!

[katon]

Does it fail to work when you have $config['assume_mod_rewrite'] = false ?