@wkor – you’re a genius!
After spending a few hours helping a client migrate a site from a local development server, we had nearly given up… until we found this post!
It seems the wp_user_roles value was a bit screwed up, but your guide helped us fix it 🙂