#1214 – The used table type doesn’t support FULLTEXT indexes

by

Before MySQL 5.6 Full-Text Search is supported only with MyISAM Engine.

Therefore either change the engine for your table to MyISAM 

CREATE TABLE gamemech_chat (
  id bigint(20) unsigned NOT NULL auto_increment,
  from_userid varchar(50) NOT NULL default '0',
  to_userid varchar(50) NOT NULL default '0',
  text text NOT NULL,
  systemtext text NOT NULL,
  timestamp datetime NOT NULL default '0000-00-00 00:00:00',
  chatroom bigint(20) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY from_userid (from_userid),
  FULLTEXT KEY from_userid_2 (from_userid),
  KEY chatroom (chatroom),
  KEY timestamp (timestamp)
) ENGINE=MyISAM;

Here is SQLFiddle demo

or upgrade to 5.6 and use InnoDB Full-Text Search.

More Related Contents:

  1. In SQL Server how to get the count of child if both parent and child are available [closed]
  2. Delete the entire content of all table in a Database [closed]
  3. MyISAM versus InnoDB [closed]
  4. Calculate a running total in MySQL
  5. What does character set and collation mean exactly?
  6. How do MySQL indexes work?
  7. How to change MySQL data directory?
  8. MySQL Syntax error message “Operand should contain 1 column(s)”
  9. Format number to 2 decimal places
  10. How to remove all non-alpha numeric characters from a string in MySQL?
  11. INSERT … ON DUPLICATE KEY (do nothing)
  12. Define a variable within select and use it within the same select
  13. How to remove new line characters from data rows in mysql?
  14. mySQL subquery limit
  15. Making changes to multiple records based on change of single record with SQL
  16. How to increase MySQL connections(max_connections)?
  17. MySQL/SQL: Update with correlated subquery from the updated table itself
  18. COUNT(*) from multiple tables in MySQL
  19. Why the rows returns by “explain” is not equal to count()?
  20. libmysqlclient15-dev on macs?
  21. Laravel Eloquent group by most recent record
  22. Are SELECT type queries the only type that can be nested?
  23. How to grant remote access to MySQL for a whole subnet?
  24. How to drop all tables from the database with manage.py CLI in Django?
  25. Database returned an invalid value in QuerySet.dates()
  26. Access to mysql container from other container
  27. How can a query multiply 2 cell for each row MySQL?
  28. Rails select random record
  29. mysql UPDATE statement – overhead for same values?
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment