Форумы / Cotonti / Extensions / Content Internationalization (i18n) of Sienna

Hmm, weird...

I just did a fresh Siena test install via the same steps as you posted earlier and it works fine here..

For some reason I can't post an image with the CKEditor here..

But here are my server details:

http://www.twiebie.com/files/dump/server-info.png

Biggest difference would be the Apache version.

2011-08-03 13:44

Fatal error: SQL error 42000: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD COLUMN `tag_locale` VARCHAR(8) NOT NULL DEFAULT ''' at line 1

#0  cot_diefatal(SQL error 42000: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD COLUMN `tag_locale` VARCHAR(8) NOT NULL DEFAULT ''' at line 1) called at [/home/k3098kru/public_html/_subsites/broens/system/database.php:436]
#1  CotDB->query(ALTER TABLE  ADD COLUMN `tag_locale` VARCHAR(8) NOT NULL DEFAULT '') called at [/home/k3098kru/public_html/_subsites/broens/plugins/i18n/setup/i18n.install.php:20]
#2  include(/home/k3098kru/public_html/_subsites/broens/plugins/i18n/setup/i18n.install.php) called at [/home/k3098kru/public_html/_subsites/broens/system/extensions.php:499]
#3  cot_extension_install(i18n, ) called at [/home/k3098kru/public_html/_subsites/broens/system/admin/admin.extensions.php:352]
#4  require(/home/k3098kru/public_html/_subsites/broens/system/admin/admin.extensions.php) called at [/home/k3098kru/public_html/_subsites/broens/system/admin/admin.main.php:67]
#5  include(/home/k3098kru/public_html/_subsites/broens/system/admin/admin.main.php) called at [/home/k3098kru/public_html/_subsites/broens/admin.php:25]

How can I solve this?

Now it works perfect, even if you install it upon installation of cotonti.

Added 3 minutes later:

But on index, news-title is changed but text isn't.

If I click on de news to open as a page, the right text is displayed.

See: http://broens.be/index.php

Added 9 minutes later:

Also Recent Items is not doing what it should do.
Titles are not translated.

I am trying to use this for the first time on a clean Sienna 0.9.9 installation and i am a bit confused how to get this to work with pages.
I got it to work so far that if you select the English flag the site shows in all English (default text fields) and when you select the Dutch flag the entire site (the default fields) are displayed in dutch.

I created 2 news items from which one in English and one in Dutch with a stucture like this:

1 en English
1.1 en-news News
2 nl Dutch
2.1 nl-news Nieuws

No matter what I do, the dutch news item does not show in the news on the index.php. It only shows when I add {INDEX_NEWS_NL_NEWS} to the index.php. But than it will always show (no matter if you select to view the Dutch or the English site).

I added the following to my urltrans.dat:
page    al=*    {pagi18n_url()}

This is showing an error as well every time: "Alert! this line contains callbacks: {pagi18n_url()}
No idea what that means.

I added the following to my htaccess:

Options FollowSymLinks -Indexes
# Server-relative path to Cotonti:
RewriteBase "/testers/xxxxxxxxx/"
RewriteRule ^(datas|images|js|themes)/(.*)$ $1/$2 [QSA,NC,NE,L]

# Pages with aliases only
# Language selector
RewriteRule "^(en|nl)/(.*)?(.*)$" $2?$3&l=$1
RewriteRule "^(en|nl)/(.*)" $2?l=$1


I am pretty sure I am doing something dumb but I just do not fully understand the instructions on the downloadpage and here in this thread (which to me look different as well which is causing more confusion.
Any help with this? 

Wow, I am so sorry. Now I understand why I felt like an idiot trying to make this work. This is so very easy to use now you explained it, thanks for the help (again) Trustmaster!

It is working now and I must say, this is incredibly perfect! This opens up many new possibilities for any site I am running or will run in the future. Although I am still not moved to Sienna for my live websites this too only makes me want to hurry things up (but working on numerous new projects is not helping with the hurry).