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
what version of cpg are you using?
GauGau
Version 1.2.1
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
// ------------------------------------------------------------------------- //
// 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
are you sure your database name is phpbb? Is coppermine installed on the phpbb database as well?
GauGau
Yes, both coppermine and phpbb share the same database. Would it be better if I used seperate databases?
no, you MUST use the same db. What about my first question: is the db actually called "phpbb"?
GauGau
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