1.3.2 & IBP 1.3.1 Final Bridge

[mickc1303]

Did a clean install of 1.3.2 and Invision 1.3.1 Final.

Both working fine standalone.

However when bridged invision works fine but when trying to access the gallery I get the following error.

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

[Joachim Müller]

go back to standalone (undo modification to init.inc.php), enable debug_mode in coppermine config, then switch integration back on. Report the actual query that fails.

Joachim

[mickc1303]

Thanks.

This is the error which occurs.

Code Select Expand


While executing query "SELECT id as user_id, name as user_name, mgroup FROM `pgallert`.ibf_members WHERE id='1' AND password='7d5ece1ed1d55d022c8918f1219893ff'" on 0

mySQL error: select command denied to user: 'pgallery@localhost' for table 'ibf_members'


EDIT:  I just noticed a typo in the bridge file .. I had mispelled the database user.  It's working fine now.

Thanks for your help 

[kwe1009]

Hi, I have the same problem with a clean install of both programs.  Here is the error I get after I turn on debug:


While executing query "SELECT id as user_id, name as user_name, mgroup FROM `valovers_ibrd1`.ibf_members WHERE id='0' AND  member_login_key='*'" on Resource id #6

mySQL error:


Thanks for any assistance.

[globalfisher]

did I edit this bridge file right:

// database configuration
define('PHPBB_DB_NAME', 'phpBB'); // global_xmb6
define('PHPBB_BD_HOST', 'localhost'); //  localhost
define('PHPBB_DB_USERNAME', 'root'); // ***
define('PHPBB_DB_PASSWORD', ''); // ***

[globalfisher]

I read all this topics posts cause I was having some problems also and made it so I could view the coppermine again. It was saying couldnt connect to the database but now I fixed that.

When I click the users page on the coppermine it comes up page cannot be displayed...Any ideas?

[Joachim Müller]

did I edit this bridge file right:

// database configuration
define('PHPBB_DB_NAME', 'phpBB'); // global_xmb6
define('PHPBB_BD_HOST', 'localhost'); // localhost
define('PHPBB_DB_USERNAME', 'root'); // ***
define('PHPBB_DB_PASSWORD', ''); // ***

never post your password on a public board, I edited your posting accordingly. You should however (if you can) change it now.

Of course you mustn't change the comments (after the double slashes), but the actual content (inside the quotes). Change your settings to:

Code Select Expand

// database configuration
define('PHPBB_DB_NAME', 'global_xmb6'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server
define('PHPBB_DB_USERNAME', '****'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', '*****'); // The password to use to connect to the databaseReplace the asterisks with the actual values.

As you seem to be very unexperienced, I strongly suggest you review the docs carefully.

I read all this topics posts cause I was having some problems also and made it so I could view the coppermine again. It was saying couldnt connect to the database but now I fixed that.

When I click the users page on the coppermine it comes up page cannot be displayed...Any ideas?

@globalfisher : the first part of this posting refers to your first posting on this thread. After having answered I realized that you posted on another thread that you were able to solve it by yourself - thanks for resolving your issue here. I have split your posting from the other thread and merged it with this one. Your behaviour is not going to win you friends here . For an answer to your question, you should search the board before posting, and you should always resolve your questions if you find the answers on your own.

Joachim