wpwsxw_wfBlocks7 table crashed, repair failed

  • Resolved hpthatsme

    (@hpthatsme)


    5 years, 7 months ago

    One of the tables (wpwsxw_wfBlocks7) is being reported as crashed by phpMyAdmin. It caused my backups to fail in ManageWP, but they have managed to exclude it to get the backups working again.

    How can I fix this? I am unable to view the table, here is the message I see:

    Table is marked as crashed and last (automatic?) repair failed

Viewing 4 replies - 1 through 4 (of 4 total)

  • Hey @hpthatsme,

    Can you try deactivating then reactivating Wordfence and let me know if it helps?

    Thanks,

    Gerroald

    Thread Starter hpthatsme

    (@hpthatsme)

    I tried it just now, didn’t work. Any other ideas?

    Hi @hpthatsme,

    Can you try repairing the table by using this query?

    REPAIR TABLE wpwsxw_wfBlocks7;

    If that doesn’t work, can you try rebuilding the table? (Note that this will remove all current blocks)

    DROP TABLE wpwsxw_wfBlocks7;

    CREATE TABLE wpwsxw_wfBlocks7 (
  id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  type int(10) unsigned NOT NULL DEFAULT '0',
  IP binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  blockedTime bigint(20) NOT NULL,
  reason varchar(255) NOT NULL,
  lastAttempt int(10) unsigned DEFAULT '0',
  blockedHits int(10) unsigned DEFAULT '0',
  expiration bigint(20) unsigned NOT NULL DEFAULT '0',
  parameters text,
  PRIMARY KEY (id),
  KEY type (type),
  KEY IP (IP),
  KEY expiration (expiration)
);
    Thread Starter hpthatsme

    (@hpthatsme)

    Sorry to reply so late.

    REPAIR TABLE wpwsxw_wfBlocks7; appears to have worked, thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘wpwsxw_wfBlocks7 table crashed, repair failed’ is closed to new replies.