You are not logged in.
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_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 ;)
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?
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 …
@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.
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.
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)
… 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…
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.
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.