Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#2473 2018-08-15 14:54:40

From: Mariupol, Ukraine
Registered: 2011-01-30
Posts: 43

Re: MLP - The Multi-Lingual Publishing Pack

I had a problem with the snippets in 4.7.1. In one of the two languages, no text was output.

In the file textpattern/publish.php you need to fix it

if (txpinterface !== 'css') {

for this

if (txpinterface !== 'css') {
    $textarray = load_lang(LANG);


#2474 2018-08-24 08:06:47

Plugin Author
From: Germany
Registered: 2008-06-29
Posts: 220

Re: MLP - The Multi-Lingual Publishing Pack

Sorry for my late reply and thank you so much for adapting the plugin to 4.7.1. I will soon setup the plugin in a new website running on latest textpattern and will post here about my experience with MLP. About what you mentioned earlier in a post…the different language codes… I have read about it in this one or another thread but cannot remember exactly what it was all about. But I THINK it is not a mistake…


#2475 2018-09-18 13:06:33

Plugin Author
From: France
Registered: 2008-07-24
Posts: 860

Re: MLP - The Multi-Lingual Publishing Pack

demoncleaner wrote #313236:

The problem that remains is now for whatever reason I cannot access to sections detail page and to Renditions page as soon as MLP is up and running.

Is there a known fix to this issue?
After upgrading I can’t access to the following tabs:

  • Contents:
    • Renditions;
    • Images;
    • File edit;
    • Links;
    • Category edit.
  • Presentation:
    • Section edit.

They are just blank.
The language switcher on the top right corner also break the layout by pushing each tab contents on the left.

I will try to update one more time and maybe take a look at the code if needed…

Edit: I also get no articles in the public side article lists and multiple error messages like:

Tag error: <txp:article_custom section="a-propos" id="3, 4, 5" wraptag="ul" class="dropdown" break="li"><txp:permlink><txp:title /></txp:permlink></txp:article_custom> ->  Textpattern Error: 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 'AND (from_unixtime(2147483647) <= Expires OR Expires IS NULL) AND ID  IN (3,4,5)' at line 1 while parsing form vsv_found_topbar on page vsv_found_magazine

textpattern/lib/txplib_db.php:418 trigger_error()
textpattern/lib/txplib_db.php:1162 safe_query()
textpattern/lib/txplib_db.php:1004 startRows()
textpattern/publish.php:850 safe_rows_start()
textpattern/publish.php:971 doArticles()
textpattern/publish.php:960 parseArticles()
textpattern/vendors/Textpattern/Tag/Registry.php:116 call_user_func()
textpattern/lib/txplib_publish.php:547 Textpattern\Tag\Registry->process()
textpattern/lib/txplib_publish.php:471 processTags()

Last edited by NicolasGraph (2018-09-19 09:01:05)

Follow me on Twitter and GitHub!
Multiple edits are usually to correct my frenglish…


#2476 2018-12-30 16:23:47

Registered: 2012-12-18
Posts: 59

Re: MLP - The Multi-Lingual Publishing Pack

I have issues after having MLP disabled for a while and now I re-enabled it and the content created in the meantime is not displayed at all. I assume I have to fix these articles somehow, could someone point me at how to proceed here?


#2477 2019-01-24 12:27:11

From: Münster, Germany
Registered: 2006-10-09
Posts: 153

Re: MLP - The Multi-Lingual Publishing Pack

So, any news on compatibility of MLP and 4.7.x?

I had to upgrade most of my sites to 4.7.x due to PHP issues, but that means I can’t activate MLP any more.

Anybody who might be able to help spiridon out here?



#2478 2021-09-17 19:17:22

Plugin Author
From: Woodbridge, VA
Registered: 2008-06-01
Posts: 999

Re: MLP - The Multi-Lingual Publishing Pack


I want to export my MLP content using MySQL so that each database record includes all the information for the article across all renditions, without any duplicate fields. Can anyone suggest a SQL query that can do this?

Since I have renditions in English (en-us) and Spanish (es-es), I see four possibly-relevant tables in the database, but I don’t understand how exactly to connect the data I want:

| l10n_articles                    |
| l10n_txp_en_us                   |
| l10n_txp_es_es                   |
| textpattern                      |

For output, what I think would be most useful is a table with one row per article, and pairs of fields for English and Spanish content. For example, I might have Title_en, Title_html_en, Title_html_es, Body_en, Body_es, Body_html_en, Body_html_es, and so on.

If there is a smarter way to combine the data so that 1 record contains both the English and Spanish content, of course I’d love to hear that too.

Thank you in advance!

Last edited by johnstephens (2021-09-17 20:54:58)


#2479 2022-12-02 14:11:30

Registered: 2009-11-18
Posts: 99

Re: MLP - The Multi-Lingual Publishing Pack

Can this branch (v4.8.1.tables2views) of MLP safely be used to upgrade a Txp 4.5.x to Txp 4.8.x?

Last edited by element (2022-12-02 14:13:08)


Board footer

Powered by FluxBB