Hi all,

I've been struggling to get a DNN site up and running. I thought I had found the issue, but trying to fix it has broken the site altogether.

When DNN was installed, the preset Portal Alias was "ipaddress/folder". The only way I could access the site was by browsing to "ipaddress/folder". www.url.com and url.com would not work.

I tried adding www.url.com and url.com to the Portal Alias list and there was no change. Since I couldn't access the site via the URL, I couldn't delete the "ipaddress/folder" Alias via the DNN control panel, so I deleted it from the database table.

At that point, the site was broken. I can't access it at all. I can't restart DNN because I can't access the site. I can't re-add the "ipaddress/folder" option due to a database error.

What can I do?

Help!!

Chris

"The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PortalAlias_Portals"

However, I'm hesitant to work from the database angle, because I'm afraid it will just result in the "ipaddress/folder" Alias reinstatement and still won't fix the core problem.

If I successfully reinstate the "ipaddress/folder" Alias, will a DNN restart fix the Alias issue??

Chris

Hello,

Thank you for the reply.

I think I broke access to the site via ipaddress/folder when I deleted it from the database. DNN was never restarted so the DNN environment was never aware of the changes. That's why I was trying to add it back.

Indeed I was inserting the wrong PortalID. I was mistaking PortalID for the AliasID and I was trying to force the insert to make the new row an AliasID of 1, which the database won't allow. I was successfully able to add the ipaddress/folder row, at a Primary Key/AliasID of 9, PortalID 0.

I still can't hit the site, even browsing directly to ipaddress/folder. I wonder if this is because the ipaddress/folder alias is now buried under two other entries? I can try deleting those...

Chris