wp_options: InnoDB: Index "option_name" is marked as corrupted

  • Resolved drapple

    (@drapple)


    9 years, 3 months ago

    I’m getting some odd things on an ecommerce site. Customers complaining items they did not add to the cart are showing in the cart at checkout.

    The database shows the following message.

    wp_options: InnoDB: Index “option_name” is marked as corrupted

Viewing 1 replies (of 1 total)
  • Thread Starter drapple

    (@drapple)

    the issue was that InnoDB table had corrupted secondary index named “option_name” (the corruption was a duplicate entry which is not allowed in indexes).
    The only way to fix it without destroying everything is deleting that key and recreate it using commands

    ALTER TABLE <NAME> DROP/ADD KEY <NAME>(PARAMS)

Viewing 1 replies (of 1 total)
  • The topic ‘wp_options: InnoDB: Index "option_name" is marked as corrupted’ is closed to new replies.