Simple Machines Community Forum

SMF Support => SMF 2.1.x Support => Topic started by: Shades. on July 28, 2021, 02:32:32 AM

Title: Database sharing?
Post by: Shades. on July 28, 2021, 02:32:32 AM
The answer is probably "no" but Im gonna ask anyways! ;)

Is it possible for a 2.0.18 board to share the same database as 2.1RC4 so the user would be able to choose which board they prefer to use?
Title: Re: Database sharing?
Post by: Aleksi "Lex" Kilpinen on July 28, 2021, 02:37:30 AM
I don't really think that's viable, if you really mean running 2.0 and 2.1 side by side with the same contents and users.
Title: Re: Database sharing?
Post by: Shades. on July 28, 2021, 03:10:07 AM
Yeah I just thought I'd ask cause some of the older folks/members may not like the change over and the younger folks and new members will! So it would be nice if they had a choice between the two. I don't have many members on my biker board now like I did on my old one but I remember how grumpy they were whenever I upgraded to a new board.

It's nice having the ability for the user to switch themes if they want but would also be nice if they could choose between the old or new board. I myself even have this issue because I like my 2.0.18 live version but also like the 2.1RC4 version so I'm torn lol!
Title: Re: Database sharing?
Post by: Illori on July 28, 2021, 05:04:11 AM
there are database changes between the versions, so this is not possible.
Title: Re: Database sharing?
Post by: Douglas on July 28, 2021, 05:46:44 AM
Just like in real time, the online world is constantly evolving and changing... either get with the program or get left in the dust.

I mean, come on... who the hell still uses Windows 3.1 anymore, anyway...
Title: Re: Database sharing?
Post by: Shades. on September 21, 2021, 12:31:17 PM
How about sharing a database with two different 2.1 boards? I just want to share the user database so they can log in on both boards. (both on same server but in different folders)

I know I've read the instructions before but all I could find was an old 2.0 post which I'm sure is gonna be way different than 2.1 now.
Title: Re: Database sharing?
Post by: Kindred on September 21, 2021, 01:03:43 PM
no.   there really is no good way to do that with core SMF

There is a multi-site mod that essentially does what you ask (for multiple domains on the same server)
Title: Re: Database sharing?
Post by: Shades. on September 21, 2021, 01:17:55 PM
Will it work for 2.1? I see one for 2.0 RC2 is all!
Title: Re: Database sharing?
Post by: Arantor on September 21, 2021, 01:19:53 PM
Sharing might work if they're using the same version but that won't fly between a 2.0 and a 2.1, because even the user table isn't compatible - 2.1 uses a stronger method of encrypting the password.
Title: Re: Database sharing?
Post by: Shades. on September 21, 2021, 02:05:08 PM
Quote from: Arantor on September 21, 2021, 01:19:53 PMSharing might work if they're using the same version but that won't fly between a 2.0 and a 2.1, because even the user table isn't compatible - 2.1 uses a stronger method of encrypting the password.
Yeah sorry I changed gears on the thread! :D

I now want to share the user database between two of the same version boards, both being 2.1RC4. They are both on the same server just in different folders.

(example one is home2/public/sample1 and the other is home2/public/sample2)
Title: Re: Database sharing?
Post by: Arantor on September 21, 2021, 02:07:39 PM
It's a mess to do, even just the members table has things in it that shouldn't be part-shared (e.g. avatar details part exist in the members table that won't work across two sites, and this is more common in 2.1 than it was in 2.0)

:(
Title: Re: Database sharing?
Post by: Shades. on September 21, 2021, 02:13:06 PM
Oh well, I'll just have to wait until 2.1 final maybe someone will come up with a compatible mod to do this or something similar! ;)
Title: Re: Database sharing?
Post by: Mike66 on September 23, 2021, 07:20:54 PM
Re: "but I remember how grumpy they were whenever I upgraded to a new board"

Maybe the answer is to design a theme in 2.1 that mimics or appears to be close enough to your current theme in 2.0 that it will feel familiar to your members?

Then, once they get used to that, you could add an additional new theme and let them choose between the two?
Title: Re: Database sharing?
Post by: Shades. on September 23, 2021, 10:07:29 PM
Quote from: Mike66 on September 23, 2021, 07:20:54 PMRe: "but I remember how grumpy they were whenever I upgraded to a new board"

Maybe the answer is to design a theme in 2.1 that mimics or appears to be close enough to your current theme in 2.0 that it will feel familiar to your members?

Then, once they get used to that, you could add an additional new theme and let them choose between the two?
I did and I'm on 2.1RC4 now I just wanted to bridge the userbase somehow in the beginning but I get it now, but I have other plans now I've moved forward and I still want to be able to share database somehow like SMF has done here with SMF2.1RC4...the wiki and the dev areas in the future. So I can wait! ;D  8)
Title: Re: Database sharing?
Post by: Arantor on September 24, 2021, 03:02:29 AM
That's a very very different proposition though.

The wiki and the forum don't share a database. There is a bridge - visit the wiki when you are logged in, the wiki sees your cookie, phones home to the forum and then creates an account for you on the wiki.

The dev areas are a little different again - things like the function DB and the customise site live in the main DB (or at least used to) and are built more like SSI style (though, that's not the method used, it's just closer to it).

Bridging two forums would actually be relatively easy, as long as you're doing it by roaming and the functional equivalent of 'login with this other forum' especially if someone did it by way of building out a functioning OAuth2 client/server since it could even interoperate with other systems with relative ease at that point.