Search field in Support Center doesn't work

[Tuttu]

Hi everyone,

I have a problem with the search field in my support center. When I want to use it, I have this error message : DAO_KbArticle(3885):The used table type doesn't support FULLTEXT indexes

I have opened a ticket on JIRA (http://www.wgmdev.com/jira/browse/CHD-723) but if someone know how to fix this issue, that will be very cool. :)

[Hildy]

The fulltext thing is an issue where InnoDB tables do not support FULLTEXT indexes, and the tables need converted to MyISAM tables.

As always, back up your database before you do anything to it, then run ALTER TABLE kb_article ENGINE=MyISAM;

[Tuttu]

Ok, I will try it and keep you inform. Thank you. :)

[Tuttu]

Thanks Hildy, it works fine. I'm sorry to have open a ticket and a subject in the forum but I have found nothing speaking about it.
Just a question : why this error exists ? It depends of MySql ? If you know it, there's no way to fix it during the installation ? (Ok... I ask you three questions :p )

[Tuttu]

I have an other error linked to this one. On my admin panel, I have created three topics for my knowledgebase and one article in each topic. When I connect myself to my kb, I see only two of the three topics.

[Hildy]

In Helpdesk Setup -> Community Tools -> <community name> -> Public Knowledgebase, make sure you have selected that all the topics should be visible ("Public Topics" section).

[Hildy]

why this error exists ?

Because InnoDB tables don't support FULLTEXT searching. Some MySQL installations default to InnoDB table types.


It depends of MySql ?

Yes, see above.


If you know it, there's no way to fix it during the installation ?

We could probably do the alter table command as part of the upgrade scripts, but I think it may be one of those things where the process could take quite some times, and the PHP timeout could get in the way. (This is a guess, I haven't specifically asked Jeff about this.)

[Tuttu]

In Helpdesk Setup -> Community Tools -> <community name> -> Public Knowledgebase, make sure you have selected that all the topics should be visible ("Public Topics" section).
Hi Hildy.

I'm so idiot, I don't remember to do this. Thanks. :)