Print

[dOoBiX]

I have Invision Board 2.0.1 and Coppermine Gallery 1.3.3.

I want to bridge them together, so I did all the required steps and now my gallery shows this:

Code: [Select]

Fatal error :
There was an error while processing a database query
I searched this forum for information and I saw someone fixed the problem with "Greg's Fix"

Where can I get "Greg's Fix"?

[Nibbler]

Undo the bridge, enable debug mode, redo the bridge, post the sql error message that you get. Make sure you have the right version of the bridge file for your IPB version.

[dOoBiX]

Code: [Select]

While executing query "SELECT id as user_id, name as user_name, mgroup FROM `bccgamers`.ibf_members WHERE id='0' AND password='*'" on 0

mySQL error: Unknown column 'password' in 'where clause'
I don't think I have the right version of the bridge file for my IPB version. Where do I get an updated version?

[Nibbler]

There's a bridge file for IPB 2 posted on the mods board.

[Bluewater]

Dear sir

I have the same problem

the 1.3.3 coppermine gallery was upgraded from 1.3.2 and seems to be working perfectly

my IPB 2.0.4 board is also all working good

I am trying to do the bridging..

// ------------------------------------------------------------------------- //

// Modify the values below according to your Board installation              //

// ------------------------------------------------------------------------- //



// database configuration

define('IB_DB_NAME', 'hanleong_dfs'); // The name of the database used by the board

define('IB_BD_HOST', 'localhost'); // The name of the database server

define('IB_DB_USERNAME', 'hanleong_dfs'); // The username to use to connect to the database

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/

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



// Prefix and names for the database tables

define('IB_TABLE_PREFIX', 'ibf_'); // The prefix used for the DB tables

define('IB_USER_TABLE', 'members'); // The members table

define('IB_SESSION_TABLE', 'sessions'); // The sessions table

define('IB_GROUP_TABLE', 'groups'); // The groups table

and I got this error message

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

any advice on how to go about doing this?

[Joachim Müller]

When requesting bridge support.

[zillionz]

Hi,

I'm a reeeeeeeeal n00b when it comes to PHP so i need some real php4dummies help.

I have installed on my server: coppermine 1.3 and I want to link it with an invision board v1.3.1.

But I get the same error:

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


i think that some kind of linkage isnt working...

HELP ME PLZ i dont even know where to begin 

[Nibbler]

Undo the bridge, enable debug mode, redo the bridge, post the sql error message that you get. Make sure you have the right version of the bridge file for your IPB version.

[zillionz]

well the version of the photogallery had an bridge standard in the package. We didnt installed it or something. It said it was compatible with invision...

so how do i un install it then?

[Nibbler]

Reverse your change in include/init.inc.php to disengage the bridge.

[louis_net]

I Have The Fix !!!!!

Open bridge/invisionboard.inc.php

Find:
$sql = "SELECT id as user_id, name as user_name, mgroup " . "FROM " . $UDB_DB_NAME_PREFIX . IB_TABLE_PREFIX . IB_USER_TABLE . " " . "WHERE id='$cookie_uid' AND password='$cookie_pass'";

Replace With:
$sql = "SELECT id as user_id, name as user_name, mgroup " . "FROM " . $UDB_DB_NAME_PREFIX . IB_TABLE_PREFIX . IB_USER_TABLE . " " . "WHERE id='$cookie_uid' AND member_login_key='$cookie_pass'";

[Nibbler]

For the 3rd time in this thread - Make sure you have the right version of the bridge file for your IPB version.