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!
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...
hey goldmar...
how did you give coppermine access?
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?
Okay, nevermind. Problem solved. I figured out how to give that user access to the database and all is well now.