MLP - The Multi-Lingual Publishing Pack

els · 2011-06-20 20:33:33

John, this simple example works for me:

<ul>
<txp:smd_query
	column="Title"
	table="l10n_txp_en_gb"
	where="section='my-section'"
	limit="3"><li>{Title}</li>
</txp:smd_query>
</ul>

Maybe you can strip your attributes and/or tags one by one and see where it starts working.

Edit: if I change that to

<ul>
<txp:smd_query
	column="Title"
	table="textpattern"
	where="section='my-section' AND l10n_lang='en-gb'"
	limit="3"><li>{Title}</li>
</txp:smd_query>
</ul>

it stops working! So start with changing

	table="textpattern"
	where="section = 'my-blog-section' AND l10n_lang = 'en-us'"

to

	table="l10n_txp_en_us"
	where="section = 'my-blog-section'"

Last edited by els (2011-06-20 20:40:25)

johnstephens · 2011-06-21 15:43:43

Thank you, Els! This works for me. I’ll try re-adding the populate="article" to see if that works with this configuration.

michaelb · 2011-07-04 10:02:23

Hi, I have recently upgraded to Txp 4.4.0 & MLP 4.3.0.12.

As far as I know I followed the upgrade procedures exactly, but now:

When I go to the Renditions tab, I get as string of messages concerning the txp_section table such as:

Warning: Unknown column ‘l10n_title_en_gb’ in ‘field list’ select `l10n_title_en_gb` as `title` from txp_section where name=‘attributes-of-mastery’ in /home/eeiwor01/public_html/textpattern/lib/txplib_db.php on line 113

Warning: Unknown column ‘l10n_title_en_gb’ in ‘field list’ select `l10n_title_en_gb` as `title` from txp_section where name=‘copyrights-disclaimers’ in /home/eeiwor01/public_html/textpattern/lib/txplib_db.php on line 113

.
.
.

etc.

When I go to the Write tab, or edit a rendition it’s a similar couple of errors but this time for the txp_category table:

Warning: Unknown column ‘l10n_title_en_gb’ in ‘field list’ select id, name, lft, rgt, parent, `l10n_title_en_gb` as `title` from txp_category where lft between 1 and 2 and type = ‘article’ and name != ‘root’ and 1=1 order by lft asc in /home/eeiwor01/public_html/textpattern/lib/txplib_db.php on line 113

I then took a look at the txp_section and txp_category tables, and they have a l10n_title_en_us column, not a l10n_title_en_gb column. I think is what I’d expect – the l10n_title_en_us – as en-us is set up as the default language.

Anyway, any help to know how to fix this would be appreciated!

johnstephens · 2011-07-04 13:44:22

@michaelb, It sounds like you replaced the MLP-modified txplib_db.php with the file in the TXP upgrade package. In non-MLP Textpattern installations, that’s exactly what you should do when you upgrade. However, MLP needs to use a patched version of the file in order to function. In order to get MLP working just revert that file to its pre-upgrade version— if you don’t have it, you can find it in the latest MLP download package. I hope this helps!

michaelb · 2011-07-04 14:02:17

Hi John – thanks very much for the advice.

However, the txplib_db.php file I am using is from the \mlp-4.3.0.12\textpattern\lib\ folder that I downloaded for the latest version of MLP. I reuploaded it just to be sure, and still get the same errors.

Something I find odd is that the error message mentions …en_gb…, but we are using en_us as our default language, so I’m not sure where MLP is picking that up from.

datorhaexa · 2011-07-28 10:25:26

I posted a question at the rah_sitemap plugin thread and will shove it here once again, because it’s relevant (I think).

Did anyone manage to get rah_sitemap working with MLP? I got the URL re-writes configuration right but now I get a sitemap of only the default language and the second one is simply ignored.

johnstephens · 2011-07-28 15:08:25

I could not— I used jmd_sitemap_mlp. It’s not as flexible rah_sitemap, but it works.

datorhaexa · 2011-07-28 15:26:11

johnstephens wrote:

I could not— I used jmd_sitemap_mlp. It’s not as flexible rah_sitemap, but it works.

Ah! Thanks a lot, John! I will give it a go. It’s a shame it actually works with one language but refuses to output the other.

mare · 2011-08-02 21:55:12

Hi everyone,
I am new in TXP and I am running out of ideas for my installation of MLP.
Everything passed well in MLP Pack Setup Report but for one thing – Add the `txp_lang.l10n_owner` field : Failed.
Nothing I have tried (re installation of both TXP and MPL, deleting/re-creating tables – with prefixes, following steps for installation of MLP, etc.) seems to fix this problem.
I have all latest versions, 4.4.1 for TXP and 4.3.0.12 for MLP.

Some info from diagnostics tab:

MySQL: 5.0.77-community-nt
Locale: English_United Kingdom.1252
Server: Microsoft-IIS/6.0
PHP Server API: isapi
RFC 2616 headers:
Server OS: Windows NT 5.2
Active plugins: zem_contact_reborn-4.0.3.20, zem_contact_lang-mlp-4.0.3.6-MLP.11, l10n-4.3.0.12, gbp_admin_library-0.4.1
Admin-side theme: classic 4.4.1

————————————

Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: utf8
character_set_filesystem: binary
character_set_results: utf8
character_set_server: utf8
character_set_system: utf8
character_sets_dir: C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\
17 Tables: OK

10 Custom Fields: custom_1, custom_2, custom_3, custom_4, custom_5, custom_6, custom_7, custom_8, custom_9, custom_10 (10)

PHP extensions: bcmath, calendar, com_dotnet/0.1, ctype, session, filter/0.11.0, ftp, hash/1.0, iconv, json/1.2.1, odbc/1.0, pcre, Reflection/0.1, date/5.2.5, libxml, standard/5.2.5, tokenizer/0.1, zlib/1.1, SimpleXML/0.1, dom/20031129, SPL/0.2, wddx, xml, xmlreader/0.1, xmlwriter/0.1, ISAPI, curl, gd, mbstring, mcrypt, mysql/1.0, mysqli/0.1, PDO/1.0.4dev, pdo_mysql/1.0.2

Thanks.

maruchan · 2011-08-02 22:09:02

Looking at the code, I would make sure you’re using utf8_general_ci in your DB, because that’s what the MLP database functions appear to be using.

els · 2011-08-02 22:31:53

maruchan wrote:

Looking at the code, I would make sure you’re using utf8_general_ci in your DB, because that’s what the MLP database functions appear to be using.

mare wrote:

Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: utf8
character_set_filesystem: binary
character_set_results: utf8
character_set_server: utf8
character_set_system: utf8

That part of my MLP sites’ diagnostics looks exactly the same and they are working fine. This though:

Server: Microsoft-IIS/6.0

might be more of a problem. I remember there has been at least one earlier mention of MLP not working on IIS.

Or is your site in a subdirectory? If so, try installing it in the root or a subdomain. MLP doesn’t work properly on sites in subdirectories.

mare · 2011-08-02 23:18:14

maruchan wrote:

Looking at the code, I would make sure you’re using utf8_general_ci in your DB, because that’s what the MLP database functions appear to be using.

I am using utf8_general_ci.

elswrote:

That part of my MLP sites’ diagnostics looks exactly the same and they are working fine.
This though: Server: Microsoft-IIS/6.0
might be more of a problem. I remember there has been at least one earlier mention of MLP not working on IIS.
Or is your site in a subdirectory? If so, try installing it in the root or a subdomain. MLP doesn’t work properly on sites in subdirectories.

Site is in top level domain in main directory.
I will change my hosting server to Linux then.

Thank you all for quick response, I appreciate it.

Textpattern CMS

Textpattern CMS support forum

#1825 2011-06-20 20:33:33

Re: MLP - The Multi-Lingual Publishing Pack

#1826 2011-06-21 15:43:43

Re: MLP - The Multi-Lingual Publishing Pack

#1827 2011-07-04 10:02:23

Re: MLP - The Multi-Lingual Publishing Pack

#1828 2011-07-04 13:44:22

Re: MLP - The Multi-Lingual Publishing Pack

#1829 2011-07-04 14:02:17

Re: MLP - The Multi-Lingual Publishing Pack

#1830 2011-07-28 10:25:26

Re: MLP - The Multi-Lingual Publishing Pack

#1831 2011-07-28 15:08:25

Re: MLP - The Multi-Lingual Publishing Pack

#1832 2011-07-28 15:26:11

Re: MLP - The Multi-Lingual Publishing Pack

#1833 2011-08-02 21:55:12

Re: MLP - The Multi-Lingual Publishing Pack

#1834 2011-08-02 22:09:02

Re: MLP - The Multi-Lingual Publishing Pack

#1835 2011-08-02 22:31:53

Re: MLP - The Multi-Lingual Publishing Pack

#1836 2011-08-02 23:18:14

Re: MLP - The Multi-Lingual Publishing Pack

Board footer