Reply To: #1214 – The used table type doesn't support FULLTEXT indexes

04/25/2015 at 11:47 am #332434
Steven Zahm
Keymaster

@ Serge

Sorry, it seems the FULLTEXT indexes are not dropped when disabling that option on the Connections : Settings. That is a bug. I just fixed it.

The first solution should work just fine though.

Another way to deal with this is to open the SQL files you exported and remove the lines that begin with FULLTEXT KEY search. There should be three instances if you exported all tables as a single export. If you exported the tables as individual SQL files then there will only be one instance in three of the connections table SQL files. Make sure to also delete the trailing , from the previous line otherwise you will end up with an invalid SQL statement.