I had someone on fiverr design a wordpress website for me awhile back. They sent me the database when they were done and I imported it on my server and set everything up.
What I've since realized is something is funky with the database.
I'm able to add plugins without issues, I've edited some pages here and there, but if I try to create a new post, page, etc I get a message that I'm "Currently editing the page that shows your latest posts."
Additionally, my users table shows zero indexes when I view the structure so in phpMyAdmin I get a warning message "Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available." Yet, if I try to create a primary index on the ID field I get an error message "Duplicate entry '0' for key
I'm stumped. Any ideas on what I can do to fix this?
Should I just export the site, create a new wordpress installation, and then import everything? I'm just afraid of inadvertently importing whatever is causing the issue.
Any suggestions appreciated.