WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] WordPress 2.5 upgrade: Database encoding serious problems (11 posts)

  1. phnk
    Member
    Posted 6 years ago #

    There is a serious issue with WP 2.5 RC1 as far as I can tell. My update went perfectly well but all accentuated characters are showing scrambled. Check it here (written in French, hence the high frequency of such chars).

    My first reflex was to blame MySQL, so I went to phpmyadmin and checked my encoding settings:

    - MySQL charset: UTF-8 Unicode (utf8)
    - MySQL connection collation: utf8_unicode_ci

    I then blamed my personal template, but the problem subsists with the Default WP template. Argh!

    What should I change to get my proper character display?

  2. Lester Chan
    Member
    Posted 6 years ago #

  3. phnk
    Member
    Posted 6 years ago #

    Thanks, but I don't think it does: my database is configured for UTF-8. Here's a copy of my server settings:

    character set client utf8
    (Global value) latin1
    character set connection utf8
    (Global value) latin1
    character set database latin1
    character set filesystem binary
    character set results utf8
    (Global value) latin1
    character set server latin1
    character set system utf8
    character sets dir /usr/share/mysql/charsets/
    collation connection utf8_unicode_ci

    It seems to me everything is well set for feeding WP with UTF-8. Help!

  4. phnk
    Member
    Posted 6 years ago #

    Solution: comment the DB_CHARSET line in the wp-config.php file. Found in this comment:

    I had a similar problem on my blog and all I had to do was to add // to one line in wp-config.php

    I changed

    define(’DB_CHARSET’, ‘utf8′);

    to

    // define(’DB_CHARSET’, ‘utf8′);

    And everything was fine.

    Your link was helpful in the end, thanks very much! Lesson: always check the comments.

  5. jokkesvin
    Member
    Posted 6 years ago #

    phnk --> You're awesome man! This was also the solution to MY problem :) I'm from Denmark, and after upgrading to 2.5, all danish characters were substituted with wrong ones. Putting // in front fixed this. I wonder why though?

  6. stlytm
    Member
    Posted 6 years ago #

    For those of you using vDeck and have had no problems uploading WordPress 2.5, maybe you can help me. The first time I ftp to my server and tried to open the blog I got this message."Error establishing a Data Base connection"

    Now when I ftp and try to install, I get the message that my wp-config is not right. I have the same data as I did in Webpress 2.3, I logged onto vDeck and checked the files in wordpress, and seen that the files were not uploaded. When using my ftp it shows the files in the Remote site, but somehow they are not reaching my files in vDeck. for the host I put in *******.startlogic.com, I also tried the old way by putting in itsmydeal.net, neither one works.

    I also just got through trying // define(’DB_CHARSET’, ‘utf8′);, but didn't work.

    So in summary, do we make changes to the wp-config that I don't know about. I am at a loss right now.

  7. jokkesvin
    Member
    Posted 6 years ago #

    stlytm --> As far as I know you shouldn't do anything to wp-config.php. It contains the login-info to the database. If you move the site, then you might have to change this file. I'm not sure though.

  8. artzja
    Member
    Posted 6 years ago #

    I have problem like jokkesvin when I upgrade from 2.0.11 to 2.5

    thanks phnk for ur advice, it's very useful for the other charset/language

  9. taoski
    Member
    Posted 6 years ago #

    @phnk

    You da man!

    Had the issue when upgrading to 2.5 from 2.3

    Thanks.

  10. flick
    Member
    Posted 5 years ago #

    Massive phew, thank you so much! :D Just a simple change in config worked (after the upgrade) much to my relief!

  11. noyz319
    Member
    Posted 5 years ago #

    I'm experiencing a similar error with special characters just show weird code after an upgrade from 2.3.3 to 2.5.1. I've tried commenting out and deleting these 2 lines, which we're not in my old wp-config:

    define('DB_CHARSET', 'utf8'′);
    define('DB_COLLATE', '');

    But when i take them out i get the following error"

    "Warning: Invalid argument supplied for foreach() in /home/content/mywebsite/html/wp-includes/classes.php on line 92"

    And all my pages and posts show page not found errors.
    I've also just tried changing it to:

    define('DB_CHARSET', 'UTF-8'′);
    and
    define('DB_CHARSET', ''′);

    But no luck. Any help would be very much appreciated!

Topic Closed

This topic has been closed to new replies.

About this Topic