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
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!
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
Wow What a database name :o
murcia-golf_co_uk_-_forum
Is this really your database name?
Hi,
Yeah.....like it!!!!!? ;D
Then did you check the table (cpg1410_usergroups) that mysql complain about that ?
http://forum.coppermine-gallery.net/index.php?topic=24842.msg114300#msg114300
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?
Do your coppermine tables reside on the database "murcia-golf_co_uk_-_forum"?
Hi,
No they are in murcia-golf_co_uk-gallery
Then check that database for existance of (cpg1410_usergroups) table and if it's there do as Nibbler suggested
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
// Connect to db - or supply a connection id to be used instead of making own connection.
$this->connect($db_connection);
Change to this
// 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.
bridge/smf10.inc.php
Hi,
Sorry just noticed that.....I'll give it a try.
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!
Hi,
The line is:LIMIT 1", __FILE__, __LINE__);
Disable database sessions in SMF.
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.
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.
wow....thanks