Missing tables problem

  • amit_murat

    (@amit_murat)


    12 years, 2 months ago

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Dave Naylor

    (@wpranger)

    12 years, 2 months ago

    Seems that you have first.wp_ set at the table prefix in your wp-config.php. Does that correspond to your actual database?

    Thread Starter amit_murat

    (@amit_murat)

    12 years, 2 months ago

    please help me for solve this problem

    Dave Naylor

    (@wpranger)

    12 years, 2 months ago

    In your wp-config.php, that’s most likely in the root of your WordPress installation, there’s a file called wp-config.php

    In that file, somewhere around line 62, you’ll find this:

    $table_prefix = 'wp_';

    Does that look like yours, or does it have this?

    $table_prefix = 'first.wp_';

    Thread Starter amit_murat

    (@amit_murat)

    12 years, 2 months ago

    $table_prefix = ‘first.wp_’;
    when i add this , it gives error

    ERROR: $table_prefix in wp-config.php can only contain numbers, letters, and underscores.

    please solve this

    Dave Naylor

    (@wpranger)

    12 years, 2 months ago

    So, the error is telling you that the prefix can only contain numbers, letters and underscores. Yours contains a period.

    Login to your hosting and see if you can administrate your database from there. You usually can. See what the names of your database tables are. The prefix in wp-config.php should match the actual prefix in the database. If there’s a mis-match, correct it.

    There’s a plugin to edit your prefix in the database:

    http://wordpress.org/plugins/db-prefix-change/

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

The topic ‘Missing tables problem’ is closed to new replies.