MLP - The Multi-Lingual Publishing Pack

graeme · 2009-03-25 01:02:05

MoonTrace wrote:

The problem is in MySQL setup. Default engine type is set to InnoDB, which does not have fulltext search.
The actual query is in textpattern\lib\l10n_admin_classes.php file, lines 1521-1523.

Thanks for that change. I’ve not used to the different engine types so I’ll do some testing and research on the topic before making the change.

graeme · 2009-03-25 01:21:00

the_ghost wrote:

Have some problems with moving to another hosting – site doesn’t load at all. Even admin-side doesn’t work…

phpinfo()

Here output from public side

Here output from admin side

Here is screenshot of admin-side

If i try to run in phpmyadmin sql’s, which are marked “as bad”, in phpmyadmin i get normal output…

Victor,

From the looks of things Txp isn’t connecting to the new database at all. You might want to check your config.php. If the settings are correct then could try disabling MLP manually with this SQL statement UPDATE txp_plugin SET status = 0 WHERE name = 'l10n' in phpMyAdmin and let me know the result.

Also some more info such as the phpinfo() from the old host and the MySQL, Txp and MLP versions are you using would be helpful. Thanks

MoonTrace · 2009-03-25 07:22:14

graeme wrote:

The structure should be identical to the main textpattern table. Those steps might of failed due to not having the correct MySQL permissions. Are you able to check weather you’ve got the CREATE permission?

Thanks for that change. I’ve not used to the different engine types so I’ll do some testing and research on the topic before making the change.

Greame, I would suggest Maded to add textpattern\lib\l10n_admin_classes.php at line 1521 this code (middle line):

$indexes = "(PRIMARY KEY  (`ID`), KEY `categories_idx` (`Category1`(10),`Category2`(10)), KEY `Posted` (`Posted`), FULLTEXT KEY `searching` (`Title`,`Body`))";
indexes .= ' ENGINE=MyISAM';
$sql = "create table `$full_name` $indexes select * from `".PFX."textpattern` where ".L10N_COL_LANG."='$lang'";

But can default engine type be set globally by a client, like setting charset?

the_ghost · 2009-03-25 07:23:34

Something strange happens – now i entered admin-side without errors, but site still looks bad.

full diag of problem site
full diag of normal site and normal’s phpinfo

I think error could be connected with encodings – switching manually to english version works well… Here is my lang_list form (which calls annoying errors in the top)

Here is strange chars in admin side by this url – http://moskomzem.nichost.ru/textpattern/index.php?event=l10n&tab=plugin&plugin=zem_contact_lang-mlp&prefix=zem_crl

And this is the same part when English is selected as admin language:

MoonTrace · 2009-03-25 15:19:11

Els wrote:

Hi MoonTrace, welcome to Txp and MLP!
…
Unfortunately that is not possible at the moment. See this post by Steve, #009.
If you don’t really need the /section/title URLs, a workaround is to use the /title permanent link mode. I’m only using this workaround myself on one, very simple, site. As soon as you need a multi-level structure, and/or categories, it’s not really an option.
..
Interesting question! :) It’s not possible ‘out of the box’ as far as I know, but there might be a way to achieve it using smd_if. Right now I don’t have time to look into it, but roughly I’m thinking about not displaying the language link if there is no rendition, and use smd_if to test for the presence of a language in the language list, and if not, add a link to the section page. Something like that…

the_ghost wrote:

I thought about it and have done this with txp:variable and smd_if

Hi guys, thank you for quick answer. I will look at it. Pity URLs cannot be translated… :/

els · 2009-03-26 23:15:34

dl33 wrote:

I am using 4.07.

At the moment I have this inside a l10n:if_lang: (…) which produces this: (but nothing visible)

(..) [SQL (0.00042200088501): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from squawk_l10n_txp_de_de as l10n_txp_de_de where 1=1 and Status >= 4 and Posted <= now() and (now() <= Expires or Expires = 0) and ID IN (127) order by Posted desc limit 0, 10]

If I understand this correctly, the query is looking for article id 127 in your de_de table, and my guess is that it’s not there… Probably caused by the l10n_if_lang tag. Actually I’d think it should look in the textpattern table. I need to think about this a little bit longer I’m afraid.

Could you post the exact code you were using please? Including the if_lang tags?

Last edited by els (2009-03-26 23:32:50)

the_ghost · 2009-03-27 23:34:37

It’s me again :) Tried step-by-step moving site to local server and i got it – at local txp 4.0.8reslease + MLP0.9.9 (graeme’s patch) works well. But! Then i did the same steps when was moving to my “problem” server. I got much less error, but one is still very annoying – it is Tag error: <txp:l10n_lang_list /> -> Notice: .... Notices are very different, but i think problem must be somewhere in php-engine or some php-settings.

Here is list of errors (the list is formatted to quickly see errors.
And here is the link to the problem site
Amount of errors varies in RU section and EN, you can see it on live site;
The problem is that <txp:l10n_lang_list /> outputs links only to english, is doesn’t output russian title at all.

P.S. Normal developing site is here

Last edited by the_ghost (2009-03-27 23:48:27)

els · 2009-04-02 23:33:49

dl33

While adding Steve’s ‘todo’ list to TXP Forge, I found an open issue that I think would solve your problem, if implemented.

Exiladler · 2009-04-03 09:39:22

Hi,

I have some sites up and running with the plug-in and have now worked on a new site, txp 4.0.8, mlp 0.9.11. languages en-gb,ca-es,es-es. Strangely even after install and reinstalling it several times, in Presentation – Sections I only get English as Section Name field. Any clues why this is the case? In txp 4.0.5 and mlp 0.7.627 I get all installed languages set in mlp preferences.

redbot · 2009-04-03 10:17:27

Exiladler wrote:

…..Sections I only get English as Section Name field. Any clues why this is the case? In txp 4.0.5 and mlp 0.7.627 I get all installed languages set in mlp preferences.

Are you sure you installed the right version?

the_ghost · 2009-04-03 11:48:47

My problem was fixed by changing php version to 5.1.6 from 5.2.8 (may be some extensions were changed too, i’m not sure)

graeme · 2009-04-03 11:57:24

the_ghost wrote:

My problem was fixed by changing php version to 5.1.6 from 5.2.8 (may be some extensions were changed too, i’m not sure)

Thats great news. If you able to get a list of extensions I’ll try find out what the problem was.

Exiladler · 2009-04-03 12:13:20

doooooh,

0.9.11-gp and all is well

Thanks

the_ghost · 2009-04-04 07:34:00

graeme wrote:

Thats great news. If you able to get a list of extensions I’ll try find out what the problem was.

Unfortunately i didn’t save phpinfo() when there were problems. But here is current phpinfo()

Last edited by the_ghost (2009-04-04 07:51:32)

the_ghost · 2009-04-16 08:18:25

Is there way to build link to rendition of different language?
I mean something like this: <txp:l10n_permlink lang="en" /> – this should output link to english rendition of article.

Textpattern CMS

Textpattern CMS support forum

#1231 2009-03-25 01:02:05

Re: MLP - The Multi-Lingual Publishing Pack

#1232 2009-03-25 01:21:00

Re: MLP - The Multi-Lingual Publishing Pack

#1233 2009-03-25 07:22:14

Re: MLP - The Multi-Lingual Publishing Pack

#1234 2009-03-25 07:23:34

Re: MLP - The Multi-Lingual Publishing Pack

#1235 2009-03-25 15:19:11

Re: MLP - The Multi-Lingual Publishing Pack

#1236 2009-03-26 23:15:34

Re: MLP - The Multi-Lingual Publishing Pack

#1237 2009-03-27 23:34:37

Re: MLP - The Multi-Lingual Publishing Pack

#1238 2009-04-02 23:33:49

Re: MLP - The Multi-Lingual Publishing Pack

#1239 2009-04-03 09:39:22

Re: MLP - The Multi-Lingual Publishing Pack

#1240 2009-04-03 10:17:27

Re: MLP - The Multi-Lingual Publishing Pack

#1241 2009-04-03 11:48:47

Re: MLP - The Multi-Lingual Publishing Pack

#1242 2009-04-03 11:57:24

Re: MLP - The Multi-Lingual Publishing Pack

#1243 2009-04-03 12:13:20

Re: MLP - The Multi-Lingual Publishing Pack

#1244 2009-04-04 07:34:00

Re: MLP - The Multi-Lingual Publishing Pack

#1245 2009-04-16 08:18:25

Re: MLP - The Multi-Lingual Publishing Pack

Board footer