MyBB Community Forums

Greetings,

I am in the need to make a relation between 2 tables. 'mybb_users' and 'noticias', however, the table engine for mybb_ is MyIsam and the only way I can achieve this is by using InnoDB.

So, I have been manually changing the engines, but when I reached 'mybb_posts', I encountered an error due to FULLTEXT.

Should I just change that index to something else and then change the engine? I'm kind of afraid of doing something that compromises the forum...

As long as you have disabled Fulltext search in the settings, you can change the Fulltext index to a B-Tree then switch to InnoDB.

Thanks for the fast reply.

Can you be more specific? What settings? On the Admin Control Panel?

ACP > Configuration > Search System > Search Type

Make sure it's set to Standard. Without the Fulltext indexes you won't have the ability to use Fulltext search.

Thank you for your help!

Hi,

I have a tables 'mybb_posts' with a high number of inserts (2 GB)
We need to change 'mybb_posts' and 'mybb_threads' to using InnoDB but show me error due to FULLTEXT.
Nathan Malcolm reply not work. how can i do that?