MLP - The Multi-Lingual Publishing Pack

slabanosa · 2012-01-31 21:53:56

ok, now the bug’s talking to me

Tag error: <txp:article searchform="search_results" searchsticky="1"/> -> Textpattern Warning: Can't find FULLTEXT index matching the column list select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod, match (`Title`, `Body`) against ('ticket') as score from l10n_txp_en_gb where 1=1 and Status >= 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (`Title` like '%ticket%' or `Body` like '%ticket%') and Section != 'search' and Section != 'today' order by score desc limit 0, 10 textpattern/lib/txplib_db.php:258 startRows() on line 113

textpattern/lib/txplib_db.php:113 trigger_error()
textpattern/lib/txplib_db.php:323 safe_query()
textpattern/lib/txplib_db.php:258 startRows()
textpattern/publish.php:815 safe_rows_start()
textpattern/publish.php:964 doArticles()
textpattern/publish.php:592 parseArticles()
textpattern/publish.php:1188 article()
textpattern/publish.php:1100 processTags()
textpattern/publish.php:538 parse()
index.php:45 textpattern()

section Today and search mentioned above are not searchable… puzzled

Last edited by slabanosa (2012-01-31 21:55:00)

els · 2012-01-31 22:12:09

I found this topic, does it help you?

slabanosa · 2012-02-01 10:51:57

certainly helps understanding what is happening, thank you, now to fix this is going to be tough on me ;-)

slabanosa · 2012-02-01 14:14:21

As per a hint our dear Els provided earlier in this thread I have ran the cleanup wizard (without checking the boxes under 3. and 4.), and then run the Setup wizard again. The search is working again and everything else seems to be working too :-)) … but as soon as wet_haystack is configured it will go havock again spitting out:

<txp:article searchform="search_results" searchsticky="1"/> -> Textpattern Warning: Can't find FULLTEXT index matching the column list select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod, match (`Title`, `Body`, `Keywords`, `custom_1`, `custom_2`, `custom_5`, `custom_7`, `custom_9`) against ('future') as score from l10n_txp_en_gb where 1=1 and Status >= 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (`Title` like '%future%' or `Body` like '%future%' or `Keywords` like '%future%' or `custom_1` like '%future%' or `custom_2` like '%future%' or `custom_5` like '%future%' or `custom_7` like '%future%' or `custom_9` like '%future%') and Section != 'search' and Section != 'today' order by score desc limit 0, 10
textpattern/lib/txplib_db.php:258 startRows() on line 113

Uninstalling wet_haystack won’t fix things, you have to go back to an earlier db, or run the scary process of launching the wizard over a zillion existing articles.

It’s been a hot and sweaty winter day but it looks now like I’m through with my troubles and I can live without wet_haystack although it would have been nice to have its functionalities. Thanks to Els again for the constant help she provides.

Last edited by slabanosa (2012-02-01 14:16:35)

wet · 2012-02-01 15:08:33

wet_haystack does not perform anything magic. It just adds a fulltext index to the textpattern table and sets the searchable_article_fields preference. As MLP apparently does not use said table for articles but its own for each language, full-text search no longer works.

You can work around this limitation by issuing a few one-time SQL queries. If you are interested, I can help with these. I believe you’d better wait for a cooler day, though ;)

Destry · 2012-02-05 23:23:35

I know I should know this, but is there a decent URL to give somebody who is interested in learning about MLP (or any multilingual publishing trick)…besides this thread? Everything that’s high in Google ranks is old net-carver locations from like 2007-8. The old demo isn’t even online.

How do we sell multilingual publishing with Textpattern? What’s the definitive link to give people who want to know what exists, however little or great?

slabanosa · 2012-02-05 23:47:12

I’m surprised nobody jumped on the bandwagon following Robert’s offer, the timing may not be right for me and I’m a code moron and just an occasional web-mason but the one thing that always drags me back to txp is how much curiosity it arrouses in me and it would be great to trick MLP to play nice with wet_haystack

@Destry I’ll let you know when My Little Pony comes online, however little …

Destry · 2012-02-05 23:56:51

@slabanosa: I’ll keep a watch for it.

Okay, I remembered this thread from Els. The TXP Forge link doesn’t seem to be responding.

I guess that’s the best there is at this point?

I’m just curious because I want to promote a link in a mag article and I’m reluctant to do so with no decent link to provide.

els · 2012-02-06 00:12:00

Hmm… txpforge.org is down quite often… Graeme needs to upgrade his hosting. It contains the downloads (MLP itself, the language strings that can also be found here, some plugins adapted for MLP), a bug/issue tracker and a “wiki” with, for now, just the system requirements and instructions on installation and upgrading.
All other kind of information can still only be “found” in this thread… I had plans to expand the wiki, moving knowledge from here to over there, but I haven’t found the time yet.

Destry · 2012-02-06 00:27:24

So what we need is a proper MLP demo site and somebody to put some writing and design time into it for marketing reasons. Does that sound right?

If so, maybe we have our first ever reason for another subdirectory on textpattern.net, mlp.textpattern.net? Put in a Textpattern install there, add MLP and I can help write content for demo reasons. Somebody else could do another language or three. And somebody else can do some design.

Last edited by Destry (2012-02-06 00:34:54)

els · 2012-02-06 00:35:29

Destry wrote:

… for marketing reasons.

I think I’ve said this before: I don’t see much use in marketing (or updating documentation) for a product that actually is hardly being maintained anymore…

Destry · 2012-02-06 00:47:52

If MLP is not being maintained, then that’s a different matter, and I would agree it’s not worth bothering with a demo site.

To anyone,

Is that the reality of things, then…Textpattern CMS does not provide multilingual publishing? That’s a legitimate question, with respect to CMS features that make a system attractive against the competition, and it needs an honest answer. If the answer is no, then I won’t be promoting it in project side content…wiki, mag, wherever…until the situation should ever change.

Textpattern CMS

Textpattern CMS support forum

#1909 2012-01-31 21:53:56

Re: MLP - The Multi-Lingual Publishing Pack

#1910 2012-01-31 22:12:09

Re: MLP - The Multi-Lingual Publishing Pack

#1911 2012-02-01 10:51:57

Re: MLP - The Multi-Lingual Publishing Pack

#1912 2012-02-01 14:14:21

Re: MLP - The Multi-Lingual Publishing Pack

#1913 2012-02-01 15:08:33

Re: MLP - The Multi-Lingual Publishing Pack

#1914 2012-02-05 23:23:35

Re: MLP - The Multi-Lingual Publishing Pack

#1915 2012-02-05 23:47:12

Re: MLP - The Multi-Lingual Publishing Pack

#1916 2012-02-05 23:56:51

Re: MLP - The Multi-Lingual Publishing Pack

#1917 2012-02-06 00:12:00

Re: MLP - The Multi-Lingual Publishing Pack

#1918 2012-02-06 00:27:24

Re: MLP - The Multi-Lingual Publishing Pack

#1919 2012-02-06 00:35:29

Re: MLP - The Multi-Lingual Publishing Pack

#1920 2012-02-06 00:47:52

Re: MLP - The Multi-Lingual Publishing Pack

Board footer