database not working

  • standardmedhop

    (@standardmedhop)


    1 day, 2 hours ago

    The wpac_users table is okay.
        
        Failed to optimize the wpac_users table. Error: Table does not support optimize, doing recreate + analyze instead

    The wpac_usermeta table is okay.
        
        Failed to optimize the wpac_usermeta table. Error: Table does not support optimize, doing recreate + analyze instead

    The wpac_posts table is okay.
        
        Failed to optimize the wpac_posts table. Error: Table does not support optimize, doing recreate + analyze instead

    The wpac_comments table is okay.
        
        Failed to optimize the wpac_comments table. Error: Table does not support optimize, doing recreate + analyze instead

    The wpac_links table is not okay. It is reporting the following error: Table 'stan26004936_ynbe1.wpac_links' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wpac_links table. Error: Table 'stan26004936_ynbe1.wpac_links' doesn't exist

    The wpac_options table is not okay. It is reporting the following error: Table 'stan26004936_ynbe1.wpac_options' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wpac_options table. Error: Table 'stan26004936_ynbe1.wpac_options' doesn't exist

    The wpac_postmeta table is okay.

    The wpac_terms table is okay.

    The wpac_term_taxonomy table is okay.

    The wpac_term_relationships table is okay.

    The wpac_termmeta table is okay.

    The wpac_commentmeta table is okay.
Viewing 1 replies (of 1 total)
  • Marta Torre

    (@martatorre)

    1 day, 1 hour ago

    Hi, thanks for posting to the official WordPress support forums!

    Good news first: those “Table does not support optimize, doing recreate + analyze instead” messages aren’t errors. They’re normal for InnoDB tables, and each one is reported as “okay” right above it. You can safely ignore them.

    The actual issue is these two tables:

    • wpac_links doesn’t exist: this is the legacy Links/Blogroll table, deprecated since WP 3.5, so it’s harmless.
    • wpac_options doesn’t exist: this is the critical one. The options table stores your site URL, active theme, active plugins, and all your settings, and WordPress can’t run without it. That’s why the site isn’t working.

    This usually happens after an interrupted or partial database import or restore. A few questions so we can point you in the right direction:

    1. Did this start right after a migration, SQL import, host change, or restoring a backup?
    2. Do you have a recent backup of the database (or a full site backup)?
    3. Which host are you on? Many keep automatic backups that could make this an easy fix.

    If you have a backup, restoring it is the cleanest solution. If not, the options table can be rebuilt manually, but you’d lose your saved settings and the list of active plugins, so let’s check for a backup first.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.