Need help about the bridge-thing

[Cheetaz]

Hey, I started using Coppermine and it's just too good, thanks.

But my problem is, I can't create a bridge. Even once, when I tried doing it, it crashed my IPSC totally, no pages were worked, all I got was a mySQL error about some "cegg" thing.

So I don't want this to happen again so how do I correctly do this? Thanks.

EDIT: Forgot to read the top thread so here's this:

I have the following issue when trying to bridge:
Not really an error message..

Coppermine install: http://anti-n00b.byethost13.com/ipsc/
Forum install: Nowhere, I couldn't install the forum
Coppermine version: You have currently installed: 1.4.7
Forum version: None
Test user account: Test_CM / temp

BridgeManager settings:
Forum URL:  This is the part I don't get...
Relative path to your BBS's config file:  This is the part I don't get... 
Use post-based groups?:  0 

Look in "BridgeManager settings"

[Nibbler]

How can you not know the url of your forum ?

Apparently it is http://anti-n00b.byethost13.com/ which makes the relative path ../

[Cheetaz]

Well, I didn't know I should have put my forum URL on there, or something, I just didn't understand it..

Sorry, I'll try that now.

EDIT: Erm, what do I put in the first text-box? :/

EDIT AGAIN: I tried just putting the URL to my forum there, with "../" in the other box, and when I came to the last page of bridging, "There was an error while processing a database query" - that showed up..

[Nibbler]

Enable debug mode and post the mysql error message you receive when you replicate the db error.

[Cheetaz]

File: /var/www/virtual/anti-n00b.byethost13.com/htdocs/ipsc/include/functions.inc.php - Line: 249

[Nibbler]

Post the mysql error message.

[Cheetaz]

Oh, sorry, got the wrong Error. Here:

While executing query "SELECT * FROM `1197_anti-n00b`.1197_antin00b_membergroups" on Resource id #6

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.1197_antin00b_membergroups' at line 1

Got this information too, if you somehow need it:

==========================
VERSION INFO :
------------------
PHP version: 5.1.4 - OK
------------------
mySQL version: 4.1.11-Debian_4sarge3-log
------------------
Coppermine version: 1.4.7(stable)

[Nibbler]

You have exactly the same issue as http://forum.coppermine-gallery.net/index.php?topic=32405.msg150649#msg150649, solution is posted there there.

[Cheetaz]

Thanks for replying again.

Try changing

Code Select Expand

$this->groupstable =  '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['groups'];

to

Code Select Expand

$this->groupstable =  $this->db['name'] . '.' . $this->db['prefix'] . $this->table['groups'];

in the bridge file.

Um, I don't know what file you're talking about? It must be bridgemgr.php since that's the only bridge file I have.. But the first code you entered, it can't be found, therefore it can't be replaced with the other code. :S I even tried an CTRL + F search to try finding part of the words in the codes, but no luck. I even did a search in my folder where I have the Coppermine, the "Search for words in the files" thing? I searched "$this" but nothing showed up. Or maybe I'm doing something wrong? Thanks again for helping me.

[Nibbler]

bridge/smf10.inc.php

[Cheetaz]

Oh, bleh. But I changed that, this comes up:

While executing query "SELECT * FROM 1197_anti-n00b.1197_antin00b_membergroups" on Resource id #6

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-n00b.1197_antin00b_membergroups' at line 1

Pretty much the same as the one before. And it isn't the same as the other guys error he got after. Should I just change those "Derived Full Table Names"? If yes, I tried looking for it but what you said he should change, isn't in my file, unless it's in another one... Thanks again! And sorry for being stupid.

[Nibbler]

Try it without the dbname. Note that the dash is not valid for database name, that is why we need the workaround.

Change

Code Select Expand


            $this->usertable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['users'];
            $this->groupstable =  '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['groups'];


to

Code Select Expand


            $this->usertable = $this->db['prefix'] . $this->table['users'];
            $this->groupstable = $this->db['prefix'] . $this->table['groups'];


[Cheetaz]

Thank you, it worked. *thumbs up*

Thanks for helping.