Error
Error Code:
1214
MariaDB Error 1214: Unsupported Table Type for FULLTEXT
Description
This error indicates that you are attempting to create or modify a table to include a FULLTEXT index, but the table's storage engine does not support this feature. It commonly occurs when using engines like MEMORY or CSV, or older versions of InnoDB before FULLTEXT capabilities were introduced.
Error Message
The used table type doesn't support FULLTEXT indexes
Known Causes
3 known causesIncompatible Storage Engine
Attempting to create a FULLTEXT index on a table that uses a storage engine (like MEMORY or CSV) which inherently lacks support for FULLTEXT indexing.
Older InnoDB Version
The InnoDB storage engine in older MariaDB (or MySQL) versions did not support FULLTEXT indexes, requiring a MyISAM table or a database upgrade for this functionality.
Explicit Engine Mismatch
The `CREATE TABLE` or `ALTER TABLE` statement explicitly specifies a storage engine that does not support FULLTEXT indexes while simultaneously defining one.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service