Support » Fixing WordPress » Database tables not accessible

  • Hi,

    my website was probably hacked. The website is down and I cannot login to the wp-admin. It says that some database tables cannot be accessed. I tried to fix this with the define(‘WP_ALLOW_REPAIR’, true); method, but this didn’t work. I was suggested to post the following error message to the forum for suggestions how to fix this:
    wp_users: Table ‘hansdsl21_wp8.wp_users’ doesn’t exist
    wp_usermeta: Table ‘hansdsl21_wp8.wp_usermeta’ doesn’t exist
    wp_posts: Table ‘hansdsl21_wp8.wp_posts’ doesn’t exist
    wp_comments: Table ‘hansdsl21_wp8.wp_comments’ doesn’t exist
    wp_links: Table ‘hansdsl21_wp8.wp_links’ doesn’t exist
    wp_options: Table ‘hansdsl21_wp8.wp_options’ doesn’t exist
    wp_postmeta: Table ‘hansdsl21_wp8.wp_postmeta’ doesn’t exist
    wp_terms: Table ‘hansdsl21_wp8.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘hansdsl21_wp8.wp_term_taxonomy’ doesn’t exist
    wp_term_relationships: Table ‘hansdsl21_wp8.wp_term_relationships’ doesn’t exist
    wp_commentmeta: Table ‘hansdsl21_wp8.wp_commentmeta’ doesn’t exist

    Hopefully someone can help me.

    Regards,

    Coen

Viewing 5 replies - 1 through 5 (of 5 total)
  • Hopefully you have a backup somewhere? If you don’t, you should contact your hosting provider and ask them if they have any automated recent backup available.

    Do you have a recent database backup of the site?

    sorry, cpanel details required for check

    I am afraid no backup was created by myself. I have asked the hosting provider and hope to receive an answer asap.
    Maybe, in order to diagnose better, please find the detailed message that my hosting provider find on the server:

    | 766834 | hansdsl21_wp8 | 10.3.0.21:41588 | hansdsl21_wp8 | Query | 7211 | Waiting for table level lock | INSERT INTO zi9td_session
    (session_id, client_id, time) VALUES
    (‘589ec84cc9009062bddcac056a |
    | 766904 | hansdsl21_wp8 | 10.3.0.21:41719 | hansdsl21_wp8 | Query | 7171 | Waiting for table level lock | DELETE
    FROM zi9td_session
    WHERE time < ‘1492131021’ |
    | 766985 | hansdsl21_wp8 | 10.3.0.21:41880 | hansdsl21_wp8 | Query | 7107 | Waiting for table level lock | INSERT INTO wp_middleclassamoptions (option_name, option_value, autoload) VALUES (‘_transien |
    | 767029 | hansdsl21_wp8 | 10.3.0.21:41975 | hansdsl21_wp8 | Query | 7081 | Waiting for table level lock | INSERT INTO wp_middleclassamoptions (option_name, option_value, autoload) VALUES (‘_transien |
    | 767093 | hansdsl21_wp8 | 10.3.0.21:42169 | hansdsl21_wp8 | Query | 7021 | Waiting for table level lock | INSERT INTO wp_primodestinprimodestinoptions (option_name, option_value, autoload) VALUES (‘ |
    | 767150 | hansdsl21_wp8 | 10.3.0.21:42273 | hansdsl21_wp8 | Query | 7004 | Waiting for table level lock | INSERT INTO wp_myprettylittleoptions (option_name, option_value, autoload) VALUES (‘_transie |
    | 767170 | hansdsl21_wp8 | 10.3.0.21:42318 | hansdsl21_wp8 | Query | 6994 | Waiting for table level lock | DELETE
    FROM flyoe_session
    WHERE time < ‘1492128497’ |
    | 767204 | hansdsl21_wp8 | 10.3.0.21:42374 | hansdsl21_wp8 | Query | 6974 | Waiting for table level lock | DELETE
    FROM zi9td_session
    WHERE time < ‘1492131217’ |
    | 767327 | hansdsl21_wp8 | 10.3.0.21:42594 | hansdsl21_wp8 | Query | 6908 | Waiting for table level lock | DELETE
    FROM flyoe_session
    WHERE time < ‘1492128583’ |
    | 767449 | hansdsl21_wp8 | 10.3.0.21:42798 | hansdsl21_wp8 | Query | 6858 | Waiting for table level lock | INSERT INTO wp_primodestinprimodestinoptions (option_name, option_value, autoload) VALUES (‘ |

    Any suggestions?

    Nope, sorry.

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.