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:
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"?
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.
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?
There's a bridge file for IPB 2 posted on the mods board.
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..
Quote// ------------------------------------------------------------------------- //
// 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 queryany advice on how to go about doing this?
When requesting bridge support. (http://forum.coppermine-gallery.net/index.php?topic=17684.0)
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 ???
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.
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?
Reverse your change in include/init.inc.php to disengage the bridge.
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'";
For the 3rd time in this thread - Make sure you have the right version of the bridge file for your IPB version.