Home  |  About  | Last |  Submit  |  Contact
AllQuests.com




Previous Question:  importing database from freeforums.org  phpBB 2.0.x 2.0.x Support ForumNext Question:  Contact Form problem  PHP
Question Multiple boards for single installation multiple databases ( phpBB phpBB 3.0.x 3.0.x Support Forum )
Updated: 2008-11-23 05:55:01 (5)
Multiple boards for single installation multiple databases

Hi.

I've successfully had phpbb3 beta 5 running for a while now under Debian with the standard database configuration.

I'm now attempting to set up a second "copy" of the board running under a different virtual host.
I'd like to re-use the base installation and just have a different database.

It's almost complete:
- I've got the second copy of the board up and running
- The two boards are using different databases
- I had to blank out the default database.inc.php and use a copy per virtual host to set the dbname
- The two boards have different images & avatars directories

But: There appear to be system-wide values stored in some common place.
If I go to the ACP and alter the 'Site Name' (General/Board Settings) then the site name for both boards alters.

Where are these values stored?
They appear in the www/cache/data_global.php file.
Is this the only place?
Is it possible to have the two boards use different cache directories?

Thanks for any hints.
J.
Answers: Multiple boards for single installation multiple databases ( phpBB phpBB 3.0.x 3.0.x Support Forum )
Multiple boards for single installation multiple databases

Yes, the cache directory is used to cache database queries, including configuration values. Somehow, you'll have to figure out how to change the cache directory for each board. In fact, it's probably best to redirect all phpBB writeable directories to somewhere separate per board.
Roberdin
Roberdin

Multiple boards for single installation multiple databases

Good to hear that it's in the db.

It appears to be in a file in the the www/cache directory as well.
Does this file get created for certain globals? To save having to query them for every hit?
Because that file is shared between the two boards, like everything in the www dir, that would also explain it.
jcosmo

Multiple boards for single installation multiple databases

Anything that you can change via the ACP is stored in the config table in the database.

Could the problem be something to do with cookies? I have seen this before where you have two forums and, where they both have the sane cookie name, you log into one and end up in the other.
David
Remember: You only know what you know and - you don't know what you don't know!
MyWebWorld
I do not provide support via PM or e-mail.
david63

Multiple boards for single installation multiple databases

Um, I thought I had sorted out the separate databases bit of it...

In each virtual host I have a line that looks like
php_value auto_prepend_file /etc/phpbb3/[boardName]_config.php

The two [boardName]_config.php files have different values for $dbname

This appears to work - the two boards have different forums and different registered users.

The issue is that some settings appear to be being shared between the two databases.
Things like the global Site Name and Site Description values that are edited in General/Board Settings in the ACP. Are these values supposedly saved in the database? Are they stored in a php file that is edited by the ACP?
jcosmo

Multiple boards for single installation multiple databases

You need to edit config.php to point to your new database.
Support Resources: Support Request Template | Preventing SPAM - Bots and Humans
My Sites: Download my phpBB MODs | pentapenguin.com
If you need professional assistance with your board, please contact me for my reasonable rates.
pentapenguin

Previous Question:  importing database from freeforums.org  phpBB  phpBB 2.0.x 2.0.x Support ForumNext Question:  Contact Form problem  SitePoint Forums  PHP

- Source: Multiple boards for single installation multiple databases phpBB phpBB 3.0.x 3.0.x Support Forum
- Previous Question: importing database from freeforums.org phpBB phpBB 2.0.x 2.0.x Support Forum
- Next Question: Contact Form problem SitePoint Forums PHP