bridging with IPB V2 2 databases, subdomains

[m0nty]

i'm having trouble setting up a bridge with invisionboard and coppermine

i have the forum on http://chat.sundissential.com/forum/

and the gallery is to be on http://gallery.sundissential.com

both are using the same db server but seperate databases.. (i would prefer to keep them seperate if possible)

how can i get this to work?

i've searched but couldn't find the relevant info for invisionboard..

[Nibbler]

They really should be in the same database. With the gallery and forum where you have them, you'll probably need to change the rediection paths in the bridge file. If you post specific problems you are having then we can help you. Also refer to the sticky on this subboard on how to request bridge support.

If you want to test the beta or wait for the full release of 1.4, you will be able to keep 2 databases and not need any code changes.

[m0nty]

k np.

i can setup on the forum database..

at moment i'm having problems with the gallery sub domain.. so it's not installed there yet..

i'm assuming;

define('IB_DB_NAME', 'ssforum'); // The name of the database used by the board
define('IB_BD_HOST', 'localhost'); // The name of the database server
define('IB_DB_USERNAME', '******'); // The username to use to connect to the database
define('IB_DB_PASSWORD', '********'); // The password to use to connect to the database

// The web path to your Invision Board directory
// In this example http://yoursite_name.com/ivboard/
define('IB_WEB_PATH', '/forum/');
// ------------------------------------------------------------------------- //
// You can keep the default values below if your installation is standard
// ------------------------------------------------------------------------- //
// The prefix for the Invision Board cookies
define('IB_COOKIE_PREFIX', 'ssforum_'); // The prefix used for board cookies

// Prefix and names for the database tables
define('IB_TABLE_PREFIX', 'ssforum_'); // The prefix used for the DB tables


--------------
define('IB_WEB_PATH', '/forum/');   this is the path, but as it's a relative path, how would i change this to the proper address. as entering http://chat.sundissential.com/forum/  wouldn't work would it?

as obviously the gallery will be on gallery.sundissential.com  and the forum is on chat.sundissential.com this would mean the path would be looking at gallery.sundissential.com/forum  in the example above..

[Nibbler]

Yes, you'd need to modify the redirection function

Code Select Expand

function udb_redirect($target)
{
    header('Location: http://' . $_SERVER['HTTP_HOST'] . IB_WEB_PATH . $target);
    exit;
}

And just hardcode in the actual url to your forum

Code Select Expand

function udb_redirect($target)
{
    header("Location: http://chat.sundissential.com/forum/$target");
    exit;
}

[m0nty]

excellent.. thanks a lot

[m0nty]

i've put the gallery into the same db as the invision.

made all the changes

now when i goto the gallery home page.

http://www.sundissential.com/gallery/

i get this:

Fatal error :

There was an error while processing a database query.


While executing query "SELECT id as user_id, name as user_name, mgroup FROM `ssforum`.ssforum_members WHERE id='0' AND password='*'" on 0

mySQL error: Unknown column 'password' in 'where clause'

[Nibbler]

Then you are using the wrong bridge file. If you are using ipb 2.0 then you need to grab the ipb 2.0 bridge file from the mods board.

[m0nty]

yup i managed to figure it out everything is working now..

thanks again