Bridging CPG 1.6.03 with VBulletin 4.2.5 - Critical Error

[ron4mac]

 
Can you please post 2 files here? Remove passwords but try not to change them in other ways.

<forum>/includes/config.php
and
<gallery>/include/config.inc.php

Or .. email them to me at ron4mac_(at sign)_me_dot_com

[Fity]

Thanks for your efforts.

I will send you an email soon.

[Fity]

Email sent.

[ron4mac]

I get a red error notification box with:

Okay .. I think it is connecting to the database now, anyway.  Can you turn off bridging, turn debug mode on in CPG then try bridge mode again. Maybe we can see what SQL error it is getting.

[Fity]

Large red error notification box.  (I have removed the sensitive info)

Critical error

There was an error while processing a database query.


While executing query 'SELECT NULL FROM `******`.user LIMIT 1' in bridge/udb_base.inc.php on line 59

database error: 1142 : SELECT command denied to user '******'@'localhost' for table 'user'



File: /home/******/public_html/photo_gallery/include/functions.inc.php - Line: 253

This in the debug info box:

/include/init.inc.php
Notice line 198: Undefined index: log_retention
/bridgemgr.php
Notice line 137: Undefined variable: return
/bridge/vbulletin30.inc.php
Notice line 34: Constant USE_BRIDGEMGR already defined

Also I think I have lost access again as I receive this while trying to access any cpg page.

Fatal error:

While executing query 'SELECT NULL FROM `******`.user LIMIT 1' in bridge/udb_base.inc.php on line 59

database error: 1142 : SELECT command denied to user '******'@'localhost' for table 'user'

[ron4mac]

Try commenting out line 36 in udb_base.inc.php
(put 2 forward slashes at the front of it)

Code Select Expand

// $this->can_join_tables = ($this->db['host'] == $CONFIG['dbserver'] . . . .

[Fity]

Success! 

Commenting out that line has given me access to the cpg again and if I follow a link from Vbulletin bridging is working too.

I have only had a quick test but it appears to be operational.  Thanks for your help resolving this. 

Now to set up the gallery.

[ron4mac]

Great!!  Thanks for working through this with me. It would have been much easier had access to your site been possible.

Now I'll have to translate all this into permanent code changes to the distribution that will keep it from occurring in the first place.

[Fity]

Glad to  help.  It was benefiting me too.

Was a change in VB4 causing the error?

[ron4mac]

Was a change in VB4 causing the error?

No, it involves MySQLi and bridging with different databases ... not so much with VB4.