[Solved]: PHPBB "error while processing a db query"

[Rascal71]

Hi there,

I just did a fresh install and tried to integrate Coppermine with PHPBB2.04.
I get the error:
Fatal error :

There was an error while processing a database query

While executing query "SELECT user_id, username as user_name, user_level FROM `FJ1200_nl`.phpbb_users WHERE user_id='2' AND user_password='f38c5d4fe16028ed6ba22b3c369d6038'" on 0

mySQL error: select command denied to user: 'myuserid@localhost' for table 'phpbb_users'

When I turn the integration off in "init.inc.php" everything works fine.

What could be the problem here?
I know my user-id has sufficient rights to perform the select command.

Thanks for the help.

[Nibbler]

Does the mysql account you are using for coppermine have permissions to access both the coppermine db *and* the phpbb db ? or are they in the same database ?

[Rascal71]

They are in the same database

[Rascal71]

It looks like there's not a solution for my problem yet and the PHPBB integration with Coppermine isn't working too well yet.  :cry:
So here's another question....is it possible to do the integration later....so that I can use Coppermine "as is" for now and integrate with PHPBB when the problems are solved?

[Joachim Müller]

sure you can, but if you allow user registration in coppermine and decide to switch integration on later, you'll have to manually add the user registered in coppermine only, or you'll have to make your users re-register. Imo phpbb integration is mature in cpg1.2.1, there are some login/logout issues that have been solved (look into the proper threads here on the board that describe the fix).
There are however issues with cpg1.3.0beta and phpbb integration (that's one of the reasons why cpg1.3.0 still has beta status); you don't happen to run the beta, do you?

GauGau

[Rascal71]

No, I'm not running the Beta...sorry.... :wink:
And I have been browsing through the threads and noticed the login/logout issues...but I'm not getting that far yet for it to be a problem....

[Joachim Müller]

hm, if you don't get the bridge file to work for you, this is probably related to some small error you did modifying the brdige file. Be sure to read the documentation carefully once more. Maybe you're on a subdomain? Posting a link to your site and a test user account might help as well...

GauGau

[Rascal71]

I suppose you mean a test user account to my coppermine installation? What rights do you need?

[Joachim Müller]

no I meant a phpBB user with bridging turned on (a "regular" user with upload permissions). If you don't want to turn bridging on, just post a link to both your phpbb forum and your coppermine gallery for a start.

GauGau

[Rascal71]

I think i solved the problem.  

When I ran a database query like this:
SELECT user_id, username as user_name, user_level FROM `FJ1200_nl`.phpbb_users WHERE user_id='2' AND user_password='f38c5d4fe16028ed6ba22b3c369d6038'

I got the following error:
mySQL error: select command denied to user: 'myuserid@localhost' for table 'phpbb_users'

But when I changed the query to this:
SELECT user_id, username as user_name, user_level FROM phpbb_users WHERE user_id='2' AND user_password='f38c5d4fe16028ed6ba22b3c369d6038'

the query worked OK.

As you might have noticed I left out the Database name "FJ1200_nl" in the second query.

I then changed the following define statement in the file "bridge/phpbb.inc.php" from

define('PHPBB_DB_NAME', 'FJ1200_nl'); // The name of the database used by the board

To:

define('PHPBB_DB_NAME', ''); // The name of the database used by the board

And it worked out.  :lol:

I'm not very familiar with PHP and MySQL but with a little common sense and enough time you can get a long way..... :wink:

Can you tell me if this is it or have I caused a potential problem with this action...

The only thing now is that I'm getting the login/out problem with the script but I've seen that discussed somewhere on the board so I'll just have to find it now   :wink: