Secondary userbase being primary in Related multisite

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.
5/16/2009 12:40:00 PM
Gravatar
Total Posts 33
www.jaosobne.cz
Windows Server 2008 R2
Microsoft SQL Server 2008
MojoPortal 2.3.6.2

Secondary userbase being primary in Related multisite

Hi Joe,

I would like to join my standalone multisites to be related. Is there any possibility (even manually in the DB) to join existing users? I now have two sites, where the primary had never been used to public registrations, but the secondary was. I would very much like to use the secondary site's userbase for the primary site if I set mojoPortal to use related sites mode. Could you please tell me how this is possible? Thank you very much

5/16/2009 12:51:50 PM
Gravatar
Total Posts 18439

Re: Secondary userbase being primary in Related multisite

I think it is possible. Assuming the site whose users you want to use is siteid 2 and the first site with only an admin user is siteid 1, then what I would do is go into the mp_Sites table and set the IsServerAdminSite field to 1 on site 2 so that it is also a server admin site like site 1 is.

Since site 1 only has 1 user, the admin, you should make usre it has a different loginname and different email than the admin from site 2.

Then set it to use related sites mode and set the RelatedSiteId = 2

In theory it should work, but I admit I have not tested much where the users were coming from a secondary site.  I'd be sure and back up your db before trying it. If it gives problems you could run a query to set all users to have siteid 1 and siteguid from that site, then change it to RelatedSiteId = 1, but I don't really expect you to have problems.

Hope it helps,

Joe

5/16/2009 2:38:48 PM
Gravatar
Total Posts 33
www.jaosobne.cz
Windows Server 2008 R2
Microsoft SQL Server 2008
MojoPortal 2.3.6.2

Re: Secondary userbase being primary in Related multisite

Wow, it worked. Thank you, my users are now shared :-) And the possibility to have all children sites IsServerAdminSite is great too :-)

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