General help

Language other than English just ???????

 
Picture of R Guy
Language other than English just ???????
 
Hi Everyone,

Sorry for the cross posting but I need help to get this fixed asap. Have instaled a new version of moodle 1.6.1 (not an upgrade) and all works fine until I try to enter any language other than English into any labels or blocks using the WYSIWYG editor.

I have the language packs up and running from the language import utility and the site language changes as required, its just in the blocks.

Filters are all set to yes and filter all strings is set to yes.

I am using a custom theme but have tried it with all stadard themes and get the same thing.

See http:www.mysensei.sie-group.com

Any help would be much appreciated.

Richard


 
Average of ratings: -
Picture of Mitsuhiro Yoshida
Re: Language other than English just ???????
Core developersDocumentation writersTranslators
Richard,

If your MySQL collation is latin1_xxxx, please try following fix.

Script: lib/setup.php
Line: 198

[ After ]
/// Set the client/server and connection to utf8 if necessary
    if ($CFG->unicodedb) {
        if ($db->databaseType == 'mysql') {
//            $db->Execute("SET NAMES 'utf8'");
        } else if ($db->databaseType == 'postgres7') {
            $db->Execute("SET NAMES 'utf8'");
        }
    }

[ Before ]
/// Set the client/server and connection to utf8 if necessary
    if ($CFG->unicodedb) {
        if ($db->databaseType == 'mysql') {
            $db->Execute("SET NAMES 'utf8'");
        } else if ($db->databaseType == 'postgres7') {
            $db->Execute("SET NAMES 'utf8'");
        }
    }


MIts
 
Average of ratings: -
Picture of R Guy
Re: Language other than English just ???????
 
That seems to do the trick, thank you so much! I owe you a beer... I work around Shibuya.

BTW, sorry but I must have missed you at the elearning expo at Tokyo Big Site last month .
 
Average of ratings: -
Picture of Mitsuhiro Yoshida
Re: Language other than English just ???????
Core developersDocumentation writersTranslators
> BTW, sorry but I must have missed you at the elearning expo at Tokyo Big Site last month .

Unfortunately I was not there this time.
 
Average of ratings: -
Picture of Joseph Rézeau
Re: Language other than English just ???????
Core developersParticularly helpful MoodlersPlugin developersTestersTranslators
Hi Mitsuhiro,
Wouldn't it be more (chrono)logical to have [Before] before [After] ?wide eyes
Joseph
 
Average of ratings: -
Picture of Mitsuhiro Yoshida
Re: Language other than English just ???????
Core developersDocumentation writersTranslators
Joseph,

Thank you.
I'll try "Before" >> "After" next time.smile

Mits
 
Average of ratings: -