Print

[Sticky]

I've scoured the forums and I've tried many of the fixes offered and I can't seem to get integration to work.  Both IPB and CPG work well as standalones.  Here is my invisionboard.inc.php setup.  My comments are (in brackets):

-------------------------------
// database configuration
define('IB_DB_NAME', 'forum'); // The name of the database used by the board (its called forum)
define('IB_BD_HOST', 'localhost'); // The name of the database server (from my host)
define('IB_DB_USERNAME', '******'); // The username to use to connect to the database (****** subs for real name and PWD)
define('IB_DB_PASSWORD', '******'); // The password to use to connect to the database

// The web path to your Invision Board directory
// In this example http://yoursite_name.com/ivboard/ (mine is "http://www.xxxxxxx.ca/forums/index.php")
define('IB_WEB_PATH', '/forums/');
// ------------------------------------------------------------------------- //
// You can keep the default values below if your installation is standard
// ------------------------------------------------------------------------- //
// The prefix for the Invision Board cookies
define('IB_COOKIE_PREFIX', ' '); // The prefix used for board cookies (I haven't assigned a prefix in my board)

-----------------------------------
-----------------------------------

When I start the integration process I get this error:
---------
Fatal error :
There was an error while processing a database query
---------
I've tried the fix by Gregory DEMAR as well as the "member_login" fix.

Any help before I abandon this gallery project altogether?

[kegobeer]

Please enable debug and post the debug information and the actual error.

Do Coppermine and IPB share the same database, or are they in separate databases?  The bridge files require them to share the same database.

[Sticky]

Do Coppermine and IPB share the same database, or are they in separate databases?  The bridge files require them to share the same database.

Yes, they are bot in the same mySQL db (tc_forum).  Dubug mode (using the original invisionboard.inc.php and init.inc.php files - modified with only the required information - not the hacked files) shows this error...

---------------------------------------------------
Fatal error :
There was an error while processing a database query
---------
While executing query "SELECT id as user_id, name as user_name, mgroup FROM `tc_forum`.ibf_members WHERE id='1' AND password='9b820df72d77820d503875a2cc011fa3'" on 0

mySQL error: Unknown column 'password' in 'where clause'
---------------------------------------------------
Obviously doesn't like the word "password" and something needs to be changed but not sure where and to what...
--
Sticky

[Sticky]

I re-tried Greg's fix (forgot to use the login.php fix as well) and it seems to be working now.

Thanks.
--
Sticky

[Tim77]

Why do people keep saying they need to share the same database?? I have never had them in the same database. It works fine even when running using two completely seporate cPanel accounts.

Please enable debug and post the debug information and the actual error.

Do Coppermine and IPB share the same database, or are they in separate databases? The bridge files require them to share the same database.

[Nibbler]

Bridge files differ in their support for seperate databases, some are fine with it, others fail, so it is easiest to simply state they must be in the same db.

[shabirvirk]

I Post my prob in new thread