Recent Topics

The used table type doesn't support FULLTEXT indexes

Started by on Nov 29, 2011 – Contents updated: Jun 19, 2016

Nov 29, 2011 23:14    

Hi,

today I tried to update my old b2evolution 2.4.5 to 4.1.2.

I uploaded all files but there is a failure during the installation.

This is the install log til it crashes:

Code

Checking files...
 
Preparing to install .htaccess ... Already installed.
Aktualisiere Daten in vorhandener b2evolution-Datenbank...
Loading module: _core/model/__core.install.php
Loading module: collections/model/_collections.install.php
Loading module: files/model/_files.install.php
Loading module: sessions/model/_sessions.install.php
Loading module: messaging/model/_messaging.install.php
Loading module: maintenance/model/_maintenance.install.php
 
Überprüfe DB-Schema-Version... 9950 : OK.
Renaming tables...OK.
Making sure all tables use desired storage ENGINE as specified in the b2evo schema...T_groups:innodb
T_settings:innodb
T_global__cache:innodb
T_users:innodb
T_users__fielddefs:innodb
T_users__fields:innodb
T_locales:innodb
T_antispam:innodb
T_plugins:innodb
T_pluginsettings:innodb
T_pluginusersettings:innodb
T_pluginevents:innodb
T_cron__task:innodb
T_cron__log:innodb
T_skins__skin:innodb
T_skins__container:innodb
T_blogs:innodb

Thats the failure:

Code

MySQL error!
 
The used table type doesn't support FULLTEXT indexes(Errno=1214)
 
Your query:
 
ALTER TABLE evo_blogs ENGINE = innodb

Has anybody an idea how to fix this problem?

Dec 05, 2011 09:54

Fixed it, don't ask me how. :) Deleted some indexes in table evo_blogs and switched some indexes from fulltext in index.

Jun 18, 2016 05:33

I really wish you had detailed what you did. I'm having the exact same problem and am coming up empty on solutions.

Jun 19, 2016 02:38

There should be no fulltext index at all, delete any fulltext index you may have in your DB.


Form is loading...

powered by b2evolution – This forum is powered by b2evolution CMS, a complete engine for your website.