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
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
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
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 .
BTW, sorry but I must have missed you at the elearning expo at Tokyo Big Site last month .
>
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.
Unfortunately I was not there this time.
Hi Mitsuhiro,
Wouldn't it be more (chrono)logical to have [Before] before [After] ?
Joseph
Wouldn't it be more (chrono)logical to have [Before] before [After] ?
Joseph
Joseph,
Thank you.
I'll try "Before" >> "After" next time.
Mits
Thank you.
I'll try "Before" >> "After" next time.
Mits