Hello. I have upgraded SMF from 1.10 version to 2.0 RC2 and upgrade gone well without any problem. When it came up to the last step (to delete upgrade.php) and when it redirects me to the forum root, this error showed up:
Unknown character set: 'windows'
Only blank page and that error. Default forum language was English, utf-8 and it had some balkanian language characters such as ćčžđš.
What should I do now ?
http://juvebalkan.com/smf/index.php
Please note that deleting the upgrade.php does not work on all servers, you might need to delete it manually.
Please login in phpMyAdmin, or similar tool, from your host (What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)), select your database, and run in the SQL tab:
SELECT value FROM smf_settings WHERE variable LIKE 'global_character_set';
and post the result here.
You might also want to make sure to re-upload the files from the language pack for English-UTF8, if I understand correctly and you had English-UTF8, to your server.
thank you, this solved an issue on another forum, good thing i searched first 8)
Quote from: Kill Em All on November 30, 2009, 01:37:21 PM
Please note that deleting the upgrade.php does not work on all servers, you might need to delete it manually.
It's deleted and it's still not working...
Quote from: Norv on November 30, 2009, 01:59:44 PM
Please login in phpMyAdmin, or similar tool, from your host (What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)), select your database, and run in the SQL tab:
SELECT value FROM smf_settings WHERE variable LIKE 'global_character_set';
and post the result here.
You might also want to make sure to re-upload the files from the language pack for English-UTF8, if I understand correctly and you had English-UTF8, to your server.
I tried both but nothing, still the same.
Any other solution ?
Thanks for trying to help.
Please post the result of the query here. It wasn't supposed to solve it yet, but to tell a character set SMF might depend on.
Here is the result of query:
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0005 sec)
SQL query:
SELECT value
FROM smf_settings
WHERE variable LIKE 'global_character_set';
LIMIT 0 , 30
Please download from your server, and open in a code editor, like Notepad++ if you're on windows, your file Settings.php from the forum directory. Is there any variable like
$db_character_set = 'something here';
in it?
Do not post that file here, it contains confidential information. Just please tell if it contains something of the kind.
Also: please make a phpinfo file, and post a link to it. (What is a phpinfo() file? (http://docs.simplemachines.org/index.php?topic=479.0))
I edited Settings.php and found that line. It's like this:
$db_character_set = 'windows-1250';
Maybe it should be changed to utf-8 or ?
PHP info:
http://www.juvebalkan.com/phpinfo.php
As a note (that may help here too, but also for the future): your server has php error logging off. Please tell your host to enable it, or let you know how to enable it for your sites.
Quote from: juvebalkan on November 30, 2009, 05:27:24 PM
I edited Settings.php and found that line. It's like this:
$db_character_set = 'windows-1250';
Maybe it should be changed to utf-8 or ?
Ah, I just saw your previous post. If you have UTF-8 forum, surely should.
Please edit it to read:
$db_character_set = 'utf8';
If you don't have an UTF8 forum and specially database, then you can simply remove this line completely.
To find out which:
please check in phpmyadmin your database tables: select your database, then select "Structure" tab, and look at all the list of tables. They should have a column named "Collation". What "collation" is there, for any of them?
It worked now when I changed to utf8 in Settings.php!
I changed before upgrading coallition to utf8_unicode_ci and it's still like that. Every table is utf8_unicode_ci.
Is that ok ?
Thank you very much for helping. Hope there won't be problems anymore here.
I will be boring a little more and ask one more question.
I had a section with bosnian letters žđš for example: Druženje i upoznavanje, and now after upgrade it looks like this: Druženje i upoznavanje
Im wondering why...
One more error...when I log in to the Administration panel it looks like this:
I guess I should reupload something or..?
Your database seems okay, then. But, as I looked at your forum files, it seems they are: Content-Type:
text/html; charset=ISO-8859-1
That's probably what is causing the wrong display of some characters.
Please try (phpmyadmin, SQL tab):
INSERT INTO smf_settings (variable, value) VALUES ('global_character_set', 'UTF-8');
(please replace "smf_" with your actual tables prefix, if necessary.)
Thank you. It helped.
What about my second question about Administration and the image I attached ?
It looks like missing language files, or text in the existing language files.
Could you please try to verify if in Admin > Languages, it's UTF8 language pack installed? If not, you may want to install/reinstall it.
Unfortunately, because of the problem I posted attached picture, I cannot see any Admin options so I cannot verify that. Is there any other way to verify that ? Or what files should I reupload ?
It should be: English UTF8 language pack, in all probability. From here: http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc2_english-utf8.zip
Unzip, and please make sure to replace all files you have with these.
Also, perhaps it helps: this is the direct link to the Admin > Languages on your forum http://juvebalkan.com/smf/index.php?action=admin;area=languages
If that section is visible, you could "Add language" or otherwise tell what languages you have installed.
Solved.
In Settings.php the language line was like this:
$language = 'english';
I just changed it to:
$language = 'english-utf8';
And it worked.
Thanks again.
Cheers, great to hear!