Database repair failed

  • Resolved picturebox1

    (@picturebox1)


    2 years, 1 month ago

    wp_options: Number of rows changed from 1385 to 1384

Full report:


The wp_users table is okay.
    The wp_users table is already optimized.

The wp_usermeta table is okay.
    The wp_usermeta table is already optimized.

The wp_posts table is okay.
    The wp_posts table is already optimized.

The wp_comments table is okay.
    The wp_comments table is already optimized.

The wp_links table is okay.
    The wp_links table is already optimized.

The wp_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 wp_options table. Error: Number of rows changed from 1385 to 1384

The wp_postmeta table is okay.

The wp_terms table is okay.

The wp_term_taxonomy table is okay.

The wp_term_relationships table is okay.

The wp_termmeta table is okay.

The wp_commentmeta table is okay.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Stef

    (@serafinnyc)

    2 years, 1 month ago

    Do you have a backup you can revert to?

    Thread Starter picturebox1

    (@picturebox1)

    2 years, 1 month ago

    Yes. I went through my hosting company. It was not straightforward as the two most recent backups were corrupt. My hosting company thought the root of the problem was most likely a conflict between plugins. Four were updated before this happened and a week ago we had problems with another plugin that stopped Elementor working.

    The plugins that may well have been the cause are:
    1. Admin and Site Enhancements (ASE)
    2. Blog2Social: Social Media Auto Post & Scheduler
    3. Fluent Forms
    4. Fluent Forms Pro Add On Pack

    This issue is now fixed but not sure yet which plugin is the culprit.

    Stef

    (@serafinnyc)

    2 years, 1 month ago

    Well at least it’s fixed. No need to continue debugging. However, if one of those apps is way way outdated, you can blame it on that one.

    Thread Starter picturebox1

    (@picturebox1)

    2 years, 1 month ago

    I always update all plugins within a day or two of a new release. That is what is so frustrating. But your right we can now get the news published again and that makes a lot of people happy.

    Stef

    (@serafinnyc)

    2 years, 1 month ago

    Take care! Have a great rest of your day!

    Thread Starter picturebox1

    (@picturebox1)

    2 years, 1 month ago

    Thank you for your attentions over this matter. Much appreciated.

    Stef

    (@serafinnyc)

    2 years, 1 month ago

    Anytime!

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

The topic ‘Database repair failed’ is closed to new replies.