ImpAKT Forum :: SIte Search Can't find FULLTEXT index matching the column li
This thread was displayed: 0 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
Andrew Stubblefield
04-10-2007 20:51:16 GMT +2
|
We are using mySQL 5 and PHP 5, when trying to add the Site Search and then test it I get the following error. I get the same error from our tables and the mySQL script that I downloaded with the extension.
Can't find FULLTEXT index matching the column list
CREATE TABLE `pg_nav` (
`id_nav` int(11) NOT NULL auto_increment,
`idpar` int(11) default '0',
`visible` int(11) default NULL,
`modpg_nav` int(11) default NULL,
`catagory_nav` int(11) default NULL,
`list_nav` int(11) default NULL,
`name_nav` varchar(60) default NULL,
`shortDesc_nav` text,
`content_nav` text,
`show_topic_nav` tinyint(4) default '1' COMMENT 'Used to hide topics from main nav',
UNIQUE KEY `id_nav` (`id_nav`),
FULLTEXT KEY `name_nav` (`name_nav`),
FULLTEXT KEY `shortDesc_nav` (`shortDesc_nav`,`content_nav`),
FULLTEXT KEY `content_nav` (`content_nav`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Is there something with the PHP5 or the mySLQ, we have it on a Plesk 8.1.1 server.
|
|
|
Razvan Racasanu[InterAKT]  04-11-2007 10:05:55 GMT +2
|
Hello,
MX Site Search does not search the table directly. It uses a cache table which needs to have the fulltext indexes. Please make sure that the cache table has been correctly created with the fulltext indexes.
Regards,
Razvan RACASANU
|
|
|
