MLP - The Multi-Lingual Publishing Pack

Bloke · 2013-09-09 18:36:00

datorhaexa

If you’re using the GithHb version you should replace all of the files, including overwriting the two plugins with the code in the repo. Once you’ve done that you can amend the l10n_admin.php to comment out my stupidity for the time being.

~~The collations would certainly have been one factor but if you fixed those~~ It’s probably something else that differs in one or more of the language tables compared to the textpattern table. But if they are truly identical in structure, you’re running the full GitHub version and it’s still giving you problems then there must be something else. If you get no joy there and wish to send me a login, I can take a look for you and see if I can figure it out.

Last edited by Bloke (2013-09-10 08:15:32)

datorhaexa · 2013-09-09 19:28:10

Stef, first thanks for the help! I will do this tomorrow on my local server and see how it goes. I’m severely restricted by the client’s sysadmin to what I can do on their server so I hope it works out.

Bloke · 2013-09-09 19:34:28

datorhaexa wrote:

Stef, first thanks for the help! I will do this tomorrow on my local server and see how it goes. I’m severely restricted by the client’s sysadmin to what I can do on their server so I hope it works out.

No worries. Let me know how it goes. I just committed the fix for the botched fix so you should be able to use the GitHub version as-is now.

Gocom · 2013-09-10 00:02:09

For multilingual databases you should be using multiple different collations. Each textpattern table should be using a collation that matches the language, and its characteristics (charset of course should be UTF-8). Otherwise MySQL will not work properly when it comes to searching, matching and sorting.

Bloke · 2013-09-10 08:14:28

Gocom wrote:

For multilingual databases you should be using multiple different collations

Oops, well spotted, thanks. Everyone ignore what I said earlier about collations (I edited the posts anyway). Just make sure the field types match.

Last edited by Bloke (2013-09-10 08:16:21)

datorhaexa · 2013-09-10 11:08:04

Ok, I made a blank new install on my xampp here of TXP latest and the latest “official” MLP, then overwrote the files with those in github (the plugin files I edited by substituting the php code from the github sources). All ok only the same problem persists — no edits are saved on the website although they are saved in the backend. New articles are being created.

I feel like an idiot right now. Am I the only one with those problems?

Bloke · 2013-09-10 12:36:31

datorhaexa

Unlikely to be you: it’s the code!

If it’s not working on a new installation with no other plugins installed, then it’s likely the plugin isn’t set up to work with the PHP / MySQL version you’re using. Since it’s a XAMPP install I won’t be able to log in and test it, but if you can let me know as much as possible about your environment it’d help — both your local one and the server you originally found the problem on.

If it’s at all possible to grant me a login to the server it’s happening on (even a Txp login would be fine for now) then I might be able to figure out what’s going on. Thanks.

datorhaexa · 2013-09-10 19:05:22

Stef, after two consecutive installs from scratch, ~~it finally worked on the xampp~~ . I don’t know what has changed as I followed the same procedure each time: new TXP install, MLP official, ran the install and it could not create the two language tables:

Add the per-language article tables… Add the English [l10n_txp_en_gb] table : Failed Add the Deutsch [l10n_txp_de_de] table : Failed

(Although when I looked into the DB the tables were there, if I recall right.)

..then I rewrote files with yours, copied the php code for each plugin file and edited them by replacing all. The last time I did that, I did changes to an article and it worked.

It bothers me that I can’t reproduce the problem because there most certainly is something but it might be caused by the fact that that there are too many procedures of changes to the MLP.

I plan on using your plugin maker to export what I have tomorrow and install on a copy of the website in question and see if it flies. If not, I’ll set up a login for you on the website and send.

P.S. Nothing has changed — still not saving changes. The above short-lived joy was based on forgotten activation of plug-ind. Doh!

Last edited by datorhaexa (2013-09-11 09:52:21)

datorhaexa · 2013-09-11 12:02:57

Ok folks, after all the mess with several installs, I’ve missed the fix-on-the-fix. Things work now. Stef, thanks a lot!!!!!

ru · 2013-09-23 21:02:13

Gocom wrote:
For multilingual databases you should be using multiple different collations

Bloke wrote:
Oops, well spotted, thanks. Everyone ignore what I said earlier about collations (I edited the posts anyway). Just make sure the field types match.

hey there,
i am trying to get the sort order (sort by title) right for german but failed.
from what i have read i need to set the collation for l10n_txp_de_de to latin1_german1_ci, is this true?
unfortunately it does not produce the expectet result :(

i am using a pretty old version of mlp 4.3.0 with txp 4.4.1, i know it has bugs but don’t want to upgrade…
i hope its not related to the temp table created by mlp while doing the queries

could someone please push me into the right direction?

cheers

jstubbs · 2013-10-04 02:27:35

Just updated an old 4.2.0 site with 4.5.4 and MLP from Github – all ok and working, just see one error on screen:

Parse error: syntax error, unexpected '<' in /var/www/vhosts/domain.com/httpdocs/old/textpattern/lib/txplib_misc.php(812) : eval()'d code on line 1 The above errors were caused by the plugin:l10n

That’s after overwriting the old l10n.php and gbp_admin_library.php plugins with the code from Github. Any ideas on this?

Bloke · 2013-10-04 10:37:17

jstubbs wrote:

Parse error: syntax error, unexpected ‘<’

At a gues I’d say don’t paste in the <?php part of the plugin source code. Just copy and paste everything between the # --- BEGIN PLUGIN CODE --- and # --- END PLUGIN CODE --- markers.

Gocom · 2013-10-04 11:23:07

ru wrote:

from what i have read i need to set the collation for l10n_txp_de_de to latin1_german1_ci, is this true?

The content is in UTF-8, so you shouldn’t be using Latin1. You will have to change both the table and its columns to utf8_german_ci, or to any other Language that uses same alphabet as German.

ru · 2013-10-04 16:40:30

Gocom wrote:

The content is in UTF-8, so you shouldn’t be using Latin1. You will have to change both the table and its columns to utf8_german_ci, or to any other Language that uses same alphabet as German.

thank you for your answer – i recognized somebody added a space as first char at this particular article….
removing the space resolved the problem. :)

jstubbs · 2013-10-05 09:13:40

Bloke wrote:

At a gues I’d say don’t paste in the <?php part of the plugin source code. Just copy and paste everything between the # --- BEGIN PLUGIN CODE --- and # --- END PLUGIN CODE --- markers.

Mmm, thanks, but didn’t work! Must be something simple, can’t see it yet.

Textpattern CMS

Textpattern CMS support forum

#2266 2013-09-09 18:36:00

Re: MLP - The Multi-Lingual Publishing Pack

#2267 2013-09-09 19:28:10

Re: MLP - The Multi-Lingual Publishing Pack

#2268 2013-09-09 19:34:28

Re: MLP - The Multi-Lingual Publishing Pack

#2269 2013-09-10 00:02:09

Re: MLP - The Multi-Lingual Publishing Pack

#2270 2013-09-10 08:14:28

Re: MLP - The Multi-Lingual Publishing Pack

#2271 2013-09-10 11:08:04

Re: MLP - The Multi-Lingual Publishing Pack

#2272 2013-09-10 12:36:31

Re: MLP - The Multi-Lingual Publishing Pack

#2273 2013-09-10 19:05:22

Re: MLP - The Multi-Lingual Publishing Pack

#2274 2013-09-11 12:02:57

Re: MLP - The Multi-Lingual Publishing Pack

#2275 2013-09-23 21:02:13

Re: MLP - The Multi-Lingual Publishing Pack

#2276 2013-10-04 02:27:35

Re: MLP - The Multi-Lingual Publishing Pack

#2277 2013-10-04 10:37:17

Re: MLP - The Multi-Lingual Publishing Pack

#2278 2013-10-04 11:23:07

Re: MLP - The Multi-Lingual Publishing Pack

#2279 2013-10-04 16:40:30

Re: MLP - The Multi-Lingual Publishing Pack

#2280 2013-10-05 09:13:40

Re: MLP - The Multi-Lingual Publishing Pack

Board footer