Hi,
We need to change the portal alias (domain) for a DNN 9 site. Unfortunatley the host site settings sections is not working so we altered the domain name in the following tables in the db (as well as some redirects in the web config file)
PortalSettings (DefaultPortalAlias)
PortalAlias (New Record)
The site now gives 404. We deleted cache files, recycled app pool etc but still the same. Anywhere else this needs updating? Thanks :-)
ps. The CloudFlare security doesn't seem to like web dot config, all one word!
Be sure your new portal alias is also marked as the PRIMARY alias. In the database, it should be the only alias for that PortalID that has a 1. The rest should be false (0). It's a BIT field. Only those two values are possible.
Thanks Will for your reply.
That table was missing columns, which might explain why the site settings didn't work originally!
Looks like the site was upgraded from v7 by querying the Version table. We have added the missing columns back in, copying from another DNN 9 database, but still getting the 404 after recycling the app pool. Any other ideas? Thanks.
Posted By Nutty About Hosting on 8/24/2023 3:25 AM Thanks Will for your reply. That table was missing columns, which might explain why the site settings didn't work originally! Looks like the site was upgraded from v7 by querying the Version table. We have added the missing columns back in, copying from another DNN 9 database, but still getting the 404 after recycling the app pool. Any other ideas? Thanks.
Whoa... That sounds scary! If it were me, I'd immediately start doing a diff for the remaining DB schema and do the same with the file system. I'd be concerned that this is only the first of many more upcoming issues you'll discover. ☹️
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.