Topic: Failed SMF bridge (Read 8916 times)

Gazab · « **on:** November 21, 2006, 05:18:49 pm »

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 · « **Reply #1 on:** November 21, 2006, 05:25:54 pm »

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.

Quote from: Gazab on November 21, 2006, 05:18:49 pm

Coppermine version: cpg1.4.2

Upgrade!

Gazab · « **Reply #2 on:** November 21, 2006, 06:33:40 pm »

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 · « **Reply #3 on:** November 21, 2006, 07:15:40 pm »

Wow What a database name

murcia-golf_co_uk_-_forum
Is this really your database name?

Gazab · « **Reply #4 on:** November 21, 2006, 07:50:48 pm »

Hi,

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

Sami · « **Reply #5 on:** November 21, 2006, 08:00:18 pm »

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

Nibbler · « **Reply #6 on:** November 21, 2006, 08:04:12 pm »

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

Gazab · « **Reply #7 on:** November 21, 2006, 09:47:50 pm »

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 · « **Reply #8 on:** November 21, 2006, 10:43:10 pm »

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

Gazab · « **Reply #9 on:** November 21, 2006, 11:00:56 pm »

Hi,

No they are in murcia-golf_co_uk-gallery

Sami · « **Reply #10 on:** November 22, 2006, 05:45:53 am »

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

Gazab · « **Reply #11 on:** November 22, 2006, 04:07:12 pm »

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]

// 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]

// 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 · « **Reply #12 on:** November 22, 2006, 04:09:02 pm »

bridge/smf10.inc.php

Gazab · « **Reply #13 on:** November 22, 2006, 04:15:57 pm »

Hi,

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

Gazab · « **Reply #14 on:** November 22, 2006, 04:25:46 pm »

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 · « **Reply #15 on:** November 22, 2006, 04:35:16 pm »

Hi,

The line is:

Code: [Select]

LIMIT 1", __FILE__, __LINE__);

Nibbler · « **Reply #16 on:** November 22, 2006, 04:46:19 pm »

Disable database sessions in SMF.

Gazab · « **Reply #17 on:** November 22, 2006, 06:17:09 pm »

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 · « **Reply #18 on:** November 22, 2006, 06:29:47 pm »

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 · « **Reply #19 on:** November 22, 2006, 06:32:59 pm »

wow....thanks

News:

Author Topic: Failed SMF bridge (Read 8916 times)

Nibbler

Nibbler

Nibbler