https://www.screencast.com/t/WSngUrJogt
For some reason it says those pages are private?? How can I change this setting? I check in member levels
I've answered your ticket. This happens when the member level mapping to the profile types is done and the users hadn't moved into the new profile type (by logging in and choosing the new type) and so they have no profile type. It's best not to do that. To resolve, please recreate the mappings as you had them and allow the members to choose their profile types when they log back in.
Alternately, it might also work to move them back into the default member level. Perhaps.
Where can I remove the mappings in the database? what columns should I edit or looking for?
This is complex and much easier and better to just recreate your mappings and let the members select those profile types. I looked and you can see it in the user_field_values but it's not so simple as you'll need to change each user to use the correct profile type.