Print

[blastof]

Sorry, this has probably been posted before, but I'm new to coppermine, and I couldn't find the answer here.  I'm trying to integrate Coppermine into my PHPBB2 board, and I followed all of the steps outlined here, but I'm still having problems.  My problem is, when i go to the gallery page and select login, it directs me to the forum login, then when i log in and go back to the gallery, I get:

Fatal error :

There was an error while processing a database query.

I turned on debugging and here is the specific message:

While executing query "SELECT (ug.group_id + 5) as group_id FROM `blastof_phpbb1`.phpbb_user_group as ug LEFT JOIN `blastof_phpbb1`.phpbb_groups as g ON ug.group_id = g.group_id WHERE user_id = 2 AND user_pending = 0 AND group_single_user = 0" on 0

mySQL error: select command denied to user: 'blastof_cop1@localhost' for table 'phpbb_user_group'

I'm a PHP and MySQL newbie, so i don't really know where to start.  Thanks!

[goldmar]

I had this problem too.

It seems that coppermine doesn't handle the database settings of the forum correct.

I have phpBB as well and I had seperate databases for the forum and the gallery (and for each database one user) and after I gave the coppermine user the privileges to access the phpBB database everything went allright.
I assume that coppermine tries to access the forum's database with his own settings...

[blastof]

hey goldmar...

how did you give coppermine access?

[blastof]

Okay, I'm still at a loss here.  I can't get this to work.  Can anyone help me out?  How do I give blastof_cop1 permission to access the phpBB user database?

[blastof]

Okay, nevermind.  Problem solved.  I figured out how to give that user access to the database and all is well now.