I have a drupal database and a phpbb3.0 database. The drupal one is not prefixed with drupal_ but the phpbb one is (phpbb_). I've changed several config options in the .php files in the /modules/phpbb/ directory and told the module to use the proper prefixes/databases.

When a user who is registered in the drupal database tries to login into phpbb he sees a query

Query failed: 0 INSERT INTO phpbb_databasename.phpbb_users -> followed by the user settings taken from the drupal database, like email, timezone, username, etc.
No other error message is displayed, no warnings or anything else.

When I created a new test user it worked flawlessly.

What am I doing wrong?

Comments

arkepp’s picture

arkepp commented

See 4th paragraph of foreword, http://drupal.i1media.no/drupal+phpbb/foreword

I'm guessing the user is crashing into the search engine users automatically created by phpBB. I haven't done much work on this, and nobody has submitted a patch or offered to fund it, so it's still hanging.

arkepp’s picture

arkepp commented

See 4th paragraph of foreword, http://drupal.i1media.no/drupal+phpbb/foreword

I'm guessing the user is crashing into the search engine users automatically created by phpBB. I haven't done much work on this, and nobody has submitted a patch or offered to fund it, so it's still hanging.

svenvr’s picture

svenvr commented

Well I changed that user's UID to 1005 to make sure it does not conflict with any search engines, and the failed query is still there.

I changed the UIDs of most of the users to not conflict with the search engine bots. The users are 1000+ and the search engines got the usual UIDs of 3-50 something.

If that's what you mean.

arkepp’s picture

arkepp commented
Status: Active » Closed (fixed)

Well if it fails then there's something in the phpBB table with the same user id.

You can go into the code and print out the exact SQL statement that fails, then figure out what it's colliding with. If new users work then I have trouble seeing how it can be anything but a collision.

I'm shutting down the issue tracking system because it doesn't work for community support, please use http://groups.drupal.org/phpbb