WordPress.org

Ready to get started?Download WordPress

Forums

database error how to fix (3 posts)

  1. muntohar
    Member
    Posted 3 years ago #

    i was deleted my database,ithink its database plugin which i used,but after that my blog cannot accessed, i was click repaired button,here are the comment after thats,

    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.

    here are the copy:
    wp_posts: 9 clients are using or haven't closed the table properly
    wp_postmeta: 5 clients are using or haven't closed the table properly
    wp_terms: 7 clients are using or haven't closed the table properly
    wp_term_taxonomy: 11 clients are using or haven't closed the table properlye
    wp_term_relationships: 7 clients are using or haven't closed the table properly

  2. muntohar
    Member
    Posted 3 years ago #

    i was repair my database by click repair and optimize,here is the result

    Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/domains/xxxxx.com/public_html/wp-config.php:83) in /home/xxxx/domains/xxxxxx.com/public_html/wp-admin/maint/repair.php on line 7
    WordPress

    The wp_users table is okay.
    The wp_users table is already optimized.

    The wp_usermeta table is okay.
    The wp_usermeta table is already optimized.

    The wp_posts table is okay.
    The wp_posts table is already optimized.

    The wp_comments table is okay.
    The wp_comments table is already optimized.

    The wp_links table is okay.
    The wp_links table is already optimized.

    The wp_options table is okay.
    The wp_options table is already optimized.

    The wp_postmeta table is okay.
    The wp_postmeta table is already optimized.

    The wp_terms table is okay.
    The wp_terms table is already optimized.

    The wp_term_taxonomy table is okay.
    The wp_term_taxonomy table is already optimized.

    The wp_term_relationships table is okay.
    The wp_term_relationships table is already optimized.

    The wp_commentmeta table is okay.
    The wp_commentmeta table is already optimized.

    Repairs complete. Please remove the following line from wp-config.php to prevent this page from being used by unauthorized users.
    define('WP_ALLOW_REPAIR', true);

    but my blog still cannot accessed,why anyone can help me?please

  3. Shane G.
    Member
    Posted 3 years ago #

    Hi,

    It is usually due to spaces, new lines, or other garbage at opening/closing PHP file <?php tag or after a closing ?> tag in wp-config.php. It can be other file too so need to check error message as it may list file name where the error occurred.

    You can either upload error file from the backup or edit erroneous file. To edit the file one need to check below mentioned points:

    1. Download the file mentioned in the error message.

    2. Open that file in a plain text editor

    3. Check that the very first characters are <?php

    4. Check that the very last characters are ?>

    5. Place the cursor between the ? and >

    6. Now press the DELETE key on your computer and keep that key pressed for at least 15 seconds.

    7. Now type > and

    8. Save without pressing any other key at all.

    That’s it!

    Thanks,

    Shane G.

Topic Closed

This topic has been closed to new replies.

About this Topic