Home page loads, all other pages return 404 error

Issue

After a site upgrade, all the pages on the site, including the Admin pages, return a 404 error. The only working page is the Home page.

Root Cause

Settings in HostSettings are causing Advanced URL Management to incorrectly rewrite and redirect URLs.

Resolution

Back up database

1. Open SQL Server Management Studio.
2. Connect to your SQL Server.
3. Expand Databases.
4. Right-click your DNN database and choose Tasks > Back Up... from the menu.
   
5. Complete a backup of your database.

Update settings

1. Right-click your DNN database again and click New Query.
2. Run the following 2 queries:
   

   UPDATE HostSettings SET SettingValue = '/DesktopModules/|/Providers/|/LinkClick\.aspx|/profilepic\.ashx|/DnnImageHandler\.ashx|/__browserLink/|/API/' WHERE SettingName = 'AUM_DoNotRewriteRegEx'

   UPDATE HostSettings SET SettingValue = '(\.axd)|/Rss\.aspx|/SiteMap\.aspx|\.ashx|/LinkClick\.aspx|/Providers/|/DesktopModules/|ctl=MobilePreview|/ctl/MobilePreview|/API/' WHERE SettingName = 'AUM_DoNotRedirectUrlRegex'

Restart site

1. Open Internet Information Services (IIS) Manager.
   
   
   
   
2. Expand the Server node, then expand the Sites node.
3. Right-click on your DNN website name and choose Manage Website > Restart from the menu.
   
   
   
   
4. Navigate to your site in a web browser and confirm the issue was resolved.