[MYSQL][SOLVED] The used table type doesn't support FULLTEXT indexes

The problem occurred because of wrong table type. To solve the problem we need to change the type of the table. Mysql supports a few different types of tables, but the most commonly used are MyISAM and InnoDB. MyISAM is the only type of table that Mysql supports for Full-text indexes.

To correct this error run following sql.

ALTER TABLE <table name> ENGINE = MYISAM




Comments

Post a Comment

Popular posts from this blog

Offers on Friday, April 24, 2020

Fatal: LoadModule: error loading module 'mod_sql_mysql.c'