Bridging CPG 1.6.03 with VBulletin 4.2.5 - Critical Error

[Fity]

I have been trialling CPG 1.6.03 and it has been functioning as expected up until now.  I enabled bridging and then the next screen that appeared was white screen with the following error message.

Coppermine critical error:
Unable to connect to UDB database !

Error: :

I can no longer access any page from Coppermine.  They all have the above message. I tried to access bridgemgr.php as suggested in the documents but the same error message appears and I can't disable bridging.

I tried a clean install of CPG1.6.03 with a new data base and the same bridging error occurred.

I know that bridging for VBulletin is for VB3, however I have used bridging with VB4 and CPG 1.5.x until a server configuration change to PHP7.1 which forced a Coppermine change.

Bridging was an important feature when selecting Coppermine.  Any ideas?

[Fity]

I forgot to mention that I tried to repair the database tables in case that was the problem with no luck.

[ron4mac]

Use the installer stub to install/upgrade to CPG 1.6 with the very latest changes. (select the bottom choice, highlighted in red, in the installer)
http://forum.coppermine-gallery.net/index.php/topic,79013.msg383037.html#msg383037

[Fity]

OK thanks. I will try that and post the results.

[Fity]

I have reinstalled CPG with a new database using the stub suggestion above with no luck.  Every time that I enable bridging I loose CPG access with the same error message.  Any other suggestions?

[Fity]

 Any suggestions?  I am liking v1.6 a lot and would like to get the gallery live.

[ron4mac]

If the vBulletin database is separate from the CPG database, make sure the correct credentials are configured for the bridge.

Or you can try installing CPG to use the same database as vB (with a different prefix).

[Fity]

Thanks for the reply.

There are 2 databases, one for the forum and the other for CPG.  I am hesitant to use the same database for CPG and VB.

The structure is:

http://www.website.com/forum
http://www.website.com/gallery

In the bridging settings I have tried different paths with no luck.  Sometimes I can recover by clicking "back" and disabling bridging and other times the CPG installation is not accessible.

Could the problem be that there is also a CPG1.5 installation bridged to the same VB4?  Do I need to disable bridging in CPG1.5 before enabling cpg1.6?

[Fity]

These are the paths that I believe to be correct.

URL of bridging app:
http://www.website.com/forum

Relative path
../forum/

[ron4mac]

I can't put together a VB 4.2.5 instance to test with so you would have to give me access to your site to try to determine the problem. You would have to PM me with your site and its credentials or I can post a file for you to place in your site root that I can use to access everything I need.

[ron4mac]

Here's the file. Place it unzipped, of course.

see next post first

[ron4mac]

I was just looking at things prior to doing any work at your site and may have come up with a solution.
Replace the vBulletin bridge file in your CPG 1.6 bridge folder with the one attached here (as .php).
Let me know if it solves the problem.

[Fity]

Thanks for the file.  I replaced the file in the bridging folder as suggested.  The error remains.

[phill104]

Did you remember to rename the file to end in.php

[Fity]

Yes i removed the .txt and left it named the same as the original file.  The original file was renamed and left in the bridging folder. Will that be an issue?

[ron4mac]

Replace bridge/udb_base.inc.php with the attached file (as .php).
It will still fail but may give more indication of the error condition.

Are you using mysqli or PDO/mysql for the CPG 1.6 install?

[Fity]

Thanks for the file.

cpg1.6 is MySQL. 

I replaced the file as suggested and the error message has a little more information.

Coppermine critical error:
Unable to connect to UDB database !

Error: 2005 : Unknown MySQL server host 'localhost:3306' (2)

[Fity]

I forgot to mention that since replacing the vbulletin30.inc.php I have reliably backed out of the error message to the previous screen to disable bridging.

[ron4mac]

suggested and the error message has a little more information.

Great! Replace vbulletin30.inc.php again with the one attached here and (I'm hopeful) it'll run now.

[Fity]

I get a red error notification box with:

Critical error
There was an error while processing a database query