Need Help Fix Database Table Wordpress, Some InnoDB Table not have auto Increament or not indexable

Job ID: 34545077

Budget: $10 – $30 USD

Hi,

I have issue with my wordpress site, doesn't seem to have right auto increment and primary key. When I try to make it a primary key from phpmyadmin structure, I get an error like in the image (Duplicate Entry #xxx for key wp_posts.PRYMARY).

This database table error after I migrated from a previous server that crashed. From the error it causes
- Featured image does not appear.
- Author's name By some Posts Not appearing
- All Images are not detected.

Hope someone can help repairing my innodb table.
Related categories: Linux WordPress MySQL Database Development phpMyAdmin