Corrupt tables

  • lwallace

    (@lwallace)


    2 days, 3 hours ago

    The site has slowed to a crawl with cpu overloaded. Host service says its maria db calls. Plesk reports corrupt tables.



    Database wp_pnsgq Repair Results
    Type Table Problem
    Warning oJo1Q_imunify_bot_rl The storage engine for the table doesn't support repair
    Warning oJo1Q_wfls_role_counts The storage engine for the table doesn't support repair
    Warning oJo1Q_wsm_bounceVisits 'wp_pnsgq.oJo1Q_wsm_bounceVisits' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_dateWiseBounce 'wp_pnsgq.oJo1Q_wsm_dateWiseBounce' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_dateWiseBounceRate 'wp_pnsgq.oJo1Q_wsm_dateWiseBounceRate' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_dateWiseFirstVisitors 'wp_pnsgq.oJo1Q_wsm_dateWiseFirstVisitors' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_dateWisePageViews 'wp_pnsgq.oJo1Q_wsm_dateWisePageViews' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_dateWiseVisitors 'wp_pnsgq.oJo1Q_wsm_dateWiseVisitors' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_hourWiseBounce 'wp_pnsgq.oJo1Q_wsm_hourWiseBounce' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_hourWiseBounceRate 'wp_pnsgq.oJo1Q_wsm_hourWiseBounceRate' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_hourWiseFirstVisitors 'wp_pnsgq.oJo1Q_wsm_hourWiseFirstVisitors' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_hourWisePageViews 'wp_pnsgq.oJo1Q_wsm_hourWisePageViews' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_hourWiseVisitors 'wp_pnsgq.oJo1Q_wsm_hourWiseVisitors' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_monthWiseBounce 'wp_pnsgq.oJo1Q_wsm_monthWiseBounce' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_monthWiseBounceRate 'wp_pnsgq.oJo1Q_wsm_monthWiseBounceRate' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_monthWiseFirstVisitors 'wp_pnsgq.oJo1Q_wsm_monthWiseFirstVisitors' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_monthWisePageViews 'wp_pnsgq.oJo1Q_wsm_monthWisePageViews' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_monthWiseVisitors 'wp_pnsgq.oJo1Q_wsm_monthWiseVisitors' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_pageViews 'wp_pnsgq.oJo1Q_wsm_pageViews' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_uniqueVisitors 'wp_pnsgq.oJo1Q_wsm_uniqueVisitors' is not of type 'BASE TABLE'. Operation failed
    Warning oJo1Q_wsm_visitorInfo 'wp_pnsgq.oJo1Q_wsm_visitorInfo' is not of type 'BASE TABLE'. Operation failed

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Support vupdraft

    (@vupdraft)

    1 day, 20 hours ago

    Please create a backup of your DB before doing anything at all (you can manually export it if you need to)

    Issue 1: InnoDB “Doesn’t Support Repair” Error

    1. Log into phpMyAdmin.
    2. Select your database and click on the Export tab.
    3. Export each affected table as a .sql file.
    4. Go back to your database structure, select that table, and Drop (Delete) the tables
    5. Go to the Import tab and upload the .sql files you just exported. Re-importing and recreating the InnoDB table structure cleanly from scratch.

    (Issue 2: “Not of type BASE TABLE” Error

    This table belongs to a WordPress statistics plugin (likely WP Slimstat based on the _wsm_ prefix). The easiest fix would be to remove and re-install the plugin

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.