coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: panem on May 13, 2004, 11:27:06 AM

Title: Problem integrating CPG with phpBB
Post by: panem on May 13, 2004, 11:27:06 AM
I recently installed Coppermine, which worked fine as a stand-alone-application.
Now I tried to integrate it into my existing installation of phpBB, but after I applied all the changes mentioned in the documentation (http://coppermine.sourceforge.net/manual.php#integrating)
I received the following error message while trying to access coppermine:

Fatal error :

There was an error while processing a database query.

Since that is not very helpful, I turned on debug mode. Now when I try to access coppermine I get the following:

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_users WHERE user_id='3' AND user_password='*************'" on 0

mySQL error: select command denied to user: 'zoom-heli@localhost' for table 'phpbb_users'

(I replaced the "password" with asterisks)

Can anyone help me resolve this issue or point me in the right direction?

Thanks,
Matt

Title: Re: Problem integrating CPG with phpBB
Post by: Joachim Müller on May 14, 2004, 07:20:26 AM
what version of cpg are you using?

GauGau
Title: Re: Problem integrating CPG with phpBB
Post by: panem on May 14, 2004, 07:44:20 AM
Version 1.2.1
Title: Re: Problem integrating CPG with phpBB
Post by: Joachim Müller on May 14, 2004, 08:04:30 AM
please paste the content of bridge/phpbb.inc.php, line 24-28 (replace the password with ***) into your posting; my guess is you haven't modified the bridge file correctly.

GauGau
Title: Re: Problem integrating CPG with phpBB
Post by: panem on May 14, 2004, 08:09:05 AM
// ------------------------------------------------------------------------- //
// 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', 'zoom-heli'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', '******'); // The password to use to connect to the database
Title: Re: Problem integrating CPG with phpBB
Post by: Joachim Müller on May 14, 2004, 08:21:04 AM
are you sure your database name is phpbb? Is coppermine installed on the phpbb database as well?

GauGau
Title: Re: Problem integrating CPG with phpBB
Post by: panem on May 14, 2004, 08:23:55 AM
Yes, both coppermine and phpbb share the same database. Would it be better if I used seperate databases?
Title: Re: Problem integrating CPG with phpBB
Post by: Joachim Müller on May 14, 2004, 08:33:47 AM
no, you MUST use the same db. What about my first question: is the db actually called "phpbb"?

GauGau
Title: Re: Problem integrating CPG with phpBB
Post by: panem on May 14, 2004, 05:21:53 PM
Sorry I took so long to respond, I had an urgent family emergency to deal with. :-\\
Anyway, back on-topic...

The database is indeed called "phpbb".

Matt