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

04/26/2015 at 7:45 am #332532
Steven Zahm
Keymaster

@ Serge

Looking at the SQL file…

The source DB on WAMP, the table engine in InnoDB which only supported FULLTEXT starting in MySQL 5.6. The host is likely on an older version.

On you WAMP install, drop the FULLTEXT indexes manually in phpMyAdmin on the following tables:

  • wpeig_connections
  • wpeig_connections_address
  • wpeig_connections_phone

OR

Like I said before, manually edit the SQL file to remove the lines that begin with:

FULLTEXT KEY search

They are still in the sample file you attached.

Also, as mentioned, make sure to also delete the trailing , from the previous line otherwise you will end up with an invalid SQL statement.