SMF Community Helpers > SMF Documentation Help
How to convert to UTF-8
agridoc:
No, it's not always necessary but their content is a known cause of trouble in conversion, as well as a search index. Their content will also probably be useless after conversion. Emptying them will do no harm, as far as I know.
I examined the structure of [smf]_log_search files and only [smf]_log_search_subjects table contains a text field. [smf]_log_search_results table is also a known cause of trouble, although not containing a text field. I had seen the suggestion of emptying all log_search tables and I adopted it in guide.
I tried to gather the most common causes and give instructions that would not affect useful data. I doubt that any guide can guarantee a successful conversion always but a more detailed guide is needed in instructions to prevent known causes of trouble, if possible, as also pointed by Illori.
--- Quote from: Illori on March 13, 2012, 11:24:02 AM ---it seems like http://wiki.simplemachines.org/smf/UTF-8_Readme
is slightly out of date, i am not that familiar with utf-8 and converting to it. can someone take a look and update the page?
--- End quote ---
agridoc:
As you are concerned about search, in this case all log_search tables were emptied
--- Quote from: amordad_yar on July 07, 2011, 01:27:30 AM ---I'm happy to say that after 2 days nobody has found anything wrong and all are EXTREMELY happy to have a functional search again. I think you've solved this and are a hero to many :) Thank you!
--- End quote ---
Dzonny:
Thanks agridoc for your help!:)
Now, i'm not sure why would upgrade be a "must" here, i've done many conversations without upgrading first?
emanuele:
--- Quote from: agridoc on April 08, 2012, 02:29:28 PM ---No, it's not always necessary but their content is a known cause of trouble in conversion, as well as a search index. Their content will also probably be useless after conversion. Emptying them will do no harm, as far as I know.
--- End quote ---
Hopefully it wouldn't be useless because as I wrote log_search_subjects is in the list of the tables converted, but since there is the possibility to recover the data it wouldn't be such a bit issue. Maybe you can add a note to do a "maintenance > repair boards" at the end of the procedure in order to restore all the search features. ;)
--- Quote from: agridoc on April 08, 2012, 02:35:56 PM ---As you are concerned about search, in this case all log_search tables were emptied
--- End quote ---
No, it's that I'm concerned by the fact that the tables are emptied, I'm more concerned by people going to open phpmyadmin! :P
I just suggested because I know many people are afraid by having to dig into the database and others are more prone to make disasters... :P
BTW, I'm not against it, I was just asking because of my inexperience in charsets conversions. ;)
agridoc:
--- Quote from: Dzonny on April 08, 2012, 02:40:51 PM ---Thanks agridoc for your help!:)
Now, i'm not sure why would upgrade be a "must" here, i've done many conversations without upgrading first?
--- End quote ---
There is a possibility that some mod might interfere with conversion process.
A Large upgrade is recommended to start with "clean" files. It's rather a cleanup. No real upgrade is necessary.
I also recommend default theme and English language to avoid possible errors from code in a custom theme or an error in language file.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version