Prepropagation and DNN

[RFH Reseller: Rappie]

I'm afriad that I can't give you the table name etc till tonight (late) as I'm way with work at the moment and don't have access to my dev machine to get the table name etc. Doing 14 hour days at the moment, so please be patient if I do not get back to you tonight.

Don't worry ... i am not in a hurry.
I appreciated your help, but don't forget to sleep. Tomorrow will be fine to, or thursday or friday or saterday or ... or ..

[Tanzy]

Sorry never got a chance to look last night. However, I have just download DNN and looked at the install sql to remind me.

There is a table called PortalAlias should begin with dbo. (It could also begin with something like dbo.dnn_)

This table consits of the following fields

[PortalAliasID]
[PortalID]
[HTTPAlias]

Which basically relate to the following


[PortalAliasID] = is an incremental value don't worry about it
[PortalID] = this is the id of your portal. If you only have one portal then it is most likley to be something like 1. (You can't miss it)
[HTTPAlias] = This is the web address of your portal.

You most likely have 2 records in this table, both with the same PortalID. One will be the alias that you installed DNN under (most likely the first record). The second one will be the one that you created for the actual domain name.

What you basically need to do, is just delete the record that has the address that you used to install DNN. This should work.

PLEASE NOTE: I am giving these details off the top of my head and have not tried it at home. It should work and be OK. What DNN does is that it looks at the address it is serving, then looks at this table to find the portal id that the address belongs to. It will then use the details for that portal to generate the website layout content etc. If you have a domain alias that is not recorded in this table, then DNN uses the Host portal (by obtaining the Host Postal ID from the HostSettings table).

[RFH Reseller: Hollywood]

I've been here!

You can't edit the alias name to which you are currently logged in!

One solution is to add a new alias...
then logout....
then browse to the domain name (not the prepropogation name)...
login to the domain name alias...
and delete the proprop alias

(but I also have no problems with logging into the database directly and editing the PortalAlias table - at least I think that is it's name!)

[RFH Reseller: Rappie]

I'll keep that mind for the next time. Sound s a lot easyer to me.

Editing the table in the db did the trick for me this time.

Thnx guys for your help