Database error

  • paulcobb

    (@paulcobb)


    12 months ago

    Had wordpress database error this morning
    Tried to repair and this was the result
    Solutions please

    wp_6_posts: Table ‘admin10_wp367.wp_6_posts’ doesn’t exist
    wp_6_comments: Table ‘admin10_wp367.wp_6_comments’ doesn’t exist
    wp_6_links: Table ‘admin10_wp367.wp_6_links’ doesn’t exist
    wp_6_options: Table ‘admin10_wp367.wp_6_options’ doesn’t exist
    wp_6_postmeta: Table ‘admin10_wp367.wp_6_postmeta’ doesn’t exist
    wp_6_terms: Table ‘admin10_wp367.wp_6_terms’ doesn’t exist
    wp_6_term_taxonomy: Table ‘admin10_wp367.wp_6_term_taxonomy’ doesn’t exist
    wp_6_term_relationships: Table ‘admin10_wp367.wp_6_term_relationships’ doesn’t exist
    wp_6_termmeta: Table ‘admin10_wp367.wp_6_termmeta’ doesn’t exist
    wp_6_commentmeta: Table ‘admin10_wp367.wp_6_commentmeta’ doesn’t exist

Viewing 2 replies - 1 through 2 (of 2 total)
  • Sandeep Dahiya

    (@sandeepdahiya)

    12 months ago

    WordPress ususally uses ‘wp_’ prefix, so make sure you are using the proper one. Go to phpMyAdmin or other any DB tool in your cPanel/hosting dashboard and see if the database and tables exist there or not.

    If it is there, check the prefix and update the same, if necessary, in your wp-config.php file under $table_prefix = ‘wp_6_’.

    And if you don’t find any table in your database, then there there is something wrong with your database import and you may either restore it from backup file or freshly install it. In case you dont have any backup file, contact your hosting provider for one.

    Moderator threadi

    (@threadi)

    12 months ago

    The prefix wp_6_ sounds like part of a multisite installation. Normally, I would recommend importing a backup for messages like this. If it is a multisite, you may need to coordinate this process with other parties involved or manually retrieve the missing databases from a backup and import them. This could be a bit tricky.

    • This reply was modified 12 months ago by threadi.
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database error’ is closed to new replies.