AI Assistant
Notifications
Clear all

[Closed] Trying to conver MyISAM tables to InnoDB

2 Posts
2 Users
0 Reactions
1,665 Views
Posts: 21
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@power505)
Eminent Member
Joined: 7 years ago
[#7903]

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
Sofy
Posts: 5781
 Sofy
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@sofy)
Support Team
Joined: 8 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/


Share: