Upgrade from 1.1.10 to 2.0 RC2 problem

Started by juvebalkan, November 30, 2009, 12:04:12 PM

Previous topic - Next topic

juvebalkan

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

Kill Em All

Please note that deleting the upgrade.php does not work on all servers, you might need to delete it manually.


My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

Norv

Please login in phpMyAdmin, or similar tool, from your host (What is phpMyAdmin?), 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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

SimpleJoe

thank you, this solved an issue on another forum, good thing i searched first  8)
Hosting Simple Machines since YaBB -- One of the first SMF Forum Hosting providers with Chat and FTP for the inner developer in us all.

juvebalkan

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?), 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.

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

juvebalkan

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

Norv

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?)
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

juvebalkan

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 ?

juvebalkan


Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Norv

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?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

juvebalkan

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.

juvebalkan

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...

juvebalkan

One more error...when I log in to the Administration panel it looks like this:

I guess I should reupload something or..?


Norv

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.)
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

juvebalkan

Thank you. It helped.

What about my second question about Administration and the image I attached ?

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

juvebalkan

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 ?

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Advertisement: