Jump to content

general error 1214 no support for fulltext indexes


hansv
 Share

Recommended Posts

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?
Link to comment
Share on other sites

  • 4 weeks later...
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

Link to comment
Share on other sites

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. 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...