[Solved]: Error after integrating coppermine with phpbb2

[qwaven]

Hello, I just followed the instructions on integrating coppermine with phpBB2.

And now when I try and access the coppermine gallery I get the following error:
"Fatal error :
There was an error while processing a database query"

It does not even take me to a login page or any page at that. Anyone help me with this?

phpBB does still work though.

Please let me know if you have any ideas, thanks...

[Joachim Müller]

if coppermine used to work before the integration, undo your changes to include/init.inc.php (making cppermine standalone again temporarily). Go to coppermine config, enable debug_mode (ath the very bottom of the page), save your settings, re-enable phpbb integration and check the additional debug_mode output when you encounter the db error. If it is alin to you, paste it into your next posting here.

GauGau

[qwaven]

ok I got this out of the debug mode:

"Fatal error :

There was an error while processing a database query.

While executing query "SELECT user_id, username as user_name, user_level FROM `phpBB`.phpbb_sessions INNER JOIN `phpBB`.phpbb_users ON session_user_id = user_id WHERE session_id='6925100d372e57cf92ff8a55526da989' AND session_user_id ='2'" on 0

mySQL error: Table 'phpBB.phpbb_sessions' doesn't exist"

I gather thats something about getting the user id from the SQL database?

I followed these instructions when I attempted the intregration if that helps,
http://coppermine.sourceforge.net/manual.php#integrating

Both coppermine and phpbb are using the same SQL database as suggested in it.

Lemmie know if you know what I should do thanks.

[Joachim Müller]

there's something fishy with your bridge file - post lines 24-28 from your bridge file (replace your password with ***), should look like this

Code Select Expand

// database configuration
define('PHPBB_DB_NAME', 'your_database_name'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server
define('PHPBB_DB_USERNAME', 'your_db_username'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', '****'); // The password to use to connect to the database
Could it be that you set your database name to phpbb, although your database is named differently?

GauGau

[qwaven]

here are the lines you requested...

// database configuration
define('PHPBB_DB_NAME', 'phpBB'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server
define('PHPBB_DB_USERNAME', 'username'); // The username to use to connect to the da
define('PHPBB_DB_PASSWORD', '***'); // The password to use to connect to the

[Joachim Müller]

ok, so your username is actually "username"? I don't think so...
You start by actually filling the values into the bridge file that apply to your server. Recommended reading: http://coppermine.sourceforge.net/manual.php#integrating

GauGau

[qwaven]

no no, I just changed that. Figured since you asked to change the pass I mise well hide the username.
I had filled out the values accordingly from "http://coppermine.sourceforge.net/manual.php#integrating"

[Joachim Müller]

ok, what value do you have for

Code Select Expand

define('PHPBB_DB_NAME', 'phpBB'); // The name of the database used by the board?

GauGau

[qwaven]

all my values were as I posted except for the user and pass...
I am guessing I was supposed to change that value? I left as it was, as I thought thats the name you want it to use or something.. I tried putting my SQL database name in there as well but it didnt seem to change anything.

[Casper]

No, you should change the 'phpBB', to the actual name of your database. 

[qwaven]

hmm, thats odd... I changed the value back to my database name and it seems to be working
Maybe I had made a typo when I tried my database name before?

Thanks all for your help, coppermine and phpbb both seem to be working fine

Keep up the great work!