wp_termmeta has unexpected keys error

  • Resolved Thomymaster

    (@thomymaster)


    3 years, 3 months ago

    Hi

    I enabled the high performance keys for all tables listed. However with wp_termmeta i got the following error
    —

    Problems Rekeying
We cannot rekey some tables.

This often means they have already been rekeyed by some other plugin or workflow.

wp_termmeta has unexpected keys, so we cannot rekey it.
??Cannot find the expected key PRIMARY KEY.
??The key meta_id exists when it should not.
??Found an unexpected definition for key meta_id. It should be , but is ADD UNIQUE KEY meta_id (meta_id).
??Cannot find the expected key PRIMARY KEY.
??The key term_id exists when it should not.
??Found an unexpected definition for key meta_key. It should be ADD KEY meta_key (meta_key, term_id), but is ADD KEY meta_key (meta_key(191)).
??Found an unexpected definition for key term_id. It should be , but is ADD KEY term_id (term_id).

    —

    I didn’t change anything in my WordPress installation, what should i do now?

    Best,
    Thomas

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author OllieJones

    (@olliejones)

    Sorry for the hassle. A new version of the plugin needs to get a lot smarter about resolving these kinds of issues.

    Do you have access to phpmyadmin? If so, could you give the command

    SHOW TABLE wp_termmeta;

    and post the results here. It would also be helpful if you were to [x] check the box allowing metadata upload so I can take a look.

    If your site is down please let me know as soon as possible, and I’ll work through the correction with you.

    Thanks for the report.

    Plugin Author OllieJones

    (@olliejones)

    1.2.0 is released. Please give it a try.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wp_termmeta has unexpected keys error’ is closed to new replies.