coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: qwaven on May 08, 2004, 06:16:15 AM

Title: [Solved]: Error after integrating coppermine with phpbb2
Post by: qwaven on May 08, 2004, 06:16:15 AM
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...
Title: Re: Error after integrating coppermine with phpbb2
Post by: Joachim Müller on May 08, 2004, 08:06:25 AM
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
Title: Re: Error after integrating coppermine with phpbb2
Post by: qwaven on May 08, 2004, 08:40:52 AM
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.

Title: Re: Error after integrating coppermine with phpbb2
Post by: Joachim Müller on May 08, 2004, 11:27:14 AM
there's something fishy with your bridge file - post lines 24-28 from your bridge file (replace your password with ***), should look like this// 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
Title: Re: Error after integrating coppermine with phpbb2
Post by: qwaven on May 08, 2004, 11:39:53 AM
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

Title: Re: Error after integrating coppermine with phpbb2
Post by: Joachim Müller on May 08, 2004, 11:42:36 AM
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
Title: Re: Error after integrating coppermine with phpbb2
Post by: qwaven on May 08, 2004, 08:19:29 PM
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"
Title: Re: Error after integrating coppermine with phpbb2
Post by: Joachim Müller on May 09, 2004, 08:25:19 AM
ok, what value do you have for define('PHPBB_DB_NAME', 'phpBB'); // The name of the database used by the board?

GauGau
Title: Re: Error after integrating coppermine with phpbb2
Post by: qwaven on May 09, 2004, 09:15:25 AM
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.
Title: Re: Error after integrating coppermine with phpbb2
Post by: Casper on May 09, 2004, 11:40:11 AM
No, you should change the 'phpBB', to the actual name of your database. 
Title: Re: Error after integrating coppermine with phpbb2
Post by: qwaven on May 09, 2004, 05:04:10 PM
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!