Advertisement:

Author Topic: Cannot convert 2.1 forum to UTF-8  (Read 3432 times)

Offline makv

  • Semi-Newbie
  • *
  • Posts: 56
Cannot convert 2.1 forum to UTF-8
« on: November 25, 2014, 05:43:08 AM »
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.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,133
Re: Cannot convert 2.1 forum to UTF-8
« Reply #1 on: November 25, 2014, 05:49:37 AM »
remove the fulltext index for searching and recreate after converting.

Offline makv

  • Semi-Newbie
  • *
  • Posts: 56
Re: Cannot convert 2.1 forum to UTF-8
« Reply #2 on: November 25, 2014, 06:00:31 AM »
remove the fulltext index for searching and recreate after converting.

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

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,392
    • StoryBB/StoryBB on GitHub
Re: Cannot convert 2.1 forum to UTF-8
« Reply #3 on: November 25, 2014, 06:52:48 AM »
Let me guess, you dropped the index manually rather than using SMF's configuration to do it?
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline makv

  • Semi-Newbie
  • *
  • Posts: 56
Re: Cannot convert 2.1 forum to UTF-8
« Reply #4 on: November 25, 2014, 06:58:38 AM »
Yup. Didn't even know the was a way of doing this through SMF. Where is that?

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,392
    • StoryBB/StoryBB on GitHub
Re: Cannot convert 2.1 forum to UTF-8
« Reply #5 on: November 25, 2014, 06:59:50 AM »
Admin > Forum > Search > Search Method
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.