Duplicate key name meta_value

Thanks for the question and the upload.

Something is set up strangely in your database tables. Can you let me know which table’s fast-key addition gave you this error? Try to convert them one at a time to figure that out if you can’t figure it out any other way.

@olliejones

Here are the tables

wp_commentmeta (307 rows, approximately)
wp_comments (11,686 rows, approximately)
wp_options (1,768 rows, approximately)
wp_postmeta (523,212 rows, approximately)
wp_posts (10,438 rows, approximately)
wp_termmeta (no rows)
wp_users (2 rows, approximately)

I tried one by one but same error.

It looks to me like you, or someone, has done quite a bit of work adding keys to your tables via some other means than this plugin. This plugin attempts to replace any keys on your tables with its high-performance keys, and it looks like that attempt isn’t working.

Given that you have already added keys, this plugin might not be suitable for your site.

If you can tell me which table (wp_postmeta, wp_termmeta) gave the error I can troubleshoot further. Please don’t hesitate to start another support thread.

@olliejones I have unmarked all and only tried to change wp_postmeta and it gives error. I have a lot of rows in wp_postmeta.

wp_postmeta (523,448 rows, approximately)

• This reply was modified 1 week, 4 days ago by davecoledave.

Do you have access to wp-cli, or to phpmyadmin? If so, try giving this SQL command:

ALTER TABLE wp_postmeta DROP KEY meta_id;

With wp_cli, you’ll do it with

wp db query "ALTER TABLE wp_postmeta DROP KEY meta_id;"

And please upload your metadata again from Tools > Index MySQL > About so I can see if anything has changed.

Thanks for your patience.