vB 3.0.8/CPG1.3.3 Integration Problems

[eljeffe]

I installed Coppermine today and after follwing the instructions for integrating CPG with vB, I am having no luck.  When I go from my vB instance, the Coppermine menu still shows "login" as an option.  When I click on "login", I am redirected back to the main page of my forums.  Can you help?

Site:  http://www.bmwlt.com/forums
Username:  testuser
Password:  testuser
Location of forums:  http://www.bmwlt.com/forums
Location of cpg:  http://www.bmwlt.com/files

Thanks.

[Nibbler]

Please post what you have changed in the bridge file.

[eljeffe]

Security information marked out with ********

Changed lines of code marked in bold

//NOTE : Your vBulletin license number is provided at the top of every php file in your vBulletin installation!
define('VB_CUST_NO', '********'); // Your vBulletin license number (NOT your customer number)
define('VB_DB_NAME', '********'); // The name of the database used by the board
define('VB_BD_HOST', '********'); // The name of the database server
define('VB_DB_USERNAME', '********'); // The username to use to connect to the database
define('VB_DB_PASSWORD', '********'); // The password to use to connect to the database

// The web path to your vBulletin Board directory
// In this example http://yoursite_name.com/vbulletin3/
define('VB_WEB_PATH', '/forums/');
// ------------------------------------------------------------------------- //
// Nothing to edit below this line
// ------------------------------------------------------------------------- //
// Prefix and names for the database tables
define('VB_TABLE_PREFIX', ''); // Leave empty, not supported by vBulletin 2.3
define('VB_USER_TABLE', 'user'); // The members table
define('VB_SESSION_TABLE', 'session'); // The sessions table
define('VB_GROUP_TABLE', 'usergroup'); // The groups table
define('VB_COOKIE_PREFIX', 'bb');  // Cookie Prefix, not supported by vBulletin 2

[eljeffe]

Please post what you have changed in the bridge file.

Hey Tom,

We also decided to reinstall the whole shebang at www.bmwlt.com (just to make sure the forums.bmwlt.net domain wasn't causing the issue).

I've updated the URL and testuser information in the first part of the post.

Your help is greatly appreciated.

[Nibbler]

Your VB_COOKIE_PREFIX should be 'forums_', not 'bb'.

[eljeffe]

I think that did the trick, but now we're onto the next problem.  Now I get the following error when I go to http://www.bmwlt.com/files

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

[Nibbler]

OK, disable the bridge, enable debug mode, re-enable the bridge, and post the real mysql error message that you get.

[eljeffe]

OK, disable the bridge, enable debug mode, re-enable the bridge, and post the real mysql error message that you get.

The error is:

While executing query "SELECT userid as user_id, username as user_name, usergroupid as mgroup, password FROM `forums`.user WHERE userid='2'" on 0

mySQL error: Table 'forums.user' doesn't exist

It appears we have vb3_ prefixing all the vBulletin tables.  Do you know where there might be a DB_PREFIX?  I'll go look in the init files.

[kegobeer]

Are your Coppermine and bbs tables in the same database?

[Nibbler]

It's the VB_TABLE_PREFIX setting in the bridge file.

[eljeffe]

Are your Coppermine and bbs tables in the same database?

Yep.  And I found the table prefix variable and added 'vvb3_' to it.  Looks like it's working like a charm.

Thanks for your  help!!!

Jeff