wordpress installation on localhost returns db errors

  • Hi there,

    After running the ‘repair’ database during installation of WordPress on my localhost, I receive the following error message.

    I take these to mean the respective tables have not been created. Why would that happen?

    wp_posts: Table ‘wpdb.wp_posts’ doesn’t exist
    wp_comments: Table ‘wpdb.wp_comments’ doesn’t exist
    wp_links: Table ‘wpdb.wp_links’ doesn’t exist
    wp_options: Table ‘wpdb.wp_options’ doesn’t exist
    wp_postmeta: Table ‘wpdb.wp_postmeta’ doesn’t exist
    wp_terms: Table ‘wpdb.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘wpdb.wp_term_taxonomy’ doesn’t exist
    wp_term_relationships: Table ‘wpdb.wp_term_relationships’ doesn’t exist
    wp_termmeta: Table ‘wpdb.wp_termmeta’ doesn’t exist
    wp_commentmeta: Table ‘wpdb.wp_commentmeta’ doesn’t exist

    Your help would be much appreciated.

    Regards,

    Nick

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    do you have the database prefix set correctly in wp-config.php?

    Thread Starter niicaux

    (@niicaux)

    I have not touched anything else.
    In the initial setup screen where it asks for the database name and so forth, I only entered the database name (wpdb) and the username, with the host as ‘localhost’. The database prefix was left at the default value of wp_

    When adding the script to wp-config to repair the table, I added it as the last line of the other variable definitions.

    ...
define('NONCE_SALT',       '%qruCu*>$,<e:twsS$=jE%;Fr d+>?C~UFuZ&OIml)rb<lq7c*D ,(%J/{dTDYfl');
define('WP_ALLOW_REPAIR', true);

    Thread Starter niicaux

    (@niicaux)

    Btw,

    Would the following values have anything to do with my problem?

    /** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8mb4');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');
    Thread Starter niicaux

    (@niicaux)

    Also, these two initial tables were created fine.

    The wp_users table is okay.

    The wp_usermeta table is okay.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘wordpress installation on localhost returns db errors’ is closed to new replies.