4577 Posts in 1388 Topics by 1377 members
| Go to End | Next > | |
| Author | Topic: | 3631 Views |
-
About Multi Language installation
12 April 2010 at 10:32am
Hello
Im new with the silverstripe im working with the 2.3.7 Version I would like to know what is the correct way to configure multi-language content, try the options I found on the forum and in the site documentation but i still getting errors
thaks for any help
-
Re: About Multi Language installation
13 April 2010 at 2:16am
Hi atroz,
To help us in the forums understand how we can help you, what are the errors that you are seeing with the multi-language content? Also, what options have you enabled?
Cheers
Owen -
Re: About Multi Language installation
13 April 2010 at 6:18am
ok first i try addthis line to the _config.php
Object::add_extension('SiteTree', 'Translatable');
as i read in http://doc.silverstripe.org/doku.php?id=multilingualcontent but i get this "There has been an error
The website server has not been able to respond to your request", then i use the command ?isDev=1 to try to look where the error was but i get a big list of errors about Mysql.then i find this in the forums
in mysite\_config.php add:
Translatable::enable();
but i get similar errors ...
im doing all bad or missunderstanding something?
please help
-
Re: About Multi Language installation
14 April 2010 at 4:06am
Hi atroz,
The errors from Mysql are important to working out what is wrong. Can you post some of them?
Cheers
Owen -
Re: About Multi Language installation
14 April 2010 at 8:58am
Important question: did you give a yoursite.com/dev/build (where yoursite.com is your web address)
Here is the code I a using right now for a multilingual website with 4 languages and german as the default language:
/* Multilingual content */
/********************/
//translatable
Translatable::set_default_locale('de_DE'); // This defines Translatable::current_lang() in Page.php
// Enable Translatable
Object::add_extension('SiteTree', 'Translatable');// i18n
i18n::enable();
// Define allowed locales overriding those present in i18n::$common_locales
global $allowed_locales;
$allowed_locales = array(
'de_DE' => array('German', 'Deutsch'),
'en_GB' => array('English', 'English'),
'fr_FR' => array('French', 'Français'),
'es_ES' => array('Spanish', 'Espanol')
//
);
i18n::$common_locales = $allowed_locales; -
Re: About Multi Language installation
15 April 2010 at 5:40am
This is what i get:
User Error] Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogTree`.*, `Calendar`.*, `CalendarEvent`.*, `FlickrGallery`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `BlogHolder`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `BlogEntry` ON `BlogEntry`.ID = `SiteTree`.ID LEFT JOIN `BlogTree` ON `BlogTree`.ID = `SiteTree`.ID LEFT JOIN `Calendar` ON `Calendar`.ID = `SiteTree`.ID LEFT JOIN `CalendarEvent` ON `CalendarEvent`.ID = `SiteTree`.ID LEFT JOIN `FlickrGallery` ON `FlickrGallery`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(, ^) *kaminu\.com *(,|$)') AND (`SiteTree`.`Locale` = 'es_ES') ORDER BY Sort LIMIT 1 | Unknown column 'SiteTree.Locale' in 'where clause'
GET /silverstripe/?isDev=1
Line 401 in /home/kaminuco/public_html/silverstripe/sapphire/core/model/MySQLDatabase.phpSource
392 }
393
394 function databaseError($msg, $errorLevel = E_USER_ERROR) {
395 // try to extract and format query
396 if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
397 $formatter = new SQLFormatter();
398 $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
399 }
400
401 user_error($msg, $errorLevel);
402 }
403 }
404
405 /**
406 * A result-set from a MySQL database.
407 * @package sapphire
Trace
•Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogTree`.*, `Calendar`.*, `CalendarEvent`.*, `FlickrGallery`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `BlogHolder`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `BlogEntry` ON `BlogEntry`.ID = `SiteTree`.ID LEFT JOIN `BlogTree` ON `BlogTree`.ID = `SiteTree`.ID LEFT JOIN `Calendar` ON `Calendar`.ID = `SiteTree`.ID LEFT JOIN `CalendarEvent` ON `CalendarEvent`.ID = `SiteTree`.ID LEFT JOIN `FlickrGallery` ON `FlickrGallery`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(, ^) *kaminu\.com *(,|$)') AND (`SiteTree`.`Locale` = 'es_ES') ORDER BY Sort LIMIT 1 | Unknown column 'SiteTree.Locale' in 'where clause'
Line 401 of MySQLDatabase.php
•MySQLDatabase->databaseError(Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogTree`.*, `Calendar`.*, `CalendarEvent`.*, `FlickrGallery`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `BlogHolder`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `BlogEntry` ON `BlogEntry`.ID = `SiteTree`.ID LEFT JOIN `BlogTree` ON `BlogTree`.ID = `SiteTree`.ID LEFT JOIN `Calendar` ON `Calendar`.ID = `SiteTree`.ID LEFT JOIN `CalendarEvent` ON `CalendarEvent`.ID = `SiteTree`.ID LEFT JOIN `FlickrGallery` ON `FlickrGallery`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(,|^) *kaminu\.com *(,|$)') AND (`SiteTree`.`Locale` = 'es_ES') ORDER BY Sort LIMIT 1 | Unknown column 'SiteTree.Locale' in 'where clause',256)
Line 102 of MySQLDatabase.php
•MySQLDatabase->query(SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogTree`.*, `Calendar`.*, `CalendarEvent`.*, `FlickrGallery`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `BlogHolder`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `BlogEntry` ON `BlogEntry`.ID = `SiteTree`.ID LEFT JOIN `BlogTree` ON `BlogTree`.ID = `SiteTree`.ID LEFT JOIN `Calendar` ON `Calendar`.ID = `SiteTree`.ID LEFT JOIN `CalendarEvent` ON `CalendarEvent`.ID = `SiteTree`.ID LEFT JOIN `FlickrGallery` ON `FlickrGallery`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(,|^) *kaminu\.com *(,|$)') AND (`SiteTree`.`Locale` = 'es_ES') ORDER BY Sort LIMIT 1,256)
Line 120 of DB.php
•DB::query(SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogTree`.*, `Calendar`.*, `CalendarEvent`.*, `FlickrGallery`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `BlogHolder`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `BlogEntry` ON `BlogEntry`.ID = `SiteTree`.ID LEFT JOIN `BlogTree` ON `BlogTree`.ID = `SiteTree`.ID LEFT JOIN `Calendar` ON `Calendar`.ID = `SiteTree`.ID LEFT JOIN `CalendarEvent` ON `CalendarEvent`.ID = `SiteTree`.ID LEFT JOIN `FlickrGallery` ON `FlickrGallery`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(,|^) *kaminu\.com *(,|$)') AND (`SiteTree`.`Locale` = 'es_ES') ORDER BY Sort LIMIT 1)
Line 426 of SQLQuery.php
•SQLQuery->execute()
Line 2531 of DataObject.php
•DataObject->instance_get_one(HomepageForDomain REGEXP '(,|^) *kaminu\.com *(,|$)',)
Line 2468 of DataObject.php
•DataObject::get_one(SiteTree,HomepageForDomain REGEXP '(,|^) *kaminu\.com *(,|$)')
Line 64 of RootURLController.php
•RootURLController::get_homepage_urlsegment()
Line 41 of RootURLController.php
•RootURLController->handleRequest(HTTPRequest)
Line 280 of Director.php
•Director::handleRequest(HTTPRequest,Session)
Line 121 of Director.php
•Director::direct(/)
Line 118 of main.php -
Re: About Multi Language installation
24 August 2010 at 8:24am
Thanks yurigoul,
I've succeeded to use your code on SS 2.4.1, but now cannot find the right way to display a language chooser in a front end. What can you recommend?
-
Re: About Multi Language installation
24 August 2010 at 9:57am
This is what I use in Page.ss for one site:
<% if Translations %>
<ul id="languageMenu" ><!-- for all translations except the current one -->
<% control Translations %>
<li class="$Locale">
<a href="$Link" hreflang="$Locale.RFC1766"
title="$Title">
$Locale
</a></li><% end_control %><!-- for the current language, but you can leave it out -->
<li class="$Locale">
<a href="$Link" hreflang="$Locale.RFC1766"
title="$Title">
$Locale
</a>
</li>
</ul>
<% end_if %>There is no function in my page.php (or is there, it has been a while, I did search for it, and I had a couple of glasses of wine, but have to sleep now and get up early in the morning
)
####################
In another:
page.php:
function LangMenu() {
if($this->URLSegment == "Security") return false;
$availTransl = Translatable::getTranslations();
if(count($availTransl) == 0) return false;
if ($this->ClassName == 'SubscriptionPage') return false;$langs = Translatable::get_existing_content_languages();
$data = new DataObjectSet();foreach(array_keys($langs) as $code) {
$page = $this->getTranslation($code);
if (isset($page)) {
if (!($code == $this->Locale)) {
// get country code (e.g. "de")
$lang = i18n::get_lang_from_locale($code);
$data->push(new ArrayData(array(
'Name' => i18n::get_language_name($lang, true),
'Title' => $page->Title,
'Link' => Director::baseURL() . $page->URLSegment,
'Code' => $code
//'page' => $page
)));
}
}
}
return $data;
}In page.ss:
<% if LangMenu %>
<ul class="languageMenu" >
<% control LangMenu %>
<li class="$Name"><a href="$Link" hreflang="$Code" title="$Name"><span>$Name</span></a></li>
<% end_control %>
</ul>
<% end_if %>
| 3631 Views | ||
| Go to Top | Next > |
