Hi there
We are currently trying out the couch search function on one of our pages and stumbled across a weird problem.
When adding the search function on one of our pages we simply get the following error upon searching:
The code used for the search function:
We tried altering the KEYS in the table with the following sql query:
The couch version with the first few tries was 2.0 but we upgraded to the latest version shortly after.
Thanks for your help!
Regards
laduma
We are currently trying out the couch search function on one of our pages and stumbled across a weird problem.
When adding the search function on one of our pages we simply get the following error upon searching:
- Code: Select all
Could not successfully run query: Can't find FULLTEXT index matching the column list
The code used for the search function:
- Code: Select all
<cms:search_form processor='/search.php' />
<cms:search masterpage="index.php" limit='10'>
<cms:if k_paginated_top >
<div>
<cms:if k_paginator_required >
Page <cms:show k_current_page /> of <cms:show k_total_pages /><br>
</cms:if>
<cms:show k_total_records /> Pages Found -
displaying: <cms:show k_record_from />-<cms:show k_record_to />
</div>
</cms:if>
<h3><a href="<cms:show k_page_link />"><cms:show k_search_title /></a></h3>
<cms:show k_search_excerpt />
<hr>
<cms:paginator />
</cms:search>
We tried altering the KEYS in the table with the following sql query:
- Code: Select all
ALTER TABLE table name ENABLE KEYS;
The couch version with the first few tries was 2.0 but we upgraded to the latest version shortly after.
Thanks for your help!
Regards
laduma