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:
// 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
Enable debug mode, reproduce the db error, and post the full sql 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 `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?
The instructions tell you that coppermine and vb should be in the same database.
Doh, my bad. Thanks for the catch. ;D