Upgraded to WordPress 3.1.2

It’s been a little while since my last upgrade of WordPress for this blog, the last version is an old 2.2.2. WordPress has changed and improved a lot since then, so I decided to upgrade it to the latest version 3.1.2. Also, I also changed the theme to give it a new look. Hopefully this is a new chance for me to post more.

The migration was basically smooth, but I still got several small problems.

  • Post revision is a new feature comparing with older versions. But it will make the database bloated and sometimes it’s not really needed. It can be disabled by adding this line to wp-config.php just before the last line:
    define('WP_POST_REVISIONS', 0);

    The number defines the number of revisions will be kept in the database’s posts table, 0 is for disabled.

  • The structure of table wp_posts is changed. I backed up my old database then restored to the new installation, but I found there’s no trash link for me to retrieve or delete posts or pages I trashed. When I checked in phpMyAdmin, I found the post_status can not be set to trash. The trashed posts or pages are still in the database but you cannot delete them, this will cause some problems, e.g., I cannot generate a new post or page with the same slug that’s used by a trashed post or page. I solved this problem by backing up the old database by its data only without selecting the structure. So that the structure of the new database will not be changed.
  • In this new version, seems the problem for Chinese support is still there. As before, I need to change the following section in wp-config.php to make it display Chinese characters correctly:

    define('DB_CHARSET', 'utf8');


    define('DB_CHARSET', '');

Related posts

Leave a comment


Leave a Reply

[ Ctrl + Enter ]