Hello,
I have new hosting and there is a two issues after installing SMF.
1. This server works in UTF-8 encoding, after create the database it has a collation utf8_general_ci and when I check this option during SMF installation: Use UTF-8 as default character set (This feature lets both the database and the forum use an international character set, UTF-8. This can be useful when working with multiple languages that use different character sets) the letters are not displayed correctly. There is bad character encoding. If I do not check this option, diacritical marks are displayed correctly. Is this a server-side issue? Or should I just not check this option during installation?
2. Second issue; After installing SMF, the graphic elements of the theme are not displayed. Because some paths do not display a domain address but a localhost address 127.0.0.1. Look at this:
(https://i.imgur.com/LfrIsd9.png)
There is no smf directory on the server. I have sent a message to the server support, unfortunately they don't know why these issues occur. I have installed SMF many times on various hosting, but I have not encountered such a issues so far.
Please help, I will send them information on what needs to be improved.
Hello there,
Not really sure how "no smf directory on the server" is possible, but anyway, those URLS in settings should not look like that, those should be real URLs with your actual domain. Once you fix those you should be able to see graphs nicely though.
Are you using latest installation pack from our download section for this, or you're using some kind of auto-installers?
this is a known bug in the installer. if you use the suggested URL's in the repair_settings.php script it will fix everything for you.
As for your other issue, did you install the correct utf-8 language pack as well as setting that option?
QuoteNot really sure how "no smf directory on the server" is possible
I meant that SMF files are not in the /smf/ directory on the server.
Quotethose URLS in settings should not look like that, those should be real URLs with your actual domain.
Definitely.
QuoteOnce you fix those you should be able to see graphs nicely though.
Sure, but why do I need to fix these paths? Why is the domain address not displayed correctly in these paths?
QuoteAre you using latest installation pack from our download section for this, or you're using some kind of auto-installers?
I'm using the latest version 2.0.15 from your download page.
Quote from: Illori on November 13, 2019, 10:07:06 AM
this is a known bug in the installer. if you use the suggested URL's in the repair_settings.php script it will fix everything for you.
I know this, but why is there such an error in the installer? This maybe a server side bug.
Quote from: Arantor on November 13, 2019, 10:10:49 AM
As for your other issue, did you install the correct utf-8 language pack as well as setting that option?
Yes. After sending SMF files and Polish-UTF8 language files to the server, I turn on the SMF installer and after mark this option:
Use UTF-8 as default character set (This feature lets both the database and the forum use an international character set, UTF-8. This can be useful when working with multiple languages that use different character sets)Polish diacritical marks do not display correctly on the forum. This only happens on this server. If I do not check this option, the characters are displayed correctly.
it is a bug that will be fixed in the next release. you need to fix the URLs with the repair_settings.php script. you are not the first person to run into this issue.
Quote from: Illori on November 13, 2019, 10:36:32 AM
it is a bug that will be fixed in the next release. you need to fix the URLs with the repair_settings.php script. you are not the first person to run into this issue.
I understand. Thank you for the clarification, but this does not happen on every server?
if they are running opcache I believe it is called. if not then they don't have this issue. in the next release this bug will be fixed.
this only happens during the install and effects nothing else.
Illori thank you very much for the clarification.
But what about incorrect encoding after marks this option?
Use UTF-8 as default character set (This feature lets both the database and the forum use an international character set, UTF-8. This can be useful when working with multiple languages that use different character sets).
Have you confirmed that your database IS actually using UTF8?
Definitely. After creating a new database, the database is automatically set to utf8_general_ci because the server uses this encoding.
Except that there are 6 different places where the encoding can be set and the one you keep mentioning may be overridden by any of the others. Don't assume, check what the tables *actually* are using by looking at the tables themselves.
I conducted a test. I created a new database that has the collation utf8_general_ci and during the SMF installation I marked this option:
Use UTF-8 as default character set (This feature lets both the database and the forum use an international character set, UTF-8. This can be useful when working with multiple languages that use different character sets).
After installation, I repaired the paths with the Repair Settings tool and after loading the theme, the category name and board name with description do not display diacritical marks correctly. The tables in phpmyadmin have the collation utf8_general_ci
(https://i.imgur.com/vSpklzZ.png)
Groups:
(https://i.imgur.com/RuKrUNC.png)
Style Settings:
(https://i.imgur.com/7gWW6wi.png)
If I create a new board, diacritics are displayed correctly:
(https://i.imgur.com/npXZOq6.png)
Database server
Server type: MariaDB
Server version: 10.1.41-MariaDB-cll-lve - MariaDB Server
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)
Just because the database is set to a thing does not guarantee what any given table or column has.
It is perfectly possible to have the database set to one collation, each table in it to a different collation, and each column inside those to different collation again.
So, again, what do your columns ACTUALLY have?
Quote from: Arantor on November 14, 2019, 05:01:21 AM
So, again, what do your columns ACTUALLY have?
Do you mean these columns?
(https://i.imgur.com/T0d3IRX.png)
(https://i.imgur.com/TUkOYen.png)
No, those are tables. Go into the actual tables themselves and select the Structure tab to see the actual columns.
Table: smf_boards
(https://i.imgur.com/iDa95Yo.png)
Table: smf_membergroups
(https://i.imgur.com/HvO6TnA.png)
Ok, so those are actually utf8. Needed checking.
Next check: in your Settings.php file, is there a declaration for $db_character_set?
QuoteNeeded checking
Should I check something?
QuoteNext check: in your Settings.php file, is there a declaration for $db_character_set?
Yes. This line is in this file:
$db_character_set = 'utf8';I installed SMF 2.1 RC2 and diacritical marks are displayed correctly in these places.
I installed SMF with this option:
Use UTF-8 as default character set (This feature lets both the database and the forum use an international character set, UTF-8. This can be useful when working with multiple languages that use different character sets).
And I manually corrected the incorrect character encoding in some places.
Look at this bug in the upcoming version 2.0.16