Bridging with Yabbse

[jns]

I searched for an answer to this problem and could not find one.

I'm trying to bridge my install of CPG 1.3.2 with Yabbse 1.5.5. After following directions in the CPG documentation,  and attempting to run CPG I get

Fatal error :
There was an error while processing a database query.

Running CPG in debug mode I get the following additional information:

mySQL error: Table 'gallery.soundoff_members' doesn't exist

Note that "soundoff" is the name of my Yabbse database. "gallery" is the chosen name for my CPG install. The dbs for these installs go by those names.

I'm guessing that somewhere along the line, the Bridge was supposed to create a table called gallery.soundoff_members, which I'm presuming is a duplicate of soundoff_members. I confirmed that the table "soundoff_members" exists. Checking the tables in my CPG install, I see nothing close to that.

Those are the clues I can find, but I need some direction on finding a solution.

Oh, and before you say, "Upgrade Yabbse to SMF," please understand that I'm not ready to do that at this time, but wish to get CPG going now.

[Nibbler]

As stated in the docs:

It is recommended that you use the same database for your board and Coppermine (in fact it is even mandatory!).

[jns]

As stated in the docs:
It is recommended that you use the same database for your board and Coppermine (in fact it is even mandatory!).

I read the documentation and followed it explicitly. If the database table location was changed, that change was caused by the bridge and not by something I did. I did not make any changes to any files, other than those listed in the documentation.

The documation as to edit the bridge file. In the Yabbse bridge file (yabbse.inc.php) there is only one line to edit about the "Nothing to edit below this line" comment. That line is to include the contents of Settings.php from Yabbse. I made that edit as specified.

The only other change to make, as I read the documentation, is to uncomment the correct line in include/init.inc.php. I did that too. It is at that point that I get the error when trying to log into CPG.

[Nibbler]

I read your post as meaning "soundoff" was a database containing yabbse and "gallery" is a database containing your coppermine install.

The bridge is looking for your yabbse stuff in the same db as coppermine, and with a soundoff_ tablename prefix. Is this correct ?

The bridge doesn't create any tables, just provides a means to read your forum's existing user table.

[jns]

I read your post as meaning "soundoff" was a database containing yabbse and "gallery" is a database containing your coppermine install.

The bridge is looking for your yabbse stuff in the same db as coppermine, and with a soundoff_ tablename prefix. Is this correct ?

You are correct. Why is CPG looking for a db in the gallery database when that does not exist?

[Joachim Müller]

this discussion is leading nowhere. The facts: both coppermine and yabbse database tables have to reside in the same database. If you have them in different databases, you're stuck and will have to move either coppermine's or yabbse's database tables over.

Post a link to your page and a test user account (non-admin) for a start...

Joachim

[jns]

this discussion is leading nowhere.

You're right. If I'm not definiing the problem sufficiently, let me know. Also, I may have caused some confusion with my last reply. I said, "Why is CPG looking for a db in the gallery database when that does not exist?" when I should have said, "Why is CPG looking for a table in the gallery database when that does not exist?"

The facts: both coppermine and yabbse database tables have to reside in the same database. If you have them in different databases, you're stuck and will have to move either coppermine's or yabbse's database tables over.

That makes perfect sense. What I don't understand is why there's nothing in the documentation about making that happen.

I have been running Yabbse for several months. I decided to try Coppermine. I installed it according to directions. Then I discovered there was a way to bridge it to my forum. Great! So I read the directions for that. If somewhere along the line the directions said, "And if you want to make Coppermine work with your fourm, do such and such as you install Coppermine's database." I sure missed it.

What I found was,

To avoid confusion, make sure to set up both coppermine and your bbs as standalone first.

I did that.

Again, if I missed something in the documentation, please tell me. If I need to move tables to a different db, tell me.

Thanks for your willingness to help me fix this problem.

Post a link to your page and a test user account (non-admin) for a start...

click here

USER: tester
PASS: testing123

[Nibbler]

Try this bridge file, it will work across different dbs.

[jns]

Try this bridge file, it will work across different dbs.

It does work! Thank you.

Was I doing something wrong, is the documentation weak here, is there a bug? What happened before?

[Joachim Müller]

1) bridge files differ
2) bridge files evolve

Conclusion: don't ask why, just say "thanks" to Nibbler.

Joachim

[jns]

Conclusion: don't ask why, just say "thanks" to Nibbler.

I did that, but it bears repeating.

Thank you.