Bug #80779
closed
SQL-ERROR: The used table type doesn't support FULLTEXT indexes
0%
Description
Executing 'Update database schema: Create tables and fields'
returns:
SQL-ERROR: The used table type doesn't support FULLTEXT indexes
Problem 1.
It doesn't state which query caused the problem.
Problem 2.
The query is 'ALTER TABLE index_fulltext ENGINE = InnoDB'
there's an error because before MySQL 5.6 Full-Text Search is supported only with MyISAM Engine.
Updated by Morton Jonuschat about 7 years ago
- Status changed from New to Needs Feedback
Are there other tables/field which should be modified on this table? It seems like it tries to downgrade the index_fulltext table from MySQL FULLTEXT to the database agnostic setup. Did you disable the config option 'useMysqlFulltext' for indexed_search or is this an upgrade from an installation that previously used indexed_search_mysql?
Updated by Christian Toffolo about 7 years ago
It's an upgrade from 7LTS to 8LTS.
The installation previously used EXT:indexed_search_mysql.
Now I checked EXT:indexed_search config and the flag basic.useMysqlFulltext is not set.
Btw, I temporarly solved the problem 2 dropping the table and recreating it with:
CREATE TABLE index_fulltext ( phash int(11) DEFAULT '0' NOT NULL, fulltextdata mediumtext, metaphonedata mediumtext NOT NULL, PRIMARY KEY (phash) ) ENGINE=InnoDB;
Updated by Benni Mack almost 7 years ago
- Target version changed from 8 LTS to Candidate for patchlevel
Updated by Alexander Opitz over 6 years ago
- Status changed from Needs Feedback to New
Updated by Christian Kuhn 3 months ago
- Status changed from New to Closed
Hey. I'm going to close here: Whatever went wrong on this 7 years ago, core v12 requires at least mysql 8, which comes with innodb fulltext support.