Jump to content

SQLSTATE[HY000]: General error: 1214 The used table type doesn't support FULLTEXT indexes


MuchDev
 Share

Recommended Posts

I have been getting this every time I try and create a new field now and I have no idea what to think of it. I know that innoDB is used on the backend of cpanel but I also have my default storage engine set to myisam. Anyone have any ideas? I really want to launch this site, but I just can't if the site is borking like this :(. Please help :)

Link to comment
Share on other sites

I just tried a new install of processwire in another folder, and reset the database. Still the same error. hmmmmm module conflict maybe?

The key is I wasn't getting the error on the new install.

Well. I guess this server really wants me to use InnoDB. I am a noob, should I care about this?

Link to comment
Share on other sites

Well for some reason no matter what I try, new fields default to InnoDB. I just upgraded to mysql5.6 which supports fulltext indexes, but I have no clue how to get my server to play ball with my old configuration.

****edit

Well after dinking around and checking everything I finally located the issue. I somehow managed to space on what database engine I was running in my site config. Well all is well, got everything cleaned up though and a fresh install and optimization of the database is done :) Now if only dns servers replicated faster. 

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...