Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#373 2007-09-11 15:05:51

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: MLP - The Multi-Lingual Publishing Pack

Does your txp_file table contain a column named ‘description’?

Offline

#374 2007-09-11 17:27:11

fuls
Member
Registered: 2005-11-16
Posts: 117
Website

Re: MLP - The Multi-Lingual Publishing Pack

It seems I got it working for now:).

I don’t understand one thing though. When I pick a language inside admin it always switches back to en-gb no matter what. I’d like to have my admin in italian (for example) and when I save it inside languages tab and go to any other admin section it switches back to english. Is there a fix for that?

Thanks!

Last edited by fuls (2007-09-11 17:27:34)

Offline

#375 2007-09-11 20:03:10

jstubbs
Moderator
From: Hong Kong
Registered: 2004-12-13
Posts: 2,395
Website

Re: MLP - The Multi-Lingual Publishing Pack

fuls, that’s the problem I see now too. I don’t think its been solved. One person posted a hack earlier in this thread, but it did not work for me. Biggest issue apart from that for me is the sections and categories – if the main language is en-gb, then the translation fields for the other languages do not appear in the section tab.

In the categories tab (and in the images tab) the fields for the other language titles do appear, but after saving titles in the various languages, the titles do not appear. In all cases (as far as I can see), it appears the changes are written to the database though.

Offline

#376 2007-09-11 20:09:19

beztak
Member
From: Czech Republic
Registered: 2005-07-21
Posts: 184
Website

Re: MLP - The Multi-Lingual Publishing Pack

jstubbs wrote:

Biggest issue apart from that for me is the sections and categories – if the main language is en-gb, then the translation fields for the other languages do not appear in the section tab.

I have the same problem. But it’s not only when main language is en-gb, it’s global problem doesn’t matter which language is main. I always have to write translation direct in database… :(

Offline

#377 2007-09-12 07:17:02

jmk
Member
Registered: 2006-09-04
Posts: 49

Re: MLP - The Multi-Lingual Publishing Pack

ruud wrote:

Does your txp_file table contain a column named ‘description’?

yes. yours doesn’t?

btw. my txp_file tabel looks like this:

field type null default
id int(11) No
filename varchar(255) No
category varchar(255) No
permissions varchar(32) No 0
description text No
downloads int(4) No 0
status smallint(6) No 4
modified datetime No 0000-00-0000:00:00
created datetime No 0000-00-0000:00:00
size bigint(20) Yes NULL
l10n_description_en_gb text No
l10n_description_de_de text No

Offline

#378 2007-09-12 08:49:20

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: MLP - The Multi-Lingual Publishing Pack

The problem is that you’re sorting on ‘description’, but since you’ve aliased l10n_description_en_gb as description in the SQL query, MySQL is not sure which description you mean.

Offline

#379 2007-09-12 08:53:15

jmk
Member
Registered: 2006-09-04
Posts: 49

Re: MLP - The Multi-Lingual Publishing Pack

alright, i thought that it would be something like that. but what do you mean by “you’ve aliased l10n_description_en_gb as description”? i am not sure how i did that :) meaning, is tht my fault, or is it mlp-packs fault :)

Offline

#380 2007-09-12 09:03:52

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: MLP - The Multi-Lingual Publishing Pack

select *,`l10n_description_en_gb` as `description` from txp_file

MLP does that, I think.

Offline

#381 2007-09-12 09:08:30

jmk
Member
Registered: 2006-09-04
Posts: 49

Re: MLP - The Multi-Lingual Publishing Pack

so, i can either sort my files not by description, or … ?

Offline

#382 2007-09-12 15:22:32

fuls
Member
Registered: 2005-11-16
Posts: 117
Website

Re: MLP - The Multi-Lingual Publishing Pack

jstubbs wrote:

fuls, that’s the problem I see now too. I don’t think its been solved. One person posted a hack earlier in this thread, but it did not work for me. Biggest issue apart from that for me is the sections and categories – if the main language is en-gb, then the translation fields for the other languages do not appear in the section tab.In the categories tab (and in the images tab) the fields for the other language titles do appear, but after saving titles in the various languages, the titles do not appear. In all cases (as far as I can see), it appears the changes are written to the database though.

Yes, now I see it also.
There’s no section name for the en-gb, and also no page title. Is anybody working on this? Can we expect some fixes in near future?

Last edited by fuls (2007-09-12 15:23:06)

Offline

#383 2007-09-12 15:43:32

jmk
Member
Registered: 2006-09-04
Posts: 49

Re: MLP - The Multi-Lingual Publishing Pack

yes, i can see the problem here, too. is it a txp 4.0.5 specific problem? or does it happen in txp 4.0.4 also?

i can confirm, though, that the table “txp_prefs” is updated correctly and holds the correct language in the “language” field. so it seems as if the mlp-pack assumes the language to be stored elsewhere?!

Offline

#384 2007-09-12 16:12:49

fuls
Member
Registered: 2005-11-16
Posts: 117
Website

Re: MLP - The Multi-Lingual Publishing Pack

jmk wrote:

yes, i can see the problem here, too. is it a txp 4.0.5 specific problem? or does it happen in txp 4.0.4 also?
i can confirm, though, that the table “txp_prefs” is updated correctly and holds the correct language in the “language” field. so it seems as if the mlp-pack assumes the language to be stored elsewhere?!

I think this is a 4.0.5 specific problem because I had it working on 4.0.4

Offline

Board footer

Powered by FluxBB