Failed SMF bridge

[Gazab]

Hi,

Sorry about this, but I could use some help here. I have tried to use the bridging manager, after selecting user based groups, I then receive this error:- There was an error while processing a database query

I thought I was following the instruction but I've obviously gone wrong at some point. All access is now lost the gallery and bridge manager.

Coppermine install: http://murcia-golf.co.uk/gallery/
Forum install: http://murcia-golf.co.uk/forum/
Coppermine version: cpg1.4.2
Forum version: SMF 1.0.9.
Test user account: some_testuser_name / the_password_for_the_test_user_account

BridgeManager settings:
Forum URL: http://www.murcia-golf.co.uk/forum
Relative path to your BBS's config file:  ../forum/ 
Use post-based groups?:  yes
Cookie name/preifx = $cookiename = 'SMFCookie10';

Any help much appreciated.

Gazab

[Joachim Müller]

Manually enable debug_mode as suggested in http://coppermine-gallery.net/tutorial/debug_mode.php and post the actual error message (not the debug_output) to see what exactly goes wrong.

Coppermine version: cpg1.4.2

Upgrade!

[Gazab]

Hi,

Thanks for the fast reply.

Here is the error message;
mySQL error: Table 'murcia-golf_co_uk_-_forum.cpg1410_usergroups' doesn't exist

If I can recover from this then I am not to worried about completing the bridge.

Cheers for your help.

Gazab

[Sami]

Wow What a database name
murcia-golf_co_uk_-_forum
Is this really your database name?

[Gazab]

Hi,

Yeah.....like it!!!!!?

[Sami]

Then did you check the table (cpg1410_usergroups) that mysql complain about that ?

[Nibbler]

http://forum.coppermine-gallery.net/index.php?topic=24842.msg114300#msg114300

[Gazab]

Hi,

Yes I've looked for the table and it doesn't exist. All SMF tables are prefixed smf_ .....?

I would be OK just to return to my working version of Coppermine and allow registration. Is this now possible?

Any ideas?

[Joachim Müller]

Do your coppermine tables reside on the database "murcia-golf_co_uk_-_forum"?

[Gazab]

Hi,

No they are in murcia-golf_co_uk-gallery

[Sami]

Then check that database for existance of (cpg1410_usergroups) table and if it's there do as Nibbler suggested

[Gazab]

Sami,

Ok I've checked and the (cpg1410_usergroups) table exisists in my gallery database. You then suggest "do as Nibbler suggested" Nibbler posted a link which leads to this post.
OK, I found the problem. SMF hijacks coppermine's database connection. Edit smf10.inc.php, find

Code Select Expand

// Connect to db - or supply a connection id to be used instead of making own connection.
$this->connect($db_connection);
Change to this

Code Select Expand

// Fix our db connection
mysql_select_db($CONFIG['dbname'], $CONFIG['LINK_ID']);

// Connect to db - or supply a connection id to be used instead of making own connection.
$this->connect($db_connection);

Problem is I cannot find the file sm10.inc.php. I notice the post is nearly two years old, do you think the file name would have changed?

Please forgive me for asking again here, but I want to get this right.

[Nibbler]

bridge/smf10.inc.php

[Gazab]

Hi,

Sorry just noticed that.....I'll give it a try.

[Gazab]

Hi,

Made the change and can now see my gallery. The following message appears at the bottom of the page.

Database Error: Table 'murcia-golf_co_uk_-_gallery.smf_sessions' doesn't exist
File: /var/www/html/forum/Sources/Load.php
Line: 1193

Also if I try to login I am taken to my forum login!

[Gazab]

Hi,

The line is:

Code Select Expand

LIMIT 1", __FILE__, __LINE__);

[Nibbler]

Disable database sessions in SMF.

[Gazab]

Nibbler,

Phew....you got me there in the end.

Just one thing, If I browse "users" in Coppermine admin my forum users open. Is this how it works?

If so, many thanks for your time.

[Joachim Müller]

Yes: when bridged, there are no more Coppermine users, but only the ones from your forum. Susequently, you're being sent to your forum when clicking on usernames.

[Gazab]

wow....thanks