[Solved]: phpBB2 integration problem [Solved]: phpBB2 integration problem
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

[Solved]: phpBB2 integration problem

Started by blastof, June 05, 2004, 09:06:46 PM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

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.