Change Site 1

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
7/15/2010 4:42:14 AM
Gravatar
Total Posts 13

Change Site 1

Hello,

I'm migrating and moving around a couple of sites to take advantage of Mojo's multi-site capabilities. The only problem is I'm stuck with a database that has a secondary site as its only site but in my new configuration I would like for that to become Site2.

In other words, in mp_Sites I want to change SiteID1 to SiteID2 so that a different site can become SiteID1. Basically swapping those two SiteIds.

Due to the constraints and keys, I was not able to change the values directly in SQL Manager. Maybe you know a trick for bypassing that error check to make a simple change from 1 to 2 and from 2 to 1 in the SiteID column? Changing the Data/Sites/x names is presumably also necessary.


Thanks!

7/15/2010 11:24:18 AM
Gravatar
Total Posts 2188

Re: Change Site 1

Hi,

The simplest method for this would be to set the IsServerAdminSite=1 for the 2nd site in the mp_Sites table in your database. You should then set IsServerAdminSite=0 for the first site.

Your SiteIDs will remain the same but you will achieve the effect of having the 2nd site as your Admin site.

I definitely suggest you make a backup of your database before attempting this change.

HTH,
Joe D.

7/16/2010 4:18:15 AM
Gravatar
Total Posts 13

Re: Change Site 1

Thanks Joe, that seems to have worked. One thing I noticed though, keeping in mind I need to set this up and test before it goes live, is that if I did not have subdomains to use as pointers, there would be no pages for the additional sites. Maybe the pages would exist but they are not be accessible in the normal way.

Is there a better way to design/build multiple sites (or even just a new site) without having to setup a fictitious subdomains that uses header mapping to "activate" it?

Thanks,

7/16/2010 6:38:12 AM
Gravatar
Total Posts 2188

Re: Change Site 1

You could use folder based multiple sites but I don't think this is any easier and I am not sure how easy it is switch between the two solutions.

HTH,
Joe D.

You must sign in to post in the forums. This thread is closed to new posts.