• Hi ,

    My issue is regarding database error . I have set up my dev environment to integrate new theme. After Integration of new theme, I copied my site to live & imported my database . Its showing me database error database tables needs to be repaired . These error comes for 2-3 hours between 2:15 EST and 5:15 EST . Below is the errors that showed me.

    The hari_users table is okay.
    The hari_usermeta table is okay.
    The hari_posts table is not okay. It is reporting the following error: 15 clients are using or haven’t closed the table properly. WordPress will attempt to repair this table…
    ????Failed to repair the hari_posts table. Error: 15 clients are using or haven’t closed the table properly
    The hari_comments table is not okay. It is reporting the following error: 30 clients are using or haven’t closed the table properly. WordPress will attempt to repair this table…
    ????Failed to repair the hari_comments table. Error: 30 clients are using or haven’t closed the table properly
    The hari_links table is okay.
    The hari_options table is not okay. It is reporting the following error: Table is marked as crashed. WordPress will attempt to repair this table…
    ????Failed to repair the hari_options table. Error: Table is marked as crashed
    The hari_postmeta table is not okay. It is reporting the following error: 139 clients are using or haven’t closed the table properly. WordPress will attempt to repair this table…
    ????Failed to repair the hari_postmeta table. Error: 139 clients are using or haven’t closed the table properly
    The hari_terms table is okay.
    The hari_term_taxonomy table is not okay. It is reporting the following error: 6 clients are using or haven’t closed the table properly. WordPress will attempt to repair this table…
    ????Failed to repair the hari_term_taxonomy table. Error: 6 clients are using or haven’t closed the table properly
    The hari_term_relationships table is not okay. It is reporting the following error: 4 clients are using or haven’t closed the table properly. WordPress will attempt to repair this table…
    ????Failed to repair the hari_term_relationships table. Error: 4 clients are using or haven’t closed the table properly
    The hari_termmeta table is okay.
    The hari_commentmeta table is not okay. It is reporting the following error: 30 clients are using or haven’t closed the table properly. WordPress will attempt to repair this table…
    ????Failed to repair the hari_commentmeta table. Error: 30 clients are using or haven’t closed the table properly

    Please help me asap.

    Thanks

Viewing 1 replies (of 1 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Do you have access to phpmyadmin on your host? If so, use it to select those tables and repair them.

    Make a backup first, of course.

Viewing 1 replies (of 1 total)
  • The topic ‘Databse Error issue’ is closed to new replies.