Textpattern CMS

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

sgw

Member

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

funtoosh

Member

From: Münster, Germany

Registered: 2006-10-09

Posts: 153

Website

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?

Cheers,
-f

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

johnstephens

Plugin Author

From: Woodbridge, VA

Registered: 2008-06-01

Posts: 1,000

Website

Re: MLP - The Multi-Lingual Publishing Pack

Hi!

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

element

Member

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)