wpForo 1.x.x [Closed] Trying to conver MyISAM tables to InnoDB

How-to and Troubleshooting

Last Post by Sofy 6 years ago

2 Posts

2 Users

0 Reactions

1,101 Views

RSS

Posts: 21

power505

Topic starter

Feb 28, 2019 12:06 am

(@power505)

Eminent Member

Joined: 6 years ago

After migrating from SMF to wpForo with official converter my wpForo forums are rather slow. Much slower then SMF was previously been.

I stumbled on this topic in which @Robert describes that all tables should be InnoDB instead of MyISAM. I succeeded to convert almost all tables, except the biggest ones:

wpforo_posts
wpforo_topics

When I tried to convert I'm getting this error:

#1214 - The used table type doesn't support FULLTEXT indexes

Do you have any solution to this?

1 Reply

Posts: 4878

Sofy

Admin

Feb 28, 2019 2:28 pm

(@sofy)

Support Team

Joined: 7 years ago

Hi @power505,

You should upgrade your MySQL to the version, It should be higher than 5.6.X. Please contact your hosting service and ask them to update the MySQL version.

Please read wpForo server requirements here: https://wpforo.com/docs/root/wpforo-installation/server-requirements/

In case you want to say thank you 😊
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.