• Welcome to Simple Machines Community Forum. Please login or sign up.
January 28, 2022, 05:26:35 AM

News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord


Share user database for 2 (or more) different forums.

Started by Spaceman-Spiff, September 03, 2004, 09:14:44 PM

Previous topic - Next topic

FireDitto

June 16, 2010, 02:48:36 AM #340 Last Edit: June 16, 2010, 02:52:35 AM by FireDitto
I shared the EzPortal and Sub Account databases, but I'm still getting the
"Unknown column 'mem.is_shareable' in 'field list'" error and none of my EzPortal things are saving still...

Playing around with it now to see if I can't fix the issue, but I'm honestly not sure what is up. =/
Second Pass Weyr
An AU Pernse RPG

SMF 2.0.6 with SP 2.3.5

Hj Ahmad Rasyid Hj Ismail

June 16, 2010, 05:42:44 AM #341 Last Edit: June 16, 2010, 05:49:17 AM by Abu Fahim Ismail
Quote from: FireDitto on June 16, 2010, 02:48:36 AM
I shared the EzPortal and Sub Account databases, but I'm still getting the
"Unknown column 'mem.is_shareable' in 'field list'" error and none of my EzPortal things are saving still...

Playing around with it now to see if I can't fix the issue, but I'm honestly not sure what is up. =/
1. Have you check your cookie settings for each forum? Is it the same or different? As suggested, it should be different.
2. Is 'mem.is_shareable' table shared too? If it is, then may be you wanna check the list whether it is the same with the other forum i.e. they are numbered the same way. Or you might want to disable any function related to that table (I dont use this mod but it may be related to the sharing of sub-account profile which might be related to its ID numbering).

Suggestions:
1. Try two fresh new forums with the same mods. See if the problems are the same.
2. Try other portal? (I like simpleportal)
3. Try without sub-account mod but with other portal? (IMHO you can always ask the portal or other mod author for help. ;))
4. Try wihout sub-account an portal mod? (May be you dont really need the sub account and portal and need something like ultimate profile and cms management mod?)

You might want to learn more about CREATE VIEW function (or limitation). Try to read this and google for more...
Limitation - http://www.java2s.com/Tutorial/MySQL/0180__View/Afewthingsarentallowedinaquerythatdefinesaview.htm
MySQL Manual - http://dev.mysql.com/doc/refman/5.0/en/create-view.html

Play around some more and see. You may finally find a good working combination. Good luck!

NB: Install mods only when it is useful in mods combination (with less headache unless I really want to) is my main preference. By the way, I like headache in learning as it makes me understand more (or stucked!) ;)

FireDitto

Quote from: Abu Fahim Ismail on June 16, 2010, 05:42:44 AM
Quote from: FireDitto on June 16, 2010, 02:48:36 AM
I shared the EzPortal and Sub Account databases, but I'm still getting the
"Unknown column 'mem.is_shareable' in 'field list'" error and none of my EzPortal things are saving still...

Playing around with it now to see if I can't fix the issue, but I'm honestly not sure what is up. =/

Unfortunately at the moment, my host is having issues so my forums are down. I'm answering these off memory, but I believe it to be right:

Quote1. Have you check your cookie settings for each forum? Is it the same or different? As suggested, it should be different.
99.9% sure they are different. I haven't touched them, so I don't see why they would be the same.

Quote2. Is 'mem.is_shareable' table shared too? If it is, then may be you wanna check the list whether it is the same with the other forum i.e. they are numbered the same way. Or you might want to disable any function related to that table (I dont use this mod but it may be related to the sharing of sub-account profile which might be related to its ID numbering).
I have NO idea what mem.is_shareable is or where to find it. I was hoping someone here would. I've looked, but I cannot find.

QuoteSuggestions:
1. Try two fresh new forums with the same mods. See if the problems are the same.
Hrm, will give it a shot when the forums are up again.

Quote2. Try other portal? (I like simpleportal)
*grimace* I'm not at all keen on the other portals. I like EzPortal far more than any of the others.

Quote3. Try without sub-account mod but with other portal? May be you dont really need the sub account and need something like ultimate profile mod? (Install mod only when it is useful in your combination (with less headache) is my main preference. ;))
No can do. I can't substitute the Sub Account mod for anything else; I need it for the functioning of the website.

QuoteYou might want to learn more about CREATE VIEW function (or limitation). Try to read this and google for more...
Limitation - http://www.java2s.com/Tutorial/MySQL/0180__View/Afewthingsarentallowedinaquerythatdefinesaview.htm
MySQL Manual - http://dev.mysql.com/doc/refman/5.0/en/create-view.html

Play around some more and see. You may finally find a good working combination. Good luck!
I'll have a look.
Second Pass Weyr
An AU Pernse RPG

SMF 2.0.6 with SP 2.3.5

Hj Ahmad Rasyid Hj Ismail

Quote from: FireDitto on June 16, 2010, 05:50:45 AM
I have NO idea what mem.is_shareable is or where to find it. I was hoping someone here would. I've looked, but I cannot find.
Your database prefix=is_ and you are looking for table=shareable?

FireDitto

My prefixes are

main1_ , bod1_ and shared_

There isn't an is_ prefix.
Second Pass Weyr
An AU Pernse RPG

SMF 2.0.6 with SP 2.3.5

hachik0

looks like the impossible just happened! thank you for sharing your idea. very enlightening to say the least! :D

PurpleCrow

I have a quick question, just as a heads up I'm using SMF 2.0 RC3.

What I would like is to have two forums to have the same memberbase and membergroups. Would it be possible to have it set up to that one membergroup can see forums on one forum that regular members cant see, but be able to request to join that membergroup from the other forum?

IE: Member X wants to see forums on Forum B, could they request to be part of that membergroup via Forum A and be able to see those forums on Forum B?

I have no idea if that makes sense mind you...
SMF 2.0 RC3

Looking for staff!

Forums Galore, a brand new Admin Forum is looking for staff to help with the launch. Send me a PM or sign up to Forums Galore if you're interested!

Add your forum to the Forums Galore Community Showcase

Hj Ahmad Rasyid Hj Ismail

That is just the membergroups and board settings. You can setup your board so that only certain membergroups be able to see it and others don't.

FireDitto

The issues I had earlier were destroyed by fully installing the different forums I wanted to use, putting all the mods on them that I wanted to use, and then going into the database and linking them all.

I may simply have miss-edited something previously, but I feel this is a clean way of doing it.

I have the following mods installed:

1.   EzPortal    0.4.0
2.   SubAccounts Mod    1.0.0
3.   Member Color Link    3.0.8
4.   Team Page    3.5.5
5.   Add IP2Location to Track IP    1.3
6.   Display Name On Registration    2.0
7.   Justify BBCode    2.3.1
8.   Custom Form Mod    1.6
9.   View / Enter Board Permissions    1.1  [not installed yet]
10.   MultiForum Mod    1.1

I run RC3

=D


Everything is working beautifully that I have thus far determined.
Second Pass Weyr
An AU Pernse RPG

SMF 2.0.6 with SP 2.3.5

Hj Ahmad Rasyid Hj Ismail


FireDitto

EzPortal is very fussy about the changes made to the database, and will only retain those instructions it was given before the databases are joined.

Any changes I've tried to make afterward, are completely ignored and do not register.

I have no idea how to correct this.
Second Pass Weyr
An AU Pernse RPG

SMF 2.0.6 with SP 2.3.5

Hj Ahmad Rasyid Hj Ismail

July 20, 2010, 12:49:40 PM #351 Last Edit: July 20, 2010, 12:53:45 PM by AbuFahim⎝⏠⏝⏠⎠
Quote from: FireDitto on July 20, 2010, 04:39:22 AM
EzPortal is very fussy about the changes made to the database, and will only retain those instructions it was given before the databases are joined.

Any changes I've tried to make afterward, are completely ignored and do not register.

I have no idea how to correct this.
Have you try installing ezportal after the database is shared? You do not need to share ezportal IMHO. As far as i know most portal  can stand alone thus need not be sharing the same database with SMF (forum).

Hj Ahmad Rasyid Hj Ismail

This has been further developed by Johncccccc but still haven't finish with its packaging yet.


There is also a subforums mod from PortaMX that will be out soon.
Quote from: ahrasis on September 21, 2010, 06:17:02 AM
I have forwarded the ideas to PortaMX and they have developed a very good mod for this and it is called a subforums mod. Those who are in need of this mod may request it from PortaMX (feline). They will release their beta soon an d it will also be packed together with PortaMX Portal mod.

DVDRiper

Hi,

I have installed two smf forums. They are installed in two different databases, but with one user and forums have another table prefix (smf1_, smf2_).

I need tutorial how to share members on these two forums.

Thanks in advance!

Hj Ahmad Rasyid Hj Ismail

The tutorial is in the first post. Some members also help in this topic but you'll need to go through all of the posts. Good luck!

DVDRiper

I need someone from the staff who is willing to give me reflect this process. I need only users connected to two forums.

The following is a reward!

Interested should contact me on pm.

Hj Ahmad Rasyid Hj Ismail

Quote from: DVDRiper on October 23, 2010, 06:46:51 PM
I need someone from the staff who is willing to give me reflect this process. I need only users connected to two forums.

The following is a reward!

Interested should contact me on pm.
From the staff? You mean SMF Team members? In that case you can just wait for pm from any of them.

semimedia

November 06, 2010, 11:51:40 AM #357 Last Edit: November 06, 2010, 12:08:20 PM by semimedia
Hi,

I'm trying to share two forums at different domains but same host.

I'm sharing members perfectly, but I need share uploaded avatars too.

For this I seperated avatars from attachments table to a new table.

I think if we edit subs files for this (not all {db_prefix}attachments to avatars table, just only related with uploaded avatars), it must be working fine.
But I don't know which are related to uploaded avatars.

Hj Ahmad Rasyid Hj Ismail

Uploaded avatars is one of the caveat mentioned when using this idea/mod. The reason is the uploaded avatars are kept in different directory/forum and have different ID.

semimedia

My forums can use same directory for uploaded avatars and they seems like not using different id for causing any problems.

I achieved making uploaded avatars stored to new table easily, but I couldn't find how to read from this table.

Advertisement: