4.2.2. installation fail UTF8MB4

  • I just started to install 4.2.2 Finnish package to hosting where I have never had any problems. The installation wizard errors right after trying to create tables.

    WordPress database error: [COLLATION ‘utf8_swedish_ci’ is not valid for CHARACTER SET ‘utf8mb4’]
    CREATE TABLE wprl_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default ”, user_pass varchar(64) NOT NULL default ”, user_nicename varchar(50) NOT NULL default ”, user_email varchar(100) NOT NULL default ”, user_url varchar(100) NOT NULL default ”, user_registered datetime NOT NULL default ‘0000-00-00 00:00:00’, user_activation_key varchar(60) NOT NULL default ”, user_status int(11) NOT NULL default ‘0’, display_name varchar(250) NOT NULL default ”, PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_swedish_ci

    The hosting company said that it’s WordPress issue. The mysql database version is 5.6.23-72.1-log

Viewing 7 replies - 1 through 7 (of 7 total)

  • Is this a brand new installation? Does your hosting company offer a one button installation?

    If this is a brand new installation, I suggest you delete everything and try a new install. If the install fails again, you might try installing the English version and then making the translation change in setting after you get a good install.

    Thread Starter sirrahikkala

    (@sirrahikkala)

    This is brand new installation. Straight from the localized, official zip. The English version works just fine.

    The issue/bug is that mysql 5.5 and 5.6 does not have UTF8_swedish_ci within UTF8MB4 so therefore this is quite big issue affecting most of nordic/scandinavian sites.

    I report same problem. Finnish latest wordpress installation with latest bitnami wamp stach fails also because Charset problem.

    WordPress database error: [COLLATION ‘utf8_swedish_ci’ is not valid for CHARACTER SET ‘utf8mb4’]

    I fixed the error with this:

    Edit wp-config.php:

    /** Tietokantatauluissa k?ytett?v? merkist?. */
define('DB_CHARSET', 'utf8mb4');

/** The Database Collate type. ?l? muuta t?t? jos et ole varma. */
define('DB_COLLATE', 'utf8mb4_swedish_ci');

    Also my database table nees to have tables defined as charset utf8mb4_swedish_ci

    The problem may be because wordpress switched to utf8mb4 caraghter set and while doing the finnish version some body forgot to change collate database type to utf8mb4_swedish_ci. Indeed the utf8mb4 set does not include the old caraghter set used past wordpress utf8 version.

    Over 2 weeks and still not fixed. This is quite critical bug and easy to fix ??

    Its not a bug in wordpress, its just the database thats set up to use a completely different collation than wordpress, I run a couple of swedish sites that doesnt have this problem for example. But like you said its easy to configure wp-config.php so it works.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘4.2.2. installation fail UTF8MB4’ is closed to new replies.