I have this table
Code:
CREATE TABLE `images` (
  `id` tinyint(4) NOT NULL auto_increment,
  `cid` tinyint(3) NOT NULL default '0',
  `name` varchar(20) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `src` varchar(150) NOT NULL default '',
  `height` smallint(4) NOT NULL default '0',
  `width` smallint(4) NOT NULL default '0',
  `transp` enum('no','yes') NOT NULL default 'no',
  `keywords` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `cid` (`cid`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `description` (`description`),
  FULLTEXT KEY `keywords` (`keywords`)
)
but when I run this query I get an error.
Code:
#sql
select
	id
	, name
	, description
	, src
	, match (name, description, keywords) against ('waking') as score
from
	images
where
	match (name, description, keywords) against ('waking')
order by
	score desc

#error
Can't find FULLTEXT index matching the column list
Now I can use full text searching fine on another table but in phpMyAdmin in the indexes list, all the indexs have a cardinality value but in the above table it says none. Could this be causing problems or have I just made a stupid error somewhere?

Also the table it works on contains ~500 records, this table contains one. I know that'll effect the search results only having one record but that wouldn't be causing the error would it?

Thanks