Why does Pro Sites have an Index – Primary key error in the database table structure?


I received a database error and when I checked the db, it said that Pro Sites cannot have blog_Id for both Index and Primary keys.

Problems with indexes of table wps_pro_sites

PRIMARY and INDEX keys should not both be set for column blog_ID

More than one INDEX key was created for column blog_ID

I don’t want to mess it up so I need you to tell me how to fix it. I tried a repair table but MSQL is not smart enough to fix this type of error.

Thanks. :slight_smile:

Kind regards,