I've noticed that in my development instance of Wordpress that wp_options contains duplicate rows. After some more investigation I found that the primary_key and auto_increment restraints were removed from the option_id column.
Does anyone know how this could have happened? I certainly didn't go in and remove these myself. Some ideas:
- Bad database import
- Plugin modified the database
- Wordpress update failed
I found this wp.stackexchange question which describes the same problem, but the answers don't seem to explain how it could have happened in the first place.
Thank you for your assistance brainstorming what would have triggered this problem. I'd like to prevent it from occurring in the future.