I have my drupal 5.x installation in 1 database and my phpbb3 installation in another one, but both have the same user ownership (access).
In your configuration.inc you mention "database.prefix_table" how do I use that in the config in order to get it working?

The names of the databases are: "website_drupal" and "website_phpbb"

Comments

dotslasher’s picture

dotslasher commented
Status: Closed (fixed) » Active

When i created a new user i got this:

Query failed: 0 INSERT INTO phpbb_website.phpbb_users )--> and then the registration info
When trying the other prefix i got this:

Query failed: 0 SELECT username, user_pass_convert FROM website_drupal.phpbb_users WHERE `user_id` = 1002

The database is website_phpbb the drupal one is website_drupal

dotslasher’s picture

dotslasher commented
Status: Active » Closed (fixed)
dotslasher’s picture

dotslasher commented
arkepp’s picture

arkepp commented

Think before you act, then you don't flood my inbox and are much more likely to get a response.

dotslasher’s picture

dotslasher commented

I'm sorry mate, I'm not familiar with this ticket system. I didn't think it would show up so many times.

dotslasher’s picture

dotslasher commented

So can I get your help please?

arkepp’s picture

arkepp commented

I thought you had figured it out when you closed it.

In configuration.inc set
$db_prefix = 'website_phpbb.phpbb_';

and in functions_drupal.php
$drupal_user_table = 'website_drupal.drupal_users';
$drupal_session_table = 'website_drupal.drupal_sessions';

Haven't really tested this, but don't see any reason why it wouldn't work if you've set the right permissions.

helpforu’s picture

helpforu commented

two databases connected with 1 SQL statement will not work. If the user name doesn't have the right permissions for both.