general error 1214 no support for fulltext indexes

[hansv]

PW 3.0.52 with uikit site profile

After installing the Core-module Language Support I get the following error

•  Session: Module reported error during install (LanguageSupport): SQLSTATE[HY000]: General error: 1214 The used table type doesn't support FULLTEXT indexes

Any idea how this error can be avoided?

[adrian]

Any chance you are running InnoDB on a version of MySQL that doesn't support fulltext indexes. I think it was introduced for InnoDB in 5.6.4

[monchu]

On 15/02/2017 at 3:05 AM, hansv said:

PW 3.0.52 with uikit site profile

After installing the Core-module Language Support I get the following error

•  Session: Module reported error during install (LanguageSupport): SQLSTATE[HY000]: General error: 1214 The used table type doesn't support FULLTEXT indexes

Any idea how this error can be avoided?

 

If you're using site-regular during pw installation, you have to remove this

$config->dbEngine = 'InnoDB'; 

from config.php

[LostKobrakai]

Just removing that line won't work. It's just there so PW knows under which db engine it was installed. Changing it will not modify the database in any way to actually resolve the issue.

[monchu]

I'm not sure LostKobrakai, in my case, once I deleted that line then I'm able to add a field. the error gone.

[LostKobrakai]

Ok, it might not have been clear enough, but my statement still stands true: Removing that config line won't change any existing database tables or the database charset itself. So if someone does have that error without trying to add something new your tip won't help. Adding a field on the other hand does create at least one new table, where pw does again determine by that line which engine it's supposed to use with that new table and this might error as well.