SMF Support > Install and Upgrade Help
Upgrade from SMF 1.1.16 to SMF 2.0.2 - language/character problem.
wildd:
Hello, our forum is located in Latvia and therefore people are writing all posts in Latvian language.
We had problems with lost buttons in forum and some other things was broken so we finally decided to move to SMF 2.0.2
We duplicated DB, upgrade worked well, all looks good, also all lost buttons like "Save change profile", etc are back, but we have strange thing with characters. There seems to be some problem with encoding.
There are screen shot from one board OLD vs NEW.
hxxp:img832.imageshack.us/img832/6315/oldforum.png [nonactive]
hxxp:img192.imageshack.us/img192/6534/newforumq.png [nonactive]
DB VARIABLES OLD
--- Quote ---character set client utf8
character set connection utf8
character set database utf8
character set filesystem binary
character set results utf8
character set server utf8
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_general_ci
collation database utf8_general_ci
collation server utf8_general_ci
completion type
--- End quote ---
DB VARIABLES NEW
--- Quote ---character set client utf8
character set connection utf8
character set database utf8
character set filesystem binary
character set results utf8
character set server utf8
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_general_ci
collation database utf8_general_ci
collation server utf8_general_ci
completion type
--- End quote ---
As you see all settings in DB are the same.
In both page source I see
--- Quote ---<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
var smf_charset = "UTF-8";
--- End quote ---
The only different thing is that in old forum under Languages we have set "Latvian" (we did translation by our self), but in new forum there is "English", but as I understand this is related only for the forum things like buttons, labels, etc. So this has nothing to do with topic titles, posts.
Only weird thing that I see, is that in new forum under Languages there is English language with "Character Set ISO-8859-1", not UTF-8 what is like WTF for me, but okay.
Also tried "Convert HTML-entities to UTF-8 characters" but that didn't do anything.
So any ideas?
Thanks!
Oldiesmann:
You need to download and install the English-UTF8 language pack.
Go to Admin -> Configuration -> Languages -> Add Language
Type "English" in the box and click Search
Click "install" next to the one with a description of "SMF 2.0.2 English-utf8"
Make sure it says "Yes" in the "Writable" column for each file and that the box in the "copy" column is checked for each file.
Click "Install" at the bottom of the page
Now go back to Admin -> Configuration -> Languages and select the radio button next to the newly-installed language pack to make it the default.
wildd:
Hi, thanks for reply, tried what you said, but nothing got fixed.
Searched for english-utf8, installed it (checked to copy all files including few that wasn't automatically checked - all files were showing green as writable). Then selected english-utf8 as default language pack for all users, and it shows that all users are using it, but forum is still messed up.
Any other solutions?
P.S. Just now tried new topic with text and there all characters are showing right ;/
Maybe there is some encoding convert that I can try to old DB?
wildd:
Although I thought that the language what is set in forum doesn't mean nothing, maybe it means?
I checked both settings.php
Old
--- Quote ---$language = 'latvian'; # The default language file set for the forum.
$db_character_set = 'utf-8';
--- End quote ---
New
--- Quote ---$language = 'english-utf8'; # The default language file set for the forum.
$db_character_set = 'utf8';
--- End quote ---
Maybe before upgrade I need to change back to english or something in old forum and then proceed with upgrade?
wildd:
Seriously forum with "279,460 Members" and no one reads this forum/board and hasn't any ideas/thoughts? :(
Today tried this
A) In 1.1.16 changed forum language back from "Latvian" to "English", so settings.php
--- Quote ---$language = 'english'; # The default language file set for the forum.
$db_character_set = 'utf-8';
--- End quote ---
All looks good, charachers are right.
B) In 1.1.16 used maintenance "'Convert the database and data to UTF-8", then "Convert HTML-entities to UTF-8 characters". After this step forum characters were wrong, but continued to next steps.
C) Upgrade from 1.1.16 to 2.0.2. The characters were wrong.
D) In 2.0.2 added and changed language to English-UTF8, all looks still wrong.
What else I can try. Maybe someone knows why forum characters are wrong after step b)?
Navigation
[0] Message Index
[#] Next page
Go to full version