Print

[Greven]

Hi!

I have recently installed Coppermine and when I started bridging I ran into some problem. After I merged the Coppermine database with the forum I get this when I go to the page of the photogallery: http://www.blacklabelsociety.se/photogallery:

Fatal error :

There was an error while processing a database query.

While executing query "SELECT user_id, username as user_name, user_level FROM phpbb_users WHERE user_id='2' AND user_password='64b4c1053f2a35be6da6c08a8facdbf7' AND user_active='1'" on Resource id #6

mySQL error:

Both the forum and the gallery work fine without the bridging.
Addresses:
Forum: http://www.blacklabelsociety.se/forum
Gallery: http://www.blacklabelsociety.se/photogallery

I have now turned the bridging off. The bridge file looks like this:

// database configuration

define('PHPBB_DB_NAME', 'blacklab_forum'); // The name of the database used by the board

define('PHPBB_BD_HOST', 'localhost'); // The name of the database server

define('PHPBB_DB_USERNAME', 'blacklab_forum'); // The username to use to connect to the database

define('PHPBB_DB_PASSWORD', '*******'); // The password to use to connect to the database



// The web path to your phpBB directory

// If your URL to your board is for example 'http://yoursite_name.com/phpBB2/',

// you'll have to set the below var to '/phpBB2/'.

define('PHPBB_WEB_PATH', '/forum/');

I havenīt changed anything else in the bridge file.

I have created a test account in the gallery called test with the password test.

Coppermine was installed with Fantastico.

I hope someone can help me fix this problem.

[fm-2]

Hello,

Could you please post the part below

MySQL Error:

That way, we can see what is going on.

Sincerely,
Christian

[Greven]

The weird part is that there is nothing below that line.

[Nibbler]

Make sure coppermine and your forum are in the same database.

[Greven]

They are in the same database.
I exported the coppermine database and imported it to the forums database.

[Greven]

BUMP

[Nibbler]

If you are happy to PM me an FTP login I can take a look for you.

[Nibbler]

OK, bridge now running.

1) If you move coppermine around you need to edit config.inc.php and correct the information otherwise it still uses the old information.

2) Your phpbb table prefix is phpbb3_, not phpbb_ so you need to state that in the bridge file where it asks for it.

3) A cookie domain is not an url, it is just a domain, ie blacklabelsociety.se.

Once I fixed those 3 things the bridge worked.