Database Repair?

  • aaroniconnect

    (@aaroniconnect)


    10 years, 4 months ago

    Hi,

    I got redirected to the forum while trying to “repair my database” during step 2 of the installation of an offline USBwebserver WordPress to ask about the following;

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

    What am I supposed to do about this?
    I have renamed the wp-config-sample.php to wp-confg.php,
    then I filled in 8 keys, filled in a new database after that,
    and tried to run again, because before I used the new database,
    I used the standard ‘test’ database which comes with phpMyadmin,
    and it turned out to read “Error establishing a database connection”
    in my browser. This resulted in me being able to repair my databases
    this time, but now I’m stuck with the above mentioned results.

    I’d really appreciate some clarification about all this.

    Thanks in advance,
    Aaron

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter aaroniconnect

    (@aaroniconnect)

    10 years, 4 months ago

    Now. without changing anything it gives me the old error message in the browser when running localhost again, namely “Error establishing a database connection”.

    Thread Starter aaroniconnect

    (@aaroniconnect)

    10 years, 4 months ago

    This is what I get if I try to change it, new database generated through phpMyadmin and rerunning the instal:

    ======================================================================
    The wp_users table is okay.

    The wp_usermeta table is okay.

    The wp_posts table is not okay. It is reporting the following error: Table ‘iconnect2.wp_posts’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_posts table. Error: Table ‘iconnect2.wp_posts’ doesn’t exist

    The wp_comments table is not okay. It is reporting the following error: Table ‘iconnect2.wp_comments’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_comments table. Error: Table ‘iconnect2.wp_comments’ doesn’t exist

    The wp_links table is not okay. It is reporting the following error: Table ‘iconnect2.wp_links’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_links table. Error: Table ‘iconnect2.wp_links’ doesn’t exist

    The wp_options table is not okay. It is reporting the following error: Table ‘iconnect2.wp_options’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_options table. Error: Table ‘iconnect2.wp_options’ doesn’t exist

    The wp_postmeta table is not okay. It is reporting the following error: Table ‘iconnect2.wp_postmeta’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_postmeta table. Error: Table ‘iconnect2.wp_postmeta’ doesn’t exist

    The wp_terms table is not okay. It is reporting the following error: Table ‘iconnect2.wp_terms’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_terms table. Error: Table ‘iconnect2.wp_terms’ doesn’t exist

    The wp_term_taxonomy table is not okay. It is reporting the following error: Table ‘iconnect2.wp_term_taxonomy’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_term_taxonomy table. Error: Table ‘iconnect2.wp_term_taxonomy’ doesn’t exist

    The wp_term_relationships table is not okay. It is reporting the following error: Table ‘iconnect2.wp_term_relationships’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_term_relationships table. Error: Table ‘iconnect2.wp_term_relationships’ doesn’t exist

    The wp_termmeta table is okay.

    The wp_commentmeta table is not okay. It is reporting the following error: Table ‘iconnect2.wp_commentmeta’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_commentmeta table. Error: Table ‘iconnect2.wp_commentmeta’ doesn’t exist

    Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.
    =======================================================================
    FOLLOWED BY A BOXED UP SUMMARRY, As following;
    =======================================================================
    wp_posts: Table ‘iconnect2.wp_posts’ doesn’t exist
    wp_comments: Table ‘iconnect2.wp_comments’ doesn’t exist
    wp_links: Table ‘iconnect2.wp_links’ doesn’t exist
    wp_options: Table ‘iconnect2.wp_options’ doesn’t exist
    wp_postmeta: Table ‘iconnect2.wp_postmeta’ doesn’t exist
    wp_terms: Table ‘iconnect2.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘iconnect2.wp_term_taxonomy’ doesn’t exist
    wp_term_relationships: Table ‘iconnect2.wp_term_relationships’ doesn’t exist
    wp_commentmeta: Table ‘iconnect2.wp_commentmeta’ doesn’t exist
    =======================================================================

    Where does this go wrong?
    Any help or suggestions are welcome!

    Thanks in advance,
    Aaron

    roaniaraujo

    (@roaniaraujo)

    9 years, 4 months ago

    Eu também tive este erro…

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

    o que faço?

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

The topic ‘Database Repair?’ is closed to new replies.