title: error 1191 in database when doing a search
body: <p>I have been trying to resolve this issue for a while but I'm stuck.</p>
  
  <p>I have a error keep throwing up every time I do a search on my website for "eastlincs" but I'm not sure how to fix the issue. </p>
  
  <p>I have googled the error and there is not much about it and have read a couple of threads on here about the problem but I'm unable to fix the issue. I know its something to do with my database and adding the FULLTEXT to categories in my database.</p>
  
  <p>The error being displayed:</p>
  
  <blockquote>
    <p>A Database Error Occurred Error Number: 1191<br>
    Can't find FULLTEXT index matching the column list</p>
  </blockquote>
  
  <p>This is the actual query:</p>
  
  <pre><code>SELECT 
      c.id, c.type_id, 
      MATCH(c.name) AGAINST('&gt;eastlincs eastlincs*' IN BOOLEAN MODE) AS categories_name_score, 
      MATCH(c.meta_title) AGAINST('&gt;eastlincs eastlincs*' IN BOOLEAN MODE) AS categories_meta_title_score, 
      MATCH(c.meta_description) AGAINST('&gt;eastlincs eastlincs*' IN BOOLEAN MODE) AS categories_meta_description_score 
  FROM (categories AS c) 
  WHERE MATCH(c.name, c.meta_title, c.meta_description) AGAINST('&gt;eastlincs eastlincs*' IN BOOLEAN MODE) 
  ORDER BY (categories_name_score*1.25+categories_meta_title_score+categories_meta_description_score*1.20) DESC
  </code></pre>
  
  <p><strong>UPDATE:</strong> table definition:</p>
  
  <pre><code>categories
  CREATE TABLE `categories` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `type_id` int(11) NOT NULL DEFAULT '0',
   `parent_category_id` int(11) NOT NULL DEFAULT '0',
   `tree_path` varchar(255) NOT NULL,
   `order_num` int(11) NOT NULL,
   `name` varchar(255) DEFAULT NULL,
   `seo_name` varchar(255) NOT NULL DEFAULT '',
   `selected_icons_serialized` text NOT NULL,
   `meta_title` varchar(255) NOT NULL,
   `meta_description` varchar(255) NOT NULL,
   `en_name` varchar(255) NOT NULL DEFAULT 'untranslated',
   `en_meta_title` varchar(255) NOT NULL DEFAULT 'untranslated',
   `en_meta_description` varchar(255) NOT NULL DEFAULT 'untranslated',
   PRIMARY KEY (`id`),
   KEY `parent_category_id` (`parent_category_id`),
   KEY `tree_path` (`tree_path`),
   FULLTEXT KEY `name` (`name`,`meta_title`,`meta_description`),
   FULLTEXT KEY `meta_title` (`meta_title`),
   FULLTEXT KEY `en_name` (`en_name`,`en_meta_title`,`en_meta_description`),
   FULLTEXT KEY `en_meta_title` (`en_meta_title`),
   FULLTEXT KEY `meta_description` (`meta_description`)
  ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 PACK_KEYS=0
  </code></pre>