Send blog post
Send post to this addresses
|
Search failed on tw.org Posted by sylvie on 05/08/09 15:57 EDT |
I do not know why, but today the search fails on tikiwiki.org with an sql error.
The problem was that the fulltext index was split into to; ft with pageName and data and description with description. In order to be able to do a fullsearch on the 3 columns, you ned to have a fulltext index on these 3 columns.
The problem was that the fulltext index was split into to; ft with pageName and data and description with description. In order to be able to do a fullsearch on the 3 columns, you ned to have a fulltext index on these 3 columns.
drop index ft on tiki_pages;drop index description on tiki_pages;create fulltext index ft on tiki_pages (pageName,description,data);
| Permalink (referenced by: Posts references: Posts) |
|