News:

SMF 2.0.19 has been released! Please update. Read more.

Main Menu

Cannot convert 2.1 forum to UTF-8

Started by makv, November 25, 2014, 05:43:08 AM

Previous topic - Next topic

makv

Following the upgrade of my sandbox environment to 2.1, I thought I would try to convert it to UTF-8 using the standard functionality under Admin/Maintenance/Forum Maintenance/Database.

This shows the message:

Quote
Your messages table is using a fulltext index for use when searching. You cannot proceed in converting to UTF-8 until that index is removed. You can re-create it after the conversion has been completed.

It is true that originally, there was FULLTEXT index on the body column of *_messages. I've since dropped this index though, but am still getting the same message.

Illori

remove the fulltext index for searching and recreate after converting.

makv

Quote from: Illori on November 25, 2014, 05:49:37 AM
remove the fulltext index for searching and recreate after converting.

As per my OP, I have now dropped the index.

Arantor

Let me guess, you dropped the index manually rather than using SMF's configuration to do it?

makv

Yup. Didn't even know the was a way of doing this through SMF. Where is that?

Arantor

Admin > Forum > Search > Search Method

Advertisement: