coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: eljeffe on September 10, 2005, 11:51:23 PM

Title: vB 3.0.8/CPG1.3.3 Integration Problems
Post by: eljeffe on September 10, 2005, 11:51:23 PM
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.
Title: Re: vB 3.0.8/CPG1.3.3 Integration Problems
Post by: Nibbler on September 10, 2005, 11:56:34 PM
Please post what you have changed in the bridge file.
Title: Re: vB 3.0.8/CPG1.3.3 Integration Problems
Post by: eljeffe on September 11, 2005, 12:04:05 AM
Security information marked out with ********

Changed lines of code marked in bold
Quote
//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
Title: Re: vB 3.0.8/CPG1.3.3 Integration Problems
Post by: eljeffe on September 11, 2005, 07:04:18 PM
Quote from: Nibbler on September 10, 2005, 11:56:34 PM
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.
Title: Re: vB 3.0.8/CPG1.3.3 Integration Problems
Post by: Nibbler on September 11, 2005, 08:05:53 PM
Your VB_COOKIE_PREFIX should be 'forums_', not 'bb'.
Title: Re: vB 3.0.8/CPG1.3.3 Integration Problems
Post by: eljeffe on September 11, 2005, 08:13:01 PM
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
Title: Re: vB 3.0.8/CPG1.3.3 Integration Problems
Post by: Nibbler on September 11, 2005, 08:16:23 PM
OK, disable the bridge, enable debug mode, re-enable the bridge, and post the real mysql error message that you get.
Title: Re: vB 3.0.8/CPG1.3.3 Integration Problems
Post by: eljeffe on September 11, 2005, 08:23:10 PM
Quote from: Nibbler on September 11, 2005, 08:16:23 PM
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.
Title: Re: vB 3.0.8/CPG1.3.3 Integration Problems
Post by: kegobeer on September 11, 2005, 08:24:12 PM
Are your Coppermine and bbs tables in the same database?
Title: Re: vB 3.0.8/CPG1.3.3 Integration Problems
Post by: Nibbler on September 11, 2005, 08:25:19 PM
It's the VB_TABLE_PREFIX setting in the bridge file.
Title: Re: vB 3.0.8/CPG1.3.3 Integration Problems
Post by: eljeffe on September 11, 2005, 08:25:54 PM
Quote from: kegobeer on September 11, 2005, 08:24:12 PM
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