MLP - The Multi-Lingual Publishing Pack

the_ghost · 2008-11-02 17:21:22

Have some error:

Warning: 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 ‘’ at line 1 select * from department_l10n_articles as l10n_articles where `ID`= textpattern/lib/txplib_db.php:237 getRow() in /home/u78707/rusx.org/www/textpattern/lib/txplib_db.php on line 117

Warning: Table ‘u78707.department_department_l10n_txp_en_us’ doesn’t exist delete from department_department_l10n_txp_en_us where `ID`=‘71’ textpattern/lib/l10n_admin.php:680 safe_delete() in /home/u78707/rusx.org/www/textpattern/lib/txplib_db.php on line 117

Error occures when trying to save english redimption of article. The steps where such:

cloned russion redimption to english
opened for editing
clicked “Save” and after page reloading errors appeared in the bottom of the page

It seems the problem is that by some reason table prefix is doubled (department_department_l10n_txp_en_us instead of department_l10n_txp_en_us) in second query

Last edited by the_ghost (2008-11-02 17:29:10)

net-carver · 2008-11-03 07:17:00

Victor

Can you get in contact with a few more details … like your txp diagnostics (low setting will do). I’ll see what I can do to fix this as it looks like an MLP bug.

Thank you.

the_ghost · 2008-11-03 07:56:01

Sent message with full diagnostic.

Another question – is it possible to make link when we are in individual_article so, that even if there is no english redimption of article, the link will be built like if it was but will follow to my custom 404 page? I want this to show message like “Sorry, the translation isn’t avaible yet.”

net-carver · 2008-11-03 08:09:53

Victor

Thanks, got it. Will handle this by email now.

Regarding your second question: Just add show_empty="1" to your l10n_lang_list tag.

the_ghost · 2008-11-03 08:35:47

I think another problem of my site is that some links are built not by context, but by custom_field Podmenu:
<txp:article_custom Podmenu='<txp:article_id />' limit="99" sort="position asc"> This builds sub-article article list. I really stucked.

els · 2008-11-03 21:53:25

Maybe I should post this in the string exchange thread, but I’m not sure if it’s meant for that. So here goes:
Does anyone have the Portuguese (pt-pt) strings for zem_contact_lang-mlp?

otti · 2008-11-04 07:59:16

Hi net-caerver,

I have just installed your MLP on a test site to sort everything out before I install on a clients live site. All went smooth – and your video really helps. My renditions are created as they should, but I don’t see a language picker on the TXP test site. In your video it states that the 10n_lang_list tag should be inserted, but apparently it wasn’t in my case. Is there a way to activate it? I looked into the MLP preferences but could not find it. I have TXP 4.0.6 (r2805) installed with PHP 4.4.8.
Your help is very much appreciated

Cheers
otti

the_ghost · 2008-11-04 11:27:12

net-carver wrote:

Victor
Thanks, got it. Will handle this by email now.

Just tried again with removing prefix from tables. Unsitalled MLP, reuploaded files, installed it again. Second error after resaving disappered, but the first still exists.

Warning: 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 '' at line 1 select * from l10n_articles where `ID`= textpattern/lib/txplib_db.php:237 getRow() in /home/u78707/rusx.org/www/textpattern/lib/txplib_db.php on line 117

And this occures every time i try to save any rendition – newly cloned from russian to english or the old russian article, whic was created before mlp pack installed

P.S. tried just now to install pack on totally another hostng – the same trouble with double prefix and with error i wrote above.

Hope this help you.

Last edited by the_ghost (2008-11-04 11:39:15)

net-carver · 2008-11-05 08:53:44

otti wrote:

I have just installed your MLP on a test site to sort everything out before I install on a clients live site. All went smooth – and your video really helps. My renditions are created as they should, but I don’t see a language picker on the TXP test site. In your video it states that the 10n_lang_list tag should be inserted, but apparently it wasn’t in my case. Is there a way to activate it? I looked into the MLP preferences but could not find it. I have TXP 4.0.6 (r2805) installed with PHP 4.4.8.
Your help is very much appreciated

Hello Otti

the MLP Pack only tries to insert tags into the default Txp forms from a virgin Txp install. Presumably your test site is a clone of your client’s live site and isn’t using the default pages and forms so it didn’t get the l10n_lang_list tag inserted. If that’s the case, you’ll need to choose where to put it. Just add…

<txp:l10n_lang_list />

…in a suitable place in your page(s) or form(s). Very simple.

the_ghost · 2008-11-06 08:38:50

How do i make this code output right article list, according that id i set is id of article, not current language rendition:
1. <txp:article_custom id="2" limit="99"><txp:l10n_permlink /></txp:article_custom>
Is my use of l10n_permlink right?

Last edited by the_ghost (2008-11-06 08:40:00)

otti · 2008-11-09 00:55:03

Hi net-carver,

thanks for the info. I inserted the tag in my pages and it worls now.
Thanks again for this excellent plugin.

Cheers
otti

net-carver · 2008-11-09 13:59:24

All

The latest dev snapshot is “delayed.”

This one will have these fixes…

compatibility with version 4.0.7 of txp
compatibility with the change to txplib_db.php
a bug in my SQL that Els and the_ghost found (probably others too.)
Els’ string editing bug
Els’ double line spacing problem with exported stringsets.

Improves…

Admin side localisation of category/section names (but this is still incomplete)
version numbering: updated to v0.9.x to avoid problems with confusing 0.8.x series version numbers.

And adds…

new tag: l10n_get_rendition_id
new indexes to the articles’ language & group columns in the DB

This version should work as-is with txp 4.0.6 stable.

Best regards,

Last edited by net-carver (2008-12-06 19:45:06)

els · 2008-11-09 17:18:22

Thank you :)

For those who don’t want to search the thread yet again for upgrade instructions: here they are. This time I’ve copied them to a form in my MLP install ;) and for myself added one more action (posting this in case there are others who are doing this as well): in l10n_langs.php change English (GB) to English.

els · 2008-11-09 22:20:04

net-carver wrote:

compatibility with the SVN version of txp

For those working with the latest SVN versions: don’t go higher than r2989. r2990 is breaking this again.
(I already mailed Steve about this.)

Edit: can easily be solved by adding a new column ‘Expires’ to the l10n_txp_(language code) tables. I added them after ‘Posted’, with the same prefs as the ‘Expires’ column in the textpattern table.

Last edited by els (2008-11-09 22:56:06)

net-carver · 2008-11-09 23:48:47

All

what do you know :) I’ll be releasing 0.9.10 pretty soon. Thank you for spotting that change Els.

Textpattern CMS

Textpattern CMS support forum

#1036 2008-11-02 17:21:22

Re: MLP - The Multi-Lingual Publishing Pack

#1037 2008-11-03 07:17:00

Re: MLP - The Multi-Lingual Publishing Pack

#1038 2008-11-03 07:56:01

Re: MLP - The Multi-Lingual Publishing Pack

#1039 2008-11-03 08:09:53

Re: MLP - The Multi-Lingual Publishing Pack

#1040 2008-11-03 08:35:47

Re: MLP - The Multi-Lingual Publishing Pack

#1041 2008-11-03 21:53:25

Re: MLP - The Multi-Lingual Publishing Pack

#1042 2008-11-04 07:59:16

Re: MLP - The Multi-Lingual Publishing Pack

#1043 2008-11-04 11:27:12

Re: MLP - The Multi-Lingual Publishing Pack

#1044 2008-11-05 08:53:44

Re: MLP - The Multi-Lingual Publishing Pack

#1045 2008-11-06 08:38:50

Re: MLP - The Multi-Lingual Publishing Pack

#1046 2008-11-09 00:55:03

Re: MLP - The Multi-Lingual Publishing Pack

#1047 2008-11-09 13:59:24

Re: MLP - The Multi-Lingual Publishing Pack

#1048 2008-11-09 17:18:22

Re: MLP - The Multi-Lingual Publishing Pack

#1049 2008-11-09 22:20:04

Re: MLP - The Multi-Lingual Publishing Pack

#1050 2008-11-09 23:48:47

Re: MLP - The Multi-Lingual Publishing Pack

Board footer