WordPress.org

Ready to get started?Download WordPress

Forums

Install- Cannot repair database error (12 posts)

  1. mvhowie
    Member
    Posted 1 year ago #

    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

  2. Keith Driscoll
    Member
    Posted 1 year ago #

    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.

  3. govpatel
    Member
    Posted 1 year ago #

    check the database see if you using some other prefix

  4. mvhowie
    Member
    Posted 1 year ago #

    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.

  5. Keith Driscoll
    Member
    Posted 1 year ago #

    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 :)

  6. mvhowie
    Member
    Posted 1 year ago #

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

  7. mvhowie
    Member
    Posted 1 year ago #

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

  8. Keith Driscoll
    Member
    Posted 1 year ago #

    the default is 'define( 'DB_COLLATE', '' );' and should work in most cases :)

  9. mvhowie
    Member
    Posted 1 year ago #

    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.

  10. mvhowie
    Member
    Posted 1 year ago #

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

  11. Keith Driscoll
    Member
    Posted 1 year ago #

    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/

  12. mvhowie
    Member
    Posted 1 year ago #

    Thank you again Keith.

Topic Closed

This topic has been closed to new replies.

About this Topic