Support » Localhost Installs » Install- Cannot repair database error

  • Please assist. thank you in advance.

    error messages below:

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

Viewing 11 replies - 1 through 11 (of 11 total)
  • What plugin or utility are you using? When does it happen? That’s not a very descriptive question.

    Those errors basically say that the WordPress tables do not exist in the database.

    check the database see if you using some other prefix

    Using Wampserver 2.4 to try and install WP 3.8.1.
    The Wamp installs on Localhost.
    Was able to login to the phpadmin,
    created the wp database,
    reconfigured wp-config.php to recognize the database (name)
    then opened using:

    localhost/wp-admin/install.php
    Added a username and pw
    clicked install–got error message
    added define(‘WP_ALLOW_REPAIR’, true); to the config file.
    The above are the error messages i get after I click “install”

    I agree. I cannot see those tables in the database!
    This is a brand new install.

    I don’t use WampServer much but I do use XAMPP all the time and the process should be similar.

    This is how I roll:

    1. I create an empty database with no user using phpMyAdmin.
    2. I unzip the WordPress download and rename the wordpress folder to the project name.
    3. I visit 127.0.0.1/projects/[new project] and run the install using ‘root’ with ‘no password’. Done.

    Since I am behind a firewall on localhost the db details don’t matter and I always export and import the db onto production sites following these steps http://interconnectit.com/719/migrating-a-wordpresswpmubuddypress-website/

    If you are getting db errors already…just delete the db and start over.

    Hope that helps 🙂

    What should my Collation default be for a new install btw?

    Thank you Keith. Gonna delete and reinstall. Will start again.

    the default is ‘define( ‘DB_COLLATE’, ” );’ and should work in most cases 🙂

    Ok. Reinstalled the Wamp and datbase.
    Got further.
    But now getting this message at the WP install page:

    Site Title
    Username User(s) already exists.

    I used root for installation puroposes-
    The Username field is greyed out and i cannot add anything here.

    i such a noob at this. thank you for your assistance.

    Here is an article from a reputable blog describing how to install Wamp and WordPress http://www.wpbeginner.com/wp-tutorials/how-to-install-wordpress-on-your-windows-computer-using-wamp/

    Thank you again Keith.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Install- Cannot repair database error’ is closed to new replies.