Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1885 2011-11-29 14:20:17

eequ
New Member
From: Germany
Registered: 2011-11-29
Posts: 3
Website

Re: MLP - The Multi-Lingual Publishing Pack

hello everyone,

i have build a website with two languages german (de-de) and english (en-gb). every time i clone and save articles for each language the following message appears underneath:

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`= in /homepages/28/d126913799/htdocs/textpattern/lib/txplib_db.php on line 113

what happens now, is that only the english articles disappear. the only really unhandy solution i have found so far is to delete and re-enter the languages in the mlp preferences every time i create articles. after doing so the english articles re-appear.

does someone know how i can get rid of this problem?

info:
txp 4.4.1 (r3575)
mlp-0.9.13-gp

Offline

#1886 2011-11-29 20:37:30

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: MLP - The Multi-Lingual Publishing Pack

eequ wrote:

txp 4.4.1 (r3575)
mlp-0.9.13-gp

You need mlp-4.3.0.12, normally available from http://txpforge.org/projects/list_files/mlp, but it seems to be down at the moment. Temporarily available here.

Offline

#1887 2011-11-30 10:00:56

eequ
New Member
From: Germany
Registered: 2011-11-29
Posts: 3
Website

Re: MLP - The Multi-Lingual Publishing Pack

hi els,

thanks for the quick reply. i will look into it.

update: it works!!! thanks a lot.

Last edited by eequ (2011-11-30 10:15:33)

Offline

#1888 2011-12-03 11:48:54

Exiladler
Member
From: somewhere in Europe
Registered: 2006-08-20
Posts: 56
Website

Re: MLP - The Multi-Lingual Publishing Pack

Hi,

Just a small question, I am using rss_auto_excerpt and within this is a hardcoded ‘keep reading …’ which as a temporary measure I have changed to

‘linktext’ => ‘more/más/mehr…’,

but I was wondering if there is any way to include a snippet within the code so I don’t have to add other languages and can have just the correct language one displayed.

Offline

#1889 2011-12-03 13:11:53

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: MLP - The Multi-Lingual Publishing Pack

Can’t you use the attribute linktext="##snippet##"?

Offline

#1890 2011-12-03 15:24:12

Exiladler
Member
From: somewhere in Europe
Registered: 2006-08-20
Posts: 56
Website

Re: MLP - The Multi-Lingual Publishing Pack

where do I then find the snippet? I searched for it without success using ##readmore##

Offline

#1891 2011-12-03 18:08:57

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: MLP - The Multi-Lingual Publishing Pack

If it doesn’t already exist you need to use it somewhere to create it. So if you use ##readmore## as the value for linktext, you will find the snippet in MLP > snippets and can then add the translations.

Offline

#1892 2011-12-03 18:21:52

Exiladler
Member
From: somewhere in Europe
Registered: 2006-08-20
Posts: 56
Website

Re: MLP - The Multi-Lingual Publishing Pack

Thanks Els, but it is not working. I added ##readmore## to an unused form and then translated the snippet but when I check the page, it just shows the snippet name and not the translation. Here are the definitions withon the Plug in:

function rss_auto_excerpt($atts) { global $thisarticle;

extract(lAtts(array( ‘linkwraptag’ => ‘p’, ‘linkclass’ => ‘’, ‘linklabel’ => ‘’, ‘linktext’ => ‘##readmore##’, ‘excerptwraptag’ => ‘’, ‘length’ => 0, ‘words’ => 0, ‘sentences’ => 0, ‘paragraphs’ => 0, ‘skiplength’ => 0, ‘skipwords’ => 0, ‘skipsentences’ => 0, ‘skipparagraphs’ => 0, ‘ending’ => ‘…’, ‘showlinkwithbody’ => 0, ‘showlinkwithexcerpt’ => 1, ‘overrideexcerpt’ => 0, ‘striptags’ => 0, ‘stripbreakstabs’ => 0, ‘wrapreadmore’ => 0, ‘excerpt’ => ‘excerpt’, ‘body’ => ‘body’, ),$atts));

Could the ‘ marks be the issue as it encases the text or does the plugion simply not work with MLP?

Offline

#1893 2011-12-03 18:47:28

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: MLP - The Multi-Lingual Publishing Pack

Strange, I just tested it, and it started working for me when I added override_excerpt="1".
This is the tag that is working:

<txp:rss_auto_excerpt words="3" override_excerpt="1" linktext="##readmore##" />

Last edited by els (2011-12-03 18:49:01)

Offline

#1894 2011-12-03 18:55:18

Exiladler
Member
From: somewhere in Europe
Registered: 2006-08-20
Posts: 56
Website

Re: MLP - The Multi-Lingual Publishing Pack

<txp:rss_auto_excerpt words=“40” override_excerpt=“1” />

still no working

I get ##readmore##

Confused, l10n version 4.3.0.12

All other MLP functionality works perfectly ….

Offline

#1895 2011-12-03 19:07:27

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: MLP - The Multi-Lingual Publishing Pack

Oh, sorry, that was really dumb… it’s not override_excerpt, but overrideexcerpt. But, surprise, I removed the attribute, so that I now just have

<txp:rss_auto_excerpt words="3" linktext="##readmore##" />

…and it still works! Did you try to clear the browser cache?

Offline

#1896 2011-12-03 23:26:06

Exiladler
Member
From: somewhere in Europe
Registered: 2006-08-20
Posts: 56
Website

Re: MLP - The Multi-Lingual Publishing Pack

Els,

I did clear Cache and checked using different browsers BUT that last fix worked, now it works a treat, THANKS

Offline

Board footer

Powered by FluxBB