Why am I getting a template error with search after upgrading OSQA

Question

I recently checked out the latest osqa build. Now, when I perform a search using the regular built-in search I get the following error:

Caught OperationalError while rendering: (1191, "Can't find FULLTEXT index matching the column list")

This error occurs in osqa/forum/skins/default/templates/questions.html at line 21:

<div id="listA">{% for question in questions.paginator.page %}

I noticed the search functions have been updated and now support some kind of ranking and adds a relevance tab. I thought maybe one of my templates was interfering with this so I reverted back to using the default skin with the new templates and I still get this error. Any ideas?

Accepted Answer

1

You have to add Full Text Search indexes to the body, title and tagnames fields of the forum_mysqlftsindex table. Use the following code for the purpose. A code that automatically does that will be pushed to the trunk soon.

ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(body);
ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(title);
ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(tagnames);

link

answered 30 May '11, 17:19

Jordan ♦♦
3.1k●6●18
accept rate: 38%

worked perfectly. thanks! Are indexes not automatically created after upgrading and performing "migrate"?

(31 May '11, 17:54) rsp

1

the code has been added to the trunk and it will be automatically triggered, indexes will be automatically created without a need to run the migrate command

(01 Jun '11, 07:56) Jordan ♦♦

Is there anything to do (except restarting osqa) ?

I'm on rev 1056 and I'm getting the same error. Quickly checking the DB shows that title and tagname are not defined in the table (see output).

mysql> desc forum_mysqlftsindex; +---------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+----------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | node_id | int(11) | NO | UNI | NULL | | | body | longtext | NO | MUL | NULL | | +---------+----------+------+-----+---------+----------------+ 3 rows in set (0.00 sec)

I did run migrate forum after svn update.

(01 Jun '11, 13:06) rastafazz

Why am I getting a template error with search after upgrading OSQA

Follow this question

Learn more about OSQA

Related questions