• Welcome to Simple Machines Community Forum. Please login or sign up.
January 23, 2022, 04:52:13 PM

News:

SMF 2.1 RC4 has been released! Try it out and help us test! :) Read more.


Database sharing?

Started by Shades., July 28, 2021, 02:32:32 AM

Previous topic - Next topic

Shades.

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?

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Aleksi "Lex" Kilpinen

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.
A Finnish Project Manager (Support Specialist)
 Happily running multiple SMF 2.x installations.
  Fooling around with i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Shades.

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!

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Illori

there are database changes between the versions, so this is not possible.

Douglas

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...
Doug Hazard
* Full Stack (Web) Developer for The Catholic Diocese of Richmond
(20+ Diocesan sites, 130+ Church sites & 24 School sites)
* Sports Photographer and Media Personality
* CFB Historian
* Tech Admin for one 1M+ post, one 2M+ post and one 10M+ post sites (last two are powered by multiple servers)
* WordPress Developer (Junkie / Guru / Maven / whatever)

Shades.

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.

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Kindred

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)
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Shades.

Will it work for 2.1? I see one for 2.0 RC2 is all!

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Arantor

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.
No good deed goes unpunished
All helpful urges should be circumvented

Shades.

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)

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Arantor

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)

:(
No good deed goes unpunished
All helpful urges should be circumvented

Shades.

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! ;)

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Mike66

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?

Shades.

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)

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Arantor

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.
No good deed goes unpunished
All helpful urges should be circumvented

Advertisement: