We are trying to use FULL INDEX on a web site, but it's not working.
When I try to set full index on a field via mysql code, I get this message:
[text]#1214 - The used table type doesn't support FULLTEXT indexes[/text]
What does that mean. Have I set the table up wrong??
FULL INDEX not working, and this odd Error message
Moderator: General Moderators
-
simonmlewis
- DevNet Master
- Posts: 4435
- Joined: Wed Oct 08, 2008 3:39 pm
- Location: United Kingdom
- Contact:
FULL INDEX not working, and this odd Error message
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.
Re: FULL INDEX not working, and this odd Error message
What table type are you using? What version of MySQL? What column type are you trying to set the index on?
https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.htmlFull-text indexes can be used only with MyISAM tables. (In MySQL 5.6 and up, they can also be used with InnoDB tables.) Full-text indexes can be created only for CHAR, VARCHAR, or TEXT columns.
-
simonmlewis
- DevNet Master
- Posts: 4435
- Joined: Wed Oct 08, 2008 3:39 pm
- Location: United Kingdom
- Contact:
Re: FULL INDEX not working, and this odd Error message
How do I find out if the table is MyISAM? I've no idea. Never had this sort of issue before.
The field is VARCHAR.
The field is VARCHAR.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.
Re: FULL INDEX not working, and this odd Error message
Code: Select all
SHOW TABLE STATUS WHERE Name = 'table_name_here';-
simonmlewis
- DevNet Master
- Posts: 4435
- Joined: Wed Oct 08, 2008 3:39 pm
- Location: United Kingdom
- Contact:
Re: FULL INDEX not working, and this odd Error message
And what am I looking for in the result, as I don't see anything about MyISAM?
EDIT:
Got it. It's InnoDB.
Is this easy to change?
EDIT:
Got it. It's InnoDB.
Is this easy to change?
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.
-
simonmlewis
- DevNet Master
- Posts: 4435
- Joined: Wed Oct 08, 2008 3:39 pm
- Location: United Kingdom
- Contact:
Re: FULL INDEX not working, and this odd Error message
Cracked it. Found the fix. And it works. Cheers.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.