WordPress database errors

  • Resolved dibbes_nl

    (@dibbes_nl)


    13 years, 8 months ago

    After filling in the first page of wp-admin/install.php and trying to install WordPress, I get a long list of database errors. The first one looks like this:

    WordPress database error: [Unknown character set: ‘utf8_general_ci’]
    CREATE TABLE wpr_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 utf8_general_ci

    What am I doing wrong and how to solve this?

Viewing 3 replies - 1 through 3 (of 3 total)
  • ricardusexa

    (@ricardusexa)

    13 years, 8 months ago

    – First, try contacting the hosting provider if the database server is online / if they have any other problem at their end, or they made any changes to your account, or if there are any limitations/restrictions, if the hosting package is set to Windows and not Linux, etc .

    – double check your wp-config.php file settings for the database name, database username and database password. This is where most errors occur.

    -Then check that you don’t need to change the database host from “localhost” to something else. You can get that info from your hosting provider.

    -Check you have actually created a database with the same database name as is in your wp-config.php file.
    -Last, but not least, if all that information is correct your database probably has a problem with it, and you may need to contact your hosting provider.

    Max

    (@clementsm)

    13 years, 8 months ago

    @dibbes_nl: Thats is very odd error, as utf8_general_ci is not the name of a character set, but rather of a database collation, thus the query above will generate that error on any MySQL database as it has DEFAULT CHARACTER SET utf8_general_ci at the end.

    This makes me wonder two things:

    1. What version of WordPress are you using, there was something I recall seeing in trac about a similar issue in WordPress 3
    2. Did you tinker with wp-config.php before you ran the install?
    Thread Starter dibbes_nl

    (@dibbes_nl)

    13 years, 8 months ago

    Thanx for your help. The problem is resolved; I’ve done a ‘clean’ install and now it works…

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

The topic ‘WordPress database errors’ is closed to new replies.