Can't move site to new hosting – DB Charset utf8mb4 problem

  • Resolved Gega

    (@gega23)


    8 years, 10 months ago

    Hello,

    we have a serious problem. We have developed a site with WPML. On our Server is MySQL Version 5.5.x is installed, but on the client’s server there is only the Version 5.1.x.
    When we tried to move the site to the hosting of the client, there was errors because of the charset of the db. We couldn’t import the DB because it has the charset ‘utf8mb4’ and this is only supported from the MySQL Version 5.53 or above.
    We tried to change the charset in the sql file, but it’s also not working. The website is there, but only 1 language is showing up, the language switcher is also gone, the footer also, and there is an error message:

    Warning: mysqli_set_charset(): Error executing query in ../wp-includes/wp-db.php on line 772

    The backend is also not working, there are 2 error messages:

    Warning: mysqli_set_charset(): Error executing query in ../wp-includes/wp-db.php on line 772

    Warning: Cannot modify header information – headers already sent by (output started at ../wp-includes/wp-db.php:772) in ../wp-includes/pluggable.php on line 1196

    Is there maybe a workaround?
    We contacted the hoster, but they can’t upgrade the MySQL. So this is not an option.
    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Justin Greer

    (@justingreerbbi)

    8 years, 10 months ago

    Sorry to hear about your issue. Unfortunately you are going to have to move to a better host. The upgrade in regards to the DB has taken place in 4.2 and for good reasons.

    A host that only support 5.1 is not a host that anyone would recommend.

    WordPress Minimum Requirements:
    – PHP 5.4 or greater
    – MySQL 5.5 or greater
    – The mod_rewrite Apache module

    These can be found at https://wordpress.org/about/requirements/

    Thread Starter Gega

    (@gega23)

    8 years, 10 months ago

    Hi Justin,

    thanks for the quick answer. Yes i know, also we know that the host is not a good one, but the client have choosed this one, and they have also other domains/hosting there. I thought there is some workaround for this.

    But than i think the moving would be the easiest way.
    Thanks anyway.

    Justin Greer

    (@justingreerbbi)

    8 years, 10 months ago

    Yup, sounds like delima. Minimum Requirements are a good ground to push back.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Can't move site to new hosting – DB Charset utf8mb4 problem’ is closed to new replies.