I have a magento website with multi store installation, i have a problem that a store domain.com/fr-ca redirects to default.com/fr-ca, the default.com/fr-ca is the default store domain this is the 1st issue. I tried to change the default store to domain.com and i got a loop redirection and the admin still loading and i no longer can access it. I tried to check the table core_config_data and see if the domain.com store gets a scope_id 0 and scope default but it seems that it didn't changed. So how to fix the issue from the database?

I have a magento website with multi store installation, i have a problem that the store domain.com redirects to default.com, the default.com is the default store domain, this is the 1st issue.

The second issue, when i tried to change the default store to domain.com, i got a loop redirection and the admin still loading and i no longer can access it. Edit: i fixed the 2nd issue in the table store_website i changed the is_default field to 1 for the default.com website