Topic on Project:Support desk

Pages with special characters (ä,ö,ü) are not shown after upgrade from 1.31.14 -> 1.35.2

4
80.146.191.156 (talkcontribs)

I've upgraded my wiki (extracted tar.gz, copied images, extensions and LocalSettings.php) and run php update.php without errors.

But now all my pages which contain an spcial character (e.g. ä, ö, ü) in title are not showen correctly. On "All Pages" page they are only the dots in the beginning but no link text. if i go to the article via direct link, i get an error title has a wrong UTF-8 sequence.

Didn't find anything on the internet about it. Any ideas?


My LocalSettings.php (runs perfectly with 1.31):

<?php

if( defined( 'MW_INSTALL_PATH' ) ) {

   $IP = MW_INSTALL_PATH;

} else {

   $IP = dirname( __FILE__ );

}

$path = array( $IP, "$IP/includes", "$IP/languages" );

set_include_path( implode( PATH_SEPARATOR, $path ) . PATH_SEPARATOR . get_include_path() );

require_once( "$IP/includes/DefaultSettings.php" );

ini_set( 'memory_limit', '128M' );

if ( $wgCommandLineMode ) {

   if ( isset( $_SERVER ) && array_key_exists( 'REQUEST_METHOD', $_SERVER ) ) {

       die( "This script must be run from the command line\n" );

   }

}

$wgSitename         = "MOS Wiki";

$wgScriptPath       = "";

$wgScriptExtension  = ".php";

$wgEnableEmail      = false;

$wgEnableUserEmail  = false; # UPO

$wgEmergencyContact = "<mail>";

$wgPasswordSender = "<mail>";

$wgEnotifUserTalk = false; # UPO

$wgEnotifWatchlist = false; # UPO

$wgEmailAuthentication = false;

$wgDBtype           = "mysql";

$wgDBserver         = "<ip>";

$wgDBname           = "<name>";

$wgDBuser           = "<user>";

$wgDBpassword       = "<pw>";

$wgDBprefix         = "wiki_";

$wgDBTableOptions   = "ENGINE=InnoDB, DEFAULT CHARSET=binary";

$wgMainCacheType = CACHE_NONE;

$wgMemCachedServers = array();

$wgEnableUploads       = true;

$wgSVGConverter = 'rsvg';

$wgShellLocale = "de_DE.utf8";

$wgUseTeX           = false;

$wgLocalInterwiki   = strtolower( $wgSitename );

$wgLanguageCode = "de";

$wgSecretKey = "<key>";

$wgDefaultSkin = 'vector';

$wgRightsPage = ""; # Set to the title of a wiki page that describes your license/copyright

$wgRightsUrl = "";

$wgRightsText = "";

$wgRightsIcon = "";

$wgDiff3 = "/usr/bin/diff3";

$wgCacheEpoch = max( $wgCacheEpoch, gmdate( 'YmdHis', @filemtime( __FILE__ ) ) );

$wgServer = "https://<ip>";

$wgGroupPermissions['*'    ]['edit']            = false;

$wgGroupPermissions['*'    ]['createpage']      = false;

$wgGroupPermissions['*'    ]['createtalk']      = false;

$wgGroupPermissions['*'    ]['read']      = true;

$wgGroupPermissions['*'    ]['createaccount']      = false;

$wgGroupPermissions['*'    ]['writeapi']      = false;

$wgGroupPermissions['sysop']['createaccount'] = true;

$wgGroupPermissions['user']['rollback']         = true;

wfLoadSkin( 'Timeless' );

wfLoadSkin( 'MonoBook' );

wfLoadSkin( 'Vector' );

$wgLogo = "{$wgScriptPath}/images/logo.jpg";

$wgFileExtensions = array('gif','png','jpg','jpeg','svg','xls','xlsx','xlsm','doc','docx','ppt','pptx','rtf','pdf', 'zip','7z','dia','sh','vsd','vsdx');

$wgTrustedMediaFormats[]='application/x-gzip';

$wgUseAjax = true;

wfLoadExtension( 'CategoryTree' );

$wgCategoryTreeDisableCache = true;

$wgCategoryTreeDefaultOptions['mode'] = 'pages';

$wgCategoryTreeCategoryPageOptions['mode'] = 'pages';

$wgCategoryTreeSpecialPageOptions = true;

$wgCategoryTreeSidebarOptions = true;

$wgVerifyMimeType = false;

$wgMaxUploadSize = 67108864;

$wgAllowExternalImages = true;

wfLoadExtension( 'Cite' );

$wgLocaltimezone = "Europe/Berlin";

$oldtz = getenv("TZ");

putenv("TZ=$wgLocaltimezone");

$wgLocalTZoffset = date("Z") / 60;

putenv("TZ=$oldtz");

wfLoadExtension( 'WikiEditor' );

$wgDefaultUserOptions['usebetatoolbar'] = 1;

$wgDefaultUserOptions['usebetatoolbar-cgd'] = 1;

$wgDefaultUserOptions['wikieditor-preview'] = 1;

$wgDefaultUserOptions['wikieditor-publish'] = 1;

wfLoadExtension( 'SyntaxHighlight_GeSHi' );

wfLoadExtension( 'PDFEmbed' );

$wgPdfEmbed['width'] = 800;

$wgPdfEmbed['height'] = 1090;

80.146.191.156 (talkcontribs)

maybe the db config is the problem?


MariaDB [(none)]> select table_name,engine,TABLE_COLLATION  from information_schema.tables where table_schema = '<db>';

+----------------------------+--------+-------------------+

| table_name                 | engine | TABLE_COLLATION   |

+----------------------------+--------+-------------------+

| wiki_user_properties       | InnoDB | binary            |

| wiki_uploadstash           | InnoDB | binary            |

| wiki_calendar_version      | MyISAM | latin1_swedish_ci |

| wiki_user_former_groups    | InnoDB | binary            |

| wiki_external_user         | InnoDB | binary            |

| wiki_trackbacks            | InnoDB | latin1_swedish_ci |

| wiki_revision_comment_temp | InnoDB | binary            |

| wiki_l10n_cache            | InnoDB | binary            |

| wiki_ipblocks_old          | InnoDB | latin1_swedish_ci |

| wiki_content               | InnoDB | binary            |

| wiki_user_newtalk          | MyISAM | latin1_swedish_ci |

| wiki_oldimage              | InnoDB | latin1_swedish_ci |

| wiki_watchlist             | InnoDB | latin1_swedish_ci |

| wiki_watchlist_expiry      | InnoDB | binary            |

| wiki_interwiki             | InnoDB | latin1_swedish_ci |

| wiki_actor                 | InnoDB | binary            |

| wiki_ip_changes            | InnoDB | binary            |

| wiki_bot_passwords         | InnoDB | binary            |

| wiki_langlinks             | InnoDB | latin1_swedish_ci |

| wiki_ipblocks_restrictions | InnoDB | binary            |

| wiki_user_groups           | InnoDB | latin1_swedish_ci |

| wiki_job                   | InnoDB | latin1_swedish_ci |

| wiki_revision_actor_temp   | InnoDB | binary            |

| wiki_user                  | InnoDB | latin1_swedish_ci |

| wiki_page_restrictions     | InnoDB | latin1_swedish_ci |

| wiki_recentchanges         | InnoDB | latin1_swedish_ci |

| wiki_querycache_info       | InnoDB | latin1_swedish_ci |

| wiki_querycachetwo         | InnoDB | latin1_swedish_ci |

| wiki_updatelog             | InnoDB | latin1_swedish_ci |

| wiki_ipblocks              | InnoDB | latin1_swedish_ci |

| wiki_templatelinks         | InnoDB | latin1_swedish_ci |

| wiki_page                  | InnoDB | latin1_swedish_ci |

| wiki_querycache            | InnoDB | latin1_swedish_ci |

| wiki_pagelinks             | InnoDB | latin1_swedish_ci |

| wiki_redirect              | InnoDB | latin1_swedish_ci |

| wiki_module_deps           | InnoDB | binary            |

| wiki_site_identifiers      | InnoDB | binary            |

| wiki_log_search            | InnoDB | binary            |

| wiki_protected_titles      | InnoDB | latin1_swedish_ci |

| wiki_objectcache           | InnoDB | latin1_swedish_ci |

| wiki_logging               | InnoDB | latin1_swedish_ci |

| wiki_slot_roles            | InnoDB | binary            |

| wiki_content_models        | InnoDB | binary            |

| wiki_site_stats            | InnoDB | latin1_swedish_ci |

| wiki_change_tag_def        | InnoDB | binary            |

| wiki_externallinks         | InnoDB | latin1_swedish_ci |

| wiki_categorylinks         | InnoDB | latin1_swedish_ci |

| wiki_filearchive           | InnoDB | latin1_swedish_ci |

| wiki_image                 | InnoDB | latin1_swedish_ci |

| wiki_slots                 | InnoDB | binary            |

| wiki_calendar_header       | MyISAM | latin1_swedish_ci |

| wiki_math                  | InnoDB | latin1_swedish_ci |

| wiki_text                  | InnoDB | latin1_swedish_ci |

| wiki_imagelinks            | InnoDB | latin1_swedish_ci |

| wiki_page_props            | InnoDB | latin1_swedish_ci |

| wiki_category              | InnoDB | latin1_swedish_ci |

| wiki_change_tag            | InnoDB | binary            |

| wiki_revision              | InnoDB | latin1_swedish_ci |

| wiki_searchindex           | MyISAM | latin1_swedish_ci |

| wiki_archive               | InnoDB | latin1_swedish_ci |

| wiki_iwlinks               | InnoDB | binary            |

| wiki_sites                 | InnoDB | binary            |

| wiki_calendar_events       | MyISAM | latin1_swedish_ci |

| wiki_validate              | InnoDB | latin1_swedish_ci |

| wiki_comment               | InnoDB | binary            |

+----------------------------+--------+-------------------+

65 rows in set (0.005 sec)

80.146.191.156 (talkcontribs)

MariaDB [(none)]> SELECT column_name, character_set_name FROM information_schema.`COLUMNS`  WHERE table_schema = "<db>" AND table_name = "wiki_page";

+--------------------+--------------------+

| column_name        | character_set_name |

+--------------------+--------------------+

| page_id            | NULL               |

| page_namespace     | NULL               |

| page_title         | latin1             |

| page_restrictions  | NULL               |

| page_is_redirect   | NULL               |

| page_is_new        | NULL               |

| page_random        | NULL               |

| page_touched       | latin1             |

| page_latest        | NULL               |

| page_len           | NULL               |

| page_content_model | NULL               |

| page_links_updated | NULL               |

| page_lang          | NULL               |

+--------------------+--------------------+

13 rows in set (0.00 sec)

Bawolff (talkcontribs)

maybe try changing the charset on everything to binary? Mediawiki generally prefers the db to be binary (with data encoded utf8, but no charset in db). Make backups before trying anything.


Worst case, export a dump, convert with iconv, change charset to binary, reimport.

Reply to "Pages with special characters (ä,ö,ü) are not shown after upgrade from 1.31.14 -> 1.35.2"