[MLF 2.0 RC 2] 2 forums with 1 database?

Hello,

i want to install 2 forums (2.0 RC 2) with 1 database by using different table-prefixes. But at the installation of the secound forum i got this error message:

Error!

* Specified database doesn't exist - please check database name (MySQL: No database selected)

Here is a screenshot of my problem.

Is this a known bug of the RC 2?

Cheers
Sascha

Hi Sascha,

Specified database doesn't exist - please check database name (MySQL: No database selected)

The strange thing is that the message isn't "Specified database doesn't exist - please check database name (MySQL: Unknown database 'xa2418_db5')".

Does the database xa2418_db5 really exist?

Alex

Hi Alex,

Does the database xa2418_db5 really exist?

Yes i hope so. Have a look at this screenshot.

Cheers
Sascha (bad english inside :-) )

OK i found a solution. I have to uncheck the "No overwriting of configuration file" checkbox and it works.

OK i found a solution. I have to uncheck the "No overwriting of configuration file" checkbox and it works.

So you already edited it (and specified other values on the installation form)?

If you have two forum installations on the same domain you should also change the setting "session_prefix" (advanced settings).

Alex

So you already edited it (and specified other values on the installation form)?

If you have two forum installations on the same domain you should also change the setting "session_prefix" (advanced settings).

There was no checkbox checked at the installation. I have change the entry of "session_prefix" and it works fine :-)

Thank you!

Cheers
Sascha

I want to install 2 forums (2.0 RC 2) with 1 database by using different table-prefixes.

I am investigating a similar solution, but with closer relation between the two forums. In addition to sharing the database, I was wondering if parts of the database can also be shared between the forums. Of course the two forums will have different session cookies and posting entries, but is it possible to share the user tables of the two forums? So if one registers on one of the forums, he is also automatically registered on the other forum. Technically, I think this is possible by using the right table prefixes, but are there still issues which will give problems in the share?

Otto

Hi Otto,

I was wondering if parts of the database can also be shared between the forums.

Yes, that's possible. These two forums use the same user data table and the same session_prefix (so if you log in on one forum you're also logged in on the other).

Alex

Hi Otto,

I was wondering if parts of the database can also be shared between the forums.

Yes, that's possible. These two forums use the same user data table and the same session_prefix (so if you log in on one forum you're also logged in on the other).

Alex

Hi,

we do that with a modified (but not that for) 1.7.6 with four forums. Categories, entries and settings are separate, smilies, userdata, useronline and banlists are the same. So each forum has a slight difference in layout and different user permissions with respect to its designation. Some of them have the view fixed and one works as some kind of wiki. We also added an alternative stylesheet (some users wanted for old Times Roman)

Hope that will continue to work with final 2.0, once adapted ;-)

Jojo

Hi Otto,

I was wondering if parts of the database can also be shared between the forums.

Yes, that's possible.

Hi Alex,

Just to be sure:

$db_settings['settings_table'] = 'mlf2_settings';
$db_settings['forum_table'] = 'mlf2_entries';
$db_settings['category_table'] = 'mlf2_categories';
$db_settings['userdata_table'] = 'mlf2_userdata';
$db_settings['smilies_table'] = 'mlf2_smilies';
$db_settings['pages_table'] = 'mlf2_pages';
$db_settings['banlists_table'] = 'mlf2_banlists';
$db_settings['useronline_table'] = 'mlf2_useronline';
$db_settings['login_control_table'] = 'mlf2_logincontrol';
$db_settings['entry_cache_table'] = 'mlf2_entries_cache';
$db_settings['userdata_cache_table'] = 'mlf2_userdata_cache';

Is it safe to share the tables depicted in blue? (Of course I can "unshare" settings if it appears that I need some different settings between the two forums.

Otto

RSS Feed of thread

my little forum

[MLF 2.0 RC 2] 2 forums with 1 database? (Bugs)