Problem with CPG 1.3.2 and vBulletin 3.0.6 - cookie prefix crashes it

[rs25.com]

Hi,

I just installed vBulletin 3.0.6 and it's up and running, and then installed Coppermine 1.3.2 and it was up and running.  When I bridge it, it works fine until I try to login.  It sends me to the forums to login, but when I come back it does not recognize me being logged in.

When I change the cookie prefix to "bb" I get this error:

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

And no other page content.  When I remove the cookie prefix, it works, but does not recognize me being logged in again!

Here's my vbulletin30.inc.php file:

Code Select Expand

// 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', '');  // Cookie Prefix, not supported by vBulletin 2


Any ideas?

URL is http://www.thesti.com/uploads

[Nibbler]

Enable debug mode, reproduce the db error, and post the full sql error message that you get.

[rs25.com]

The error is:

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

mySQL error: Table 'thesti_copp1.user' doesn't exist
------------------------------

This is the Coppermine DB it is looking at, not my vBulletin one. 

I have the init.inc.php file set properly as well:


define('COPPERMINE_VERSION', '1.3.2');
// User database integration
// Uncomment the applicable line if you want to use it
// define('UDB_INTEGRATION', 'phpbb');
// define('UDB_INTEGRATION', 'invisionboard');
// define('UDB_INTEGRATION', 'vbulletin23');
define('UDB_INTEGRATION', 'vbulletin30');
// define('UDB_INTEGRATION', 'yabbse');
// define('UDB_INTEGRATION', 'smf');
// define('UDB_INTEGRATION', 'woltlab21');
// define('UDB_INTEGRATION', 'punbb');

Ideas?

[Nibbler]

The instructions tell you that coppermine and vb should be in the same database.

[rs25.com]

Doh, my bad.  Thanks for the catch.