6,566
edits
(→Meta template and templates for commonly used logotypes and icons: Did Hooray mean both logotypes and icons? Some ideas and advice.) |
(Editing pages with UTF-8 names.) |
||
Line 45: | Line 45: | ||
—[[User:Johan G|Johan G]] ([[User_talk:Johan_G|Talk]] | [[Special:Contributions/Johan_G|contribs]]) 06:44, 12 April 2020 (EDT) | —[[User:Johan G|Johan G]] ([[User_talk:Johan_G|Talk]] | [[Special:Contributions/Johan_G|contribs]]) 06:44, 12 April 2020 (EDT) | ||
== UTF-8 language pages cannot be edited (cont. from 2015) == | |||
While migrating my own unrelated MediaWiki instance, I may have stumbled upon "a" SQL issue blocking the creation of pages with non-latin characters in their titles. See: | |||
* [[FlightGear wiki:Village pump/Archive 2015#UTF-8 language pages cannot be edited]] | |||
* [[FlightGear wiki:Village pump/Archive 2016#UTF-8 language pages cannot be edited]] | |||
* [[FlightGear wiki:Village pump/Archive 2019#Language flags on the main page]] | |||
If someone has access to the MySQL backend (command line or phpMyAdmin), could you check what the "Collation" of our database is set to? For example: | |||
<syntaxhighlight lang="sql"> | |||
USE dbname; | |||
SELECT @@character_set_database, @@collation_database; | |||
</syntaxhighlight> | |||
Or in phpMyAdmin the collation is given in the database listing. My guess is that we are not using UTF-8. That can be changed (after a backup) with: | |||
<syntaxhighlight lang="sql"> | |||
ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci; | |||
</syntaxhighlight> | |||
Or in phpMyAdmin, select the databse of this wiki, click on the "Operations" tab, in the "Collation" box select "utf8_general_ci", and finally click on "Go". Hopefully this is the cause of this long standing and painful issue. | |||
[[User:Bugman|Bugman]] ([[User talk:Bugman|talk]]) 03:33, 9 September 2020 (EDT) |