News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Utf8 error

Started by Shades., September 14, 2020, 10:51:42 PM

Previous topic - Next topic

Shades.

Tried converting my 2.0.17 forum to Utf8 and get this error:

Column 'title' cannot be part of FULLTEXT index
File: /xxxxx/xxxx/public_html/xxxxxx/Sources/ManageMaintenance.php
Line: 664
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

shawnb61

There are a few limitations for using fulltext search indexes...

I would go to Search settings, delete the fulltext index, and retry the utf8 conversion.

After the utf8 conversion, rebuild the search index.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

shawnb61

... and if you haven't already,  do a full db backup before continuing.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Shades.

Quote from: shawnb61 on September 14, 2020, 11:05:12 PM
There are a few limitations for using fulltext search indexes...

I would go to Search settings, delete the fulltext index, and retry the utf8 conversion.

After the utf8 conversion, rebuild the search index.
It has "No Index" checked
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

shawnb61

Is the link to delete the fulltext index present?  If so, delete it.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Shades.

Quote from: shawnb61 on September 14, 2020, 11:23:07 PM
Is the link to delete the fulltext index present?  If so, delete it.

No its not there. Uploading pic so you can see what Im looking at...
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Sir Osis of Liver

Screenshots in your other thread look like this is a scratch install, no content.  Try uninstalling the mods.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Shades.

Quote from: Sir Osis of Liver on September 14, 2020, 11:39:10 PM
Screenshots in your other thread look like this is a scratch install, no content.  Try uninstalling the mods.
Ok that was my last resort lol was hoping it wouldn't come to that! :o ;D
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

shawnb61

If you are (re-)starting a new 2.0 forum from scratch, select the utf8 option. 

utf8 conversions are always tricky.  Just starting off with utf8 is the way to go. 
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Shades.

Quote from: shawnb61 on September 15, 2020, 02:14:36 AM
If you are (re-)starting a new 2.0 forum from scratch, select the utf8 option. 

utf8 conversions are always tricky.  Just starting off with utf8 is the way to go.
Ok thanks! I was able choose the utf8 option out of the menu and it worked. The first time it had something else selected like ISO-8859 i cant remember what it was exactly now but its working fine as far as I can tell.
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Advertisement: